{
 "culture": "en-US",
 "name": "",
 "guid": "",
 "catalogPath": "",
 "snippet": "A database view summarizing the ages of shelter residents.\n\nUSE [data1]\nGO\n\n/****** Object:  View [sde].[SHELTER_AGERANGE_VIEW]    Script Date: 7/24/2025 4:44:56 PM ******/\nSET ANSI_NULLS ON\nGO\n\nSET QUOTED_IDENTIFIER ON\nGO\n\n\nCREATE VIEW [sde].[SHELTER_AGERANGE_VIEW] AS\nSELECT \n  ROW_NUMBER() OVER (ORDER BY \n    CASE\n      WHEN Age BETWEEN 0 AND 3 THEN '0-3'\n      WHEN Age BETWEEN 4 AND 7 THEN '4-7'\n      WHEN Age BETWEEN 8 AND 12 THEN '8-12'\n      WHEN Age BETWEEN 13 AND 18 THEN '13-18'\n      WHEN Age BETWEEN 19 AND 65 THEN '19-65'\n      ELSE '65+'\n    END\n  ) AS OBJECTID,\n\n  CASE\n    WHEN Age BETWEEN 0 AND 3 THEN '0-3'\n    WHEN Age BETWEEN 4 AND 7 THEN '4-7'\n    WHEN Age BETWEEN 8 AND 12 THEN '8-12'\n    WHEN Age BETWEEN 13 AND 18 THEN '13-18'\n    WHEN Age BETWEEN 19 AND 65 THEN '19-65'\n    ELSE '65+'\n  END AS age_range,\n\n  COUNT(*) AS count\n\nFROM Shelter_ResidentApplication\n\nGROUP BY \n  CASE\n    WHEN Age BETWEEN 0 AND 3 THEN '0-3'\n    WHEN Age BETWEEN 4 AND 7 THEN '4-7'\n    WHEN Age BETWEEN 8 AND 12 THEN '8-12'\n    WHEN Age BETWEEN 13 AND 18 THEN '13-18'\n    WHEN Age BETWEEN 19 AND 65 THEN '19-65'\n    ELSE '65+'\n  END;\nGO",
 "description": "",
 "summary": "A database view summarizing the ages of shelter residents.\n\nUSE [data1]\nGO\n\n/****** Object:  View [sde].[SHELTER_AGERANGE_VIEW]    Script Date: 7/24/2025 4:44:56 PM ******/\nSET ANSI_NULLS ON\nGO\n\nSET QUOTED_IDENTIFIER ON\nGO\n\n\nCREATE VIEW [sde].[SHELTER_AGERANGE_VIEW] AS\nSELECT \n  ROW_NUMBER() OVER (ORDER BY \n    CASE\n      WHEN Age BETWEEN 0 AND 3 THEN '0-3'\n      WHEN Age BETWEEN 4 AND 7 THEN '4-7'\n      WHEN Age BETWEEN 8 AND 12 THEN '8-12'\n      WHEN Age BETWEEN 13 AND 18 THEN '13-18'\n      WHEN Age BETWEEN 19 AND 65 THEN '19-65'\n      ELSE '65+'\n    END\n  ) AS OBJECTID,\n\n  CASE\n    WHEN Age BETWEEN 0 AND 3 THEN '0-3'\n    WHEN Age BETWEEN 4 AND 7 THEN '4-7'\n    WHEN Age BETWEEN 8 AND 12 THEN '8-12'\n    WHEN Age BETWEEN 13 AND 18 THEN '13-18'\n    WHEN Age BETWEEN 19 AND 65 THEN '19-65'\n    ELSE '65+'\n  END AS age_range,\n\n  COUNT(*) AS count\n\nFROM Shelter_ResidentApplication\n\nGROUP BY \n  CASE\n    WHEN Age BETWEEN 0 AND 3 THEN '0-3'\n    WHEN Age BETWEEN 4 AND 7 THEN '4-7'\n    WHEN Age BETWEEN 8 AND 12 THEN '8-12'\n    WHEN Age BETWEEN 13 AND 18 THEN '13-18'\n    WHEN Age BETWEEN 19 AND 65 THEN '19-65'\n    ELSE '65+'\n  END;\nGO",
 "title": "Emergency Shelter Age Range statistics",
 "tags": [
  "emergency operations",
  "shelter"
 ],
 "type": "",
 "typeKeywords": [],
 "thumbnail": "",
 "url": "",
 "minScale": 150000000,
 "maxScale": 5000,
 "spatialReference": "",
 "accessInformation": "",
 "licenseInfo": "",
 "portalUrl": ""
}