Layer: survey (ID:0)

View In: Map Viewer

Name: survey

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:

Drawing Info:

{"labelingInfo":null,"renderer":{"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:

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: 128, 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: 128, nullable: true, editable: false)
organization_name (type: esriFieldTypeString, alias: Business or Nonprofit Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
business_owner_name_ (type: esriFieldTypeString, alias: Business Owner Name , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
business_address (type: esriFieldTypeString, alias: Business Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
business_number (type: esriFieldTypeDouble, alias: Main Business Number (with no dashes, such as 1234567890), SQL Type: sqlTypeOther, nullable: true, editable: true)
preferred_contact_method (type: esriFieldTypeString, alias: Preferred Contact Method, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [email: Business Phone], [business_phone_: Cell Phone], [cell_phone: Email])
cell_phone (type: esriFieldTypeDouble, alias: Owner’s Cell Phone Number (with no dashes, such as 1234567890), SQL Type: sqlTypeOther, nullable: true, editable: true)
email (type: esriFieldTypeString, alias: Owner's Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
pledge (type: esriFieldTypeString, alias: Have you taken the Better.SAfer.Together Pledge?” , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
field_13 (type: esriFieldTypeDouble, alias: How many employees do you currently have? , SQL Type: sqlTypeOther, nullable: true, editable: true)
field_14 (type: esriFieldTypeString, alias: Is your organization experiencing COVID-related challenges?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
what_are_the_top_challenges_fac (type: esriFieldTypeString, alias: What are the top challenges facing your business right now?, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
what_kind_of_service_does_your_ (type: esriFieldTypeString, alias: What kind of service does your organization provide?, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
are_you_certified_by_the_sctrca (type: esriFieldTypeString, alias: Are you certified by the SCTRCA as a small, minority, or women owned business enterprise? Are you veteran owned?, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
field_20 (type: esriFieldTypeString, alias: Are you part of any chambers or business associations?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
field_21 (type: esriFieldTypeString, alias: If so, which?, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
field_23 (type: esriFieldTypeDouble, alias: How many employees have been laid off or furloughed since March 1, 2020?, SQL Type: sqlTypeOther, nullable: true, editable: true)
field_24 (type: esriFieldTypeString, alias: Do you plan to rehire any employees by Dec 31, 2020?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
field_25 (type: esriFieldTypeDouble, alias: How many employees, if any, have you been able to rehire so far?, SQL Type: sqlTypeOther, nullable: true, editable: true)
what_were_the_top_two_challenge (type: esriFieldTypeString, alias: What were the top two challenges facing your business before COVID?, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
is_your_organization_having_fin (type: esriFieldTypeString, alias: Is your organization having financing challenges?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
field_28 (type: esriFieldTypeString, alias: If so, which are the top challenges are you experiencing?, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
field_29 (type: esriFieldTypeString, alias: Did you apply or receive funds from the San Antonio LiftFund grant?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [applied: Applied], [received: Received])
field_30 (type: esriFieldTypeString, alias: Did you apply or receive funds from the Small Business Administration's Paycheck Protection Program?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [applied: Applied], [received: Received])
field_31 (type: esriFieldTypeString, alias: Did you apply or receive funds from the Small Business Administration's Economic Injury Disaster Loan?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [applied: Applied], [received: Received])
field_32 (type: esriFieldTypeString, alias: Did you apply or receive funds from the Bexar County LiftFund Grant?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [applied: Applied], [received: Received])
field_33 (type: esriFieldTypeString, alias: Did you apply or receive funds from the Bexar County LiftFund Loan?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [applied_: Applied ], [received: Received])
field_34 (type: esriFieldTypeString, alias: Is your organization experiencing health and safety challenges?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
field_35 (type: esriFieldTypeString, alias: If so, which are the top challenges are you experiencing?, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
field_36 (type: esriFieldTypeString, alias: Is your organization experiencing public services challenges (for example, with permitting or utilities or traffic)?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
field_37 (type: esriFieldTypeString, alias: If so, which are the top challenges are you experiencing?, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
field_38 (type: esriFieldTypeString, alias: Is your organization experiencing operating/business challenges (such as marketing, bookkeeping, legal)? , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
field_39 (type: esriFieldTypeString, alias: If so, which are the top challenges are you experiencing?, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
for_staff_what_services_did_you (type: esriFieldTypeString, alias: For staff: What services did you provide or recommend?, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
for_staff_if_you_connected_them (type: esriFieldTypeString, alias: For staff: If you connected them to another resource, which resource did you connect them with?, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
field_42 (type: esriFieldTypeString, alias: For staff: How did you engage with the organization?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [in_person: In Person], [phone: Phone], [email: Email], ... 1 more ...)
do_you_still_need_support_in_an (type: esriFieldTypeString, alias: Do you still need support in any of the following areas?, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
what_kind_of_support_does_your_ (type: esriFieldTypeString, alias: What kind of support does your organization still need?, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
are_you_more_aware_of_the_small (type: esriFieldTypeString, alias: Are you more aware of the small business support organizations and resources available?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [strongly_disagree: Strongly disagree], [disagree: Disagree], [neutral: Neutral], ... 2 more ...)
do_you_plan_to_use_any_other_sm (type: esriFieldTypeString, alias: Do you plan to use any other small business resources? , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
which_small_business_resources_ (type: esriFieldTypeString, alias: Which small business resources do you plan to use?, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
how_likely_are_you_to_refer_thi (type: esriFieldTypeDouble, alias: On a scale from 1-10, with 1 being not at all and 10 being definitely, how likely are you to recommend this resource to a friend or colleague?, SQL Type: sqlTypeOther, nullable: true, editable: true)
field_56 (type: esriFieldTypeString, alias: Are you part of any chambers or business associations?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
would_you_be_willing_to_promote (type: esriFieldTypeString, alias: Would you be willing to promote this program on behalf of the City of San Antonio?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
what_would_have_improved_your_e (type: esriFieldTypeString, alias: What would have improved your experience?, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
how_are_you_making_your_busines (type: esriFieldTypeString, alias: How are you making your business stronger for the long term?, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
field_61 (type: esriFieldTypeString, alias: For staff: How did you engage with the organization?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [in_person: In Person], [phone: Phone], [email: Email], ... 1 more ...)
_date (type: esriFieldTypeDate, alias: Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
open_for_business (type: esriFieldTypeString, alias: Open for Business, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
location_is_limiting_number_of_ (type: esriFieldTypeString, alias: Location is limiting number of customers?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
field_68 (type: esriFieldTypeString, alias: Business Street Address (e.g. 600 Soledad St), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
business_zip (type: esriFieldTypeDouble, alias: Zip Code, SQL Type: sqlTypeOther, nullable: true, editable: true)
suite (type: esriFieldTypeDouble, alias: Suite, SQL Type: sqlTypeOther, nullable: true, editable: true)
notes (type: esriFieldTypeString, alias: Additional Notes, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
industry_type (type: esriFieldTypeString, alias: Industry Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [choice_1: Choice 1], [choice_2: Choice 2], [choice_3: Choice 3])
outreach_team_name (type: esriFieldTypeString, alias: Outreach Team Name, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
for_field_staff_how_did_you_eng (type: esriFieldTypeString, alias: For field staff: How did you engage with the organization?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [in_person: In Person], [phone: Phone], [email: Email], ... 1 more ...)
referral_for_outreach_partner (type: esriFieldTypeString, alias: Referral for Outreach Partner, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
which_small_business_resourcess (type: esriFieldTypeString, alias: Which small business resources/services have you used since March?, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
do_you_have_better_knowledge_of (type: esriFieldTypeString, alias: Do you have better knowledge of financial practices that promote long-term business health?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
are_you_aware_of_the_small_busi (type: esriFieldTypeString, alias: Are you aware of the small business support organizations and resources available?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
if_so_which (type: esriFieldTypeString, alias: If so, which?, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
survey_section (type: esriFieldTypeString, alias: Survey Section, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [part_1:_initial_outreach_: Part 1: Initial Outreach ], [part_2:_service: Part 2: Service], [part_3:_close_out_survey: Part 3: Close Out Survey])
jump_to_part_ (type: esriFieldTypeString, alias: Jump to Part , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [part_1:_initial_outreach: Part 1: Initial Outreach], [choice_2: Part 2: Service], [choice_3: Part 3: Closing Out Survey])

Templates:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/16/2020 6:58:38 PM

Schema Last Edit Date: 7/16/2020 6:58:38 PM

Data Last Edit Date: 7/16/2020 6:58:38 PM

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