20250121 14572500 1.0 TRUE 150000000 5000 ItemDescription Updated weekly on scheduled sql agent job <DIV STYLE="text-align:Left;"><DIV><DIV>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%'</DIV></DIV></DIV> City Owned parcels 20250513