{ "culture": "en-US", "name": "", "guid": "", "catalogPath": "", "snippet": "Development parcel", "description": "
Retrieved rows from the TRAKiT database and select from LR_PARCEL<\/SPAN><\/P> SELECT<\/SPAN><\/P> CASE WHEN STATUS = \u2018SEE PARENT PROJECT\u2019 THEN PARENT_PROJECT_NO<\/SPAN><\/P> ELSE PROJECT_NO<\/SPAN><\/P> END AS PROJECT_NUMBER,<\/SPAN><\/P> [PARENT_PROJECT_NO]<\/SPAN><\/P> ,[PROJECT_NO]<\/SPAN><\/P> ,[PROJECT_NAME]<\/SPAN><\/P> ,[PROJECTTYPE]<\/SPAN><\/P> ,[STATUS]<\/SPAN><\/P> ,[APPLICANT_NAME]<\/SPAN><\/P> ,[SITE_APN]<\/SPAN><\/P> ,[SITE_ADDR]<\/SPAN><\/P> ,[SITE_CITY]<\/SPAN><\/P> ,[SITE_STATE]<\/SPAN><\/P> ,[SITE_ZIP]<\/SPAN><\/P> ,[APPLIED]<\/SPAN><\/P> ,[APPROVED]<\/SPAN><\/P> ,[CLOSED]<\/SPAN><\/P> FROM [TRAKIT_prod].[dbo].[PROJECT_MAIN]<\/SPAN><\/P> WHERE STATUS IN (\u2018COMPLETE\u2019,\u2019ON HOLD',\u2018PENDING ASSIGNMENT\u2019,\u2019PENDING STATUS LTR', \u2018SEE PARENT PROJECT\u2019)<\/SPAN><\/P> AND APPLIED != \u20182012-01-01 00:00:00.000\u2019<\/SPAN><\/P><\/DIV><\/DIV><\/DIV>",
"summary": "Development parcel",
"title": "LR_PARCEL_DEVELOPMENT",
"tags": [
"Parcel"
],
"type": "",
"typeKeywords": [],
"thumbnail": "",
"url": "",
"minScale": 150000000,
"maxScale": 5000,
"spatialReference": "",
"accessInformation": "",
"licenseInfo": "",
"portalUrl": ""
}