View In:   ArcGIS Online Map Viewer

Name: Vacant CAMA Parcels

Display Field: assessornum

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description: <p style='box-sizing:border-box; margin-top:0px; margin-bottom:10.5px; max-width:100%; font-family:&quot;Avenir Next&quot;, &quot;Avenir Next&quot;; font-size:14px;'></p><p style='margin-bottom:7.9pt; background:white;'><b><span style='font-size:12.0pt; font-family:&quot;Tw Cen MT&quot;,sans-serif; color:#4C4C4C;'>Tax Parcel polygons joined to tabular data from CAMA system</span></b></p> <p style='margin-bottom:0in; background:white;'><span style='font-size:12.0pt; font-family:&quot;Tw Cen MT&quot;,sans-serif; color:#4C4C4C;'>A view of divisions of land for the sole purposes of equitable taxation, combined with assessing information from CAMA system, combined with sales records.</span></p> <p style='margin-bottom:0in; background:white;'><span style='font-size:12.0pt; font-family:&quot;Tw Cen MT&quot;,sans-serif; color:#4C4C4C;'>This is the instrumental feature layer that services the Sales Finder Application.</span></p><p style='margin-bottom:0in; background:white;'><span style='font-family:&quot;Tw Cen MT&quot;, sans-serif; font-size:12pt;'>This feature layer has been added to the Enterprise Portal from its </span><b>AGOL</b><span style='font-family:&quot;Tw Cen MT&quot;, sans-serif; font-size:12pt;'> URL.</span></p> <p style='margin-bottom:0in; background:white;'><b><span style='font-size:12.0pt; font-family:&quot;Tw Cen MT&quot;,sans-serif; color:red;'>DO NOT DELETE THIS ITEM!!</span></b></p> <p style='margin-bottom:0in; background:white;'><span style='font-family:&quot;Tw Cen MT&quot;, sans-serif;'>This file geodatabase contains two feature classes: </span><br /></p> <ul> <li><u><span style='font-family:&quot;Tw Cen MT&quot;,sans-serif;'>Lucas_Parcels_CAMA</span></u><span style='font-family:&quot;Tw Cen MT&quot;,sans-serif;'> (polygon): information from .dbo.OHLUC_CAMA table joined to <b>CADASTRE </b>dataset's Parcels geometry. Table created by LCIS expressly for this purpose with CAMA data from LEGDAT, OWNDAT, and PARDAT tables.</span></li> <li><u><span style='font-family:&quot;Tw Cen MT&quot;,sans-serif;'>Lucas Sales</span></u><span style='font-family:&quot;Tw Cen MT&quot;,sans-serif;'> (point): CAMA data from PARDAT and SALES tables</span><span style='font-size:11.5pt; font-family:&quot;Tw Cen MT&quot;,sans-serif;'>.</span></li> </ul> <p style='margin-bottom:0in; background:white;'><span style='font-family:&quot;Tw Cen MT&quot;, sans-serif;'>Geodatabase is updated weekly, on Sunday evenings with an ETL script &quot;JoinstoGDB_OverwriteAGOL.py&quot; currently located on test machine. Script written by Esri Technical Consultant, Richard L'Esperance</span></p> <p style='margin-bottom:0in; background:white;'><span style='font-family:&quot;Tw Cen MT&quot;,sans-serif; color:#4C4C4C;'>As of  12/14/2021:</span></p> <ul> <li><span style='font-family:&quot;Tw Cen MT&quot;,sans-serif;'>basePath = E:\CamaLayerUpdate</span></li> <li><span style='font-family:&quot;Tw Cen MT&quot;,sans-serif;'>SDE  = basePath, sqlserv1-vm_Lucas_GIS.sde</span></li> <li><span style='font-family:&quot;Tw Cen MT&quot;,sans-serif;'>Parcels = SDE, GIS.Parcels&lt;</span></li> <li><span style='font-family:&quot;Tw Cen MT&quot;,sans-serif;'>CAMA = SDE, DBO.OHLUC_CAMA</span></li> <li><span style='font-family:&quot;Tw Cen MT&quot;,sans-serif;'>Sales = SDE, DBO.OHLUC_Sales</span></li> </ul> <p style='margin-bottom:0in; background:white;'><span style='font-family:&quot;Tw Cen MT&quot;, sans-serif; font-size:10pt;'>Base paths and data source subject to change; notification will be given. </span><br /></p> <p style='margin-bottom:0in; background:white;'><b><span style='font-size:12pt; font-family:&quot;Tw Cen MT&quot;, sans-serif; color:red; background-image:initial; background-position:initial; background-size:initial; background-repeat:initial; background-attachment:initial; background-origin:initial; background-clip:initial;'>DO NOT DELETE THIS FILE GEODATABASE!!!</span></b><br /></p>

Service Item Id: 18c01e27ce2f4880b427432072c11faf

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 50000.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: -9337830.1883
YMin: 5073743.5320999995
XMax: -9250734.2488
YMax: 5125391.856899999
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: usedc
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 110
  Label: Vacant CAUV
  Description: N/A
  Symbol:
  Style: esriSFSBackwardDiagonal
  Color: [168, 168, 0, 255]
  Outline:
  Style: esriSLSSolid
  Color: [168, 168, 0, 255]
  Width: 1
• Value: 100
  Label: Vacant Agriculture
  Description: N/A
  Symbol:
  Style: esriSFSBackwardDiagonal
  Color: [56, 168, 0, 255]
  Outline:
  Style: esriSLSSolid
  Color: [56, 168, 0, 255]
  Width: 1
• Value: 300
  Label: Vacant Industrial
  Description: N/A
  Symbol:
  Style: esriSFSBackwardDiagonal
  Color: [230, 0, 0, 255]
  Outline:
  Style: esriSLSSolid
  Color: [230, 0, 0, 255]
  Width: 1
• Value: 400
  Label: Vacant Commercial
  Description: N/A
  Symbol:
  Style: esriSFSBackwardDiagonal
  Color: [0, 77, 168, 255]
  Outline:
  Style: esriSLSSolid
  Color: [0, 77, 168, 255]
  Width: 1
• Value: 500
  Label: Vacant Residential
  Description: N/A
  Symbol:
  Style: esriSFSBackwardDiagonal
  Color: [0, 0, 0, 255]
  Outline:
  Style: esriSLSSolid
  Color: [0, 0, 0, 255]
  Width: 1
• Value: 501
  Label: Vacant Residential
  Description: N/A
  Symbol:
  Style: esriSFSBackwardDiagonal
  Color: [0, 0, 0, 255]
  Outline:
  Style: esriSLSSolid
  Color: [0, 0, 0, 255]
  Width: 1
• Value: 502
  Label: Vacant Residential
  Description: N/A
  Symbol:
  Style: esriSFSBackwardDiagonal
  Color: [0, 0, 0, 255]
  Outline:
  Style: esriSLSSolid
  Color: [0, 0, 0, 255]
  Width: 1
Transparency: 0
Labeling Info:
Label Placement: esriServerPolygonPlacementAlwaysHorizontal
Label Expression: N/A
Use Coded Values: true
Symbol:
Color: [0, 0, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 12
Font Family: Tw Cen MT
Font Style: normal
Font Weight: bold
Font Decoration: none

Min. Scale: 1500.0
Max. Scale: 0.0

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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: true
Supports Query With LOD Spatial Reference: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: usedc

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: objectid, alias: OBJECTID )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, modelName: GlobalID, alias: GlobalID )
• parcelid ( modelName: parcelid, nullable: true, editable: true, defaultValue: null, length: 30, alias: PARCELID, type: esriFieldTypeString )
• assessornum ( modelName: assessornum, nullable: true, editable: true, defaultValue: null, length: 30, alias: ASSESSORNUM, type: esriFieldTypeString )
• statedarea ( modelName: statedarea, nullable: true, editable: true, defaultValue: null, alias: STATEDAREA, type: esriFieldTypeDouble )
• cvttxcd ( modelName: cvttxcd, nullable: true, editable: true, defaultValue: null, length: 5, alias: CVTTXCD, type: esriFieldTypeString )
• cvttxdscrp ( modelName: cvttxdscrp, nullable: true, editable: true, defaultValue: null, length: 40, alias: CVTTXDSCRP, type: esriFieldTypeString )
• usedc ( modelName: usedc, nullable: true, editable: true, defaultValue: null, length: 40, alias: USEDC, type: esriFieldTypeString )
• usedscrp ( modelName: usedscrp, nullable: true, editable: true, defaultValue: null, length: 40, alias: USEDSCRP, type: esriFieldTypeString )
• nghbrhdcd ( modelName: nghbrhdcd, nullable: true, editable: true, defaultValue: null, length: 8, alias: NGHBRHDCD, type: esriFieldTypeString )
• classcd ( modelName: classcd, nullable: true, editable: true, defaultValue: null, length: 4, alias: CLASSCD, type: esriFieldTypeString )
• classdscrp ( modelName: classdscrp, nullable: true, editable: true, defaultValue: null, length: 40, alias: CLASSDSCRP, type: esriFieldTypeString )
• siteaddress ( modelName: siteaddress, nullable: true, editable: true, defaultValue: null, length: 364, alias: SITEADDRESS, type: esriFieldTypeString )
• sitecity ( modelName: sitecity, nullable: true, editable: true, defaultValue: null, length: 50, alias: SITECITY, type: esriFieldTypeString )
• sitezip ( modelName: sitezip, nullable: true, editable: true, defaultValue: null, length: 10, alias: SITEZIP, type: esriFieldTypeString )
• prprtydscrp ( modelName: prprtydscrp, nullable: true, editable: true, defaultValue: null, alias: SPECIALUSE, type: esriFieldTypeDouble )
• cnvyname ( modelName: cnvyname, nullable: true, editable: true, defaultValue: null, length: 60, alias: LEGALDSRCRP, type: esriFieldTypeString )
• ownernme1 ( modelName: ownernme1, nullable: true, editable: true, defaultValue: null, length: 205, alias: OWNERNME1, type: esriFieldTypeString )
• ownernme2 ( modelName: ownernme2, nullable: true, editable: true, defaultValue: null, length: 205, alias: OWNERNME2, type: esriFieldTypeString )
• lndvalue ( modelName: lndvalue, nullable: true, editable: true, defaultValue: null, alias: LNDVALUE, type: esriFieldTypeDouble )
• bldgvalue ( modelName: bldgvalue, nullable: true, editable: true, defaultValue: null, alias: BLDGVALUE, type: esriFieldTypeDouble )
• totalvalue ( modelName: totalvalue, nullable: true, editable: true, defaultValue: null, alias: TOTALVALUE, type: esriFieldTypeDouble )
• waterserv ( modelName: waterserv, nullable: true, editable: true, defaultValue: null, length: 4, alias: WATERSERV, type: esriFieldTypeString )
• sewerserv ( modelName: sewerserv, nullable: true, editable: true, defaultValue: null, length: 6, alias: SEWERSERV, type: esriFieldTypeString )
• zoning ( modelName: zoning, nullable: true, editable: true, defaultValue: null, length: 8, alias: ZONING, type: esriFieldTypeString )
• zoning_desc ( modelName: zoning_desc, nullable: true, editable: true, defaultValue: null, length: 40, alias: ZONING_DESC, type: esriFieldTypeString )
• grade ( modelName: grade, nullable: true, editable: true, defaultValue: null, alias: GRADE, type: esriFieldTypeDouble )
• grade_desc ( modelName: grade_desc, nullable: true, editable: true, defaultValue: null, length: 30, alias: GRADE_DESC, type: esriFieldTypeString )
• cond ( modelName: cond, nullable: true, editable: true, defaultValue: null, alias: COND, type: esriFieldTypeDouble )
• cond_desc ( modelName: cond_desc, nullable: true, editable: true, defaultValue: null, length: 40, alias: COND_DESC, type: esriFieldTypeString )
• style ( modelName: style, nullable: true, editable: true, defaultValue: null, alias: STYLE, type: esriFieldTypeDouble )
• style_desc ( modelName: style_desc, nullable: true, editable: true, defaultValue: null, length: 40, alias: STYLE_DESC, type: esriFieldTypeString )
• SHAPE__Length ( virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Length, type: esriFieldTypeDouble )
• SHAPE__Area ( virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Area, type: esriFieldTypeDouble )

Types:

ID: 110
Name: Vacant CAUV
Domains:
Templates:
• Name: 110
  Description:
  Prototype:
  siteaddress: null
  classdscrp: null
  cnvyname: null
  ownernme2: null
  nghbrhdcd: null
  ownernme1: null
  sewerserv: null
  cond: null
  style_desc: null
  parcelid: null
  sitezip: null
  bldgvalue: null
  zoning_desc: null
  zoning: null
  cond_desc: null
  totalvalue: null
  usedc: null
  cvttxdscrp: null
  waterserv: null
  assessornum: null
  statedarea: null
  usedscrp: null
  lndvalue: null
  grade_desc: null
  prprtydscrp: null
  sitecity: null
  grade: null
  classcd: null
  style: null
  cvttxcd: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

ID: 100
Name: Vacant Agriculture
Domains:
Templates:
• Name: 100
  Description:
  Prototype:
  siteaddress: null
  classdscrp: null
  cnvyname: null
  ownernme2: null
  nghbrhdcd: null
  ownernme1: null
  sewerserv: null
  cond: null
  style_desc: null
  parcelid: null
  sitezip: null
  bldgvalue: null
  zoning_desc: null
  zoning: null
  cond_desc: null
  totalvalue: null
  usedc: null
  cvttxdscrp: null
  waterserv: null
  assessornum: null
  statedarea: null
  usedscrp: null
  lndvalue: null
  grade_desc: null
  prprtydscrp: null
  sitecity: null
  grade: null
  classcd: null
  style: null
  cvttxcd: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

ID: 300
Name: Vacant Industrial
Domains:
Templates:
• Name: 300
  Description:
  Prototype:
  siteaddress: null
  classdscrp: null
  cnvyname: null
  ownernme2: null
  nghbrhdcd: null
  ownernme1: null
  sewerserv: null
  cond: null
  style_desc: null
  parcelid: null
  sitezip: null
  bldgvalue: null
  zoning_desc: null
  zoning: null
  cond_desc: null
  totalvalue: null
  usedc: null
  cvttxdscrp: null
  waterserv: null
  assessornum: null
  statedarea: null
  usedscrp: null
  lndvalue: null
  grade_desc: null
  prprtydscrp: null
  sitecity: null
  grade: null
  classcd: null
  style: null
  cvttxcd: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

ID: 400
Name: Vacant Commercial
Domains:
Templates:
• Name: 400
  Description:
  Prototype:
  siteaddress: null
  classdscrp: null
  cnvyname: null
  ownernme2: null
  nghbrhdcd: null
  ownernme1: null
  sewerserv: null
  cond: null
  style_desc: null
  parcelid: null
  sitezip: null
  bldgvalue: null
  zoning_desc: null
  zoning: null
  cond_desc: null
  totalvalue: null
  usedc: null
  cvttxdscrp: null
  waterserv: null
  assessornum: null
  statedarea: null
  usedscrp: null
  lndvalue: null
  grade_desc: null
  prprtydscrp: null
  sitecity: null
  grade: null
  classcd: null
  style: null
  cvttxcd: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

ID: 500
Name: Vacant Residential
Domains:
Templates:
• Name: 500
  Description:
  Prototype:
  siteaddress: null
  classdscrp: null
  cnvyname: null
  ownernme2: null
  nghbrhdcd: null
  ownernme1: null
  sewerserv: null
  cond: null
  style_desc: null
  parcelid: null
  sitezip: null
  bldgvalue: null
  zoning_desc: null
  zoning: null
  cond_desc: null
  totalvalue: null
  usedc: null
  cvttxdscrp: null
  waterserv: null
  assessornum: null
  statedarea: null
  usedscrp: null
  lndvalue: null
  grade_desc: null
  prprtydscrp: null
  sitecity: null
  grade: null
  classcd: null
  style: null
  cvttxcd: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

ID: 501
Name: Vacant Residential
Domains:
Templates:
• Name: 501
  Description:
  Prototype:
  siteaddress: null
  classdscrp: null
  cnvyname: null
  ownernme2: null
  nghbrhdcd: null
  ownernme1: null
  sewerserv: null
  cond: null
  style_desc: null
  parcelid: null
  sitezip: null
  bldgvalue: null
  zoning_desc: null
  zoning: null
  cond_desc: null
  totalvalue: null
  usedc: null
  cvttxdscrp: null
  waterserv: null
  assessornum: null
  statedarea: null
  usedscrp: null
  lndvalue: null
  grade_desc: null
  prprtydscrp: null
  sitecity: null
  grade: null
  classcd: null
  style: null
  cvttxcd: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

ID: 502
Name: Vacant Residential
Domains:
Templates:
• Name: 502
  Description:
  Prototype:
  siteaddress: null
  classdscrp: null
  cnvyname: null
  ownernme2: null
  nghbrhdcd: null
  ownernme1: null
  sewerserv: null
  cond: null
  style_desc: null
  parcelid: null
  sitezip: null
  bldgvalue: null
  zoning_desc: null
  zoning: null
  cond_desc: null
  totalvalue: null
  usedc: null
  cvttxdscrp: null
  waterserv: null
  assessornum: null
  statedarea: null
  usedscrp: null
  lndvalue: null
  grade_desc: null
  prprtydscrp: null
  sitecity: null
  grade: null
  classcd: null
  style: null
  cvttxcd: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

Capabilities: Query,Sync

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Calculate   Validate SQL   Generate Renderer   Return Updates   Metadata