| 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> |