{ "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": "" }