Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, DBH, PlotSize, PermitNotes
| Link | rowid | TreeID ▲ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 184620 | 184620 | 221570 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 117 Alpine Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001705.56397 | 2108155.3423 | 37.768688901296294 | -122.437411868978 | (37.7686889012963, -122.437411868978) | |||
| 51201 | 51201 | 221569 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 616 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6003001.08037 | 2104529.5167 | 37.7588068286936 | -122.432671745707 | (37.7588068286936, -122.432671745707) | |||
| 41267 | 41267 | 221568 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 359 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6001813.22675 | 2103761.96483 | 37.7566318794794 | -122.436724942504 | (37.7566318794794, -122.436724942504) | |||
| 155244 | 155244 | 221567 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 324 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004154.58593 | 2103373.98314 | 37.7556993571514 | -122.428600021096 | (37.7556993571514, -122.428600021096) | |||
| 55535 | 55535 | 221566 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 4286 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001342.8820400005 | 2102344.46852 | 37.7527130350975 | -122.43825001643299 | (37.7527130350975, -122.438250016433) | |||
| 158034 | 158034 | 221565 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 4286 23rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001328.916669999 | 2102339.67059 | 37.7526990668325 | -122.438297967381 | (37.7526990668325, -122.438297967381) | |||
| 179875 | 179875 | 221564 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 4286 23rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001316.917769999 | 2102341.7359599997 | 37.7527040553705 | -122.438339609582 | (37.7527040553705, -122.438339609582) | |||
| 179284 | 179284 | 221563 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 4286 23rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001305.60339 | 2102341.6071 | 37.752703058000705 | -122.438378727412 | (37.7527030580007, -122.438378727412) | |||
| 44105 | 44105 | 221562 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 100 San Jose Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006161.28805 | 2102498.9287799997 | 37.753410020459995 | -122.421598049829 | (37.75341002046, -122.421598049829) | |||
| 148793 | 148793 | 221561 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 100 San Jose Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006161.81341 | 2102510.42937 | 37.7534416280528 | -122.42159704977 | (37.7534416280528, -122.42159704977) | |||
| 71884 | 71884 | 221560 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 100 San Jose Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006161.42459 | 2102519.64651 | 37.7534669142699 | -122.42159904898001 | (37.7534669142699, -122.42159904898) | |||
| 155379 | 155379 | 221559 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 1306 York St | 4 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6010039.89073 | 2101557.1439900002 | 37.7510420290671 | -122.408118546954 | (37.7510420290671, -122.408118546954) | |||
| 169550 | 169550 | 221558 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000x Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6005728.5881 | 2102926.2105099997 | 37.754558828830106 | -122.423124788381 | (37.7545588288301, -122.423124788381) | |||
| 67326 | 67326 | 221557 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000x Guerrero St | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6005743.02813 | 2102638.73526 | 37.7537703032837 | -122.42305441913099 | (37.7537703032837, -122.423054419131) | |||
| 180267 | 180267 | 221556 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000x Guerrero St | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6005741.57845 | 2102677.06839 | 37.753875475376 | -122.42306215689501 | (37.753875475376, -122.423062156895) | |||
| 182798 | 182798 | 221555 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000x Guerrero St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 3ft | 6005738.9106 | 2102712.57542 | 37.753972818908 | -122.423073906548 | (37.753972818908, -122.423073906548) | |||
| 76663 | 76663 | 221554 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000x Guerrero St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 3ft | 6005736.5559 | 2102753.56312 | 37.754085228758505 | -122.423084962814 | (37.7540852287585, -122.423084962814) | |||
| 68227 | 68227 | 221553 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000x Guerrero St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6005734.111409999 | 2102791.4847 | 37.7541892146839 | -122.42309611170799 | (37.7541892146839, -122.423096111708) | |||
| 176544 | 176544 | 221552 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000x Guerrero St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6005734.10722 | 2102815.94179 | 37.754256367947704 | -122.423097864468 | (37.7542563679477, -122.423097864468) | |||
| 143107 | 143107 | 221551 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000x Guerrero St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 3ft | 6005731.5319 | 2102850.00284 | 37.7543497463656 | -122.423109191463 | (37.7543497463656, -122.423109191463) | |||
| 177873 | 177873 | 221550 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000x Guerrero St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 3ft | 6005729.97057 | 2102894.68155 | 37.7544723356343 | -122.423117766494 | (37.7544723356343, -122.423117766494) | |||
| 176764 | 176764 | 221549 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000x Guerrero St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 3ft | 6005728.89674 | 2102911.59468 | 37.7545187145683 | -122.423122682192 | (37.7545187145683, -122.423122682192) | |||
| 131374 | 131374 | 221548 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000x Guerrero St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6005727.072790001 | 2102965.9789400003 | 37.7546679382008 | -122.42313285530899 | (37.7546679382008, -122.423132855309) | |||
| 135861 | 135861 | 221547 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000x Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6005723.41397 | 2102999.7023 | 37.7547603282456 | -122.42314790545299 | (37.7547603282456, -122.423147905453) | |||
| 76927 | 76927 | 221546 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000x Guerrero St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6005723.96055 | 2103030.09242 | 37.7548438033068 | -122.423148175257 | (37.7548438033068, -122.423148175257) | |||
| 34286 | 34286 | 221545 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000x Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 3ft | 6005721.87722 | 2103062.7074700003 | 37.754933239094704 | -122.423157698184 | (37.7549332390947, -122.423157698184) | |||
| 168829 | 168829 | 221544 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 900x Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 3ft | 6005705.623380001 | 2103333.32509 | 37.755675374928295 | -122.423233144119 | (37.7556753749283, -122.423233144119) | |||
| 61658 | 61658 | 221543 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 900x Guerrero St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 3ft | 6005707.0284 | 2103306.91954 | 37.7556029507207 | -122.42322640818999 | (37.7556029507207, -122.42322640819) | |||
| 149575 | 149575 | 221542 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 900x Guerrero St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 3ft | 6005709.18006 | 2103278.9471400003 | 37.7555262664424 | -122.423216978787 | (37.7555262664424, -122.423216978787) | |||
| 178961 | 178961 | 221541 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 900x Guerrero St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 3ft | 6005710.1718 | 2103251.3867 | 37.7554506478492 | -122.423211590049 | (37.7554506478492, -122.423211590049) | |||
| 34243 | 34243 | 221540 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1100x Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 3ft | 6005754.92272 | 2102467.8076299997 | 37.753301646771 | -122.42300113699301 | (37.753301646771, -122.423001136993) | |||
| 177057 | 177057 | 221539 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1100x Guerrero St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 3ft | 6005756.51513 | 2102435.1394700003 | 37.753212037416 | -122.422993308391 | (37.753212037416, -122.422993308391) | |||
| 32785 | 32785 | 221538 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1100x Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 3ft | 6005757.68157 | 2102409.38047 | 37.7531413749784 | -122.422987443927 | (37.7531413749784, -122.422987443927) | |||
| 130218 | 130218 | 221537 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1100x Guerrero St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 3ft | 6005757.84067 | 2102377.3752200003 | 37.753053504939 | -122.422984619142 | (37.753053504939, -122.422984619142) | |||
| 185218 | 185218 | 221536 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1100x Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 3ft | 6005762.1987 | 2102333.32685 | 37.75293280420979 | -122.422966417762 | (37.7529328042098, -122.422966417762) | |||
| 129563 | 129563 | 221535 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1100x Guerrero St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 3ft | 6005763.23809 | 2102308.0919 | 37.7528635735186 | -122.42296102995199 | (37.7528635735186, -122.422961029952) | |||
| 163113 | 163113 | 221534 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1100x Guerrero St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 3ft | 6005765.63484 | 2102254.12398 | 37.7527155253202 | -122.422948906168 | (37.7527155253202, -122.422948906168) | |||
| 188083 | 188083 | 221533 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1100x Guerrero St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 3ft | 6005767.42939 | 2102227.70946 | 37.75264309841 | -122.422940823082 | (37.75264309841, -122.422940823082) | |||
| 159464 | 159464 | 221532 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1100x Guerrero St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 3ft | 6005770.103999999 | 2102168.30473 | 37.7524801376575 | -122.42292735211201 | (37.7524801376575, -122.422927352112) | |||
| 150449 | 150449 | 221531 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1100x Guerrero St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 3ft | 6005769.92765 | 2102140.767 | 37.7524045154572 | -122.422926004956 | (37.7524045154572, -122.422926004956) | |||
| 42667 | 42667 | 221530 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1100x Guerrero St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 3ft | 6005772.5167 | 2102115.11175 | 37.75233421815221 | -122.422915228372 | (37.7523342181522, -122.422915228372) | |||
| 55516 | 55516 | 221529 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1200x Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 3ft | 6005786.9094 | 2101880.5255400003 | 37.751690910628 | -122.42284878555701 | (37.751690910628, -122.422848785557) | |||
| 47639 | 47639 | 221528 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1200x Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 3ft | 6005788.731319999 | 2101828.76193 | 37.7515488824818 | -122.422838806667 | (37.7515488824818, -122.422838806667) | |||
| 65787 | 65787 | 221527 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1200x Guerrero St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 3ft | 6005790.21854 | 2101800.81566 | 37.7514722323764 | -122.422831677752 | (37.7514722323764, -122.422831677752) | |||
| 73681 | 73681 | 221526 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1200x Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 3ft | 6005792.85635 | 2101748.62489 | 37.7513290773756 | -122.42281884712601 | (37.7513290773756, -122.422818847126) | |||
| 48249 | 48249 | 221525 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1200x Guerrero St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 3ft | 6005795.99168 | 2101720.64475 | 37.7512524272579 | -122.422806016491 | (37.7512524272579, -122.422806016491) | |||
| 54972 | 54972 | 221524 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1200x Guerrero St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 3ft | 6005795.8556 | 2101693.96335 | 37.7511791585977 | -122.42280459107401 | (37.7511791585977, -122.422804591074) | |||
| 25270 | 25270 | 221523 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1200x Guerrero St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 3ft | 6005797.77147 | 2101666.82906 | 37.751104762181 | -122.42279603761101 | (37.751104762181, -122.422796037611) | |||
| 32093 | 32093 | 221522 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1200x Guerrero St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | Width 3ft | 6005804.6365 | 2101559.54048 | 37.750810559762705 | -122.42276467376999 | (37.7508105597627, -122.42276467377) | |||
| 182320 | 182320 | 221521 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1200x Guerrero St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 3ft | 6005805.669319999 | 2101529.55059 | 37.7507282726947 | -122.422758971142 | (37.7507282726947, -122.422758971142) | |||
| 150263 | 150263 | 221520 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1200x Guerrero St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 3ft | 6005805.491090001 | 2101500.8171 | 37.7506493670819 | -122.422757545722 | (37.7506493670819, -122.422757545722) | |||
| 74207 | 74207 | 221519 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1300x Guerrero St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 3ft | 6005822.7904900005 | 2101267.93468 | 37.7500109014944 | -122.422681175305 | (37.7500109014944, -122.422681175305) | |||
| 48258 | 48258 | 221518 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1300x Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 3ft | 6005823.14172 | 2101242.96968 | 37.7499423731511 | -122.42267818684799 | (37.7499423731511, -122.422678186848) | |||
| 153605 | 153605 | 221517 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1300x Guerrero St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 3ft | 6005823.4134 | 2101214.1336 | 37.7498632112216 | -122.422675198428 | (37.7498632112216, -122.422675198428) | |||
| 137049 | 137049 | 221516 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1300x Guerrero St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 3ft | 6005827.472999999 | 2101138.31675 | 37.749655264584 | -122.42265577304701 | (37.749655264584, -122.422655773047) | |||
| 52769 | 52769 | 221515 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1300x Guerrero St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 3ft | 6005828.19442 | 2101110.33186 | 37.7495784651962 | -122.42265128992399 | (37.7495784651962, -122.422651289924) | |||
| 73212 | 73212 | 221514 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1300x Guerrero St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 3ft | 6005830.22915 | 2101083.18072 | 37.7495040291878 | -122.42264232458 | (37.7495040291878, -122.42264232458) | |||
| 41002 | 41002 | 221513 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1300x Guerrero St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 3ft | 6005831.83209 | 2101056.03846 | 37.7494295931996 | -122.42263485302799 | (37.7494295931996, -122.422634853028) | |||
| 182868 | 182868 | 221512 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1300x Guerrero St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 3ft | 6005835.43443 | 2101000.02463 | 37.749275995297296 | -122.422618416129 | (37.7492759952973, -122.422618416129) | |||
| 185178 | 185178 | 221511 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1300x Guerrero St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 3ft | 6005835.54562 | 2100976.57743 | 37.749211620932606 | -122.422616365666 | (37.7492116209326, -122.422616365666) | |||
| 178254 | 178254 | 221510 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1300x Guerrero St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 3ft | 6005838.80296 | 2100921.0233299998 | 37.7490592658716 | -122.422601154533 | (37.7490592658716, -122.422601154533) | |||
| 46563 | 46563 | 221509 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 1201 San Jose Ave | 38 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6004439.440880001 | 2096038.0117799998 | 37.735572586401894 | -122.42709240931102 | (37.7355725864019, -122.427092409311) | ||||
| 29150 | 29150 | 221508 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 1201 San Jose Ave | 15 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6004291.813569999 | 2095940.5809 | 37.73529671397821 | -122.427595874056 | (37.7352967139782, -122.427595874056) | ||||
| 148070 | 148070 | 221507 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 900x Guerrero St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 3ft | 6005699.48542 | 2103446.5929900003 | 37.755986035831704 | -122.42326242243999 | (37.7559860358317, -122.42326242244) | |||
| 35380 | 35380 | 221506 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 900x Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 3ft | 6005698.11962 | 2103476.06965 | 37.756066894799204 | -122.423269241105 | (37.7560668947992, -122.423269241105) | |||
| 48680 | 48680 | 221505 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 600x Guerrero St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 3ft | 6005615.32825 | 2104975.43597 | 37.760179131174795 | -122.423662162075 | (37.7601791311748, -122.423662162075) | |||
| 4487 | 4487 | 221504 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 600x Guerrero St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/21/2015 11:05:00 PM | 2 | Width 3ft | 6005611.75297 | 2105011.45268 | 37.7602778227802 | -122.42367708812901 | (37.7602778227802, -122.423677088129) | ||
| 4517 | 4517 | 221503 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 600x Guerrero St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/21/2015 11:06:00 PM | 2 | Width 3ft | 6005610.53101 | 2105047.42068 | 37.7603765134773 | -122.423683871708 | (37.7603765134773, -122.423683871708) | ||
| 4481 | 4481 | 221502 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 600x Guerrero St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/21/2015 11:07:00 PM | 2 | Width 3ft | 6005607.7078 | 2105081.85863 | 37.760470912626296 | -122.42369608451 | (37.7604709126263, -122.42369608451) | ||
| 4526 | 4526 | 221501 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 600x Guerrero St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/21/2015 11:08:00 PM | 2 | Width 3ft | 6005604.17413 | 2105138.97106 | 37.7606275304574 | -122.423712366728 | (37.7606275304574, -122.423712366728) | ||
| 4478 | 4478 | 221500 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 600x Guerrero St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/28/2015 11:10:00 PM | 2 | Width 3ft | 6005602.08318 | 2105171.2083400004 | 37.7607159284129 | -122.423721890569 | (37.7607159284129, -122.423721890569) | ||
| 4499 | 4499 | 221499 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 600x Guerrero St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/28/2015 11:01:00 PM | 2 | Width 3ft | 6005601.090469999 | 2105206.48742 | 37.760812740428904 | -122.42372783238899 | (37.7608127404289, -122.423727832389) | ||
| 184414 | 184414 | 221498 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 600x Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6005599.77613 | 2105242.7413 | 37.7609122108583 | -122.423734955914 | (37.7609122108583, -122.423734955914) | |||
| 4491 | 4491 | 221497 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 600x Guerrero St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/21/2015 10:57:00 PM | 2 | Width 3ft | 6005595.06917 | 2105295.4476799998 | 37.761056664463204 | -122.42375498292499 | (37.7610566644632, -122.423754982925) | ||
| 4523 | 4523 | 221496 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 600x Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/21/2015 12:00:00 AM | 2 | Width 3ft | 6005594.03058 | 2105332.56679 | 37.761158526170895 | -122.423761214331 | (37.7611585261709, -122.423761214331) | ||
| 4454 | 4454 | 221495 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 600x Guerrero St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/21/2015 10:54:00 PM | 2 | Width 3ft | 6005593.17627 | 2105367.35468 | 37.761253997298205 | -122.42376664264299 | (37.7612539972982, -122.423766642643) | ||
| 4507 | 4507 | 221494 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 600x Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/21/2015 10:53:00 PM | 2 | Width 3ft | 6005589.49697 | 2105398.2938599996 | 37.7613387412987 | -122.423781567769 | (37.7613387412987, -122.423781567769) | ||
| 159086 | 159086 | 221493 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 500x Guerrero St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 3ft | 6005583.08285 | 2105563.4275 | 37.7617917972666 | -122.42381549380801 | (37.7617917972666, -122.423815493808) | |||
| 47104 | 47104 | 221492 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 500x Guerrero St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 3ft | 6005579.45797 | 2105601.3239599997 | 37.761895647375205 | -122.42383072560301 | (37.7618956473752, -122.423830725603) | |||
| 179323 | 179323 | 221491 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 500x Guerrero St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 3ft | 6005578.642000001 | 2105634.14294 | 37.7619857144891 | -122.423835881448 | (37.7619857144891, -122.423835881448) | |||
| 66900 | 66900 | 221490 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 500x Guerrero St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6005576.38505 | 2105666.63585 | 37.7620748049423 | -122.423845997918 | (37.7620748049423, -122.423845997918) | |||
| 51561 | 51561 | 221489 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 500x Guerrero St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 3ft | 6005574.236269999 | 2105711.57302 | 37.7621980705008 | -122.423856625205 | (37.7621980705008, -122.423856625205) | |||
| 38301 | 38301 | 221488 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 500x Guerrero St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 3ft | 6005571.71667 | 2105739.51079 | 37.7622746387822 | -122.42386732621999 | (37.7622746387822, -122.42386732622) | |||
| 52085 | 52085 | 221487 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 500x Guerrero St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 3ft | 6005570.243559999 | 2105766.57088 | 37.762348856238205 | -122.42387434542101 | (37.7623488562382, -122.423874345421) | |||
| 55100 | 55100 | 221486 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 500x Guerrero St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6005569.00136 | 2105791.30468 | 37.7624166992856 | -122.423880400579 | (37.7624166992856, -122.423880400579) | |||
| 151865 | 151865 | 221485 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 500x Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6005566.92978 | 2105826.00789 | 37.762511869155105 | -122.42389003321101 | (37.7625118691551, -122.423890033211) | |||
| 65305 | 65305 | 221484 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 500x Guerrero St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 3ft | 6005563.22827 | 2105880.05418 | 37.7626600585326 | -122.42390667874399 | (37.7626600585326, -122.423906678744) | |||
| 115942 | 115942 | 221483 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 500x Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 3ft | 6005560.35948 | 2105916.5024900003 | 37.7627599750213 | -122.42391919281201 | (37.7627599750213, -122.423919192812) | |||
| 169800 | 169800 | 221482 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 500x Guerrero St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 3ft | 6005559.28434 | 2105952.19302 | 37.762857912083795 | -122.423925449408 | (37.7628579120838, -122.423925449408) | |||
| 169767 | 169767 | 221481 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 500x Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 3ft | 6005557.328430001 | 2105982.39063 | 37.7629407171602 | -122.423934361684 | (37.7629407171602, -122.423934361684) | |||
| 4437 | 4437 | 221480 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 400x Guerrero St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/29/2015 05:03:00 AM | 1 | Width 3ft | 6005548.13055 | 2106148.7780400002 | 37.7633970583515 | -122.423978006683 | (37.7633970583515, -122.423978006683) | ||
| 4340 | 4340 | 221479 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 400x Guerrero St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/28/2015 07:46:00 PM | 1 | Width 3ft | 6005545.66803 | 2106187.37905 | 37.7635029085615 | -122.42398926890199 | (37.7635029085615, -122.423989268902) | ||
| 4316 | 4316 | 221478 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 400x Guerrero St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/29/2015 05:18:00 AM | 1 | Width 3ft | 6005544.06849 | 2106215.1538 | 37.763579081143604 | -122.423996776447 | (37.7635790811436, -122.423996776447) | ||
| 4419 | 4419 | 221477 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 400x Guerrero St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/29/2015 05:29:00 AM | 1 | Width 3ft | 6005543.73868 | 2106251.90953 | 37.763679985054495 | -122.424000531101 | (37.7636799850545, -122.424000531101) | ||
| 4336 | 4336 | 221476 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 400x Guerrero St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/29/2015 09:37:00 AM | 1 | Width 3ft | 6005539.0927099995 | 2106307.4884599997 | 37.7638323293302 | -122.42402055271799 | (37.7638323293302, -122.424020552718) | ||
| 4412 | 4412 | 221475 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 400x Guerrero St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/29/2015 10:13:00 AM | 1 | Width 3ft | 6005538.26376 | 2106334.58706 | 37.763906688864495 | -122.42402534700001 | (37.7639066888645, -122.424025347) | ||
| 4416 | 4416 | 221474 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 400x Guerrero St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/29/2015 10:16:00 AM | 1 | Width 3ft | 6005537.16302 | 2106367.52425 | 37.7639970644374 | -122.42403149656401 | (37.7639970644374, -122.424031496564) | ||
| 4386 | 4386 | 221473 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 400x Guerrero St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/29/2015 10:20:00 AM | 1 | Width 3ft | 6005534.54232 | 2106397.63335 | 37.764079588928496 | -122.424042702116 | (37.7640795889285, -122.424042702116) | ||
| 4408 | 4408 | 221472 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 400x Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/29/2015 10:24:00 AM | 1 | Width 3ft | 6005534.310819999 | 2106426.8401 | 37.7641597706703 | -122.424045579956 | (37.7641597706703, -122.424045579956) | ||
| 4370 | 4370 | 221471 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 400x Guerrero St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/29/2015 10:27:00 AM | 1 | Width 3ft | 6005532.14271 | 2106464.3538900004 | 37.764262652233704 | -122.42405574678301 | (37.7642626522337, -122.424055746783) |
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");