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