Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5603 | 5603 | 34246 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 38056 | ||||||||||
5617 | 5617 | 35204 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
6825 | 6825 | 35207 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
6835 | 6835 | 35197 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
7167 | 7167 | 35203 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
9617 | 9617 | 35183 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
10310 | 10310 | 35176 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
11317 | 11317 | 35209 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
11988 | 11988 | 35180 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
12435 | 12435 | 35178 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
12458 | 12458 | 35205 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
12489 | 12489 | 35198 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
12872 | 12872 | 35210 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
14195 | 14195 | 35181 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
14575 | 14575 | 35206 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
14588 | 14588 | 35174 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
16081 | 16081 | 35175 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
16133 | 16133 | 35179 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
16225 | 16225 | 35208 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
16452 | 16452 | 35177 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
16638 | 16638 | 35212 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
43657 | 43657 | 177729 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5990316.61378 | 2090071.1896099998 | 37.718380449173395 | -122.47548437190399 | (37.7183804491734, -122.475484371904) | ||||
67488 | 67488 | 177728 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 0 Gonzalez Dr | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 5990346.90752 | 2090145.93714 | 37.7185874434309 | -122.475385114628 | (37.7185874434309, -122.475385114628) | ||||
117022 | 117022 | 177727 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 0 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 5989471.66726 | 2089216.87415 | 37.715985694863896 | -122.47834253249201 | (37.7159856948639, -122.478342532492) | ||||
132572 | 132572 | 177726 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 0 Gonzalez Dr | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 5989405.70354 | 2089245.5650799999 | 37.7160606434521 | -122.478572628528 | (37.7160606434521, -122.478572628528) | ||||
31755 | 31755 | 177719 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 0 Higuera Ave | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 5987711.1405 | 2090208.21579 | 37.7186053084801 | -122.484500336223 | (37.7186053084801, -122.484500336223) | ||||
42703 | 42703 | 177725 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 0 Higuera Ave | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 5988008.57998 | 2090059.3129099999 | 37.718213775114705 | -122.483461311716 | (37.7182137751147, -122.483461311716) | ||||
45885 | 45885 | 177724 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 0 Higuera Ave | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 5987989.67805 | 2090060.89205 | 37.7182170108739 | -122.483526762543 | (37.7182170108739, -122.483526762543) | ||||
47232 | 47232 | 177720 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 0 Higuera Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 5987685.94194 | 2090080.2958 | 37.718252605151 | -122.48457805833401 | (37.718252605151, -122.484578058334) | ||||
55590 | 55590 | 177722 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 0 Higuera Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 5987952.98255 | 2090060.4914900002 | 37.718213775123 | -122.48365357235201 | (37.718213775123, -122.483653572352) | ||||
64183 | 64183 | 177716 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 0 Higuera Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 5988036.19276 | 2090189.53925 | 37.7185729508722 | -122.483375408458 | (37.7185729508722, -122.483375408458) | ||||
72121 | 72121 | 177721 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 0 Higuera Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 5987879.7411400005 | 2090066.7584400002 | 37.7182267190545 | -122.483907192865 | (37.7182267190545, -122.483907192865) | ||||
73479 | 73479 | 177715 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 0 Higuera Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 5988076.41192 | 2090188.68677 | 37.7185729508557 | -122.483236326522 | (37.7185729508557, -122.483236326522) | ||||
93195 | 93195 | 177723 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 0 Higuera Ave | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 5987970.7514 | 2090061.29327 | 37.718217010886896 | -122.48359221251002 | (37.7182170108869, -122.48359221251) | ||||
128970 | 128970 | 177717 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 0 Higuera Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 5987909.7455400005 | 2090198.1120900002 | 37.718589129668295 | -122.483813107608 | (37.7185891296683, -122.483813107608) | ||||
172055 | 172055 | 177718 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 0 Higuera Ave | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 5987733.66581 | 2090210.0949900001 | 37.7186117799813 | -122.48442261413601 | (37.7186117799813, -122.484422614136) | ||||
26144 | 26144 | 193867 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 02nd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6012381.112509999 | 2115366.8632099996 | 37.7890912099288 | -122.40099251058999 | (37.7890912099288, -122.40099251059) | |||
27289 | 27289 | 193870 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 02nd St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6012336.70693 | 2115412.40487 | 37.789213779452 | -122.40114935057899 | (37.789213779452, -122.401149350579) | |||
28152 | 28152 | 193865 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 02nd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6012406.27008 | 2115340.7719900003 | 37.7890209728958 | -122.400903634192 | (37.7890209728958, -122.400903634192) | |||
62453 | 62453 | 193863 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 02nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6012425.42682 | 2115316.80914 | 37.788956245087206 | -122.40083566974899 | (37.7889562450872, -122.400835669749) | |||
157099 | 157099 | 193869 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 02nd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6012351.8489 | 2115401.56416 | 37.7891848581286 | -122.40109619884599 | (37.7891848581286, -122.401096198846) | |||
167609 | 167609 | 193866 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 02nd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6012392.8904099995 | 2115351.57685 | 37.7890498941745 | -122.400950685846 | (37.7890498941745, -122.400950685846) | |||
175047 | 175047 | 193864 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 02nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6012415.10855 | 2115329.55793 | 37.7889906747295 | -122.400872265863 | (37.7889906747295, -122.400872265863) | |||
178870 | 178870 | 193868 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 02nd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6012367.10488 | 2115383.95012 | 37.7891373451717 | -122.401042176578 | (37.7891373451717, -122.401042176578) | |||
26430 | 26430 | 250032 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 Daniel Burnham Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6006018.87581 | 2114696.26596 | 37.7868929610919 | -122.422957386799 | (37.7868929610919, -122.422957386799) | |||
32820 | 32820 | 250034 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 Daniel Burnham Ct | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6006280.63624 | 2114735.2377 | 37.7870147346962 | -122.42205452411001 | (37.7870147346962, -122.42205452411) | |||
50020 | 50020 | 250031 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 Daniel Burnham Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6005997.1495199995 | 2114693.35623 | 37.786883745724104 | -122.423032347976 | (37.7868837457241, -122.423032347976) | |||
60740 | 60740 | 250036 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 Daniel Burnham Ct | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6006319.47688 | 2114739.2343200003 | 37.7870278989762 | -122.421920428003 | (37.7870278989762, -122.421920428003) | |||
76100 | 76100 | 250033 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 Daniel Burnham Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6006037.94021 | 2114698.51114 | 37.786900201525604 | -122.422891587897 | (37.7869002015256, -122.422891587897) | |||
89448 | 89448 | 101600 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 Daniel Burnham Ct | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | Permit Number 23334 | 6006156.1 | 2114693.3 | 37.7868925594682 | -122.42248241113899 | (37.7868925594682, -122.422482411139) | ||
101723 | 101723 | 101594 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 Daniel Burnham Ct | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | Permit Number 23334 | 6006156.1 | 2114693.3 | 37.7868925594682 | -122.42248241113899 | (37.7868925594682, -122.422482411139) | ||
105000 | 105000 | 101597 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 Daniel Burnham Ct | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | Permit Number 23334 | 6006156.1 | 2114693.3 | 37.7868925594682 | -122.42248241113899 | (37.7868925594682, -122.422482411139) | ||
105588 | 105588 | 62952 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 Daniel Burnham Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/07/1986 12:00:00 AM | 8 | 3x3 | Permit Number 23334 | 6006152.0 | 2114643.0 | 37.7867542168079 | -122.42249302073 | (37.7867542168079, -122.42249302073) | |
105722 | 105722 | 101592 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 Daniel Burnham Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | Permit Number 23334 | 6006156.1 | 2114693.3 | 37.7868925594682 | -122.42248241113899 | (37.7868925594682, -122.422482411139) | ||
133781 | 133781 | 250035 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 Daniel Burnham Ct | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6006298.52089 | 2114736.52863 | 37.787019287955104 | -122.421992738875 | (37.7870192879551, -122.421992738875) | |||
139252 | 139252 | 101593 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 Daniel Burnham Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | Permit Number 23334 | 6006156.1 | 2114693.3 | 37.7868925594682 | -122.42248241113899 | (37.7868925594682, -122.422482411139) | ||
142413 | 142413 | 101595 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 Daniel Burnham Ct | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | Permit Number 23334 | 6006156.1 | 2114693.3 | 37.7868925594682 | -122.42248241113899 | (37.7868925594682, -122.422482411139) | ||
52719 | 52719 | 231428 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 Elizabeth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006075.43025 | 2102272.62997 | 37.7527838144353 | -122.421878891024 | (37.7527838144353, -122.421878891024) | |||
170619 | 170619 | 231429 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 Elizabeth St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006127.807130001 | 2102274.97563 | 37.752793208759606 | -122.421697928544 | (37.7527932087596, -122.421697928544) | |||
177836 | 177836 | 231427 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | Width 3ft | 6006061.40742 | 2102271.86531 | 37.75278092402029 | -122.421927330283 | (37.7527809240203, -122.421927330283) | |||
100373 | 100373 | 37439 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 Elsie St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42376 | 6007699.64971821 | 2099462.43084291 | 37.7451591053054 | -122.416063030013 | (37.7451591053054, -122.416063030013) | ||
106844 | 106844 | 37438 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42376 | 6007699.64971821 | 2099462.43084291 | 37.7451591053054 | -122.416063030013 | (37.7451591053054, -122.416063030013) | ||
154142 | 154142 | 91184 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 Fell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 10/16/2008 12:00:00 AM | 5 | Permit Number 51891 | 6007394.40571 | 2110929.76906 | 37.776628592972 | -122.417931258428 | (37.776628592972, -122.417931258428) | |
49831 | 49831 | 213233 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 Geneva Ave | 2 | : 4 | Tree 1 | Private 1 | 13 | Width 0ft | 5997185.51842 | 2091545.7549299998 | 37.722825048916604 | -122.451847881795 | (37.7228250489166, -122.451847881795) | |||
170330 | 170330 | 213234 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 Geneva Ave | 3 | : 4 | Tree 1 | Private 1 | 10 | Width 0ft | 5997198.168740001 | 2091539.55227 | 37.72280874240921 | -122.451803705299 | (37.7228087424092, -122.451803705299) | |||
174489 | 174489 | 213232 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 Geneva Ave | 1 | : 4 | Tree 1 | Private 1 | 15 | Width 0ft | 5997159.34871 | 2091557.33009 | 37.7228553326789 | -122.45193917916201 | (37.7228553326789, -122.451939179162) | |||
83824 | 83824 | 114600 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 IRVING ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5995817.0 | 2106753.0 | 37.7645019012702 | -122.45767834259199 | (37.7645019012702, -122.457678342592) | ||||
84710 | 84710 | 114596 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 IRVING ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5995817.0 | 2106753.0 | 37.7645019012702 | -122.45767834259199 | (37.7645019012702, -122.457678342592) | ||||
87479 | 87479 | 114601 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 IRVING ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5995817.0 | 2106753.0 | 37.7645019012702 | -122.45767834259199 | (37.7645019012702, -122.457678342592) | ||||
91388 | 91388 | 114598 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 IRVING ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5995817.0 | 2106753.0 | 37.7645019012702 | -122.45767834259199 | (37.7645019012702, -122.457678342592) | ||||
93343 | 93343 | 114599 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 IRVING ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5995817.0 | 2106753.0 | 37.7645019012702 | -122.45767834259199 | (37.7645019012702, -122.457678342592) | ||||
107672 | 107672 | 114602 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 IRVING ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5995817.0 | 2106753.0 | 37.7645019012702 | -122.45767834259199 | (37.7645019012702, -122.457678342592) | ||||
118522 | 118522 | 114603 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 IRVING ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5995817.0 | 2106753.0 | 37.7645019012702 | -122.45767834259199 | (37.7645019012702, -122.457678342592) | ||||
122086 | 122086 | 114597 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 IRVING ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5995817.0 | 2106753.0 | 37.7645019012702 | -122.45767834259199 | (37.7645019012702, -122.457678342592) | ||||
141415 | 141415 | 114604 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 IRVING ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5995817.0 | 2106753.0 | 37.7645019012702 | -122.45767834259199 | (37.7645019012702, -122.457678342592) | ||||
26061 | 26061 | 131640 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 John Maher St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6012516.3959800005 | 2119702.01834 | 37.8010020586619 | -122.400829137966 | (37.8010020586619, -122.400829137966) | |||
28328 | 28328 | 131636 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 John Maher St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6012488.72872 | 2119699.54646 | 37.8009937282283 | -122.400924705329 | (37.8009937282283, -122.400924705329) | |||
35386 | 35386 | 131638 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 John Maher St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6012504.601 | 2119700.3906900003 | 37.800996931627004 | -122.40086983946999 | (37.800996931627, -122.40086983947) | |||
133110 | 133110 | 131637 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 John Maher St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6012505.475269999 | 2119693.07389 | 37.8009768902256 | -122.400866299755 | (37.8009768902256, -122.400866299755) | |||
153701 | 153701 | 131635 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 John Maher St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6012489.93167 | 2119691.5224 | 37.800971763197 | -122.40091997849899 | (37.800971763197, -122.400919978499) | |||
174235 | 174235 | 131634 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 John Maher St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6012476.57757 | 2119697.05581 | 37.800986211703 | -122.400966578661 | (37.800986211703, -122.400966578661) | |||
179666 | 179666 | 131633 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 John Maher St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6012478.4844 | 2119690.22702 | 37.8009675678597 | -122.40095950010799 | (37.8009675678597, -122.400959500108) | |||
188757 | 188757 | 131639 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 John Maher St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6012517.79158 | 2119695.20026 | 37.8009834157025 | -122.40082382928301 | (37.8009834157025, -122.400823829283) | |||
82561 | 82561 | 60444 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 Majestic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/1982 12:00:00 AM | Permit Number 20028 | 5997483.83946465 | 2089883.9709991 | 37.7182792597053 | -122.45069689971001 | (37.7182792597053, -122.45069689971) | ||
184791 | 184791 | 213237 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 Majestic Ave | 1 | : 4 | Tree 1 | Private 1 | 21 | Width 3ft | 5997483.43481 | 2089893.9519099998 | 37.718306641805896 | -122.45069901764201 | (37.7183066418059, -122.450699017642) | |||
10817 | 10817 | 9300 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 Mansell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/10/1992 12:00:00 AM | 12 | 3X3 | 6011786.56982 | 2090691.5636900002 | 37.7213050795375 | -122.40131483301901 | (37.7213050795375, -122.401314833019) | ||
11461 | 11461 | 9299 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 Mansell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6011744.95061 | 2090679.05023 | 37.7212683980005 | -122.401457820749 | (37.7212683980005, -122.401457820749) | |||
67295 | 67295 | 250709 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 McLaren Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 4ft | 5987014.24531 | 2114847.8204200002 | 37.7862183841057 | -122.488719310471 | (37.7862183841057, -122.488719310471) | |||
178087 | 178087 | 250710 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 McLaren Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 4ft | 5987057.03847 | 2114843.86093 | 37.7862100096394 | -122.488570968169 | (37.7862100096394, -122.488570968169) | |||
80336 | 80336 | 91183 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 Polk St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/16/2008 12:00:00 AM | Permit Number 51891 | 6007496.395175 | 2110885.881534 | 37.7765138277066 | -122.41757533494 | (37.7765138277066, -122.41757533494) | |||
97792 | 97792 | 89263 | Section 143 8 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775142 | 6007496.395175 | 2110885.881534 | 37.7765138277066 | -122.41757533494 | (37.7765138277066, -122.41757533494) | |
116379 | 116379 | 91176 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 Polk St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/16/2008 12:00:00 AM | Permit Number 51891 | 6007496.395175 | 2110885.881534 | 37.7765138277066 | -122.41757533494 | (37.7765138277066, -122.41757533494) | |||
119446 | 119446 | 91177 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 Polk St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/16/2008 12:00:00 AM | Permit Number 51891 | 6007496.395175 | 2110885.881534 | 37.7765138277066 | -122.41757533494 | (37.7765138277066, -122.41757533494) | |||
141242 | 141242 | 91182 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 Polk St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/16/2008 12:00:00 AM | Permit Number 51891 | 6007496.395175 | 2110885.881534 | 37.7765138277066 | -122.41757533494 | (37.7765138277066, -122.41757533494) | |||
179782 | 179782 | 131513 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 Polk St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6007404.69424 | 2110945.32585 | 37.7766718872206 | -122.41789677034201 | (37.7766718872206, -122.417896770342) | |||
30361 | 30361 | 124197 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 Rossi Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 5996306.67631 | 2111912.14603 | 37.778695691486 | -122.456357771299 | (37.778695691486, -122.456357771299) | |||
34954 | 34954 | 124193 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 Rossi Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5996287.60217 | 2112048.11001 | 37.7790679176894 | -122.456433590029 | (37.7790679176894, -122.456433590029) | |||
38132 | 38132 | 124196 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 Rossi Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 5996306.605380001 | 2111949.08179 | 37.7787971032678 | -122.45636068813499 | (37.7787971032678, -122.456360688135) | |||
66366 | 66366 | 124190 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 Rossi Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5996275.69954 | 2112164.1975 | 37.7793859799522 | -122.45648316266599 | (37.7793859799522, -122.456483162666) | |||
72026 | 72026 | 124191 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 Rossi Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5996280.4567599995 | 2112149.828 | 37.7793467982144 | -122.456465666169 | (37.7793467982144, -122.456465666169) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");