Hydrants (English, CSV)

Explore the interactive map. Hydrants: English CSV file you can open as a table, filter, chart and export up to 10,000 rows. From City of Saint John, updated May 2023.

Format
CSV
Access
Table on demand (prepared when opened) and interactive map
Fields
10
Publisher-reported update
2023-05-17

Point features that represent locations of fire hydrants.

Access original file

Data overview

Formats
CSV
File languages
English
Available actions
Explore table (prepared automatically) · Explore map · Access original file

Available fields (10/10)

Fields from the recorded map schema.

FieldRecorded type
OBJECTIDesriFieldTypeOID
HydrantTypeesriFieldTypeString
AbandonedesriFieldTypeString
PrivateesriFieldTypeString
StatusesriFieldTypeString
Hydrant_ColouresriFieldTypeString
GlobalIDesriFieldTypeGlobalID
FlagesriFieldTypeString
Asset_IDesriFieldTypeString
For_Internal_Use_OnlyesriFieldTypeString

Sample rows

The first 10 rows, as CanQuery read them from the start of the publisher's file on 2026-11-05.

OBJECTIDAbandonedPrivateStatusHydrant ColourAvailable Fire Flow TypeGlobalIDFlagAsset_IDFor Internal Use Onlyxy
1NoNoActiveBlueType 4 (1500 GPM & Above)387e678c-a7aa-442e-b48e-3c96434d087fNoWD-HYD-00002No2539575.654047617365176.3460138
2NoNoActiveBlueType 4 (1500 GPM & Above)77223e1d-6c8d-4865-b7fd-2d57d3ceaf27NoWD-HYD-00003No2539489.785961757365184.74901242
3NoNoActiveBlueType 4 (1500 GPM & Above)61ed192e-3ac9-4a34-a1fc-6e6c04fc9ed2NoWD-HYD-00005No2539450.505968227365084.99402884
4NoNoActiveBlueType 4 (1500 GPM & Above)3bd940be-9c2f-4ca7-840e-1dbe3e2bfec9NoWD-HYD-00006No2539578.002047237365035.70403695
7NoNoActiveBlueType 4 (1500 GPM & Above)c9ed2f43-5074-4035-aa92-d37f540883e0NoWD-HYD-00011No2536952.134979527365071.3000311
8NoNoActiveGreenType 3 (1000 to 1499 GPM)23c23d20-5d35-426d-a5cb-069966251267YesWD-HYD-00012No2537118.631952117365167.79601521
9NoNoActiveBlueType 4 (1500 GPM & Above)26252616-187f-4680-ac50-8f051c5d72baNoWD-HYD-00013No2536243.046996257365036.44203683
10NoNoActiveBlueType 4 (1500 GPM & Above)f4bf912d-4ef9-4d63-8ebd-1276c45a9d75NoWD-HYD-00014No2536405.119969577365045.21603539
11NoNoActiveBlueType 4 (1500 GPM & Above)20bbcb6a-25f9-4574-ad4b-3dbf84911559YesWD-HYD-00015No2536587.17703967365056.71903349
12NoNoActiveBlueType 4 (1500 GPM & Above)89501a7d-8538-42a1-937b-326ead947ebaNoWD-HYD-00016No2536663.330027067365097.3940268

Official sources and licences

Related open data