Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▲ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10259 | 10259 | 141190 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1771 ELLIS ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9999 | Width 0ft | 6002407.0405 | 2112959.471 | 37.781919696317296 | -122.43532920805599 | (37.7819196963173, -122.435329208056) | |||
6334 | 6334 | 6269 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1355 Ellis St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 125 | 3X3 | 6004413.7404 | 2113247.5728 | 37.7828245080819 | -122.42840749249201 | (37.7828245080819, -122.428407492492) | |||
2681 | 2681 | 10334 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 850 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 4X4 | 6002067.0 | 2109164.0 | 37.7714789673294 | -122.436233885162 | (37.7714789673294, -122.436233885162) | |||
3503 | 3503 | 14499 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 350 Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 4x4 | 5999064.4701 | 2111602.7455 | 37.7780040877061 | -122.44679526057199 | (37.7780040877061, -122.446795260572) | |||
5742 | 5742 | 14498 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 350 Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 5999068.9707 | 2111582.6972 | 37.7779492973394 | -122.44677824853001 | (37.7779492973394, -122.44677824853) | |||
5814 | 5814 | 6256 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1315 Ellis St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6004614.9344 | 2113276.215 | 37.7829145353129 | -122.427713486832 | (37.7829145353129, -122.427713486832) | |||
7137 | 7137 | 6252 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1315 Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6004508.0501 | 2113262.2432 | 37.78287012558321 | -122.42808226621099 | (37.7828701255832, -122.428082266211) | |||
17143 | 17143 | 10434 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1457 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 5999128.9575 | 2108690.2041 | 37.7700106766776 | -122.44636259863998 | (37.7700106766776, -122.44636259864) | |||
17349 | 17349 | 10372 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1216 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6000283.8166 | 2108900.9156 | 37.7706551281266 | -122.442383101019 | (37.7706551281266, -122.442383101019) | |||
18605 | 18605 | 10373 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1234 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 9x5 | 6000208.6256 | 2108891.1906 | 37.770624139779 | -122.44264248857 | (37.770624139779, -122.44264248857) | |||
19432 | 19432 | 5731 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1703 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6005358.59777 | 2098401.9936900004 | 37.7421154825341 | -122.424082592458 | (37.7421154825341, -122.424082592458) | |||
20706 | 20706 | 10325 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 807 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6002259.2753800005 | 2109123.5178 | 37.7713787357685 | -122.435565898974 | (37.7713787357685, -122.435565898974) | |||
22001 | 22001 | 10329 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 826 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 4X4 | 6002169.5428 | 2109164.5209999997 | 37.7714862234563 | -122.435879222083 | (37.7714862234563, -122.435879222083) | |||
77970 | 77970 | 12741 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1638 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 100 | 4X4 | 5990321.4540800005 | 2114762.4147099997 | 37.786176325151295 | -122.47727111168899 | (37.7861763251513, -122.477271111689) | |||
92656 | 92656 | 10376 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1255X Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 21x6 | 6000170.7774495995 | 2108835.6049214 | 37.7704693578958 | -122.44276941339199 | (37.7704693578958, -122.442769413392) | |||
101797 | 101797 | 1506 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 345 Arguello Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 5995528.42515 | 2113903.2607299997 | 37.7841180535654 | -122.45919424672701 | (37.7841180535654, -122.459194246727) | |||
103017 | 103017 | 10275 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 222 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3x3 | 6004852.2764800005 | 2109616.19972 | 37.772878454111705 | -122.42663166961701 | (37.7728784541117, -122.426631669617) | |||
106368 | 106368 | 10362 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1126 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X4 | 6000713.44362 | 2108968.6618 | 37.7708656202791 | -122.440901879767 | (37.7708656202791, -122.440901879767) | |||
112742 | 112742 | 13155 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1871 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 100 | 3x3 | 6003453.14477 | 2119540.71202 | 37.8000494585448 | -122.43218031398199 | (37.8000494585448, -122.432180313982) | |||
143064 | 143064 | 12729 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1600 Lake St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 5990435.001209999 | 2114760.85795 | 37.786178638116 | -122.47687815891899 | (37.786178638116, -122.476878158919) | |||
143942 | 143942 | 14544 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 740 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 5x5 | 5999285.75973 | 2110200.8265 | 37.7741674161959 | -122.445928888319 | (37.7741674161959, -122.445928888319) | |||
5576 | 5576 | 14497 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 350 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 5999071.4256 | 2111558.1482 | 37.7778820323449 | -122.446767989356 | (37.7778820323449, -122.446767989356) | |||
6364 | 6364 | 13127 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1700 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 6004182.8465 | 2119787.4466 | 37.8007682730329 | -122.42967287413 | (37.8007682730329, -122.42967287413) | |||
17953 | 17953 | 5410 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 400 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 4X6 | 6004853.94973 | 2105972.8018799997 | 37.762874653875606 | -122.426366424394 | (37.7628746538756, -122.426366424394) | |||
18464 | 18464 | 5398 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 347 Dolores St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6004916.74294 | 2106419.98328 | 37.7641060568743 | -122.426181082194 | (37.7641060568743, -122.426181082194) | |||
18860 | 18860 | 10473 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1632 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3x3 | 5998321.0771 | 2108628.9487 | 37.7697963108216 | -122.449152617838 | (37.7697963108216, -122.449152617838) | |||
19006 | 19006 | 10367 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1190 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X4 | 6000483.5353 | 2108928.9047 | 37.77074336050121 | -122.441694282188 | (37.7707433605012, -122.441694282188) | |||
20007 | 20007 | 10371 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1202 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6000331.2557 | 2108908.0315 | 37.7706773703693 | -122.442219519892 | (37.7706773703693, -122.442219519892) | |||
20012 | 20012 | 10298 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 545 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6003525.02911 | 2109303.7259299997 | 37.771945352740005 | -122.43120046383699 | (37.77194535274, -122.431200463837) | |||
20504 | 20504 | 10495 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1701 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3x3 | 5997835.7259 | 2108510.475 | 37.7694432404816 | -122.450822883239 | (37.7694432404816, -122.450822883239) | |||
20788 | 20788 | 14571 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 5x5 | 5999361.6418 | 2109001.7234 | 37.7708793165263 | -122.445580154944 | (37.7708793165263, -122.445580154944) | |||
20794 | 20794 | 10296 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 533 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6003575.42628 | 2109315.1173099997 | 37.7719794864975 | -122.431026949543 | (37.7719794864975, -122.431026949543) | |||
21128 | 21128 | 14599 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1250 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 5999487.9613 | 2108521.9825 | 37.769569280142996 | -122.44510871908001 | (37.769569280143, -122.44510871908) | |||
21600 | 21600 | 10501 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1738 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3x3 | 5997829.7408 | 2108561.4434 | 37.769582844047896 | -122.450847260907 | (37.7695828440479, -122.450847260907) | |||
21617 | 21617 | 5729 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1699 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6005355.71793 | 2098501.9900599997 | 37.7423898872871 | -122.424099659768 | (37.7423898872871, -122.424099659768) | |||
84185 | 84185 | 5423 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 460X Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6004889.2026724005 | 2105697.5669461996 | 37.7621209168257 | -122.42622490044901 | (37.7621209168257, -122.426224900449) | |||
98768 | 98768 | 12732 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1619 Lake St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 5990481.52989 | 2114717.45643 | 37.7860621686584 | -122.476714011555 | (37.7860621686584, -122.476714011555) | |||
101463 | 101463 | 11447 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2X Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3 | 5995514.85453 | 2115936.98374 | 37.789701328403794 | -122.459388527967 | (37.7897013284038, -122.459388527967) | |||
115458 | 115458 | 9984 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 699X Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 5999124.13341 | 2110521.95513 | 37.7750399229531 | -122.446511088309 | (37.7750399229531, -122.446511088309) | |||
117968 | 117968 | 5435 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 500X Dolores St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 90 | 6 | 6004896.4850004995 | 2105439.5076575 | 37.7614127588524 | -122.426181340905 | (37.7614127588524, -122.426181340905) | |||
125837 | 125837 | 12727 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1600 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 4X4 | 5990457.1993 | 2114785.86556 | 37.7862485896694 | -122.476803188002 | (37.7862485896694, -122.476803188002) | |||
127236 | 127236 | 5415 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 430X Dolores St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 6 | 6004853.970832599 | 2105864.857711 | 37.7625782660478 | -122.42635866544599 | (37.7625782660478, -122.426358665446) | |||
141559 | 141559 | 10422 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1407 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3x3 | 5999387.74957 | 2108726.3420700002 | 37.7701246795762 | -122.44547004321699 | (37.7701246795762, -122.445470043217) | |||
7372 | 7372 | 6254 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1315 Ellis St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 85 | 3X3 | 6004557.65 | 2113267.8319 | 37.7828882768645 | -122.427911069574 | (37.7828882768645, -122.427911069574) | |||
6819 | 6819 | 23867 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1460 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 4X6 | 6003686.8148 | 2113759.4476 | 37.7841888268021 | -122.430958893029 | (37.7841888268021, -122.430958893029) | |||
8403 | 8403 | 23863 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1420 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 4X4 | 6003705.9488 | 2113626.0727 | 37.783823696929396 | -122.430883174483 | (37.7838236969294, -122.430883174483) | |||
17936 | 17936 | 10282 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 359 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6004422.78828 | 2109427.83457 | 37.772336958917606 | -122.428103893873 | (37.7723369589176, -122.428103893873) | |||
21444 | 21444 | 14592 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1222 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3x3 | 5999472.8199 | 2108630.0925 | 37.7698652586639 | -122.445168866065 | (37.7698652586639, -122.445168866065) | |||
21846 | 21846 | 5476 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 635 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 80 | 4X4 | 6005015.06111 | 2104677.01858 | 37.7593258454205 | -122.425716962778 | (37.7593258454205, -122.425716962778) | |||
82439 | 82439 | 10255 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 140 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6005448.277840001 | 2109623.5866799997 | 37.7729324136912 | -122.424570554491 | (37.7729324136912, -122.424570554491) | |||
85625 | 85625 | 382 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3721X 19th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 2 | 5990351.3309 | 2090950.31436 | 37.72079632016629 | -122.475428522866 | (37.7207963201663, -122.475428522866) | |||
87467 | 87467 | 10261 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 198 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X4 | 6005221.62679 | 2109603.34443 | 37.772864030808 | -122.425353127526 | (37.772864030808, -122.425353127526) | |||
89238 | 89238 | 12750 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1720 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 5990071.960109999 | 2114756.1152 | 37.7861445495756 | -122.47813382493601 | (37.7861445495756, -122.478133824936) | |||
99200 | 99200 | 22800 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 300X Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 5999029.37493 | 2111788.901 | 37.7785132178028 | -122.44693006588699 | (37.7785132178028, -122.446930065887) | |||
111396 | 111396 | 14594 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1232 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3x3 | 5999479.363609999 | 2108625.40478 | 37.769852760873 | -122.445145894536 | (37.769852760873, -122.445145894536) | |||
119220 | 119220 | 20107 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1875X Haight St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 5997178.90707 | 2108418.4655400002 | 37.7691529849708 | -122.453088136651 | (37.7691529849708, -122.453088136651) | |||
6338 | 6338 | 6270 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1355 Ellis St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 75 | 3X3 | 6004445.8756 | 2113251.7643 | 37.782837835273206 | -122.428296616989 | (37.7828378352732, -122.428296616989) | |||
8035 | 8035 | 6267 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1355 Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 75 | 3X3 | 6004345.2786 | 2113236.3953 | 37.7827899431792 | -122.42864354459499 | (37.7827899431792, -122.428643544595) | |||
17952 | 17952 | 22564 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 225 Topaz Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 75 | 3X3 | 6001403.30325 | 2097649.91071 | 37.7398263284251 | -122.437704879797 | (37.7398263284251, -122.437704879797) | |||
19070 | 19070 | 4884 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 639X Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 4X4 | 6005016.1788 | 2104614.4519599997 | 37.7591541153895 | -122.425708644037 | (37.7591541153895, -122.425708644037) | |||
22010 | 22010 | 5354 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 214 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 6 | 6004794.21046 | 2107092.80643 | 37.7659465419134 | -122.426652801811 | (37.7659465419134, -122.426652801811) | |||
82708 | 82708 | 10263 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 212 Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6005030.70582 | 2109564.31462 | 37.77274607605089 | -122.426010766966 | (37.7727460760509, -122.426010766966) | |||
84213 | 84213 | 23853 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 4X4 | 6003700.6561807 | 2113512.2535027 | 37.7835108780695 | -122.430893359317 | (37.7835108780695, -122.430893359317) | |||
90438 | 90438 | 11451 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 30 ARGUELLO BLVD | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X12 | 5995510.0 | 2115730.0 | 37.789132728017 | -122.45939032806801 | (37.789132728017, -122.459390328068) | |||
96746 | 96746 | 27434 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1275 Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/03/2015 12:00:00 AM | 70 | 3X3 | 6007539.61625 | 2121483.94928 | 37.8056159411906 | -122.41817736946899 | (37.8056159411906, -122.418177369469) | ||
97198 | 97198 | 10426 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1418 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3x4 | 5999318.4357900005 | 2108766.88191 | 37.7702320345214 | -122.44571271379 | (37.7702320345214, -122.44571271379) | |||
141134 | 141134 | 12730 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1619 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3x3 | 5990437.55256 | 2114717.69591 | 37.786060275243294 | -122.476866177185 | (37.7860602752433, -122.476866177185) | |||
21070 | 21070 | 10450 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1535 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 65 | 3X3 | 5998775.5559 | 2108640.5401 | 37.769854121546395 | -122.447581428516 | (37.7698541215464, -122.447581428516) | |||
341 | 341 | 14553 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 875 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 5999239.2853 | 2109883.9856 | 37.7732947980524 | -122.446066856713 | (37.7732947980524, -122.446066856713) | |||
670 | 670 | 13108 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1557 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3x3 | 6004929.5061 | 2119810.12 | 37.80087277869679 | -122.427090735634 | (37.8008727786968, -122.427090735634) | |||
17176 | 17176 | 5399 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 347 Dolores St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6004915.02967 | 2106451.3331299997 | 37.764192039253004 | -122.426189239948 | (37.764192039253, -122.426189239948) | |||
17963 | 17963 | 9405 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 473 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6001706.5922 | 2097649.68492 | 37.7398429487944 | -122.43665621990499 | (37.7398429487944, -122.436656219905) | |||
18289 | 18289 | 5540 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900X Dolores St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6005033.64005 | 2102782.9896400003 | 37.7541263358861 | -122.425517912248 | (37.7541263358861, -122.425517912248) | |||
18513 | 18513 | 5608 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1148 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6005093.57807 | 2101711.52687 | 37.7511877345454 | -122.425234393764 | (37.7511877345454, -122.425234393764) | |||
21007 | 21007 | 14593 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1227 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 5999415.7366 | 2108593.9044 | 37.7697626368824 | -122.44536371280898 | (37.7697626368824, -122.445363712809) | |||
21950 | 21950 | 5509 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 807 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 5X5 | 6005073.51013 | 2103628.5671599996 | 37.7564503468259 | -122.42544020362301 | (37.7564503468259, -122.425440203623) | |||
92803 | 92803 | 12746 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1708 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 5990140.905069999 | 2114757.41663 | 37.7861521246527 | -122.477895391404 | (37.7861521246527, -122.477895391404) | |||
101444 | 101444 | 12809 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2112 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 5 | 5988863.55424 | 2114711.62184 | 37.7859521665696 | -122.482311278452 | (37.7859521665696, -122.482311278452) | |||
114004 | 114004 | 11450 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 30X ARGUELLO BLVD | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X12 | 5995510.0 | 2115730.0 | 37.789132728017 | -122.45939032806801 | (37.789132728017, -122.459390328068) | |||
139842 | 139842 | 5418 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 430X Dolores St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 6 | 6004853.970832599 | 2105864.857711 | 37.7625782660478 | -122.42635866544599 | (37.7625782660478, -122.426358665446) | |||
131350 | 131350 | 186614 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1501 Sunset Blvd | 85 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 57 | Width 0ft | 5984775.1737 | 2104397.9779 | 37.7573951766754 | -122.495694716519 | (37.7573951766754, -122.495694716519) | |||
5472 | 5472 | 6255 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1315 Ellis St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 55 | 3X3 | 6004589.0866 | 2113270.6263 | 37.782897727980206 | -122.427802511173 | (37.7828977279802, -122.427802511173) | |||
17458 | 17458 | 10319 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 739 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 6002579.70252 | 2109173.84871 | 37.7715351260824 | -122.434461126791 | (37.7715351260824, -122.434461126791) | |||
18859 | 18859 | 10484 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1668 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 5998167.2674 | 2108607.159 | 37.7697276834376 | -122.449683068712 | (37.7697276834376, -122.449683068712) | |||
102239 | 102239 | 7100 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2058 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3x3 | 5997582.9576900005 | 2109593.20764 | 37.772401673045394 | -122.451775311192 | (37.7724016730454, -122.451775311192) | |||
125152 | 125152 | 12736 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1625 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 5990372.3863 | 2114714.93418 | 37.786048911894795 | -122.477091430633 | (37.7860489118948, -122.477091430633) | |||
97092 | 97092 | 5467 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 600X Dolores St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 48 | 6004918.892342701 | 2104703.9652182 | 37.7593943997498 | -122.426051479658 | (37.7593943997498, -122.426051479658) | ||||
7077 | 7077 | 6266 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1355 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6004309.6505 | 2113217.5334 | 37.7827361367074 | -122.428765457764 | (37.7827361367074, -122.428765457764) | |||
120724 | 120724 | 13067 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 610 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 2X2 | 6009404.55183 | 2120549.65161 | 37.803155386878 | -122.41165741430001 | (37.803155386878, -122.4116574143) | |||
37447 | 37447 | 220241 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 10x Benton Ave | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 42 | 6004791.23434 | 2095030.3631099998 | 37.7328256962469 | -122.425804423654 | (37.7328256962469, -122.425804423654) | ||||
65626 | 65626 | 247850 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 152 Chapman St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 42 | 6009080.756440001 | 2098231.91815 | 37.7418579436943 | -122.41120047681801 | (37.7418579436943, -122.411200476818) | ||||
117772 | 117772 | 98323 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1899X Pierce St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 42 | 3x3 | 6001966.9 | 2114999.4 | 37.7874958161075 | -122.4369979772 | (37.7874958161075, -122.4369979772) | |||
121153 | 121153 | 98325 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1899X Pierce St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 42 | 3x3 | 6001829.0 | 2114886.0 | 37.7871766097641 | -122.43746695879999 | (37.7871766097641, -122.4374669588) | |||
72260 | 72260 | 188721 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1062 Key Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 41 | Width 5ft | 6013117.817000001 | 2089964.07481 | 37.7193817246629 | -122.396662082497 | (37.7193817246629, -122.396662082497) | |||
6522 | 6522 | 14481 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 281 Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/09/1990 12:00:00 AM | 40 | 3X3 | 5998935.5096 | 2112063.3301 | 37.779261366231104 | -122.447274536897 | (37.7792613662311, -122.447274536897) | ||
8054 | 8054 | 14425 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 90X Masonic Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 12 | 5998875.1013 | 2112962.0092 | 37.781725454134396 | -122.447548220181 | (37.7817254541344, -122.447548220181) | |||
17243 | 17243 | 9406 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 479 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6001730.266559999 | 2097665.12438 | 37.7398866873164 | -122.436575468878 | (37.7398866873164, -122.436575468878) | |||
98662 | 98662 | 358 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3690X 19th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 2 | 5990489.74295 | 2091103.38095 | 37.7212246253626 | -122.474961247113 | (37.7212246253626, -122.474961247113) | |||
104032 | 104032 | 98994 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 745X SANCHEZ ST | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 40 | 6003713.0 | 2103768.0 | 37.7567562336472 | -122.430155272915 | (37.7567562336472, -122.430155272915) | ||||
110954 | 110954 | 10487 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1672 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 5998120.168880001 | 2108653.8259900003 | 37.769853124399795 | -122.449849344019 | (37.7698531243998, -122.449849344019) |
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");