trees
8,758 rows where qSpecies_id = 16 sorted by qAddress
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1303 | 35175 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
2323 | 35205 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
3913 | 35208 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
4587 | 35197 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
7474 | 35177 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
8676 | 34246 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 38056 | |||||||||||||||
9631 | 35176 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
9856 | 35210 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
10031 | 35174 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
10551 | 35179 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
10979 | 35203 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
11690 | 35212 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
12844 | 35183 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
13515 | 35181 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
14889 | 35207 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
15754 | 35209 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
16270 | 35178 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
16636 | 35198 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
17110 | 35180 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
18187 | 35206 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
18230 | 35204 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
21654 | 177726 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 0 Gonzalez Dr | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 5989405.70354 | 2089245.56508 | 37.7160606434521 | -122.478572628528 | (37.7160606434521, -122.478572628528) | 1 | 8 | 4 | 64 | 14 | ||||
120120 | 177728 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 0 Gonzalez Dr | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 5990346.90752 | 2090145.93714 | 37.7185874434309 | -122.475385114628 | (37.7185874434309, -122.475385114628) | 1 | 8 | 4 | 64 | 14 | ||||
134199 | 177729 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5990316.61378 | 2090071.18961 | 37.7183804491734 | -122.475484371904 | (37.7183804491734, -122.475484371904) | 1 | 8 | 4 | 64 | 14 | ||||
164660 | 177727 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 0 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 5989471.66726 | 2089216.87415 | 37.7159856948639 | -122.478342532492 | (37.7159856948639, -122.478342532492) | 1 | 8 | 4 | 64 | 14 | ||||
27102 | 177715 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 0 Higuera Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 5988076.41192 | 2090188.68677 | 37.7185729508557 | -122.483236326522 | (37.7185729508557, -122.483236326522) | 1 | 8 | 4 | 64 | 14 | ||||
56989 | 177719 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 0 Higuera Ave | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 5987711.1405 | 2090208.21579 | 37.7186053084801 | -122.484500336223 | (37.7186053084801, -122.484500336223) | 1 | 8 | 4 | 64 | 14 | ||||
72680 | 177720 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 0 Higuera Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 5987685.94194 | 2090080.2958 | 37.718252605151 | -122.484578058334 | (37.718252605151, -122.484578058334) | 1 | 8 | 4 | 64 | 14 | ||||
84508 | 177725 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 0 Higuera Ave | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 5988008.57998 | 2090059.31291 | 37.7182137751147 | -122.483461311716 | (37.7182137751147, -122.483461311716) | 1 | 8 | 4 | 64 | 14 | ||||
102457 | 177721 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 0 Higuera Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 5987879.74114 | 2090066.75844 | 37.7182267190545 | -122.483907192865 | (37.7182267190545, -122.483907192865) | 1 | 8 | 4 | 64 | 14 | ||||
114323 | 177723 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 0 Higuera Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 5987970.7514 | 2090061.29327 | 37.7182170108869 | -122.48359221251 | (37.7182170108869, -122.48359221251) | 1 | 8 | 4 | 64 | 14 | ||||
120736 | 177716 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 0 Higuera Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 5988036.19276 | 2090189.53925 | 37.7185729508722 | -122.483375408458 | (37.7185729508722, -122.483375408458) | 1 | 8 | 4 | 64 | 14 | ||||
125550 | 177718 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 0 Higuera Ave | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 5987733.66581 | 2090210.09499 | 37.7186117799813 | -122.484422614136 | (37.7186117799813, -122.484422614136) | 1 | 8 | 4 | 64 | 14 | ||||
130344 | 177724 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 0 Higuera Ave | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 5987989.67805 | 2090060.89205 | 37.7182170108739 | -122.483526762543 | (37.7182170108739, -122.483526762543) | 1 | 8 | 4 | 64 | 14 | ||||
153455 | 177722 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 0 Higuera Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 5987952.98255 | 2090060.49149 | 37.718213775123 | -122.483653572352 | (37.718213775123, -122.483653572352) | 1 | 8 | 4 | 64 | 14 | ||||
177524 | 177717 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 0 Higuera Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 5987909.74554 | 2090198.11209 | 37.7185891296683 | -122.483813107608 | (37.7185891296683, -122.483813107608) | 1 | 8 | 4 | 64 | 14 | ||||
29967 | 193866 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 02nd St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6012392.89041 | 2115351.57685 | 37.7890498941745 | -122.400950685846 | (37.7890498941745, -122.400950685846) | 12 | 2 | 9 | 28855 | 6 | |||
53483 | 193863 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 02nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6012425.42682 | 2115316.80914 | 37.7889562450872 | -122.400835669749 | (37.7889562450872, -122.400835669749) | 12 | 2 | 9 | 28855 | 6 | |||
119909 | 193868 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 02nd St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6012367.10488 | 2115383.95012 | 37.7891373451717 | -122.401042176578 | (37.7891373451717, -122.401042176578) | 12 | 2 | 9 | 28855 | 6 | |||
141038 | 193867 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 02nd St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6012381.11251 | 2115366.86321 | 37.7890912099288 | -122.40099251059 | (37.7890912099288, -122.40099251059) | 12 | 2 | 9 | 28855 | 6 | |||
144255 | 193870 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 02nd St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6012336.70693 | 2115412.40487 | 37.789213779452 | -122.401149350579 | (37.789213779452, -122.401149350579) | 12 | 2 | 9 | 28855 | 6 | |||
171470 | 193869 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 02nd St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6012351.8489 | 2115401.56416 | 37.7891848581286 | -122.401096198846 | (37.7891848581286, -122.401096198846) | 12 | 2 | 9 | 28855 | 6 | |||
176457 | 193865 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 02nd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6012406.27008 | 2115340.77199 | 37.7890209728958 | -122.400903634192 | (37.7890209728958, -122.400903634192) | 12 | 2 | 9 | 28855 | 6 | |||
178467 | 193864 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 02nd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6012415.10855 | 2115329.55793 | 37.7889906747295 | -122.400872265863 | (37.7889906747295, -122.400872265863) | 12 | 2 | 9 | 28855 | 6 | |||
65442 | 250034 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 Daniel Burnham Ct | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6006280.63624 | 2114735.2377 | 37.7870147346962 | -122.42205452411 | (37.7870147346962, -122.42205452411) | 13 | 9 | 1 | 28858 | 41 | |||
65721 | 101600 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 Daniel Burnham Ct | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 23334 | 6006156.1 | 2114693.3 | 37.7868925594682 | -122.422482411139 | (37.7868925594682, -122.422482411139) | 13 | 9 | 1 | 28858 | 41 | ||
84265 | 250032 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 Daniel Burnham Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6006018.87581 | 2114696.26596 | 37.7868929610919 | -122.422957386799 | (37.7868929610919, -122.422957386799) | 13 | 9 | 1 | 28858 | 41 | |||
108285 | 101594 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 Daniel Burnham Ct | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | Permit Number 23334 | 6006156.1 | 2114693.3 | 37.7868925594682 | -122.422482411139 | (37.7868925594682, -122.422482411139) | 13 | 9 | 1 | 28858 | 41 | ||
115783 | 101597 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 Daniel Burnham Ct | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | Permit Number 23334 | 6006156.1 | 2114693.3 | 37.7868925594682 | -122.422482411139 | (37.7868925594682, -122.422482411139) | 13 | 9 | 1 | 28858 | 41 | ||
116244 | 101592 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 Daniel Burnham Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | Permit Number 23334 | 6006156.1 | 2114693.3 | 37.7868925594682 | -122.422482411139 | (37.7868925594682, -122.422482411139) | 13 | 9 | 1 | 28858 | 41 | ||
131698 | 62952 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 Daniel Burnham Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/07/1986 12:00:00 AM | 8 | 3x3 | Permit Number 23334 | 6006152 | 2114643 | 37.7867542168079 | -122.42249302073 | (37.7867542168079, -122.42249302073) | 13 | 9 | 1 | 28858 | 41 | |
132539 | 250036 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 Daniel Burnham Ct | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6006319.47688 | 2114739.23432 | 37.7870278989762 | -122.421920428003 | (37.7870278989762, -122.421920428003) | 13 | 9 | 1 | 28858 | 41 | |||
172431 | 101593 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 Daniel Burnham Ct | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | Permit Number 23334 | 6006156.1 | 2114693.3 | 37.7868925594682 | -122.422482411139 | (37.7868925594682, -122.422482411139) | 13 | 9 | 1 | 28858 | 41 | ||
181392 | 250033 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 Daniel Burnham Ct | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6006037.94021 | 2114698.51114 | 37.7869002015256 | -122.422891587897 | (37.7869002015256, -122.422891587897) | 13 | 9 | 1 | 28858 | 41 | |||
186178 | 101595 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 Daniel Burnham Ct | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | Permit Number 23334 | 6006156.1 | 2114693.3 | 37.7868925594682 | -122.422482411139 | (37.7868925594682, -122.422482411139) | 13 | 9 | 1 | 28858 | 41 | ||
187457 | 250031 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 Daniel Burnham Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6005997.14952 | 2114693.35623 | 37.7868837457241 | -122.423032347976 | (37.7868837457241, -122.423032347976) | 13 | 9 | 1 | 28858 | 41 | |||
192224 | 250035 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 Daniel Burnham Ct | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6006298.52089 | 2114736.52863 | 37.7870192879551 | -122.421992738875 | (37.7870192879551, -122.421992738875) | 13 | 9 | 1 | 28858 | 41 | |||
27077 | 231429 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 Elizabeth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006127.80713 | 2102274.97563 | 37.7527932087596 | -122.421697928544 | (37.7527932087596, -122.421697928544) | 2 | 4 | 5 | 28859 | 19 | |||
179497 | 231427 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | Width 3ft | 6006061.40742 | 2102271.86531 | 37.7527809240203 | -122.421927330283 | (37.7527809240203, -122.421927330283) | 2 | 4 | 5 | 28859 | 19 | |||
187952 | 231428 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 Elizabeth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006075.43025 | 2102272.62997 | 37.7527838144353 | -122.421878891024 | (37.7527838144353, -122.421878891024) | 2 | 4 | 5 | 28859 | 19 | |||
96068 | 37439 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 Elsie St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42376 | 6007699.64971821 | 2099462.43084291 | 37.7451591053054 | -122.416063030013 | (37.7451591053054, -122.416063030013) | 2 | 7 | 7 | 28859 | 2 | ||
124994 | 37438 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42376 | 6007699.64971821 | 2099462.43084291 | 37.7451591053054 | -122.416063030013 | (37.7451591053054, -122.416063030013) | 2 | 7 | 7 | 28859 | 2 | ||
171910 | 91184 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 Fell St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 10/16/2008 12:00:00 AM | 5 | Permit Number 51891 | 6007394.40571 | 2110929.76906 | 37.776628592972 | -122.417931258428 | (37.776628592972, -122.417931258428) | 7 | 9 | 9 | 28852 | 36 | |
18128 | 213232 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 Geneva Ave | 1 | : | Tree | Private 2 | 15 | Width 0ft | 5997159.34871 | 2091557.33009 | 37.7228553326789 | -122.451939179162 | (37.7228553326789, -122.451939179162) | 9 | 8 | 4 | 28861 | 24 | |||
21382 | 213233 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 Geneva Ave | 2 | : | Tree | Private 2 | 13 | Width 0ft | 5997185.51842 | 2091545.75493 | 37.7228250489166 | -122.451847881795 | (37.7228250489166, -122.451847881795) | 9 | 8 | 4 | 28861 | 24 | |||
86442 | 213234 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 Geneva Ave | 3 | : | Tree | Private 2 | 10 | Width 0ft | 5997198.16874 | 2091539.55227 | 37.7228087424092 | -122.451803705299 | (37.7228087424092, -122.451803705299) | 9 | 8 | 4 | 28861 | 24 | |||
47512 | 114600 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 IRVING ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995817 | 2106753 | 37.7645019012702 | -122.457678342592 | (37.7645019012702, -122.457678342592) | 15 | 5 | 11 | 56 | 12 | ||||
72116 | 114596 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 IRVING ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995817 | 2106753 | 37.7645019012702 | -122.457678342592 | (37.7645019012702, -122.457678342592) | 15 | 5 | 11 | 56 | 12 | ||||
73220 | 114601 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 IRVING ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995817 | 2106753 | 37.7645019012702 | -122.457678342592 | (37.7645019012702, -122.457678342592) | 15 | 5 | 11 | 56 | 12 | ||||
89020 | 114599 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 IRVING ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995817 | 2106753 | 37.7645019012702 | -122.457678342592 | (37.7645019012702, -122.457678342592) | 15 | 5 | 11 | 56 | 12 | ||||
93990 | 114598 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 IRVING ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995817 | 2106753 | 37.7645019012702 | -122.457678342592 | (37.7645019012702, -122.457678342592) | 15 | 5 | 11 | 56 | 12 | ||||
128327 | 114602 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 IRVING ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995817 | 2106753 | 37.7645019012702 | -122.457678342592 | (37.7645019012702, -122.457678342592) | 15 | 5 | 11 | 56 | 12 | ||||
155518 | 114597 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 IRVING ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995817 | 2106753 | 37.7645019012702 | -122.457678342592 | (37.7645019012702, -122.457678342592) | 15 | 5 | 11 | 56 | 12 | ||||
161907 | 114603 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 IRVING ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995817 | 2106753 | 37.7645019012702 | -122.457678342592 | (37.7645019012702, -122.457678342592) | 15 | 5 | 11 | 56 | 12 | ||||
176013 | 114604 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 IRVING ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995817 | 2106753 | 37.7645019012702 | -122.457678342592 | (37.7645019012702, -122.457678342592) | 15 | 5 | 11 | 56 | 12 | ||||
3280 | 131640 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 John Maher St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6012516.39598 | 2119702.01834 | 37.8010020586619 | -122.400829137966 | (37.8010020586619, -122.400829137966) | 3 | 1 | 10 | 28860 | 6 | |||
83245 | 131636 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 John Maher St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6012488.72872 | 2119699.54646 | 37.8009937282283 | -122.400924705329 | (37.8009937282283, -122.400924705329) | 3 | 1 | 10 | 28860 | 6 | |||
83362 | 131634 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 John Maher St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6012476.57757 | 2119697.05581 | 37.800986211703 | -122.400966578661 | (37.800986211703, -122.400966578661) | 3 | 1 | 10 | 28860 | 6 | |||
88842 | 131633 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 John Maher St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6012478.4844 | 2119690.22702 | 37.8009675678597 | -122.400959500108 | (37.8009675678597, -122.400959500108) | 3 | 1 | 10 | 28860 | 6 | |||
101702 | 131637 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 John Maher St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6012505.47527 | 2119693.07389 | 37.8009768902256 | -122.400866299755 | (37.8009768902256, -122.400866299755) | 3 | 1 | 10 | 28860 | 6 | |||
119983 | 131638 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 John Maher St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6012504.601 | 2119700.39069 | 37.800996931627 | -122.40086983947 | (37.800996931627, -122.40086983947) | 3 | 1 | 10 | 28860 | 6 | |||
165044 | 131635 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 John Maher St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6012489.93167 | 2119691.5224 | 37.800971763197 | -122.400919978499 | (37.800971763197, -122.400919978499) | 3 | 1 | 10 | 28860 | 6 | |||
176156 | 131639 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 John Maher St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6012517.79158 | 2119695.20026 | 37.8009834157025 | -122.400823829283 | (37.8009834157025, -122.400823829283) | 3 | 1 | 10 | 28860 | 6 | |||
50893 | 60444 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 Majestic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/24/1982 12:00:00 AM | Permit Number 20028 | 5997483.83946465 | 2089883.9709991 | 37.7182792597053 | -122.45069689971 | (37.7182792597053, -122.45069689971) | 9 | 8 | 6 | 28861 | 24 | ||
149676 | 213237 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 Majestic Ave | 1 | : | Tree | Private 2 | 21 | Width 3ft | 5997483.43481 | 2089893.95191 | 37.7183066418059 | -122.450699017642 | (37.7183066418059, -122.450699017642) | 9 | 8 | 6 | 28861 | 24 | |||
46006 | 9300 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 Mansell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/10/1992 12:00:00 AM | 12 | 3X3 | 6011786.56982 | 2090691.56369 | 37.7213050795375 | -122.401314833019 | (37.7213050795375, -122.401314833019) | 10 | 7 | 8 | 309 | 28 | ||
92947 | 9299 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 Mansell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6011744.95061 | 2090679.05023 | 37.7212683980005 | -122.401457820749 | (37.7212683980005, -122.401457820749) | 10 | 7 | 8 | 309 | 28 | |||
16147 | 260471 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 Masonic Ave | 6 | Side Yard : Yard | Tree | Private 2 | 5998961 | 2113697 | 37.7837484562249 | -122.447303968308 | (37.7837484562249, -122.447303968308) | 15 | 6 | 1 | 54 | 31 | |||||
142069 | 250709 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 McLaren Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 4ft | 5987014.24531 | 2114847.82042 | 37.7862183841057 | -122.488719310471 | (37.7862183841057, -122.488719310471) | 11 | 6 | 1 | 55 | 33 | |||
157739 | 250710 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 McLaren Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 4ft | 5987057.03847 | 2114843.86093 | 37.7862100096394 | -122.488570968169 | (37.7862100096394, -122.488570968169) | 11 | 6 | 1 | 55 | 33 | |||
43056 | 91183 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 Polk St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/16/2008 12:00:00 AM | Permit Number 51891 | 6007496.395175 | 2110885.881534 | 37.7765138277066 | -122.41757533494 | (37.7765138277066, -122.41757533494) | 7 | 2 | 9 | 28852 | 36 | |||
104613 | 89263 | Section 143 10 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775142 | 6007496.395175 | 2110885.881534 | 37.7765138277066 | -122.41757533494 | (37.7765138277066, -122.41757533494) | 7 | 2 | 9 | 28852 | 36 | |
125384 | 131513 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 Polk St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6007404.69424 | 2110945.32585 | 37.7766718872206 | -122.417896770342 | (37.7766718872206, -122.417896770342) | 7 | 9 | 9 | 28852 | 36 | |||
146157 | 91176 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 Polk St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/16/2008 12:00:00 AM | Permit Number 51891 | 6007496.395175 | 2110885.881534 | 37.7765138277066 | -122.41757533494 | (37.7765138277066, -122.41757533494) | 7 | 2 | 9 | 28852 | 36 | |||
169799 | 91177 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 Polk St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/16/2008 12:00:00 AM | Permit Number 51891 | 6007496.395175 | 2110885.881534 | 37.7765138277066 | -122.41757533494 | (37.7765138277066, -122.41757533494) | 7 | 2 | 9 | 28852 | 36 | |||
178867 | 91182 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 Polk St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/16/2008 12:00:00 AM | Permit Number 51891 | 6007496.395175 | 2110885.881534 | 37.7765138277066 | -122.41757533494 | (37.7765138277066, -122.41757533494) | 7 | 2 | 9 | 28852 | 36 | |||
36529 | 124190 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 Rossi Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5996275.69954 | 2112164.1975 | 37.7793859799522 | -122.456483162666 | (37.7793859799522, -122.456483162666) | 11 | 6 | 2 | 54 | 16 | |||
73604 | 124191 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 Rossi Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5996280.45676 | 2112149.828 | 37.7793467982144 | -122.456465666169 | (37.7793467982144, -122.456465666169) | 11 | 6 | 2 | 54 | 16 | |||
79619 | 124192 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 Rossi Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5996288.20718 | 2112097.2031 | 37.7792027490858 | -122.45643504799 | (37.7792027490858, -122.45643504799) | 11 | 6 | 2 | 54 | 16 | |||
88155 | 124199 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 Rossi Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5996318.05215 | 2111831.32394 | 37.778474428383 | -122.456312572589 | (37.778474428383, -122.456312572589) | 11 | 6 | 2 | 54 | 16 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );