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: 1000
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":{"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:
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: 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)
- actual_expend_amount (type: esriFieldTypeDouble, alias: Contractor/Sub-Recipient Actual Expenditures Amount, SQL Type: sqlTypeOther, nullable: true, editable: true)
- rem_bal_amount (type: esriFieldTypeDouble, alias: Remaining Balance Amount, SQL Type: sqlTypeOther, nullable: true, editable: true)
- admin_bud_amount (type: esriFieldTypeDouble, alias: Department Administrative Budget Amount, SQL Type: sqlTypeOther, nullable: true, editable: true)
- evidence_based_amount (type: esriFieldTypeDouble, alias: EBI Allocation Amount, SQL Type: sqlTypeOther, nullable: true, editable: true)
- source_information (type: esriFieldTypeString, alias: Detail other sources, SQL Type: sqlTypeOther, length: 7500, nullable: true, editable: true)
- department (type: esriFieldTypeString, alias: Department, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Ag_Comm_Weights_Measures: Agricultural Commissioner/ Weights & Measures], [Alternate_Public_Defender: Alternate Public Defender], [Animal_Care_Control: Animal Care & Control], ... 38 more ...)
- contact_name (type: esriFieldTypeString, alias: Primary Contact Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- contact_phone_number (type: esriFieldTypeString, alias: Primary Contact Phone Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- project_name (type: esriFieldTypeString, alias: Project Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Project_Homekey: Project Homekey 2.0], [Conversion_Interim_HU_Permanent: Conversion of Interim Housing Units to Permanent Housing], [Permanent_Supportive_Housing: Permanent Supportive and Interim Housing], ... 78 more ...)
- ecaps_project_code (type: esriFieldTypeString, alias: eCAPS Project Code, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [ARPAR101: ARPAR101], [ARPCAT101: ARPCAT101], [ARPCAT102: ARPCAT102], ... 84 more ...)
- actual_expend_status (type: esriFieldTypeString, alias: Contractor/Sub-Recipient Actual Expenditures Status, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- actual_expend_issues (type: esriFieldTypeString, alias: Contractor/Sub-Recipient Actual Expenditures Issues, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- rem_bal_status (type: esriFieldTypeString, alias: Remaining Balance Status, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- rem_bal_issues (type: esriFieldTypeString, alias: Remaining Balance Issues, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- admin_bud_status (type: esriFieldTypeString, alias: Department Administrative Budget Status, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- admin_bud_issues (type: esriFieldTypeString, alias: Department Administrative Budget Issues, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- evidence_based_status (type: esriFieldTypeString, alias: EBI Allocation Amount Status, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- evidence_based_issues (type: esriFieldTypeString, alias: EBI Allocation Amount Issues, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- contact_email (type: esriFieldTypeString, alias: Primary Contact Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- other_department (type: esriFieldTypeString, alias: Other - Department, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- other_project (type: esriFieldTypeString, alias: Other - Project Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- ecaps_project_code_other (type: esriFieldTypeString, alias: Other - eCAPS Project Code, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- contractor_sub_budget_amount (type: esriFieldTypeDouble, alias: Contractor/Sub-Recipient Administrative Budget Amount, SQL Type: sqlTypeOther, nullable: true, editable: true)
- contractor_sub_budget_status (type: esriFieldTypeString, alias: Contractor/Sub-Recipient Administrative Budget Status, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- contractor_sub_budget_issues (type: esriFieldTypeString, alias: Contractor/Sub-Recipient Administrative Budget Issues, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- other_funding_source_amount (type: esriFieldTypeDouble, alias: Other Funding Source Amount, SQL Type: sqlTypeOther, nullable: true, editable: true)
- other_funding_source_status (type: esriFieldTypeString, alias: Other Funding Source Status, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- other_funding_source_issues (type: esriFieldTypeString, alias: Other Funding Source Issues, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- was_budget_appropriated (type: esriFieldTypeString, alias: Was the budget appropriated?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- budget_appropriated_amount (type: esriFieldTypeDouble, alias: Budget Appropriated Amount, SQL Type: sqlTypeOther, nullable: true, editable: true)
- budget_appropriation_status (type: esriFieldTypeString, alias: Please provide a status and detail any issues that may have arisen related to budget appropriation., SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- project_changes (type: esriFieldTypeString, alias: Have any issues arisen during implementation that could impact the Project design, budget, or success of the program?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- change_date (type: esriFieldTypeDate, alias: When was the recommendation approved?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- revised_project_budget (type: esriFieldTypeDouble, alias: What is the revised Project budget?, SQL Type: sqlTypeOther, nullable: true, editable: true)
- change_need (type: esriFieldTypeString, alias: What is your recommendation for solving the identified issue(s)?, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- implementation_issues (type: esriFieldTypeString, alias: What issue(s) arose during implementation that could impact the Project design, budget, or success of the program?, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- have_project_launch_date (type: esriFieldTypeString, alias: Do you have a Project launch date?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- project_launch_date (type: esriFieldTypeDate, alias: Please enter the launch date., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- project_launch_status (type: esriFieldTypeString, alias: Please provide an update on the status of Project launch., SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- have_project_closure_date (type: esriFieldTypeString, alias: Do you have a Project closure date?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- project_closure_date (type: esriFieldTypeDate, alias: Please enter the date all expenditures are final in the field below., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- project_closure_status (type: esriFieldTypeString, alias: Please provide an update on the status of Project closure., SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- delegated_authority_given (type: esriFieldTypeString, alias: Was delegated authority given to administer the program?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- date_authority_given (type: esriFieldTypeDate, alias: Date authority given, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- how_authority_given (type: esriFieldTypeString, alias: Please explain how authority was given., SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- authority_status (type: esriFieldTypeString, alias: Please provide a status and detail any issues that may have arisen, related to delegation of authority to administer the Project., SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- contractsub_recipient_needed (type: esriFieldTypeString, alias: Contractor/Sub-Recipient needed?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- contract_date (type: esriFieldTypeDate, alias: Contract Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- number_of_contracts (type: esriFieldTypeDouble, alias: Number of contracts, SQL Type: sqlTypeOther, nullable: true, editable: true)
- subcontracting_issues (type: esriFieldTypeString, alias: Please detail any issues that may have arisen related to contractor/sub-recipient contracting., SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- have_solicitation_date (type: esriFieldTypeString, alias: Do you have a solicitation date for Contractor/Sub-Recipient(s)?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- solicitation_date (type: esriFieldTypeDate, alias: What is the solicitation date?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- solicitation_status (type: esriFieldTypeString, alias: Please provide an update on the status of contractor/sub-recipient solicitations., SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- have_deadline (type: esriFieldTypeString, alias: Do you have an application deadline for participants in the Project?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- application_deadline_date (type: esriFieldTypeDate, alias: Application deadline date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- application_status (type: esriFieldTypeString, alias: Please provide an update on the status of applications., SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- have_signed_subagreement (type: esriFieldTypeString, alias: Do you have signed a Contractor/Sub-Recipient Agreement(s)?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- subagreement_signed_date (type: esriFieldTypeDate, alias: Date the contractor/sub-recipient agreement was signed., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- subagreement_status (type: esriFieldTypeString, alias: Please provide an update on the status of contractor/sub-recipient agreement(s)., SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- contracts_above_50k (type: esriFieldTypeString, alias: Are any of the contracts greater than or equal to $50,000? , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- contracts_50k_dates_details (type: esriFieldTypeString, alias: Please enter the date and detail how many., SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- sub_grants_above_50k (type: esriFieldTypeString, alias: Does your Project have contractor/sub-recipients issuing grants greater than or equal to $50,000? (CRG pg. 17), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- grants_received (type: esriFieldTypeString, alias: Have the grants been received?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- dates_grants_received (type: esriFieldTypeString, alias: Dates grants received., SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- ngc_budget_amount (type: esriFieldTypeDouble, alias: Non-Geographically Concentrated Communities Budget Amount, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ngc_budget_status (type: esriFieldTypeString, alias: Non-Geographically Concentrated Communities Budget Status, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- ngc_budget_issues (type: esriFieldTypeString, alias: Non-Geographically Concentrated Communities Budget Issues, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- concept_design_finalized (type: esriFieldTypeString, alias: Conceptual Design Finalized?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- concept_design_finalized_date (type: esriFieldTypeDate, alias: Please enter date finalized., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- concept_design_finalized_status (type: esriFieldTypeString, alias: Please provide a status and detail any issues that may have arisen, related to conceptual design finalization., SQL Type: sqlTypeOther, length: 7500, nullable: true, editable: true)
- anticipated_issues_identified (type: esriFieldTypeString, alias: Any anticipated issues identified by Board Deputies?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- anticipated_issues_details (type: esriFieldTypeString, alias: Please explain issues identified in detail., SQL Type: sqlTypeOther, length: 7500, nullable: true, editable: true)
- ardi_equity_report_received (type: esriFieldTypeString, alias: Was ARDI Equity Report Received?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- ardi_equity_report_receive_date (type: esriFieldTypeDate, alias: Please enter date Equity report received., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- ardi_equity_report_status (type: esriFieldTypeString, alias: Please provide a status and detail any issues that may have arisen, related to Equity report., SQL Type: sqlTypeOther, length: 7500, nullable: true, editable: true)
- ardi_project_review_completed (type: esriFieldTypeString, alias: Was ARDI Project Review Completed?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- ardi_project_review_date (type: esriFieldTypeDate, alias: Please enter date Project review was completed., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- ardi_project_review_status (type: esriFieldTypeString, alias: Please provide a status and detail any issues that may have arisen, related to Project review completion., SQL Type: sqlTypeOther, length: 7500, nullable: true, editable: true)
- ardi_design_approval (type: esriFieldTypeString, alias: Was Project design approved by ARDI?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- ardi_design_approval_date (type: esriFieldTypeDate, alias: Please enter date Project design was approved by ARDI., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- ardi_design_approval_status (type: esriFieldTypeString, alias: Please provide a status and detail any issues that may have arisen, related to Project design approval by ARDI., SQL Type: sqlTypeOther, length: 7500, nullable: true, editable: true)
- counsel_design_approval (type: esriFieldTypeString, alias: Was Project design approved by County Counsel?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- counsel_design_approval_date (type: esriFieldTypeDate, alias: Please enter date Project design was approved by County Counsel., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- counsel_design_approval_status (type: esriFieldTypeString, alias: Please provide a status and detail any issues that may have arisen, related to Project design approval by County Counsel., SQL Type: sqlTypeOther, length: 7500, nullable: true, editable: true)
- ceo_design_approval (type: esriFieldTypeString, alias: Was Project design approved by CEO?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- ceo_design_approval_date (type: esriFieldTypeDate, alias: Please enter date Project design was approved by CEO., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- ceo_design_approval_status (type: esriFieldTypeString, alias: Please provide a status and detail any issues that may have arisen, related to Project design approval by CEO., SQL Type: sqlTypeOther, length: 7500, nullable: true, editable: true)
- equity_tool_completed_date (type: esriFieldTypeDate, alias: Date Equity Explorer Mapping Tool Utilized, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- reflects_arpa_pillar1 (type: esriFieldTypeString, alias: Does this Project reflect ARPA Pillar 1: Equity-Focused Investments?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- pillar1_spending_category (type: esriFieldTypeString, alias: Select a Pillar 1 Spending category, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- reflects_arpa_pillar2 (type: esriFieldTypeString, alias: Does this Project reflect ARPA Pillar 2: Building a Bridge to an Equitable Recovery?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- pillar2_spending_category (type: esriFieldTypeString, alias: Select a Pillar 2 Spending category, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- reflects_arpa_pillar3 (type: esriFieldTypeString, alias: Does this Project reflect ARPA Pillar 3: Fiscal Stability and Social Safety Net?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- pillar3_spending_category (type: esriFieldTypeString, alias: Select a Pillar 3 Spending category, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- estimated_expenditure_amount (type: esriFieldTypeDouble, alias: Estimated Current Expenditure Amount, SQL Type: sqlTypeOther, nullable: true, editable: true)
- estimated_expenditure_status (type: esriFieldTypeString, alias: Estimated Current Expenditure Status, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- estimated_expenditure_issues (type: esriFieldTypeString, alias: Estimated Current Expenditure Issues, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- services_end_date (type: esriFieldTypeDate, alias: When will services end?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- participant_eligibility (type: esriFieldTypeString, alias: Describe participant eligibility criteria., SQL Type: sqlTypeOther, length: 7500, nullable: true, editable: true)
- overall_project_status (type: esriFieldTypeString, alias: What is the status of the Project overall? (CGR pg. 17), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Not_started: Not started], [Competed_less_than_50%: Competed less than 50%], [Completed_more_than_50%: Completed more than 50%], ... 1 more ...)
- goals_progress (type: esriFieldTypeString, alias: What is the progress made on key Project outcome goals? (CRG pg. 24), SQL Type: sqlTypeOther, length: 7500, nullable: true, editable: true)
- had_challenges (type: esriFieldTypeString, alias: Did you encounter any challenges or opportunities during this reporting period?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- challenge_details (type: esriFieldTypeString, alias: Please describe in detail any other challenges encountered in implementation., SQL Type: sqlTypeOther, length: 7500, nullable: true, editable: true)
- relevant_outcomes (type: esriFieldTypeString, alias: Outcomes: Are intended outcomes focused on closing gaps, reaching universal levels of service, or disaggregating progress by race, ethnicity, and other equity dimensions where relevant for the policy objective? , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- outcome_details (type: esriFieldTypeString, alias: Please describe in detail how intended outcomes are closing gaps, reaching universal levels of service, or disaggregating progress by race, ethnicity, and other equity dimensions where relevant for the policy objective., SQL Type: sqlTypeOther, length: 7500, nullable: true, editable: true)
- financial_recovery_approved (type: esriFieldTypeString, alias: Was the recommendation presented to the Financial Recovery?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- change_approved_details (type: esriFieldTypeString, alias: What recommendation was approved by Financial Recovery?, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- recommendation_approved (type: esriFieldTypeString, alias: Was the recommendation approved by the Financial Recovery?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- revised_project_budget_appr_rec (type: esriFieldTypeDouble, alias: What is the revised Project budget for the approved recommendation?, SQL Type: sqlTypeOther, nullable: true, editable: true)
- rec_not_presented_details (type: esriFieldTypeString, alias: Why was the recommendation not presented to the Financial Recovery?, SQL Type: sqlTypeOther, length: 7500, 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: 10/12/2022 4:31:17 PM
Schema Last Edit Date: 10/12/2022 4:31:17 PM
Data Last Edit Date: 10/12/2022 4:31:17 PM
Supported Operations:
Add Features
Apply Edits
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat