Name: surveyPoint

Display Field:

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -180
YMin: -90
XMax: 180
YMax: 90
Spatial Reference: 4326 (4326)

Drawing Info:

{"labelingInfo":null,"renderer":{"description":"Survey Data Locations","label":"Survey Point","symbol":{"angle":0,"color":[255,0,0,255],"outline":{"color":[255,255,0,255],"width":1},"size":8,"style":"esriSMSCircle","type":"esriSMS","xoffset":0,"yoffset":0},"type":"simple"},"transparency":0}

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: ObjectId

Unique ID Field:

Name : ObjectId

IsSystemMaintained : True

Global ID Field: globalid

Type ID Field:

Fields:

• ObjectId (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: false)
• field_1 (type: esriFieldTypeDouble, alias: Parcel Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• field_3 (type: esriFieldTypeString, alias: Your Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• field_4 (type: esriFieldTypeString, alias: How did you know the property was for sale?, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• field_4_other (type: esriFieldTypeString, alias: Other - How did you know the property was for sale?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• field_5 (type: esriFieldTypeString, alias: Was the property exposed to the open market?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [choice0: Yes], [choice1: No])
• field_6 (type: esriFieldTypeString, alias: Was the home a foreclosure or short sale?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [choice0: Yes], [choice1: No])
• field_8 (type: esriFieldTypeString, alias: What was the asking price?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• field_10 (type: esriFieldTypeString, alias: What was the final sale price?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• field_11 (type: esriFieldTypeString, alias: Was there a fee appraisal?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [choice0: Yes], [choice1: No], [choice2: Unsure])
• field_12 (type: esriFieldTypeDouble, alias: If there was a fee appraisal, what was the concluded value of the home?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• field_13 (type: esriFieldTypeString, alias: Will the property be used as a rental?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [choice0: Yes], [choice1: No])
• field_14 (type: esriFieldTypeString, alias: If the property will be used as a rental, what is the proposed monthly rent?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• field_15 (type: esriFieldTypeString, alias: What condition was the property in at the time of sale?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• field_16 (type: esriFieldTypeString, alias: What repairs if any are needed to the property?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• field_17 (type: esriFieldTypeString, alias: What work/repairs have been completed since the purchase?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• field_23 (type: esriFieldTypeString, alias: Has there been any major remodeling or modernization in the last 10 years?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [choice0: Yes], [choice1: No])
• field_24 (type: esriFieldTypeString, alias: In what year did the remodel occur and what were the costs?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• field_25 (type: esriFieldTypeString, alias: Select all the areas that were remodeled or updated., SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• field_25_other (type: esriFieldTypeString, alias: Other - Select all the areas that were remodeled or updated., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• field_26 (type: esriFieldTypeString, alias: Select all rooms that were remodeled., SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• field_26_other (type: esriFieldTypeString, alias: Other - Select all rooms that were remodeled., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• field_27 (type: esriFieldTypeString, alias: Heating Type, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• field_27_other (type: esriFieldTypeString, alias: Other - Heating Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• field_28 (type: esriFieldTypeString, alias: Air Conditioning Type, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• field_28_other (type: esriFieldTypeString, alias: Other - Air Conditioning Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• field_31 (type: esriFieldTypeString, alias: Does the home have any fireplaces?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [choice0: Yes], [choice1: No])
• field_32 (type: esriFieldTypeDouble, alias: How many fireplaces does the home have?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• field_33 (type: esriFieldTypeString, alias: What type(s) of fireplaces does the home have?, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• field_35 (type: esriFieldTypeDouble, alias: Bedroom(s), SQL Type: sqlTypeOther, nullable: true, editable: true)
• field_36 (type: esriFieldTypeDouble, alias: Converted Room(s), SQL Type: sqlTypeOther, nullable: true, editable: true)
• field_37 (type: esriFieldTypeDouble, alias: Kitchen(s), SQL Type: sqlTypeOther, nullable: true, editable: true)
• field_38 (type: esriFieldTypeDouble, alias: Living Room(s), SQL Type: sqlTypeOther, nullable: true, editable: true)
• field_39 (type: esriFieldTypeDouble, alias: Family/Rec Room(s), SQL Type: sqlTypeOther, nullable: true, editable: true)
• field_40 (type: esriFieldTypeDouble, alias: Dining Room(s), SQL Type: sqlTypeOther, nullable: true, editable: true)
• field_41 (type: esriFieldTypeDouble, alias: Living/Dining Combo, SQL Type: sqlTypeOther, nullable: true, editable: true)
• field_42 (type: esriFieldTypeDouble, alias: Kitchen/Dining Combo, SQL Type: sqlTypeOther, nullable: true, editable: true)
• field_44 (type: esriFieldTypeString, alias: Other types of Rooms, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• field_45 (type: esriFieldTypeString, alias: Does the home have an attic with permanent stairs?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [choice0: Yes], [choice1: No])
• field_46 (type: esriFieldTypeString, alias: Is the attic finished?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [choice0: Yes], [choice1: No])
• field_47 (type: esriFieldTypeString, alias: How much of the attic is finished?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• field_49 (type: esriFieldTypeString, alias: Is there a basement?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [choice0: Yes], [choice1: No])
• field_50 (type: esriFieldTypeString, alias: Please select the type of basement., SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• field_51 (type: esriFieldTypeString, alias: Is there any finish in the basement?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [choice0: Yes], [choice1: No])
• field_52 (type: esriFieldTypeDouble, alias: Number of Bedrooms in the basement?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• field_53 (type: esriFieldTypeDouble, alias: Number of Bathrooms in the basement?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• field_54 (type: esriFieldTypeDouble, alias: Number of Family/Rec Rooms in the basement? , SQL Type: sqlTypeOther, nullable: true, editable: true)
• field_55 (type: esriFieldTypeString, alias: How much of the basement is finished?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• field_56 (type: esriFieldTypeString, alias: Is the quality of workmanship on the flooring, walls, and ceiling finish equivalent to the main/upper floor living area?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [choice0: Yes], [choice1: No])
• field_57 (type: esriFieldTypeDouble, alias: How many full bathroom(s) does the home have?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• field_58 (type: esriFieldTypeDouble, alias: How many 3/4 bathroom(s) does the home have? , SQL Type: sqlTypeOther, nullable: true, editable: true)
• field_59 (type: esriFieldTypeDouble, alias: How many 1/2 bathroom(s) does the home have? , SQL Type: sqlTypeOther, nullable: true, editable: true)
• field_61 (type: esriFieldTypeDouble, alias: Double Vanities, SQL Type: sqlTypeOther, nullable: true, editable: true)
• field_62 (type: esriFieldTypeDouble, alias: Spa Tub(s), SQL Type: sqlTypeOther, nullable: true, editable: true)
• field_63 (type: esriFieldTypeDouble, alias: Laundry/Utility Sink(s), SQL Type: sqlTypeOther, nullable: true, editable: true)
• field_64 (type: esriFieldTypeDouble, alias: Wet Bar(s), SQL Type: sqlTypeOther, nullable: true, editable: true)
• field_66 (type: esriFieldTypeString, alias: Does the home have an attached garage?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [choice0: Yes], [choice1: No])
• field_67 (type: esriFieldTypeDouble, alias: What is the garage capacity?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• field_68 (type: esriFieldTypeString, alias: Is there a detached garage on the property?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [choice0: Yes], [choice1: No])
• field_69 (type: esriFieldTypeDouble, alias: What is the capacity of the detached garage?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• field_85 (type: esriFieldTypeString, alias: Is your mailing address the same as the property address?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [choice0: Yes], [choice1: No])
• field_86 (type: esriFieldTypeString, alias: If no, what is the mailing address?, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• field_77 (type: esriFieldTypeDate, alias: Date of sale?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• field_75 (type: esriFieldTypeString, alias: Did the seller assist with any of the closing cost?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [choice0: Yes], [choice1: No])
• field_76 (type: esriFieldTypeString, alias: If yes, what was the amount?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• field_78 (type: esriFieldTypeString, alias: How was the sale price arrived at?, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• field_78_other (type: esriFieldTypeString, alias: Other - How was the sale price arrived at?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• field_79 (type: esriFieldTypeString, alias: Was there any major personal property included in the sale price?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [choice0: Yes], [choice1: No])
• field_80 (type: esriFieldTypeString, alias: If yes, were these items specified in the bill of sale or purchase agreement?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [choice0: Yes], [choice1: No])
• field_81 (type: esriFieldTypeString, alias: If yes, what was the dollar amount of the items included?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• field_82 (type: esriFieldTypeString, alias: Was there any relationship between the buyer and seller?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [choice0: Yes], [choice1: No])
• field_83 (type: esriFieldTypeString, alias: Did this relationship affect the sale price?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [choice0: Yes], [choice1: No])
• field_84 (type: esriFieldTypeString, alias: How long was the property on the market?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• field_87 (type: esriFieldTypeString, alias: Was the property occupied at the time of the sale?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [choice0: Yes ], [choice1: No])
• field_88 (type: esriFieldTypeString, alias: Are utilities included in the rent amount?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [choice0: Yes], [choice1: No])
• field_90 (type: esriFieldTypeString, alias: Were any changes made to the property after January 1st of this year?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [choice0: Yes], [choice1: No])
• field_92 (type: esriFieldTypeString, alias: Are there Ingress or Egress windows in the basement?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [choice0: Yes], [choice1: No])
• field_94 (type: esriFieldTypeString, alias: House Overall, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• field_95 (type: esriFieldTypeString, alias: Roof, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• field_96 (type: esriFieldTypeString, alias: Flooring, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• field_97 (type: esriFieldTypeString, alias: Electrical, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• field_98 (type: esriFieldTypeString, alias: Plumbing, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• field_99 (type: esriFieldTypeString, alias: Interior Walls/Ceilings, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• field_100 (type: esriFieldTypeString, alias: Foundation, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• field_101 (type: esriFieldTypeString, alias: Infestations, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• field_102 (type: esriFieldTypeString, alias: Exterior Walls, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• field_103 (type: esriFieldTypeString, alias: Additional Comments, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• property_address (type: esriFieldTypeString, alias: Property Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• if_yes_what_changes_have_been_m (type: esriFieldTypeString, alias: If yes, what changes have been made since January 1st?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• please_estimate_the_percent_com (type: esriFieldTypeString, alias: Please estimate the percent complete of the remodeling:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• select_all_that_apply (type: esriFieldTypeString, alias: Select all that apply, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• house_overall (type: esriFieldTypeString, alias: House Overall, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [non_functional: Non-functional], [needs_work: Needs work], [average_for_its_age: Average for its age], ... 1 more ...)
• roof (type: esriFieldTypeString, alias: Roof, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [non_functional: Non-functional], [needs_work: Needs work], [average_for_its_age: Average for its age], ... 1 more ...)
• flooring (type: esriFieldTypeString, alias: Flooring, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [non_functional: Non-functional], [needs_work: Needs work], [average_for_its_age: Average for its age], ... 1 more ...)
• electrical (type: esriFieldTypeString, alias: Electrical, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [non_functional: Non-functional], [needs_work: Needs work], [average_for_its_age: Average for its age], ... 1 more ...)
• plumbing (type: esriFieldTypeString, alias: Plumbing, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [non_functional: Non-functional], [needs_work: Needs work], [average_for_its_age: Average for its age], ... 1 more ...)
• interior_wallsceiling (type: esriFieldTypeString, alias: Interior Walls/Ceiling, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [non_functional: Non-functional], [needs_work: Needs work], [average_for_its_age: Average for its age], ... 1 more ...)
• foundation (type: esriFieldTypeString, alias: Foundation, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [non_functional: Non-functional], [needs_work: Needs work], [average_for_its_age: Average for its age], ... 1 more ...)
• infestations (type: esriFieldTypeString, alias: Infestations, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [non_functional: Non-functional], [needs_work: Needs work], [average_for_its_age: Average for its age], ... 1 more ...)
• exterior_walls (type: esriFieldTypeString, alias: Exterior Walls, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [non_functional: Non-functional], [needs_work: Needs work], [average_for_its_age: Average for its age], ... 1 more ...)
• other (type: esriFieldTypeString, alias: Other, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• are_you_the (type: esriFieldTypeString, alias: Are you the, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [owner: Owner], [tenant_: Tenant ], [agent_: Agent ], ... 1 more ...)
• daytime_phone_ (type: esriFieldTypeString, alias: Daytime Phone #, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Templates:

Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/16/2019 7:03:57 PM

Schema Last Edit Date: 7/16/2019 7:03:57 PM

Data Last Edit Date: 7/16/2019 7:03:57 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Attachments   Add Features   Update Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat