Name: City Properties

Display Field: Owner_Name

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description: SQL Code running on schedule -use [Assessor]GOIF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Assessor].[dbo].[CITY_PROPERTIES]') AND type in (N'U'))TRUNCATE TABLE [Assessor].[dbo].[CITY_PROPERTIES]GOInsert into [Assessor].[dbo].[CITY_PROPERTIES]/****** Script for SelectTopNRows command from SSMS ******/SELECT [OBJECTID] ,[Shape] ,[GDB_GEOMATTR_DATA] ,[Parcel_ID] ,[LRSN] ,[Site_House_Number] ,[Site_Address] ,[Site_City] ,[Site_Zip] ,[Owner_Name] ,[Tax_Payer_Name] ,[Mail_Add] ,[Mail_City] ,[TAXPRSTATE] ,[TAXPRZIP] ,[Landuse] ,[Xempt] ,[Total_Value_Regular] ,[Market_Total_Value] ,[MK_Imp] ,[MK_Lnd] ,[CUIMP] ,[CULND] ,[Neighborhood_Code] ,[TCA_Number] ,[PDF_Parcel_Map] ,[TIF_Parcel_Map] ,[Neighborhood_Sales_Search] ,[Property_Account_Summary] ,[Building_Photo] ,[Township_Number] ,[Range_Number] ,[Quarter_Number] ,[Description] ,[Acres_Gross] ,[Area_SF] ,[CREATEDATE] ,[CORRDATE] ,[RETIREDATE] ,[Last_Download] ,[Parcel_Status] ,[Parcel_Source] ,[Legal_Description] ,[PAR_OID] ,[TAX_YEAR] ,[COMMENT] ,[X_COORD] ,[Y_COORD] ,[Parcel_ID_Concatenated] ,[Site_House_Number_Concatenated] ,[Site_Address_Concatenated] ,[Stacked_Parcel] ,[Stacked_Label] FROM [Assessor].[dbo].[SNOCO_ALL_PARCELS] where Owner_Name IN ('CITY OF MARYSVILLE','MARYSVILLE CITY OF') OR Owner_Name LIKE '%MARYSVILLE FIRE%' AND Owner_Name not like '%school%'

Service Item Id: 753ce641c2c24c82b48327568be4be9d

Copyright Text:

Default Visibility: true

Max Result Window: N/A

Max Record Count: 2000

Standard Max Record Count No Geometry: 32000

Max Record Count Factor: 1

Standard MaxRecord Count: 4000

Tile Max Record Count: 4000

MaxSelectionCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: true

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: NaN
YMin: NaN
XMax: NaN
YMax: NaN
Spatial Reference: 102748  (2285)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSFSSolid
Color: [204, 204, 204, 255]
Outline:
Style: esriSLSNull
Color: [110, 110, 110, 0]
Width: 0
Label: N/A
Description: N/A
Transparency: 35
Labeling Info:

Feature Draw Order:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports Result Pagination Token: false
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: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Cache Hint: false
Supports Query With Current User: true
Supports Query With Result Type: true

HasZ: false

HasM: false

Has Attachments: false

Has Last Edit Time: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: N/A

Fields:

• OBJECTID ( nullable: false, alias: OBJECTID, type: esriFieldTypeOID )
• Shape ( nullable: true, alias: SHAPE, type: esriFieldTypeGeometry )
• Parcel_ID ( nullable: true, length: 14, alias: Parcel_ID, type: esriFieldTypeString )
• LRSN ( nullable: true, alias: LRSN, type: esriFieldTypeInteger )
• Site_House_Number ( nullable: true, length: 20, alias: Site_House_Number, type: esriFieldTypeString )
• Site_Address ( nullable: true, length: 200, alias: Site_Address, type: esriFieldTypeString )
• Site_City ( nullable: true, length: 200, alias: Site_City, type: esriFieldTypeString )
• Site_Zip ( nullable: true, length: 20, alias: Site_Zip, type: esriFieldTypeString )
• Owner_Name ( nullable: true, length: 200, alias: Owner_Name, type: esriFieldTypeString )
• Tax_Payer_Name ( nullable: true, length: 200, alias: Tax_Payer_Name, type: esriFieldTypeString )
• Mail_Add ( nullable: true, length: 60, alias: Mail_Add, type: esriFieldTypeString )
• Mail_City ( nullable: true, length: 102, alias: Mail_City, type: esriFieldTypeString )
• TAXPRSTATE ( nullable: true, length: 20, alias: TAXPRSTATE, type: esriFieldTypeString )
• TAXPRZIP ( nullable: true, length: 20, alias: TAXPRZIP, type: esriFieldTypeString )
• Landuse ( nullable: true, length: 60, alias: Landuse, type: esriFieldTypeString )
• Xempt ( nullable: true, length: 128, alias: Xempt, type: esriFieldTypeString )
• Total_Value_Regular ( nullable: true, length: 20, alias: Total_Value_Regular, type: esriFieldTypeString )
• Market_Total_Value ( nullable: true, length: 20, alias: Market_Total_Value, type: esriFieldTypeString )
• MK_Imp ( nullable: true, length: 30, alias: MK_Imp, type: esriFieldTypeString )
• MK_Lnd ( nullable: true, length: 30, alias: MK_Lnd, type: esriFieldTypeString )
• CUIMP ( nullable: true, alias: CUIMP, type: esriFieldTypeInteger )
• CULND ( nullable: true, alias: CULND, type: esriFieldTypeInteger )
• Neighborhood_Code ( nullable: true, length: 8, alias: Neighborhood_Code, type: esriFieldTypeString )
• TCA_Number ( nullable: true, length: 200, alias: TCA_Number, type: esriFieldTypeString )
• PDF_Parcel_Map ( nullable: true, length: 200, alias: PDF_Parcel_Map, type: esriFieldTypeString )
• TIF_Parcel_Map ( nullable: true, length: 200, alias: TIF_Parcel_Map, type: esriFieldTypeString )
• Neighborhood_Sales_Search ( nullable: true, length: 200, alias: Neighborhood_Sales_Search, type: esriFieldTypeString )
• Property_Account_Summary ( nullable: true, length: 200, alias: Property_Account_Summary, type: esriFieldTypeString )
• Building_Photo ( nullable: true, length: 200, alias: Building_Photo, type: esriFieldTypeString )
• Township_Number ( nullable: true, length: 2, alias: Township_Number, type: esriFieldTypeString )
• Range_Number ( nullable: true, length: 2, alias: Range_Number, type: esriFieldTypeString )
• Quarter_Number ( nullable: true, length: 1, alias: Quarter_Number, type: esriFieldTypeString )
• Description ( nullable: true, length: 30, alias: Description, type: esriFieldTypeString )
• Acres_Gross ( nullable: true, length: 30, alias: Acres_Gross, type: esriFieldTypeString )
• Area_SF ( nullable: true, alias: Area_SF, type: esriFieldTypeDouble )
• CREATEDATE ( nullable: true, length: 8, alias: CREATEDATE, type: esriFieldTypeDate )
• CORRDATE ( nullable: true, length: 8, alias: CORRDATE, type: esriFieldTypeDate )
• RETIREDATE ( nullable: true, length: 8, alias: RETIREDATE, type: esriFieldTypeDate )
• Last_Download ( nullable: false, length: 8, alias: Last_Download, type: esriFieldTypeDate )
• Parcel_Status ( nullable: true, length: 50, alias: Parcel_Status, type: esriFieldTypeString )
• Parcel_Source ( nullable: false, length: 500, alias: Parcel_Source, type: esriFieldTypeString )
• Legal_Description ( nullable: true, length: 1073741822, alias: Legal_Description, type: esriFieldTypeString )
• PAR_OID ( nullable: true, length: 50, alias: PAR_OID, type: esriFieldTypeString )
• TAX_YEAR ( nullable: true, length: 8, alias: TAX_YEAR, type: esriFieldTypeString )
• COMMENT ( nullable: true, length: 254, alias: COMMENT, type: esriFieldTypeString )
• X_COORD ( nullable: true, alias: X_COORD, type: esriFieldTypeDouble )
• Y_COORD ( nullable: true, alias: Y_COORD, type: esriFieldTypeDouble )
• Parcel_ID_Concatenated ( nullable: true, length: 1000, alias: Parcel_ID_Concatenated, type: esriFieldTypeString )
• Site_House_Number_Concatenated ( nullable: true, length: 1000, alias: Site_House_Number_Concatenated, type: esriFieldTypeString )
• Site_Address_Concatenated ( nullable: true, length: 1000, alias: Site_Address_Concatenated, type: esriFieldTypeString )
• Stacked_Parcel ( nullable: true, length: 20, alias: Stacked_Parcel, type: esriFieldTypeString )
• Stacked_Label ( nullable: true, length: 20, alias: Stacked_Label, type: esriFieldTypeString )
• Shape.STArea() ( nullable: true, alias: Shape.STArea(), type: esriFieldTypeDouble )
• Shape.STLength() ( nullable: true, alias: Shape.STLength(), type: esriFieldTypeDouble )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata