View In:   ArcGIS Online Map Viewer

Name: CAMA Parcels Land Values

Display Field: parcelid

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:
Class Breaks Renderer:
Field: lndvalue
Min. Value: 0.0
ClassBreakInfos:
• Class Maximum Value: 0
  Label: No Value/Unknown
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [255, 252, 255, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Class Maximum Value: 1000
  Label: $1 - $1,000
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [255, 206, 255, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Class Maximum Value: 5000
  Label: $1,001 - $5,000
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [255, 160, 255, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Class Maximum Value: 10000
  Label: $5,001 - $10,000
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [255, 111, 255, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Class Maximum Value: 20000
  Label: $10,001 -$20,000
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [255, 53, 255, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Class Maximum Value: 30000
  Label: $20,001 - $30,000
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [229, 0, 255, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Class Maximum Value: 40000
  Label: $30,001 - $40,000
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [184, 0, 255, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Class Maximum Value: 50000
  Label: $40,001 - $50,000
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [137, 0, 255, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Class Maximum Value: 60000
  Label: $50,001 - $60,000
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [84, 0, 255, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Class Maximum Value: 70000
  Label: $60,001 - $70,000
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [17, 20, 255, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Class Maximum Value: 80000
  Label: $70,001 - $80,000
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [48, 77, 255, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Class Maximum Value: 90000
  Label: $80,001 - $90,000
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [58, 127, 255, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Class Maximum Value: 100000
  Label: $90,001 - $100,000
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [55, 181, 255, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Class Maximum Value: 125000
  Label: $100,001 - $125,000
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [29, 238, 255, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Class Maximum Value: 150000
  Label: $125,001 - $150,000
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [36, 255, 217, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Class Maximum Value: 175000
  Label: $150,001 - $175,000
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [47, 255, 165, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Class Maximum Value: 200000
  Label: $175,000 - $200,000
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [45, 255, 116, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Class Maximum Value: 250000
  Label: $200,001 - $250,000
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [32, 255, 64, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Class Maximum Value: 300000
  Label: $250,001 - $300,000
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [45, 255, 0, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Class Maximum Value: 350000
  Label: $300,001 - $350,000
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [110, 255, 0, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Class Maximum Value: 400000
  Label: $350,001 - $400,000
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [159, 255, 0, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Class Maximum Value: 450000
  Label: $400,001 - $450,000
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [205, 255, 0, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Class Maximum Value: 500000
  Label: $450,001 - $500,000
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [249, 255, 0, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Class Maximum Value: 600000
  Label: $500,001 - $600,000
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [255, 230, 0, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Class Maximum Value: 700000
  Label: $600,001 - $700,000
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [255, 201, 0, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Class Maximum Value: 800000
  Label: $700,001 - $800,000
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [255, 172, 0, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Class Maximum Value: 900000
  Label: $800,001 - $900,000
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [255, 144, 0, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Class Maximum Value: 1000000
  Label: $900,001 - $1,000,000
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [241, 115, 0, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Class Maximum Value: 1250000
  Label: $1,000,001 - $1,250,000
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [211, 87, 0, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Class Maximum Value: 1500000
  Label: $1,250,001 - $1,500,000
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [182, 61, 0, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Class Maximum Value: 2000000
  Label: $1,500,001 - $2,000,00
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [154, 36, 0, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Class Maximum Value: 20000000000
  Label: $2,000,001+
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [127, 0, 0, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
Transparency: 11
Labeling Info:

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:

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 )

Templates:

• Name: New Feature
  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