number

cartodb_id_

geometry

the_geom_GEO

string

active_

string

addby_

string

adddttm_

string

castsub_

string

chr0_

string

chr1_

string

cmpression_

string

code_

string

color_

string

created_

string

dir_

number

disfrmcrnr_

number

feature_id_

number

feederlen_

string

fireonly_

string

id_

string

incomm_

string

instdate1_

string

line_

string

modby_

string

modified_

string

oldhydnum_

string

oocdate_

string

oocnotes_

string

oracleid_

string

remarks_

string

status_

string

street_

string

street_num_

string

subsystem_

geometry

the_geom_webmercator_GEO

number

unitid_

string

unittype_

date

created_at_

date

updated_at_

3459
GeoJSON
Active
covDBimport
2009-11-10
null
null
null
No
TC
Blue
09:33 AM
null
0
31568
0.6
N
WH-T16-026
Yes
1961-01-01
null
SDE 834766
03:06 PM
52C32
null
null
__FJ8TF6
RS
IN_SERVICE
SEC E 27TH AV & NANAIMO S
null
DSTR
GeoJSON
31568
TC1
2015-07-06T05:39:05Z
2015-07-06T05:39:05Z
3894
GeoJSON
Active
covDBimport
2009-11-10
null
null
null
No
TC
Blue
09:00 AM
E-EAST
396.5
27591
0.6
Y
WH-Q11-009
Yes
null
E-EAST
ENYAPGK
12:27 PM
20B13
null
null
__FJFK80
FR. EL @ STATION RS (IFO 520 Industrial)
IN_SERVICE
INDUSTRIAL AV
NS 500
DSTR
GeoJSON
27591
TC1
2015-07-06T05:39:05Z
2015-07-06T05:39:05Z
3974
GeoJSON
Active
covDBimport
2009-11-10
null
null
null
Yes
AVK
Blue
09:17 AM
null
0
28159
2.4
N
WH-N12-003
Yes
1975-01-01
null
SDE 834766
03:06 PM
30C33
null
null
__FJ8VSG
RS
IN_SERVICE
NEC LAMEY'S MILL ROAD & CHARLESON
null
DSTR
GeoJSON
28159
2780
2015-07-06T05:39:05Z
2015-07-06T05:39:05Z
4270
GeoJSON
Active
covDBimport
2009-11-10
null
null
null
No
TC
Blue
09:41 AM
S-SOUTH
1.5
32825
0.9
N
WH-R22-013
Yes
1971-01-01
S-SOUTH
SDE 834766
03:06 PM
73D20
null
null
__FJ8X0Z
RS
IN_SERVICE
SWC SHERBROOKE ST & E 55TH AV
null
DSTR
GeoJSON
32825
TC1
2015-07-06T05:39:05Z
2015-07-06T05:39:05Z
161
GeoJSON
Active
covDBimport
2009-11-10
null
null
null
No
TC
Blue
09:34 AM
null
0
31835
0.9
N
WH-P22-007
Yes
null
null
SDE 834766
03:06 PM
72D09
null
null
__FJ8UDU
FOUND PAINTED SILVER
IN_SERVICE
NEC E 56TH AV & QUEBEC ST
null
DSTR
GeoJSON
31835
TC1
2015-07-06T05:39:05Z
2015-07-06T05:39:05Z
234
GeoJSON
Active
covDBimport
2009-11-10
null
null
null
No
TC
Blue
09:35 AM
null
0
31104
0.9
N
WH-P20-006
Yes
null
null
SDE 834766
03:06 PM
72C15
null
null
__FJ8W56
null
IN_SERVICE
NEC W 47TH AV & MANITOBA ST
null
DSTR
GeoJSON
31104
TC1
2015-07-06T05:39:05Z
2015-07-06T05:39:05Z
272
GeoJSON
Active
covDBimport
2009-11-10
null
null
null
No
TC
Blue
09:38 AM
S-SOUTH
82
30592
1.2
N
WH-W12-016
Yes
1958-01-01
S-SOUTH
SDE 834766
03:06 PM
35A06
null
null
__FJ8SRC
FR. SL @ E 5TH RS
IN_SERVICE
KEENA ST
WS 2100
DSTR
GeoJSON
30592
TC1
2015-07-06T05:39:05Z
2015-07-06T05:39:05Z
595
GeoJSON
Active
covDBimport
2009-11-10
null
null
null
No
TC
Green
09:35 AM
W-WEST
1.2
31973
0.9
N
WH-H13-007
Yes
null
W-WEST
SDE 834766
03:06 PM
28B31
null
null
__FJ8TQ4
null
IN_SERVICE
NWC W 13TH AV & WALLACE ST
null
DSTR
GeoJSON
31973
TC1
2015-07-06T05:39:05Z
2015-07-06T05:39:05Z
1620
GeoJSON
Active
covDBimport
2009-11-10
null
null
null
No
TC
Blue
09:46 AM
null
0
32662
0.3
N
WH-L12-010
Yes
1974-01-01
null
SDE 834766
03:06 PM
30A23
null
null
__FJ8U3V
null
IN_SERVICE
SWC W 7TH AV & BURRARD ST
null
DSTR
GeoJSON
32662
TC1
2015-07-06T05:39:05Z
2015-07-06T05:39:05Z
1972
GeoJSON
Active
covDBimport
2009-11-10
null
null
null
No
TC
Blue
09:36 AM
N-NORTH
3.4
31156
0.9
N
WH-R14-005
Yes
1997-01-01
N-NORTH
SDE 834766
03:06 PM
32D35
null
null
__FJ8WZ5
AR
IN_SERVICE
NWC ST. CATHERINES ST & E 15TH AV
null
DSTR
GeoJSON
31156
TC1
2015-07-06T05:39:05Z
2015-07-06T05:39:05Z
2139
GeoJSON
Active
covDBimport
2009-11-10
null
null
null
No
TC
Blue
09:43 AM
N-NORTH
2.1
32887
1.8
N
WH-W09-011
Yes
1969-01-01
N-NORTH
SDE 834766
03:06 PM
15A10
null
null
__FJ8SVL
AR
IN_SERVICE
NWC KOOTENAY ST & E GEORGIA ST
null
DSTR
GeoJSON
32887
TC1
2015-07-06T05:39:05Z
2015-07-06T05:39:05Z
2380
GeoJSON
Active
covDBimport
2009-11-10
null
null
null
No
TC
Green
09:41 AM
null
0
33191
1.5
N
WH-T17-029
Yes
1961-01-01
null
SDE 834766
03:06 PM
52D20
null
null
__FJ8TED
RS
IN_SERVICE
E 30TH AV
SS 2200
DSTR
GeoJSON
33191
TC1
2015-07-06T05:39:05Z
2015-07-06T05:39:05Z
2697
GeoJSON
Active
covDBimport
2009-11-10
null
null
null
No
TC
Blue
09:35 AM
W-WEST
3
31016
1.2
N
WH-U11-005
Yes
1964-01-01
W-WEST
SDE 834766
03:06 PM
18B07
null
null
__FJ8SRH
RS
IN_SERVICE
SWC E 2ND AV & PENTICTON ST
null
DSTR
GeoJSON
31016
TC1
2015-07-06T05:39:05Z
2015-07-06T05:39:05Z
3330
GeoJSON
Active
covDBimport
2009-11-10
null
null
null
No
TC
Blue
09:44 AM
W-WEST
2.1
32163
0.6
N
WH-I13-009
Yes
1963-01-01
W-WEST
SDE 834766
03:06 PM
28B28
null
null
__FJ8UAT
null
IN_SERVICE
NWC W 12TH AV & ALMA ST
null
DSTR
GeoJSON
32163
TC1
2015-07-06T05:39:05Z
2015-07-06T05:39:05Z
3744
GeoJSON
Active
covDBimport
2009-11-10
null
null
null
No
TC
Red
09:32 AM
W-WEST
99.1
31626
0.6
N
WH-N20-011
Yes
1958-01-01
W-WEST
SDE 834766
03:06 PM
62D21
null
null
__FJ8VAX
RS
IN_SERVICE
W 48TH AV
NS 1055
DSTR
GeoJSON
31626
TC1
2015-07-06T05:39:05Z
2015-07-06T05:39:05Z
3828
GeoJSON
Active
covDBimport
2009-11-10
null
null
null
No
TC
Blue
09:40 AM
null
0
33742
0.6
N
WH-J12-011
Yes
1975-01-01
null
SDE 834766
03:06 PM
28D05
null
null
__FJ8U8L
null
IN_SERVICE
SWC W 8TH AV & TRUTCH ST
null
DSTR
GeoJSON
33742
TC1
2015-07-06T05:39:05Z
2015-07-06T05:39:05Z
5344
GeoJSON
Active
covDBimport
2009-11-10
null
null
null
No
TC
Blue
09:19 AM
null
0
28336
0.9
N
WH-I20-016
Yes
1954-01-01
null
SDE 834766
03:06 PM
66D03
null
null
__FJ8UR6
null
IN_SERVICE
COLLINGWOOD PLACE
BLVD 6100
DSTR
GeoJSON
28336
TC1
2015-07-06T05:39:05Z
2015-07-06T05:39:05Z
6389
GeoJSON
Active
ENJAK
2010-12-09
null
null
null
No
TC
null
10:33 AM
null
0
4127468
2.1
Y
WH-H21-801
Yes
1974-01-01
null
SDE 834766
03:06 PM
null
null
null
__FJ8TMH
PRIVATE
IN_SERVICE
W 51st Av
4000
DSTR
GeoJSON
4127468
TC1
2015-07-06T05:39:05Z
2015-07-06T05:39:05Z
6471
GeoJSON
Active
ENYAMW
2014-06-30
null
null
null
Yes
TC
Blue
11:11 AM
null
0
4235421
2
N
WH-R10-025
Yes
2004-10-07
null
SDE 834766
03:06 PM
null
null
null
__FTDI5E
null
IN_SERVICE
CHESS ST
1330
DSTR
GeoJSON
4235421
C71P
2015-07-06T05:39:05Z
2015-07-06T05:39:05Z
6154
GeoJSON
Active
covDBimport
2009-11-10
null
null
null
No
TC
Blue
09:41 AM
null
0
33607
0.9
N
WH-P20-007
Yes
null
null
SDE 834766
03:06 PM
72C16
null
null
__FJ8W5A
null
IN_SERVICE
NEC W 46TH AV & MANITOBA ST
null
DSTR
GeoJSON
33607
TC1
2015-07-06T05:39:05Z
2015-07-06T05:39:05Z
Leaflet | © OpenStreetMap contributors, © CARTO

water_hydrants

  • over 9 years ago
  • 6,481 rows
More info

Maps using this dataset