trees
339 rows where qSpecies_id = 30 sorted by PlantDate
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 53 | 264969 | Undocumented 4 | Acacia stenophylla :: Shoestring Acacia 30 | 1099X Hollister Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 15x15 | 6014337 | 2089983 | 37.719501468928 | -122.392449109694 | (37.719501468928, -122.392449109694) | 10 | 3 | 8 | 58 | 1 | |||
| 981 | 221424 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 900x Guerrero St | 3 | Median : Cutout | Tree | DPW 1 | 6 | 3x3 | Permit Number 56125 | 6005689.53453 | 2103630.03961 | 37.7564891759384 | -122.423309876046 | (37.7564891759384, -122.423309876046) | 2 | 4 | 5 | 28859 | 19 | ||
| 1071 | 240683 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1100x Guerrero St | 7 | Median : Cutout | Tree | DPW 1 | 6 | 3x3 | Permit Number 56125 | 6005765.02468 | 2102281.28975 | 37.7527900818195 | -122.422952946818 | (37.7527900818195, -122.422952946818) | 2 | 4 | 5 | 28859 | 19 | ||
| 1553 | 221523 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1200x Guerrero St | 8 | Median : Cutout | Tree | DPW 1 | 7 | Width 3ft | 6005797.77147 | 2101666.82906 | 37.751104762181 | -122.422796037611 | (37.751104762181, -122.422796037611) | 2 | 4 | 5 | 28859 | 19 | |||
| 1567 | 240680 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1200x Guerrero St | 9 | Median : Cutout | Tree | DPW 1 | 8 | 3x3 | Permit Number 56125 | 6005798.46813 | 2101640.54094 | 37.7510326203604 | -122.422791760451 | (37.7510326203604, -122.422791760451) | 2 | 4 | 5 | 28859 | 19 | ||
| 1947 | 240678 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1300x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 4 | 3x3 | Permit Number 56125 | 6005819.90053 | 2101295.53343 | 37.7500865182761 | -122.422693129992 | (37.7500865182761, -122.422693129992) | 2 | 4 | 5 | 28859 | 19 | ||
| 2093 | 221427 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 900x Guerrero St | 10 | Median : Cutout | Tree | DPW 1 | 6 | 3x3 | Permit Number 56125 | 6005696.85287 | 2103501.5592 | 37.7561368116793 | -122.423275433821 | (37.7561368116793, -122.423275433821) | 2 | 4 | 5 | 28859 | 19 | ||
| 2506 | 240677 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1300x Guerrero St | 5 | Median : Cutout | Tree | DPW 1 | 5 | 3x3 | Permit Number 56125 | 6005825.90541 | 2101167.17913 | 37.7497344256173 | -122.422663244623 | (37.7497344256173, -122.422663244623) | 2 | 4 | 5 | 28859 | 19 | ||
| 2914 | 203291 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 11 Jules Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5994415.48252 | 2089998.39973 | 37.7184173393668 | -122.461311125716 | (37.7184173393668, -122.461311125716) | 9 | 8 | 6 | 28861 | 24 | |||
| 3021 | 221542 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 900x Guerrero St | 12 | Median : Cutout | Tree | DPW 1 | 8 | Width 3ft | 6005709.18006 | 2103278.94714 | 37.7555262664424 | -122.423216978787 | (37.7555262664424, -122.423216978787) | 2 | 4 | 5 | 28859 | 19 | |||
| 3115 | 221554 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000x Guerrero St | 12 | Median : Cutout | Tree | DPW 1 | 4 | 3x3 | Permit Number 56125 | 6005736.5559 | 2102753.56312 | 37.7540852287585 | -122.423084962814 | (37.7540852287585, -122.423084962814) | 2 | 4 | 5 | 28859 | 19 | ||
| 3421 | 221449 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 7 | Median : Cutout | Tree | DPW 1 | 1 | Width 3ft | 6005469.95975 | 2107527.18332 | 37.767177417921 | -122.424346419355 | (37.767177417921, -122.424346419355) | 8 | 4 | 5 | 28853 | 19 | |||
| 5169 | 221481 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 500x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 2 | 3x3 | Permit Number 56125 | 6005557.32843 | 2105982.39063 | 37.7629407171602 | -122.423934361684 | (37.7629407171602, -122.423934361684) | 8 | 4 | 5 | 28859 | 19 | ||
| 5313 | 221425 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 900x Guerrero St | 4 | Median : Cutout | Tree | DPW 1 | 6 | Width 3ft | 6005689.68683 | 2103597.2936 | 37.7563992716189 | -122.423307021613 | (37.7563992716189, -122.423307021613) | 2 | 4 | 5 | 28859 | 19 | |||
| 5912 | 221553 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000x Guerrero St | 11 | Median : Cutout | Tree | DPW 1 | 3 | 3x3 | Permit Number 56125 | 6005734.11141 | 2102791.4847 | 37.7541892146839 | -122.423096111708 | (37.7541892146839, -122.423096111708) | 2 | 4 | 5 | 28859 | 19 | ||
| 6246 | 221421 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 800x Guerrero St | 9 | Median : Cutout | Tree | DPW 1 | 7 | 3x3 | Permit Number 56125 | 6005663.97142 | 2104121.3615 | 37.7578367884406 | -122.423433209975 | (37.7578367884406, -122.423433209975) | 2 | 4 | 5 | 28859 | 19 | ||
| 6280 | 221541 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 900x Guerrero St | 13 | Median : Cutout | Tree | DPW 1 | 6 | Width 3ft | 6005710.1718 | 2103251.3867 | 37.7554506478492 | -122.423211590049 | (37.7554506478492, -122.423211590049) | 2 | 4 | 5 | 28859 | 19 | |||
| 6810 | 243265 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 900x Guerrero St | 7 | Median : Cutout | Tree | DPW 1 | 0 | 3x3 | Permit Number 56125 | 6005691.43766 | 2103575.20205 | 37.7563387121803 | -122.42329939627 | (37.7563387121803, -122.42329939627) | 2 | 4 | 5 | 28859 | 19 | ||
| 7774 | 221416 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 800x Guerrero St | 2 | Median : Cutout | Tree | DPW 1 | 2 | 3x3 | Permit Number 56125 | 6005677.18728 | 2103848.76992 | 37.7570890615162 | -122.423368126034 | (37.7570890615162, -122.423368126034) | 2 | 4 | 5 | 28859 | 19 | ||
| 8268 | 221535 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1100x Guerrero St | 6 | Median : Cutout | Tree | DPW 1 | 4 | 3x3 | Permit Number 56125 | 6005763.23809 | 2102308.0919 | 37.7528635735186 | -122.422961029952 | (37.7528635735186, -122.422961029952) | 2 | 4 | 5 | 28859 | 19 | ||
| 8628 | 221426 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 900x Guerrero St | 9 | Median : Cutout | Tree | DPW 1 | 6 | 3x3 | Permit Number 56125 | 6005693.61577 | 2103548.60767 | 37.7562658131324 | -122.423289973179 | (37.7562658131324, -122.423289973179) | 2 | 4 | 5 | 28859 | 19 | ||
| 8773 | 262076 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 800X Alemany Blvd | 16 | Median : Cutout | Tree | DPW 1 | 3x3 | 6004191 | 2094544 | 37.7314563142861 | -122.427844943089 | (37.7314563142861, -122.427844943089) | 9 | 7 | 6 | 28861 | 5 | ||||
| 9125 | 240676 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1300x Guerrero St | 12 | Median : Cutout | Tree | DPW 1 | 7 | 3x3 | Permit Number 56125 | 6005837.06183 | 2100943.32688 | 37.7491204080812 | -122.42260876008 | (37.7491204080812, -122.42260876008) | 2 | 4 | 5 | 28859 | 19 | ||
| 9435 | 221556 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000x Guerrero St | 14 | Median : Cutout | Tree | DPW 1 | 3 | 3x3 | Permit Number 56125 | 6005741.57845 | 2102677.06839 | 37.753875475376 | -122.423062156895 | (37.753875475376, -122.423062156895) | 2 | 4 | 5 | 28859 | 19 | ||
| 10217 | 240681 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1200x Guerrero St | 2 | Median : Cutout | Tree | DPW 1 | 8 | 3x3 | Permit Number 56125 | 6005788.04336 | 2101855.46027 | 37.751622151155 | -122.422843082969 | (37.751622151155, -122.422843082969) | 2 | 4 | 5 | 28859 | 19 | ||
| 10432 | 221544 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 900x Guerrero St | 8 | Median : Cutout | Tree | DPW 1 | 7 | 3x3 | Permit Number 56125 | 6005705.62338 | 2103333.32509 | 37.7556753749283 | -122.423233144119 | (37.7556753749283, -122.423233144119) | 2 | 4 | 5 | 28859 | 19 | ||
| 11084 | 187784 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 101 Pennsylvania Ave | 35 | Front Yard : Yard | Tree | Private 2 | 4 | 6014258.31464 | 2106694.98019 | 37.7653847111611 | -122.393890307196 | (37.7653847111611, -122.393890307196) | 14 | 3 | 8 | 28856 | 20 | ||||
| 11768 | 221543 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 900x Guerrero St | 11 | Median : Cutout | Tree | DPW 1 | 8 | Width 3ft | 6005707.0284 | 2103306.91954 | 37.7556029507207 | -122.42322640819 | (37.7556029507207, -122.42322640819) | 2 | 4 | 5 | 28859 | 19 | |||
| 12356 | 152416 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 700x Guerrero St | 5 | Median : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6005631.99539 | 2104658.58909 | 37.7593100848133 | -122.423581991114 | (37.7593100848133, -122.423581991114) | 2 | 4 | 5 | 28859 | 19 | |||
| 13182 | 243321 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 900x Guerrero St | 5 | Median : Cutout | Tree | DPW 1 | 5 | 3x3 | Permit Number 56125 | 6005700.91818 | 2103420.38667 | 37.7559141602344 | -122.423255604682 | (37.7559141602344, -122.423255604682) | 2 | 4 | 5 | 28859 | 19 | ||
| 13462 | 240682 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1100x Guerrero St | 13 | Median : Cutout | Tree | DPW 1 | 8 | 3x3 | Permit Number 56125 | 6005773.46778 | 2102086.45101 | 37.7522555760398 | -122.422909902588 | (37.7522555760398, -122.422909902588) | 2 | 4 | 5 | 28859 | 19 | ||
| 13699 | 152413 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 700x Guerrero St | 2 | Median : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6005625.07408 | 2104777.98262 | 37.7596375207611 | -122.423614417069 | (37.7596375207611, -122.423614417069) | 2 | 4 | 5 | 28859 | 19 | |||
| 13786 | 221552 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000x Guerrero St | 10 | Median : Cutout | Tree | DPW 1 | 3 | 3x3 | Permit Number 56125 | 6005734.10722 | 2102815.94179 | 37.7542563679477 | -122.423097864468 | (37.7542563679477, -122.423097864468) | 2 | 4 | 5 | 28859 | 19 | ||
| 14715 | 221546 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000x Guerrero St | 2 | Median : Cutout | Tree | DPW 1 | 3 | 3x3 | Permit Number 56125 | 6005723.96055 | 2103030.09242 | 37.7548438033068 | -122.423148175257 | (37.7548438033068, -122.423148175257) | 2 | 4 | 5 | 28859 | 19 | ||
| 15879 | 221486 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 500x Guerrero St | 6 | Median : Cutout | Tree | DPW 1 | 3 | 3x3 | Permit Number 56125 | 6005569.00136 | 2105791.30468 | 37.7624166992856 | -122.423880400579 | (37.7624166992856, -122.423880400579) | 8 | 4 | 5 | 28859 | 19 | ||
| 15920 | 221557 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000x Guerrero St | 15 | Median : Cutout | Tree | DPW 1 | 3 | 3x3 | Permit Number 56125 | 6005743.02813 | 2102638.73526 | 37.7537703032837 | -122.423054419131 | (37.7537703032837, -122.423054419131) | 2 | 4 | 5 | 28859 | 19 | ||
| 17216 | 240679 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1200x Guerrero St | 10 | Median : Cutout | Tree | DPW 1 | 4 | 3x3 | Permit Number 56125 | 6005802.65315 | 2101583.39169 | 37.7508759377955 | -122.422773227227 | (37.7508759377955, -122.422773227227) | 2 | 4 | 5 | 28859 | 19 | ||
| 18001 | 243333 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 900x Guerrero St | 6 | Median : Cutout | Tree | DPW 1 | 0 | 3x3 | Permit Number 56125 | 6005703.0197 | 2103377.21002 | 37.7557957257993 | -122.423245267872 | (37.7557957257993, -122.423245267872) | 2 | 4 | 5 | 28859 | 19 | ||
| 18108 | 221419 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 800x Guerrero St | 6 | Median : Cutout | Tree | DPW 1 | 6 | 3x3 | Permit Number 56125 | 6005664.4202 | 2104015.71487 | 37.7575467328056 | -122.423424147502 | (37.7575467328056, -122.423424147502) | 2 | 4 | 5 | 28859 | 19 | ||
| 18986 | 221548 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000x Guerrero St | 4 | Median : Cutout | Tree | DPW 1 | 3 | 3x3 | Permit Number 56125 | 6005727.07279 | 2102965.97894 | 37.7546679382008 | -122.423132855309 | (37.7546679382008, -122.423132855309) | 2 | 4 | 5 | 28859 | 19 | ||
| 20283 | 221522 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1200x Guerrero St | 11 | Median : Cutout | Tree | DPW 1 | 18 | Width 3ft | 6005804.6365 | 2101559.54048 | 37.7508105597627 | -122.42276467377 | (37.7508105597627, -122.42276467377) | 2 | 4 | 5 | 28859 | 19 | |||
| 21108 | 243241 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 800x Guerrero St | 11 | Median : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6005660.54217 | 2104179.64824 | 37.7579966366535 | -122.423449213415 | (37.7579966366535, -122.423449213415) | 2 | 4 | 5 | 28859 | 19 | |||
| 22553 | 187785 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1740 20th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 6012766.00153 | 2104746.33455 | 37.7599511143744 | -122.398915128835 | (37.7599511143744, -122.398915128835) | 10 | 3 | 8 | 28856 | 29 | |||
| 22666 | 221560 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 100 San Jose Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006161.42459 | 2102519.64651 | 37.7534669142699 | -122.42159904898 | (37.7534669142699, -122.42159904898) | 2 | 4 | 5 | 28859 | 19 | |||
| 24279 | 175079 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1104x Alemany Blvd | 1 | Median : Yard | Tree | DPW 1 | 1 | Width 10ft | 6003837.73065 | 2094453.46286 | 37.7311877286109 | -122.429059809376 | (37.7311877286109, -122.429059809376) | 9 | 7 | 6 | 28861 | 25 | |||
| 26579 | 221545 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 2 | Width 3ft | 6005721.87722 | 2103062.70747 | 37.7549332390947 | -122.423157698184 | (37.7549332390947, -122.423157698184) | 2 | 4 | 5 | 28859 | 19 | |||
| 27720 | 221540 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1100x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 6 | Width 3ft | 6005754.92272 | 2102467.80763 | 37.753301646771 | -122.423001136993 | (37.753301646771, -122.423001136993) | 2 | 4 | 5 | 28859 | 19 | |||
| 28021 | 187781 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 101 Pennsylvania Ave | 4 | Front Yard : Yard | Tree | Private 2 | 3 | 6014331.70125 | 2106323.79299 | 37.7643695906061 | -122.393610496623 | (37.7643695906061, -122.393610496623) | 14 | 3 | 8 | 310 | 29 | ||||
| 28727 | 201712 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 724 Jamestown Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6015351.33364 | 2088303.0821 | 37.7149450173645 | -122.388825682463 | (37.7149450173645, -122.388825682463) | 10 | 3 | 8 | 58 | 1 | |||
| 29061 | 221538 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1100x Guerrero St | 3 | Median : Cutout | Tree | DPW 1 | 7 | Width 3ft | 6005757.68157 | 2102409.38047 | 37.7531413749784 | -122.422987443927 | (37.7531413749784, -122.422987443927) | 2 | 4 | 5 | 28859 | 19 | |||
| 29249 | 221506 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 900x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 5 | Width 3ft | 6005698.11962 | 2103476.06965 | 37.7560668947992 | -122.423269241105 | (37.7560668947992, -122.423269241105) | 2 | 4 | 5 | 28859 | 19 | |||
| 31806 | 221488 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 500x Guerrero St | 8 | Median : Cutout | Tree | DPW 1 | 2 | Width 3ft | 6005571.71667 | 2105739.51079 | 37.7622746387822 | -122.42386732622 | (37.7622746387822, -122.42386732622) | 8 | 4 | 5 | 28859 | 19 | |||
| 34481 | 201714 | Undocumented 4 | Acacia stenophylla :: Shoestring Acacia 30 | 726 Jamestown Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6015317.96334 | 2088364.51894 | 37.7151118613908 | -122.388945312084 | (37.7151118613908, -122.388945312084) | 10 | 3 | 8 | 58 | 1 | |||
| 34578 | 203292 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 10 Jules Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5994458.02189 | 2089982.35817 | 37.7183757412389 | -122.461162923744 | (37.7183757412389, -122.461162923744) | 9 | 8 | 6 | 28861 | 24 | |||
| 38474 | 243239 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 800x Guerrero St | 4 | Median : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6005667.36599 | 2103954.71663 | 37.7573794121443 | -122.423409623453 | (37.7573794121443, -122.423409623453) | 2 | 4 | 5 | 28859 | 19 | |||
| 40155 | 221518 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1300x Guerrero St | 3 | Median : Cutout | Tree | DPW 1 | 7 | Width 3ft | 6005823.14172 | 2101242.96968 | 37.7499423731511 | -122.422678186848 | (37.7499423731511, -122.422678186848) | 2 | 4 | 5 | 28859 | 19 | |||
| 40660 | 221528 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1200x Guerrero St | 3 | Median : Cutout | Tree | DPW 1 | 8 | Width 3ft | 6005788.73132 | 2101828.76193 | 37.7515488824818 | -122.422838806667 | (37.7515488824818, -122.422838806667) | 2 | 4 | 5 | 28859 | 19 | |||
| 42106 | 221525 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1200x Guerrero St | 6 | Median : Cutout | Tree | DPW 1 | 4 | Width 3ft | 6005795.99168 | 2101720.64475 | 37.7512524272579 | -122.422806016491 | (37.7512524272579, -122.422806016491) | 2 | 4 | 5 | 28859 | 19 | |||
| 44242 | 221415 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 800x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 1 | Width 3ft | 6005678.5014 | 2103825.14435 | 37.7570242653802 | -122.423361901832 | (37.7570242653802, -122.423361901832) | 2 | 4 | 5 | 28859 | 19 | |||
| 44991 | 187786 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1650 Galvez Ave | 1 | Side Yard : Yard | Tree | Private 2 | 6 | 6015560.61147 | 2097934.79581 | 37.7414033822515 | -122.388774319486 | (37.7414033822515, -122.388774319486) | 10 | 3 | 8 | 58 | 1 | ||||
| 45188 | 221530 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1100x Guerrero St | 12 | Median : Cutout | Tree | DPW 1 | 11 | Width 3ft | 6005772.5167 | 2102115.11175 | 37.7523342181522 | -122.422915228372 | (37.7523342181522, -122.422915228372) | 2 | 4 | 5 | 28859 | 19 | |||
| 45689 | 221513 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1300x Guerrero St | 9 | Median : Cutout | Tree | DPW 1 | 7 | Width 3ft | 6005831.83209 | 2101056.03846 | 37.7494295931996 | -122.422634853028 | (37.7494295931996, -122.422634853028) | 2 | 4 | 5 | 28859 | 19 | |||
| 45759 | 221492 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 500x Guerrero St | 12 | Median : Cutout | Tree | DPW 1 | 2 | Width 3ft | 6005579.45797 | 2105601.32396 | 37.7618956473752 | -122.423830725603 | (37.7618956473752, -122.423830725603) | 8 | 4 | 5 | 28859 | 19 | |||
| 46202 | 152421 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 700x Guerrero St | 10 | Median : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6005642.99765 | 2104457.73967 | 37.7587592203909 | -122.42352966049 | (37.7587592203909, -122.42352966049) | 2 | 4 | 5 | 28859 | 19 | |||
| 48962 | 187787 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1650 Galvez Ave | 2 | Side Yard : Yard | Tree | Private 2 | 7 | 6015518.87332 | 2097965.19798 | 37.7414845469671 | -122.388920758811 | (37.7414845469671, -122.388920758811) | 10 | 3 | 8 | 58 | 1 | ||||
| 52094 | 152420 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 700x Guerrero St | 9 | Median : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6005641.89151 | 2104501.69931 | 37.7588798608311 | -122.42353661134 | (37.7588798608311, -122.42353661134) | 2 | 4 | 5 | 28859 | 19 | |||
| 52247 | 221440 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 100x Guerrero St | 13 | Median : Cutout | Tree | DPW 1 | 1 | Width 3ft | 6005447.60224 | 2108007.88033 | 37.7684960344855 | -122.424457946087 | (37.7684960344855, -122.424457946087) | 8 | 4 | 5 | 28853 | 19 | |||
| 54220 | 221505 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x Guerrero St | 12 | Median : Cutout | Tree | DPW 1 | 2 | Width 3ft | 6005615.32825 | 2104975.43597 | 37.7601791311748 | -122.423662162075 | (37.7601791311748, -122.423662162075) | 2 | 4 | 5 | 28859 | 19 | |||
| 57039 | 152414 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 700x Guerrero St | 3 | Median : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6005626.99355 | 2104746.96336 | 37.7595524574982 | -122.423605573157 | (37.7595524574982, -122.423605573157) | 2 | 4 | 5 | 28859 | 19 | |||
| 58618 | 152419 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 700x Guerrero St | 8 | Median : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6005637.90033 | 2104551.94757 | 37.7590176055009 | -122.423553987148 | (37.7590176055009, -122.423553987148) | 2 | 4 | 5 | 28859 | 19 | |||
| 60003 | 187783 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 101 Pennsylvania Ave | 26 | Front Yard : Yard | Tree | Private 2 | 4 | 6014314.48936 | 2106550.7653 | 37.7649918504189 | -122.393685915597 | (37.7649918504189, -122.393685915597) | 14 | 3 | 8 | 310 | 29 | ||||
| 61134 | 152423 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 700x Guerrero St | 12 | Median : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6005645.11359 | 2104396.78205 | 37.7585919644709 | -122.423518008854 | (37.7585919644709, -122.423518008854) | 2 | 4 | 5 | 28859 | 19 | |||
| 63104 | 221529 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1200x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 10 | Width 3ft | 6005786.9094 | 2101880.52554 | 37.751690910628 | -122.422848785557 | (37.751690910628, -122.422848785557) | 2 | 4 | 5 | 28859 | 19 | |||
| 68150 | 221564 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 4286 23rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001316.91777 | 2102341.73596 | 37.7527040553705 | -122.438339609582 | (37.7527040553705, -122.438339609582) | 2 | 4 | 5 | 28862 | 22 | |||
| 68247 | 221515 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1300x Guerrero St | 7 | Median : Cutout | Tree | DPW 1 | 7 | Width 3ft | 6005828.19442 | 2101110.33186 | 37.7495784651962 | -122.422651289924 | (37.7495784651962, -122.422651289924) | 2 | 4 | 5 | 28859 | 19 | |||
| 73744 | 221562 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 100 San Jose Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006161.28805 | 2102498.92878 | 37.75341002046 | -122.421598049829 | (37.75341002046, -122.421598049829) | 2 | 4 | 5 | 28859 | 19 | |||
| 73812 | 221487 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 500x Guerrero St | 7 | Median : Cutout | Tree | DPW 1 | 2 | Width 3ft | 6005570.24356 | 2105766.57088 | 37.7623488562382 | -122.423874345421 | (37.7623488562382, -122.423874345421) | 8 | 4 | 5 | 28859 | 19 | |||
| 75109 | 221524 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1200x Guerrero St | 7 | Median : Cutout | Tree | DPW 1 | 8 | Width 3ft | 6005795.8556 | 2101693.96335 | 37.7511791585977 | -122.422804591074 | (37.7511791585977, -122.422804591074) | 2 | 4 | 5 | 28859 | 19 | |||
| 76054 | 221489 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 500x Guerrero St | 9 | Median : Cutout | Tree | DPW 1 | 2 | Width 3ft | 6005574.23627 | 2105711.57302 | 37.7621980705008 | -122.423856625205 | (37.7621980705008, -122.423856625205) | 8 | 4 | 5 | 28859 | 19 | |||
| 77452 | 221561 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 100 San Jose Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006161.81341 | 2102510.42937 | 37.7534416280528 | -122.42159704977 | (37.7534416280528, -122.42159704977) | 2 | 4 | 5 | 28859 | 19 | |||
| 80085 | 201713 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 724 Jamestown Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6015343.41284 | 2088314.94317 | 37.7149771465452 | -122.3888538879 | (37.7149771465452, -122.3888538879) | 10 | 3 | 8 | 58 | 1 | |||
| 80816 | 221527 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1200x Guerrero St | 4 | Median : Cutout | Tree | DPW 1 | 7 | Width 3ft | 6005790.21854 | 2101800.81566 | 37.7514722323764 | -122.422831677752 | (37.7514722323764, -122.422831677752) | 2 | 4 | 5 | 28859 | 19 | |||
| 81807 | 243240 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 800x Guerrero St | 7 | Median : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6005663.74872 | 2104041.4182 | 37.7576172702474 | -122.423428296996 | (37.7576172702474, -122.423428296996) | 2 | 4 | 5 | 28859 | 19 | |||
| 83337 | 221569 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 616 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003001.08037 | 2104529.5167 | 37.7588068286936 | -122.432671745707 | (37.7588068286936, -122.432671745707) | 2 | 4 | 5 | 28862 | 3 | |||
| 83971 | 105071 | Significant Tree 6 | Acacia stenophylla :: Shoestring Acacia 30 | 1808 Vallejo St | 1 | Front Yard : Yard | Tree | Private 2 | 3 | Permit Number 771033 | 6004794.05676 | 2118138.55822 | 37.7962754378239 | -122.427440299436 | (37.7962754378239, -122.427440299436) | 13 | 9 | 1 | 57 | 17 | |||
| 84262 | 221514 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1300x Guerrero St | 8 | Median : Cutout | Tree | DPW 1 | 8 | Width 3ft | 6005830.22915 | 2101083.18072 | 37.7495040291878 | -122.42264232458 | (37.7495040291878, -122.42264232458) | 2 | 4 | 5 | 28859 | 19 | |||
| 84453 | 152418 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 700x Guerrero St | 7 | Median : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6005636.4507 | 2104585.07924 | 37.7591084954784 | -122.42356135619 | (37.7591084954784, -122.42356135619) | 2 | 4 | 5 | 28859 | 19 | |||
| 85750 | 221484 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 500x Guerrero St | 4 | Median : Cutout | Tree | DPW 1 | 2 | Width 3ft | 6005563.22827 | 2105880.05418 | 37.7626600585326 | -122.423906678744 | (37.7626600585326, -122.423906678744) | 8 | 4 | 5 | 28859 | 19 | |||
| 85812 | 221490 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 500x Guerrero St | 10 | Median : Cutout | Tree | DPW 1 | 3 | Width 3ft | 6005576.38505 | 2105666.63585 | 37.7620748049423 | -122.423845997918 | (37.7620748049423, -122.423845997918) | 8 | 4 | 5 | 28859 | 19 | |||
| 92341 | 221565 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 4286 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001328.91667 | 2102339.67059 | 37.7526990668325 | -122.438297967381 | (37.7526990668325, -122.438297967381) | 2 | 4 | 5 | 28862 | 22 | |||
| 94070 | 203290 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 11 Jules Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5994415.40381 | 2090011.14136 | 37.7184523203103 | -122.461312320932 | (37.7184523203103, -122.461312320932) | 9 | 8 | 6 | 28861 | 24 | |||
| 96242 | 221567 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 324 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004154.58593 | 2103373.98314 | 37.7556993571514 | -122.428600021096 | (37.7556993571514, -122.428600021096) | 2 | 4 | 5 | 28862 | 22 | |||
| 96333 | 152415 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 700x Guerrero St | 4 | Median : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6005628.48676 | 2104715.95286 | 37.7594673942256 | -122.423598204106 | (37.7594673942256, -122.423598204106) | 2 | 4 | 5 | 28859 | 19 | |||
| 99261 | 221483 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 500x Guerrero St | 3 | Median : Cutout | Tree | DPW 1 | 1 | Width 3ft | 6005560.35948 | 2105916.50249 | 37.7627599750213 | -122.423919192812 | (37.7627599750213, -122.423919192812) | 8 | 4 | 5 | 28859 | 19 | |||
| 100554 | 221519 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1300x Guerrero St | 2 | Median : Cutout | Tree | DPW 1 | 7 | Width 3ft | 6005822.79049 | 2101267.93468 | 37.7500109014944 | -122.422681175305 | (37.7500109014944, -122.422681175305) | 2 | 4 | 5 | 28859 | 19 | |||
| 101099 | 115516 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 7 | Median : Cutout | Tree | DPW 1 | 6005415.2 | 2107753.5 | 37.7677957371292 | -122.424551925681 | (37.7677957371292, -122.424551925681) | 8 | 4 | 5 | 28853 | 19 | |||||
| 106244 | 152412 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 700x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6005623.17605 | 2104812.38517 | 37.7597318749526 | -122.4236234274 | (37.7597318749526, -122.4236234274) | 2 | 4 | 5 | 28859 | 19 | |||
| 106309 | 221537 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1100x Guerrero St | 4 | Median : Cutout | Tree | DPW 1 | 6 | Width 3ft | 6005757.84067 | 2102377.37522 | 37.753053504939 | -122.422984619142 | (37.753053504939, -122.422984619142) | 2 | 4 | 5 | 28859 | 19 | |||
| 107424 | 152417 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 700x Guerrero St | 6 | Median : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6005634.27087 | 2104624.16733 | 37.7592156991708 | -122.423571674116 | (37.7592156991708, -122.423571674116) | 2 | 4 | 5 | 28859 | 19 | |||
| 108354 | 221438 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 100x Guerrero St | 11 | Median : Cutout | Tree | DPW 1 | 2 | Width 3ft | 6005446.19377 | 2108068.29327 | 37.7686618344154 | -122.424467115559 | (37.7686618344154, -122.424467115559) | 8 | 4 | 5 | 28853 | 19 |
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) );