{
 "snippet": "Updated weekly on scheduled sql agent job",
 "summary": "Updated weekly on scheduled sql agent job",
 "accessInformation": "",
 "thumbnail": "",
 "maxScale": 5000,
 "typeKeywords": [],
 "description": "<DIV STYLE=\"text-align:Left;\"><DIV><DIV><P><SPAN>SQL Code running on schedule -<\/SPAN><\/P><P><SPAN>use [Assessor]<\/SPAN><\/P><P><SPAN>GO<\/SPAN><\/P><P><SPAN>IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Assessor].[dbo].[CITY_PROPERTIES]') AND type in (N'U'))<\/SPAN><\/P><P><SPAN>TRUNCATE TABLE [Assessor].[dbo].[CITY_PROPERTIES]<\/SPAN><\/P><P><SPAN>GO<\/SPAN><\/P><P><SPAN>Insert into [Assessor].[dbo].[CITY_PROPERTIES]<\/SPAN><\/P><P><SPAN>/****** Script for SelectTopNRows command from SSMS  ******/<\/SPAN><\/P><P><SPAN>SELECT [OBJECTID]<\/SPAN><\/P><P><SPAN>      ,[Shape]<\/SPAN><\/P><P><SPAN>      ,[GDB_GEOMATTR_DATA]<\/SPAN><\/P><P><SPAN>      ,[Parcel_ID]<\/SPAN><\/P><P><SPAN>      ,[LRSN]<\/SPAN><\/P><P><SPAN>      ,[Site_House_Number]<\/SPAN><\/P><P><SPAN>      ,[Site_Address]<\/SPAN><\/P><P><SPAN>      ,[Site_City]<\/SPAN><\/P><P><SPAN>      ,[Site_Zip]<\/SPAN><\/P><P><SPAN>      ,[Owner_Name]<\/SPAN><\/P><P><SPAN>      ,[Tax_Payer_Name]<\/SPAN><\/P><P><SPAN>      ,[Mail_Add]<\/SPAN><\/P><P><SPAN>      ,[Mail_City]<\/SPAN><\/P><P><SPAN>      ,[TAXPRSTATE]<\/SPAN><\/P><P><SPAN>      ,[TAXPRZIP]<\/SPAN><\/P><P><SPAN>      ,[Landuse]<\/SPAN><\/P><P><SPAN>      ,[Xempt]<\/SPAN><\/P><P><SPAN>      ,[Total_Value_Regular]<\/SPAN><\/P><P><SPAN>      ,[Market_Total_Value]<\/SPAN><\/P><P><SPAN>      ,[MK_Imp]<\/SPAN><\/P><P><SPAN>      ,[MK_Lnd]<\/SPAN><\/P><P><SPAN>      ,[CUIMP]<\/SPAN><\/P><P><SPAN>      ,[CULND]<\/SPAN><\/P><P><SPAN>      ,[Neighborhood_Code]<\/SPAN><\/P><P><SPAN>      ,[TCA_Number]<\/SPAN><\/P><P><SPAN>      ,[PDF_Parcel_Map]<\/SPAN><\/P><P><SPAN>      ,[TIF_Parcel_Map]<\/SPAN><\/P><P><SPAN>      ,[Neighborhood_Sales_Search]<\/SPAN><\/P><P><SPAN>      ,[Property_Account_Summary]<\/SPAN><\/P><P><SPAN>      ,[Building_Photo]<\/SPAN><\/P><P><SPAN>      ,[Township_Number]<\/SPAN><\/P><P><SPAN>      ,[Range_Number]<\/SPAN><\/P><P><SPAN>      ,[Quarter_Number]<\/SPAN><\/P><P><SPAN>      ,[Description]<\/SPAN><\/P><P><SPAN>      ,[Acres_Gross]<\/SPAN><\/P><P><SPAN>      ,[Area_SF]<\/SPAN><\/P><P><SPAN>      ,[CREATEDATE]<\/SPAN><\/P><P><SPAN>      ,[CORRDATE]<\/SPAN><\/P><P><SPAN>      ,[RETIREDATE]<\/SPAN><\/P><P><SPAN>      ,[Last_Download]<\/SPAN><\/P><P><SPAN>      ,[Parcel_Status]<\/SPAN><\/P><P><SPAN>      ,[Parcel_Source]<\/SPAN><\/P><P><SPAN>      ,[Legal_Description]<\/SPAN><\/P><P><SPAN>      ,[PAR_OID]<\/SPAN><\/P><P><SPAN>      ,[TAX_YEAR]<\/SPAN><\/P><P><SPAN>      ,[COMMENT]<\/SPAN><\/P><P><SPAN>      ,[X_COORD]<\/SPAN><\/P><P><SPAN>      ,[Y_COORD]<\/SPAN><\/P><P><SPAN>      ,[Parcel_ID_Concatenated]<\/SPAN><\/P><P><SPAN>      ,[Site_House_Number_Concatenated]<\/SPAN><\/P><P><SPAN>      ,[Site_Address_Concatenated]<\/SPAN><\/P><P><SPAN>      ,[Stacked_Parcel]<\/SPAN><\/P><P><SPAN>      ,[Stacked_Label]<\/SPAN><\/P><P><SPAN>  FROM [Assessor].[dbo].[SNOCO_ALL_PARCELS]<\/SPAN><\/P><P><SPAN>  where Owner_Name IN ('CITY OF MARYSVILLE','MARYSVILLE CITY OF') OR Owner_Name LIKE '%MARYSVILLE FIRE%' AND Owner_Name not like '%school%'<\/SPAN><\/P><P><SPAN /><\/P><\/DIV><\/DIV><\/DIV>",
 "licenseInfo": "",
 "catalogPath": "",
 "title": "City Owned parcels",
 "type": "",
 "url": "",
 "tags": [],
 "culture": "en-US",
 "portalUrl": "",
 "name": "",
 "guid": "",
 "minScale": 150000000,
 "spatialReference": ""
}