trees
8,758 rows where qSpecies_id = 16 sorted by Zip Codes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
39672 | 131504 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 599 Turk St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6007514.85335 | 2112978.98813 | 37.7822620335141 | -122.41765987271 | (37.7822620335141, -122.41765987271) | 7 | 9 | 9 | 28852 | 36 | |||
41438 | 131476 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 440 Polk St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6007212.91851 | 2112526.76592 | 37.7810033459715 | -122.418672355545 | (37.7810033459715, -122.418672355545) | 7 | 9 | 9 | 28852 | 36 | |||
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 | |||
47186 | 108408 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 99x Hyde St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 11 | 3x3 | Permit Number 773269 | 6008126.98045 | 2112612.39837 | 37.7812898924571 | -122.415516217226 | (37.7812898924571, -122.415516217226) | 7 | 10 | 9 | 28852 | 36 | |
48038 | 102978 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 555 Turk St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007348.4 | 2112963.4 | 37.7822098643106 | -122.41823462296 | (37.7822098643106, -122.41823462296) | 7 | 9 | 9 | 28852 | 36 | ||||
48238 | 131422 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 455 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6009306.65271 | 2114577.92028 | 37.7867529825087 | -122.411574026431 | (37.7867529825087, -122.411574026431) | 5 | 10 | 9 | 28852 | 36 | |||
50386 | 131434 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 290 O'Farrell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009888.12565 | 2114405.38254 | 37.7863118344661 | -122.40955007699 | (37.7863118344661, -122.40955007699) | 5 | 10 | 10 | 28852 | 36 | |||
50680 | 120969 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 376 Larkin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 6007689.7019 | 2112608.237 | 37.7812538778377 | -122.417028695396 | (37.7812538778377, -122.417028695396) | 7 | 9 | 9 | 28852 | 36 | ||||
52117 | 131429 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 300 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6009867.09443 | 2114421.62691 | 37.7863552591459 | -122.40962398688 | (37.7863552591459, -122.40962398688) | 5 | 10 | 10 | 28852 | 36 | |||
52313 | 7731 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 300 Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | War Memorial 17 | 12 | 3x3 | 6006429.42696 | 2111183.21834 | 37.7772701477293 | -122.4212874096 | (37.7772701477293, -122.4212874096) | 7 | 9 | 11 | 28852 | 10 | |||
53122 | 131460 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 240 Ellis St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6009625.04441 | 2114015.97769 | 37.7852278771125 | -122.410432767864 | (37.7852278771125, -122.410432767864) | 14 | 10 | 9 | 28852 | 36 | |||
53161 | 245855 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 350 Laguna St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6005110.3262 | 2110160.0885 | 37.7743864261161 | -122.42577776482 | (37.7743864261161, -122.42577776482) | 7 | 9 | 11 | 28852 | 10 | |||
53278 | 131448 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 65 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6010354.65305 | 2114041.15525 | 37.7853378830921 | -122.407910310715 | (37.7853378830921, -122.407910310715) | 14 | 10 | 10 | 28852 | 36 | |||
54129 | 245852 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 350 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6005118.9395 | 2110099.7959 | 37.7742213640181 | -122.425743677462 | (37.7742213640181, -122.425743677462) | 7 | 9 | 11 | 28852 | 10 | |||
54407 | 131439 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 333 O'Farrell St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009740.30213 | 2114326.31803 | 37.7860864580769 | -122.410055926744 | (37.7860864580769, -122.410055926744) | 14 | 10 | 9 | 28852 | 36 | |||
54719 | 131453 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 30 Powell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6010407.74266 | 2113925.74357 | 37.7850239621269 | -122.407718495232 | (37.7850239621269, -122.407718495232) | 14 | 10 | 10 | 28852 | 6 | |||
55111 | 131442 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 245 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6009842.72913 | 2114248.49731 | 37.7858785213125 | -122.409696060348 | (37.7858785213125, -122.409696060348) | 14 | 10 | 9 | 28852 | 36 | |||
55172 | 142808 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 570 Polk St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6007172.1637 | 2112846.0936 | 37.7818778477773 | -122.418836000828 | (37.7818778477773, -122.418836000828) | 7 | 9 | 9 | 28852 | 36 | |||
55701 | 131489 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6009025.0433 | 2112895.25798 | 37.7821169953408 | -122.412429349139 | (37.7821169953408, -122.412429349139) | 7 | 10 | 9 | 28852 | 36 | |||
58376 | 7730 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 300 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | War Memorial 17 | 12 | 3x3 | 6006431.70019 | 2111170.55941 | 37.7772355175274 | -122.421278646599 | (37.7772355175274, -122.421278646599) | 7 | 9 | 11 | 28852 | 10 | |||
59206 | 131452 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 30 Powell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6010408.3153 | 2113905.69978 | 37.7849689586942 | -122.407715100279 | (37.7849689586942, -122.407715100279) | 14 | 10 | 10 | 28852 | 6 | |||
59568 | 131427 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 256 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6009191.26148 | 2113608.59985 | 37.7840849880821 | -122.411904731439 | (37.7840849880821, -122.411904731439) | 14 | 10 | 9 | 28852 | 36 | |||
59657 | 18483 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 10X Powell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6010431.72174 | 2113841.7632 | 37.7847947142736 | -122.407629611527 | (37.7847947142736, -122.407629611527) | 14 | 10 | 10 | 28852 | 6 | |||
61075 | 131495 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 599 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6007190.10119 | 2112936.77751 | 37.7821278537691 | -122.418780378511 | (37.7821278537691, -122.418780378511) | 7 | 9 | 9 | 28852 | 36 | |||
61797 | 117020 | Planning Code 138.1 required 2 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 168 Hyde St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777550 | 6008118.25915 | 2113018.66588 | 37.7824049150971 | -122.415575161466 | (37.7824049150971, -122.415575161466) | 7 | 10 | 9 | 28852 | 36 | |
62323 | 131503 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 599 Turk St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6007492.04889 | 2112974.98665 | 37.7822497631524 | -122.417738482458 | (37.7822497631524, -122.417738482458) | 7 | 9 | 9 | 28852 | 36 | |||
62656 | 131445 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 245 Mason St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6009851.97373 | 2114172.57855 | 37.7856705845808 | -122.409658716002 | (37.7856705845808, -122.409658716002) | 14 | 10 | 9 | 28852 | 36 | |||
62951 | 131480 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 333 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6007909.33155 | 2112688.94831 | 37.7814878440283 | -122.416274601095 | (37.7814878440283, -122.416274601095) | 7 | 10 | 9 | 28852 | 36 | |||
65558 | 102984 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 555 Turk St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007348.4 | 2112963.4 | 37.7822098643106 | -122.41823462296 | (37.7822098643106, -122.41823462296) | 7 | 9 | 9 | 28852 | 36 | ||||
65751 | 131438 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 333 O'Farrell St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009620.36723 | 2114315.57484 | 37.786050236973 | -122.410470112229 | (37.786050236973, -122.410470112229) | 14 | 10 | 9 | 28852 | 36 | |||
66777 | 18496 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 59 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 4X4 | 6010363.68125 | 2113973.70419 | 37.7851531839521 | -122.407874317642 | (37.7851531839521, -122.407874317642) | 14 | 10 | 10 | 28852 | 36 | |||
66817 | 35476 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 455 Golden Gate Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/17/1998 12:00:00 AM | 7 | Permit Number 38887 | 6007367.26407 | 2112616.43769 | 37.7812582515991 | -122.418144755699 | (37.7812582515991, -122.418144755699) | 7 | 9 | 9 | 28852 | 36 | ||
68035 | 117021 | Planning Code 138.1 required 2 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 168 Hyde St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777550 | 6008114.19003 | 2113031.70239 | 37.7824404814865 | -122.415590162171 | (37.7824404814865, -122.415590162171) | 7 | 10 | 9 | 28852 | 36 | |
68122 | 142805 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 548 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6007184.3475 | 2112772.0816 | 37.7816753147829 | -122.418788599911 | (37.7816753147829, -122.418788599911) | 7 | 9 | 9 | 28852 | 36 | |||
68872 | 100564 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 312 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6009858 | 2114440 | 37.7864051976389 | -122.409656748713 | (37.7864051976389, -122.409656748713) | 5 | 10 | 10 | 28852 | 36 | |||
71810 | 120975 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 399 Golden Gate Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007742 | 2112644 | 37.7813550161976 | -122.416850303744 | (37.7813550161976, -122.416850303744) | 7 | 10 | 9 | 28852 | 36 | |||||
72237 | 18485 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 10X Powell St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6010431.72174 | 2113841.7632 | 37.7847947142736 | -122.407629611527 | (37.7847947142736, -122.407629611527) | 14 | 10 | 10 | 28852 | 6 | |||
77179 | 131437 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 333 O'Farrell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009586.84821 | 2114307.95336 | 37.7860274310667 | -122.410585541087 | (37.7860274310667, -122.410585541087) | 14 | 10 | 9 | 28852 | 36 | |||
77289 | 35473 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 455 Golden Gate Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/17/1998 12:00:00 AM | 5 | Permit Number 38887 | 6007339.6011 | 2112611.80882 | 37.7812439847738 | -122.418240127899 | (37.7812439847738, -122.418240127899) | 7 | 9 | 9 | 28852 | 36 | ||
77603 | 131488 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 25 Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6008142.61987 | 2112486.03995 | 37.7809438216347 | -122.415453163946 | (37.7809438216347, -122.415453163946) | 7 | 10 | 9 | 28852 | 36 | |||
77658 | 94315 | Planning Code 138.1 required 2 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 399X Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777550 | 6008122 | 2112982 | 37.7823044496932 | -122.415559622955 | (37.7823044496932, -122.415559622955) | 7 | 10 | 9 | 28852 | 36 | |
78685 | 131433 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 290 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009909.65467 | 2114402.50015 | 37.7863051264344 | -122.409475388293 | (37.7863051264344, -122.409475388293) | 5 | 10 | 10 | 28852 | 36 | |||
78748 | 18486 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 10X Powell St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6010431.72174 | 2113841.7632 | 37.7847947142736 | -122.407629611527 | (37.7847947142736, -122.407629611527) | 14 | 10 | 10 | 28852 | 6 | |||
78890 | 131507 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 391 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6008146.95768 | 2113065.94872 | 37.7825363555003 | -122.415479225409 | (37.7825363555003, -122.415479225409) | 7 | 10 | 9 | 28852 | 36 | |||
79428 | 102985 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 555 Turk St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007348.4 | 2112963.4 | 37.7822098643106 | -122.41823462296 | (37.7822098643106, -122.41823462296) | 7 | 9 | 9 | 28852 | 36 | ||||
80808 | 131509 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 54 McAllister St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6008813.24843 | 2112515.87763 | 37.7810634197833 | -122.413135231526 | (37.7810634197833, -122.413135231526) | 7 | 10 | 9 | 28852 | 36 | |||
81286 | 54052 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 284 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/1972 12:00:00 AM | 12 | 3x3 | Permit Number 9774 | 6009944.92418425 | 2114405.86793531 | 37.7863163497004 | -122.409353602077 | (37.7863163497004, -122.409353602077) | 5 | 10 | 10 | 28852 | 36 | |
81347 | 117017 | Planning Code 138.1 required 2 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 168 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777550 | 6008130.7573 | 2112963.51283 | 37.7822541806174 | -122.415528017206 | (37.7822541806174, -122.415528017206) | 7 | 10 | 9 | 28852 | 36 | |
81893 | 35463 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 430 Polk St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/17/1998 12:00:00 AM | Permit Number 38886 | 6007237.08907724 | 2112375.34283194 | 37.7805889355944 | -122.418577996505 | (37.7805889355944, -122.418577996505) | 7 | 9 | 9 | 28852 | 36 | |||
82234 | 39236 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 450 Golden Gate Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1998 12:00:00 AM | 7 | Permit Number 40872 | 6007400.69008 | 2112672.52156 | 37.781414125695 | -122.418033094957 | (37.781414125695, -122.418033094957) | 7 | 9 | 9 | 28852 | 36 | ||
84973 | 108407 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 99x Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 12 | 3x3 | Permit Number 773269 | 6008123.88182 | 2112634.14044 | 37.7813494167874 | -122.415528476779 | (37.7813494167874, -122.415528476779) | 7 | 10 | 9 | 28852 | 36 | |
85839 | 131500 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 599 Turk St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6007377.02616 | 2112958.46502 | 37.7821979253276 | -122.418135239058 | (37.7821979253276, -122.418135239058) | 7 | 9 | 9 | 28852 | 36 | |||
86219 | 131479 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 455 Golden Gate Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6007541.67388 | 2112634.46959 | 37.7813175780732 | -122.417542660477 | (37.7813175780732, -122.417542660477) | 7 | 9 | 9 | 28852 | 36 | |||
87890 | 35477 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 455 Golden Gate Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/17/1998 12:00:00 AM | 7 | Permit Number 38887 | 6007459.46451 | 2112625.06322 | 37.7812871243533 | -122.417826398385 | (37.7812871243533, -122.417826398385) | 7 | 9 | 9 | 28852 | 36 | ||
88920 | 131474 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 440 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6007221.39742 | 2112495.83883 | 37.7809189050344 | -122.418640828906 | (37.7809189050344, -122.418640828906) | 7 | 9 | 9 | 28852 | 36 | |||
89395 | 131515 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 5ft | 6007406.95555 | 2111027.03783 | 37.7768963760133 | -122.41789474145 | (37.7768963760133, -122.41789474145) | 7 | 9 | 9 | 28852 | 36 | |||
89740 | 18492 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 41 Powell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6010272.95462 | 2113932.96668 | 37.7850362487489 | -122.408185330865 | (37.7850362487489, -122.408185330865) | 14 | 10 | 10 | 28852 | 36 | |||
90361 | 18491 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 41 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 4X4 | 6010272.95462 | 2113932.96668 | 37.7850362487489 | -122.408185330865 | (37.7850362487489, -122.408185330865) | 14 | 10 | 10 | 28852 | 36 | |||
90485 | 120976 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 399 Golden Gate Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007742 | 2112644 | 37.7813550161976 | -122.416850303744 | (37.7813550161976, -122.416850303744) | 7 | 10 | 9 | 28852 | 36 | |||||
90611 | 131430 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 300 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6009862.8392 | 2114434.38658 | 37.7863900557017 | -122.409639609883 | (37.7863900557017, -122.409639609883) | 5 | 10 | 10 | 28852 | 36 | |||
90733 | 39237 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 450 Golden Gate Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1998 12:00:00 AM | 6 | Permit Number 40872 | 6007370.26248 | 2112668.82776 | 37.7814022708283 | -122.418138097991 | (37.7814022708283, -122.418138097991) | 7 | 9 | 9 | 28852 | 36 | ||
92267 | 102980 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 555 Turk St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007348.4 | 2112963.4 | 37.7822098643106 | -122.41823462296 | (37.7822098643106, -122.41823462296) | 7 | 9 | 9 | 28852 | 36 | ||||
93009 | 131516 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2 Polk St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6007396.8469 | 2111134.69849 | 37.7771914174847 | -122.417937344141 | (37.7771914174847, -122.417937344141) | 7 | 9 | 9 | 28852 | 36 | |||
93029 | 142804 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 401 Larkin St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6007611.6893 | 2112827.727 | 37.7818521556351 | -122.417314140113 | (37.7818521556351, -122.417314140113) | 7 | 9 | 9 | 28852 | 36 | |||
93647 | 120972 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 399 Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 6007792.03946 | 2112672.19297 | 37.7814352417762 | -122.416679188994 | (37.7814352417762, -122.416679188994) | 7 | 10 | 9 | 28852 | 36 | ||||
94039 | 39240 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 450 Golden Gate Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1998 12:00:00 AM | 7 | Permit Number 40872 | 6007278.86556 | 2112652.19627 | 37.7813514600389 | -122.418453108031 | (37.7813514600389, -122.418453108031) | 7 | 9 | 9 | 28852 | 36 | ||
94645 | 131423 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 455 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6009309.57479 | 2114551.58799 | 37.7866808442822 | -122.411562055547 | (37.7866808442822, -122.411562055547) | 5 | 10 | 9 | 28852 | 36 | |||
94832 | 18481 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 10X Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6010431.72174 | 2113841.7632 | 37.7847947142736 | -122.407629611527 | (37.7847947142736, -122.407629611527) | 14 | 10 | 10 | 28852 | 6 | |||
96013 | 131492 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100 Golden Gate Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6008958.59126 | 2112886.74672 | 37.7820898960759 | -122.412658642087 | (37.7820898960759, -122.412658642087) | 7 | 10 | 9 | 28852 | 36 | |||
96772 | 142800 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 441 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6007598.2326 | 2112926.2884 | 37.7821220243165 | -122.417367681073 | (37.7821220243165, -122.417367681073) | 7 | 9 | 9 | 28852 | 36 | |||
97431 | 131456 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 30 Powell St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6010396.29569 | 2113989.98173 | 37.7851997040536 | -122.407762629464 | (37.7851997040536, -122.407762629464) | 14 | 10 | 10 | 28852 | 6 | |||
97662 | 117018 | Planning Code 138.1 required 2 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 168 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777550 | 6008125.66458 | 2112987.05621 | 37.7823185388132 | -122.415547303188 | (37.7823185388132, -122.415547303188) | 7 | 10 | 9 | 28852 | 36 | |
98207 | 131463 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 240 Ellis St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6009455.03534 | 2113979.87366 | 37.7851192120233 | -122.411018398278 | (37.7851192120233, -122.411018398278) | 14 | 10 | 9 | 28852 | 36 | |||
98569 | 18490 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 29 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 4x4 | 6010377.42756 | 2113906.8182 | 37.784970300477 | -122.407822041378 | (37.784970300477, -122.407822041378) | 14 | 10 | 10 | 28852 | 36 | |||
98581 | 35467 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 430 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/17/1998 12:00:00 AM | Permit Number 38886 | 6007237.08907724 | 2112375.34283194 | 37.7805889355944 | -122.418577996505 | (37.7805889355944, -122.418577996505) | 7 | 9 | 9 | 28852 | 36 | |||
101442 | 18482 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 10X Powell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6010431.72174 | 2113841.7632 | 37.7847947142736 | -122.407629611527 | (37.7847947142736, -122.407629611527) | 14 | 10 | 10 | 28852 | 6 | |||
101507 | 131435 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 333 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6009439.52365 | 2114286.3168 | 37.7859597615809 | -122.411093717397 | (37.7859597615809, -122.411093717397) | 14 | 10 | 9 | 28852 | 36 | |||
102130 | 142806 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 550 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6007178.5284 | 2112797.5403 | 37.7817448905574 | -122.418810537383 | (37.7817448905574, -122.418810537383) | 7 | 9 | 9 | 28852 | 36 | |||
102353 | 131491 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100 Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6008978.48 | 2112890.04129 | 37.7821000584078 | -122.412590068788 | (37.7821000584078, -122.412590068788) | 7 | 10 | 9 | 28852 | 36 | |||
104199 | 39239 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 450 Golden Gate Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1998 12:00:00 AM | 11 | Permit Number 40872 | 6007311.11292 | 2112654.00244 | 37.7813582346481 | -122.418341675743 | (37.7813582346481, -122.418341675743) | 7 | 9 | 9 | 28852 | 36 | ||
104217 | 18495 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 53 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/1991 12:00:00 AM | 5 | 4X4 | 6010365.89587 | 2113957.09982 | 37.7851077162803 | -122.407865484424 | (37.7851077162803, -122.407865484424) | 14 | 10 | 10 | 28852 | 36 | ||
104570 | 39235 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 450 Golden Gate Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1998 12:00:00 AM | 9 | Permit Number 40872 | 6007429.24766 | 2112675.63731 | 37.781424288039 | -122.417934520279 | (37.781424288039, -122.417934520279) | 7 | 9 | 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 | |
105993 | 7733 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 300 Franklin St | 4 | Sidewalk: Curb side : Cutout | Tree | War Memorial 17 | 12 | 3x3 | 6006420.56293 | 2111227.36292 | 37.7773908583325 | -122.421321208805 | (37.7773908583325, -122.421321208805) | 7 | 9 | 11 | 28852 | 10 | |||
106525 | 39241 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 450 Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1998 12:00:00 AM | 8 | Permit Number 40872 | 6007524.30861 | 2112689.7266 | 37.7814683233506 | -122.417606653531 | (37.7814683233506, -122.417606653531) | 7 | 9 | 9 | 28852 | 36 | ||
106610 | 142802 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 421 Larkin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6007604.0517 | 2112880.4628 | 37.7819965256936 | -122.417344301066 | (37.7819965256936, -122.417344301066) | 7 | 9 | 9 | 28852 | 36 | |||
108153 | 39234 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 450 Golden Gate Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1998 12:00:00 AM | 8 | Permit Number 40872 | 6007465.2982 | 2112681.68355 | 37.7814429183935 | -122.417810231283 | (37.7814429183935, -122.417810231283) | 7 | 9 | 9 | 28852 | 36 | ||
110582 | 131458 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 30 Powell St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6010385.0802 | 2114041.51221 | 37.7853405666475 | -122.407805066666 | (37.7853405666475, -122.407805066666) | 14 | 10 | 10 | 28852 | 6 | |||
110961 | 43069 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 501 Geary St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/2000 12:00:00 AM | Permit Number 42918 | 6009321.30456052 | 2114618.7954083 | 37.7868660376301 | -122.411526223257 | (37.7868660376301, -122.411526223257) | 5 | 1 | 9 | 28852 | 36 | ||
111202 | 131432 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 300 Mason St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6009855.5243 | 2114478.27764 | 37.7865101601487 | -122.409668016778 | (37.7865101601487, -122.409668016778) | 5 | 10 | 10 | 28852 | 36 | |||
112294 | 39230 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 450 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1998 12:00:00 AM | 7 | Permit Number 40872 | 6007583.29397 | 2112696.5368 | 37.7814903414384 | -122.417403074904 | (37.7814903414384, -122.417403074904) | 7 | 9 | 9 | 28852 | 36 | ||
113736 | 138850 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 501 OCTAVIA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6005420.7303 | 2111069.008 | 37.776899634116 | -122.424768692311 | (37.776899634116, -122.424768692311) | 7 | 9 | 11 | 28852 | 10 | |||
113871 | 131449 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 65 Powell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6010356.16668 | 2114019.13789 | 37.7852775133954 | -122.407903520831 | (37.7852775133954, -122.407903520831) | 14 | 10 | 10 | 28852 | 36 | |||
114952 | 108409 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 99x Hyde St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 13 | 3x3 | Permit Number 773269 | 6008129.59407 | 2112591.6747 | 37.7812331371452 | -122.415505707716 | (37.7812331371452, -122.415505707716) | 7 | 10 | 9 | 28852 | 36 | |
115189 | 142816 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 401 LARKIN ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6007645.3311 | 2112592.2344 | 37.7812074424706 | -122.41718106262 | (37.7812074424706, -122.41718106262) | 7 | 9 | 9 | 28852 | 36 | |||
116170 | 63395 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 345 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/18/1987 12:00:00 AM | 6 | Permit Number 23977 | 6009361.09199 | 2114172.80795 | 37.7856436948569 | -122.411357048805 | (37.7856436948569, -122.411357048805) | 14 | 10 | 9 | 28852 | 36 | ||
116795 | 131462 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 240 Ellis St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6009485.60196 | 2113987.0666 | 37.7851406761379 | -122.410913155112 | (37.7851406761379, -122.410913155112) | 14 | 10 | 9 | 28852 | 36 | |||
117056 | 120971 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 399 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 6007749.87117 | 2112664.99032 | 37.781413093288 | -122.416824560813 | (37.781413093288, -122.416824560813) | 7 | 10 | 9 | 28852 | 36 | ||||
117063 | 131441 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 245 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6009836.86174 | 2114273.53497 | 37.7859469399444 | -122.409718127886 | (37.7859469399444, -122.409718127886) | 14 | 10 | 9 | 28852 | 36 | |||
117904 | 121076 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 500x Polk St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6007170.66569 | 2112873.3893 | 37.7819527108018 | -122.418843119712 | (37.7819527108018, -122.418843119712) | 7 | 9 | 9 | 28852 | 36 |
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) );