View In:   ArcGIS Online Map Viewer

Name: Capital Projects

Display Field: projname

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: -9272839.742473008
YMin: 3230956.1695715208
XMax: -9161470.842970701
YMax: 3270503.759438494
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [168, 76, 0, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• projid ( type: esriFieldTypeString, alias: Project Identifier, editable: true, nullable: false, length: 50, defaultValue: null, modelName: projid )
• projname ( type: esriFieldTypeString, alias: Project Name, editable: true, nullable: false, length: 255, defaultValue: null, modelName: projname )
• projdesc ( type: esriFieldTypeString, alias: Description, editable: true, nullable: false, length: 1000, defaultValue: null, modelName: projdesc )
• rationale ( type: esriFieldTypeString, alias: Rationale, editable: true, nullable: false, length: 1000, defaultValue: null, modelName: rationale )
• projtype ( type: esriFieldTypeString, alias: Project Type, editable: true, nullable: false, length: 50, defaultValue: null, modelName: projtype , Coded Values: [Art & Cultural Affairs: Art & Cultural Affairs] , [Contract Administration: Contract Administration] , [Convention Center & Tourism: Convention Center & Tourism] , ...15 more... )
• safety ( type: esriFieldTypeString, alias: Health and Safety, editable: true, nullable: false, length: 5, defaultValue: No, modelName: safety , Coded Values: [Yes: Yes] , [No: No] )
• mandate ( type: esriFieldTypeString, alias: Mandate, editable: true, nullable: false, length: 5, defaultValue: No, modelName: mandate , Coded Values: [Yes: Yes] , [No: No] )
• repair ( type: esriFieldTypeString, alias: Repair, editable: true, nullable: false, length: 5, defaultValue: No, modelName: repair , Coded Values: [Yes: Yes] , [No: No] )
• replace ( type: esriFieldTypeString, alias: Replacement, editable: true, nullable: false, length: 5, defaultValue: No, modelName: replace , Coded Values: [Yes: Yes] , [No: No] )
• expand ( type: esriFieldTypeString, alias: Expansion, editable: true, nullable: false, length: 5, defaultValue: No, modelName: expand , Coded Values: [Yes: Yes] , [No: No] )
• efficient ( type: esriFieldTypeString, alias: Efficiency, editable: true, nullable: false, length: 5, defaultValue: No, modelName: efficient , Coded Values: [Yes: Yes] , [No: No] )
• fiscalyr ( type: esriFieldTypeString, alias: Fiscal Year, editable: true, nullable: false, length: 10, defaultValue: null, modelName: fiscalyr )
• fundsource ( type: esriFieldTypeString, alias: Funding Source, editable: true, nullable: false, length: 50, defaultValue: null, modelName: fundsource , Coded Values: [American Rescue Plan Act: American Rescue Plan Act] , [CBD DRI: CBD DRI] , [Community Investment Taxes: Community Investment Taxes] , ...23 more... )
• planstart ( type: esriFieldTypeDate, alias: Planned Start Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: planstart )
• planend ( type: esriFieldTypeDate, alias: Planned End Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: planend )
• estcost ( type: esriFieldTypeDouble, alias: Estimated Cost, editable: true, nullable: false, defaultValue: 0, modelName: estcost )
• pocname ( type: esriFieldTypeString, alias: Contact Name, editable: true, nullable: false, length: 255, defaultValue: null, modelName: pocname )
• pocphone ( type: esriFieldTypeString, alias: Contact Phone, editable: true, nullable: false, length: 12, defaultValue: null, modelName: pocphone )
• pocemail ( type: esriFieldTypeString, alias: Contact Email, editable: true, nullable: false, length: 255, defaultValue: null, modelName: pocemail )
• funded ( type: esriFieldTypeString, alias: Funded Project, editable: true, nullable: false, length: 5, defaultValue: No, modelName: funded , Coded Values: [Yes: Yes] , [No: No] )
• projphase ( type: esriFieldTypeString, alias: Project Phase, editable: true, nullable: false, length: 100, defaultValue: null, modelName: projphase , Coded Values: [P1: Planning: P1: Planning] , [P2: Design: P2: Design] , [P3: Procurement: P3: Procurement] , ...2 more... )
• actstart ( type: esriFieldTypeDate, alias: Actual Start Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: actstart )
• actend ( type: esriFieldTypeDate, alias: Actual End Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: actend )
• actcost ( type: esriFieldTypeDouble, alias: Actual Cost, editable: true, nullable: true, defaultValue: 0, modelName: actcost )
• status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: false, length: 1000, defaultValue: null, modelName: status , Coded Values: [Planning: Planning] , [30% Design Completion: 30% Design Completion] , [60% Design Completion: 60% Design Completion] , ...12 more... )
• docpath ( type: esriFieldTypeString, alias: Project Detail URL, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: docpath )
• CreationDate ( type: esriFieldTypeDate, alias: Creation Date, editable: true, nullable: true, length: 8, defaultValue: -2209161600000, modelName: CreationDate )
• Creator ( type: esriFieldTypeString, alias: Creator, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Creator )
• EditDate ( type: esriFieldTypeDate, alias: Edit Date, editable: true, nullable: true, length: 8, defaultValue: -2209161600000, modelName: EditDate )
• Editor ( type: esriFieldTypeString, alias: Editor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Editor )
• MultiYear ( type: esriFieldTypeString, alias: Multi Year Project, editable: true, nullable: false, length: 5, defaultValue: No, modelName: MultiYear , Coded Values: [Yes: Yes] , [No: No] )
• NumVotes ( type: esriFieldTypeSmallInteger, alias: Number of Votes, editable: true, nullable: true, defaultValue: null, modelName: NumVotes )
• ShowPublic ( type: esriFieldTypeString, alias: Show Public, editable: true, nullable: false, length: 5, defaultValue: No, modelName: ShowPublic , Coded Values: [Yes: Yes] , [No: No] )
• EBO ( type: esriFieldTypeDouble, alias: EBO Goal Set, editable: true, nullable: true, defaultValue: null, modelName: EBO )
• JobsCreated ( type: esriFieldTypeSmallInteger, alias: Jobs Created, editable: true, nullable: true, defaultValue: null, modelName: JobsCreated )
• Neighborhood ( type: esriFieldTypeString, alias: Neighborhood, editable: true, nullable: true, length: 200, defaultValue: null, modelName: Neighborhood )
• Council ( type: esriFieldTypeString, alias: Council, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Council )
• EBOAttained ( type: esriFieldTypeDouble, alias: EBO Goal Attained, editable: true, nullable: true, defaultValue: null, modelName: EBOAttained )
• ContractNumber ( type: esriFieldTypeString, alias: Contract Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ContractNumber )
• ActivityStatus ( type: esriFieldTypeString, alias: Activity Status, editable: true, nullable: true, length: 500, defaultValue: null, modelName: ActivityStatus , Coded Values: [W1.1-Assignment of PA/PC: W1.1-Assignment of PA/PC] , [W1.2-Completion and submission of the draft PSF: W1.2-Completion and submission of the draft PSF] , [W1.3-Project name and funding verification: W1.3-Project name and funding verification] , ...90 more... )
• ProjectSiteURL ( type: esriFieldTypeString, alias: Project Site URL, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: ProjectSiteURL )
• RelatedProject ( type: esriFieldTypeString, alias: Related Project, editable: true, nullable: true, length: 10, defaultValue: No, modelName: RelatedProject , Coded Values: [Yes: Yes] , [No: No] )
• MapScale ( type: esriFieldTypeDouble, alias: Map Scale, editable: true, nullable: true, defaultValue: 6000, modelName: MapScale )
• WMBESLBE ( type: esriFieldTypeDouble, alias: WMBE / SLBE Participation, editable: true, nullable: true, defaultValue: null, modelName: WMBESLBE )
• ProjectNumerical ( type: esriFieldTypeInteger, alias: Project Numerical, editable: true, nullable: true, defaultValue: null, modelName: ProjectNumerical )
• DepPrjNum ( type: esriFieldTypeString, alias: Department Project Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DepPrjNum )
• BudgetBook ( type: esriFieldTypeString, alias: Budget Book, editable: true, nullable: true, length: 5, defaultValue: No, modelName: BudgetBook , Coded Values: [Yes: Yes] , [No: No] )
• BudgetYear ( type: esriFieldTypeSmallInteger, alias: Budget Year, editable: true, nullable: true, defaultValue: null, modelName: BudgetYear )
• CRA ( type: esriFieldTypeString, alias: Community Redevelopment Area, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CRA )
• FundComm ( type: esriFieldTypeString, alias: Funding Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FundComm )

Templates:

• Name: Capital Projects
  Description:
  Prototype:
  CRA: null
  BudgetYear: null
  FundComm: null
  projid:
  projname:
  projdesc:
  rationale:
  projtype:
  safety: No
  mandate: No
  repair: No
  replace: No
  expand: No
  efficient: No
  fiscalyr:
  fundsource:
  planstart: null
  planend: null
  estcost: 0
  pocname:
  pocphone:
  pocemail:
  funded: No
  projphase:
  actstart: null
  actend: null
  actcost: 0
  status:
  docpath: null
  CreationDate: -2209161600000
  Creator: null
  EditDate: -2209161600000
  Editor: null
  MultiYear: No
  NumVotes: null
  ShowPublic: No
  EBO: null
  JobsCreated: null
  Neighborhood: null
  Council: null
  EBOAttained: null
  ContractNumber: null
  ActivityStatus: null
  ProjectSiteURL: null
  RelatedProject: No
  MapScale: 6000
  WMBESLBE: null
  ProjectNumerical: null
  DepPrjNum: null
  BudgetBook: No
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Analytic   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata