trees
835 rows where qSpecies_id = 122 sorted by SiteOrder descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3626 | 20062 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 15ST | |||||||||||||
| 27992 | 49579 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 400REVISED Alemany Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2003 12:00:00 AM | Permit Number 46462 | 6008204.64175087 | 2095122.01632245 | 37.7332696598424 | -122.414009852171 | (37.7332696598424, -122.414009852171) | 2 | 7 | 7 | 28859 | 2 | |||
| 175850 | 103892 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1750 Fulton St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5999308.7043 | 2110849.4957 | 37.7759498061666 | -122.44589618201 | (37.7759498061666, -122.44589618201) | 15 | 5 | 11 | 29492 | 16 | |||
| 4696 | 117040 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 2220x SUTTER ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001781 | 2114465 | 37.7860179225956 | -122.437602866759 | (37.7860179225956, -122.437602866759) | 13 | 6 | 1 | 29490 | 27 | ||||
| 5215 | 20061 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 15ST | |||||||||||||
| 36597 | 138344 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2250 Sutter St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6001758.896 | 2114311.2519 | 37.7855945128702 | -122.437668325433 | (37.7855945128702, -122.437668325433) | 13 | 6 | 1 | 29490 | 27 | |||
| 94890 | 203655 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 230 Edna St | 8 | Side Yard : Yard | Tree | Private 2 | 12 | 5998797.91036 | 2095380.6148 | 37.7334468948521 | -122.446549972903 | (37.7334468948521, -122.446549972903) | 9 | 7 | 4 | 59 | 40 | ||||
| 117270 | 49577 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 400REVISED Alemany Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2003 12:00:00 AM | Permit Number 46462 | 6008204.64175087 | 2095122.01632245 | 37.7332696598424 | -122.414009852171 | (37.7332696598424, -122.414009852171) | 2 | 7 | 7 | 28859 | 2 | |||
| 186545 | 103891 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1750 Fulton St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 5999322.5796 | 2110851.5262 | 37.7759561736689 | -122.445848329979 | (37.7759561736689, -122.445848329979) | 15 | 5 | 11 | 29492 | 16 | |||
| 14981 | 20060 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 15ST | |||||||||||||
| 16044 | 19729 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY14 | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 40ST | |||||||||||||
| 109674 | 23678 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 319 Virginia Ave | 7 | Median : Cutout | Tree | DPW 1 | 6 | 12 | 6006936.2458165 | 2098250.5638735 | 37.741788638282 | -122.418616833275 | (37.741788638282, -122.418616833275) | 2 | 7 | 7 | 28859 | 2 | |||
| 139053 | 29224 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1902X 41st Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 5983534.5176829 | 2102185.1808128 | 37.7512467209802 | -122.499821775189 | (37.7512467209802, -122.499821775189) | 1 | 8 | 3 | 29491 | 35 | |||
| 142595 | 124762 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1055 Greenwich St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007906.12641 | 2119914.20021 | 37.8013264288216 | -122.416797725058 | (37.8013264288216, -122.416797725058) | 5 | 1 | 1 | 308 | 32 | |||
| 155129 | 49581 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 400REVISED Alemany Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2003 12:00:00 AM | Permit Number 46462 | 6008204.64175087 | 2095122.01632245 | 37.7332696598424 | -122.414009852171 | (37.7332696598424, -122.414009852171) | 2 | 7 | 7 | 28859 | 2 | |||
| 172925 | 103890 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1750 Fulton St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3x3 | 5999343.5617 | 2110855.9257 | 37.7759694515949 | -122.445776064165 | (37.7759694515949, -122.445776064165) | 15 | 5 | 11 | 29492 | 16 | |||
| 3129 | 20059 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 15ST | |||||||||||||
| 36970 | 103889 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1750 Fulton St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 5999356.4217 | 2110857.6178 | 37.7759748319201 | -122.445731699945 | (37.7759748319201, -122.445731699945) | 15 | 5 | 11 | 29492 | 16 | |||
| 59237 | 138342 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2250 Sutter St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6001808.8392 | 2114319.4393 | 37.7856198329437 | -122.437496123305 | (37.7856198329437, -122.437496123305) | 13 | 6 | 1 | 29490 | 27 | |||
| 88476 | 29223 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1902X 41st Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 5983534.5176829 | 2102185.1808128 | 37.7512467209802 | -122.499821775189 | (37.7512467209802, -122.499821775189) | 1 | 8 | 3 | 29491 | 35 | |||
| 112319 | 138353 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2499 Bush St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6001742.4732 | 2114607.6747 | 37.7864074802067 | -122.437746380915 | (37.7864074802067, -122.437746380915) | 13 | 6 | 1 | 29490 | 27 | |||
| 114454 | 23677 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 319 Virginia Ave | 6 | Median : Cutout | Tree | DPW 1 | 6 | 12 | 6006936.2458165 | 2098250.5638735 | 37.741788638282 | -122.418616833275 | (37.741788638282, -122.418616833275) | 2 | 7 | 7 | 28859 | 2 | |||
| 126489 | 49578 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 400REVISED Alemany Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2003 12:00:00 AM | Permit Number 46462 | 6008204.64175087 | 2095122.01632245 | 37.7332696598424 | -122.414009852171 | (37.7332696598424, -122.414009852171) | 2 | 7 | 7 | 28859 | 2 | |||
| 165658 | 17229 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1880X Alemany Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3X3 | 6000980.93913 | 2091103.33988 | 37.7218269300432 | -122.438696258244 | (37.7218269300432, -122.438696258244) | 9 | 7 | 6 | 28861 | 25 | |||
| 178228 | 117038 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 2220x SUTTER ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001781 | 2114465 | 37.7860179225956 | -122.437602866759 | (37.7860179225956, -122.437602866759) | 13 | 6 | 1 | 29490 | 27 | ||||
| 11039 | 19285 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1770 Scott St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/1998 12:00:00 AM | 11 | 3X3 | 6001619.01622 | 2114490.46983 | 37.786078645055 | -122.438165110876 | (37.786078645055, -122.438165110876) | 13 | 6 | 1 | 29490 | 27 | ||
| 19723 | 103888 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1750 Fulton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 5999371.6507 | 2110859.3099 | 37.7759803474835 | -122.445679140757 | (37.7759803474835, -122.445679140757) | 15 | 5 | 11 | 29492 | 16 | |||
| 42343 | 39503 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 216 Jersey St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | Permit Number 40959 | 6003716.05884842 | 2101601.85489178 | 37.7508086831914 | -122.429990180024 | (37.7508086831914, -122.429990180024) | 2 | 4 | 5 | 28862 | 22 | ||
| 49476 | 42106 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 305 Hearst Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42409 | 5999382.77994639 | 2094344.80390055 | 37.730636191214 | -122.444453504412 | (37.730636191214, -122.444453504412) | 9 | 7 | 4 | 28861 | 40 | ||
| 50536 | 203666 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 123 Detroit St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5999405.93855 | 2093561.74161 | 37.7284874062446 | -122.4443171901 | (37.7284874062446, -122.4443171901) | 9 | 7 | 4 | 28861 | 40 | |||
| 59668 | 220054 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 300 Virginia Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 6006920.61613 | 2098340.82095 | 37.7420355840878 | -122.418677274846 | (37.7420355840878, -122.418677274846) | 2 | 7 | 7 | 28859 | 2 | |||
| 64639 | 42110 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 100@ Detroit Judson Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42411 | 5999403.96940848 | 2093509.81726433 | 37.7283447217324 | -122.444320267584 | (37.7283447217324, -122.444320267584) | 9 | 7 | 4 | 28861 | 40 | ||
| 106096 | 75790 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 2080 FOLSOM ST | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 03/15/1997 12:00:00 AM | 3x3 | 6008075 | 2106289 | 37.7639244108872 | -122.415248284425 | (37.7639244108872, -122.415248284425) | 8 | 4 | 7 | 28859 | 19 | |||
| 115462 | 32345 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1201 35th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | Permit Number 37068 | 5985179.95256355 | 2107022.76154853 | 37.7646257968319 | -122.494488338591 | (37.7646257968319, -122.494488338591) | 1 | 8 | 3 | 56 | 35 | ||
| 117643 | 49582 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 400REVISED Alemany Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2003 12:00:00 AM | Permit Number 46462 | 6008204.64175087 | 2095122.01632245 | 37.7332696598424 | -122.414009852171 | (37.7332696598424, -122.414009852171) | 2 | 7 | 7 | 28859 | 2 | |||
| 128242 | 23676 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 319 Virginia Ave | 5 | Median : Cutout | Tree | DPW 1 | 6 | 12 | 6006936.2458165 | 2098250.5638735 | 37.741788638282 | -122.418616833275 | (37.741788638282, -122.418616833275) | 2 | 7 | 7 | 28859 | 2 | |||
| 133217 | 220022 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1334 Diamond St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6001965.37109 | 2100066.86744 | 37.746494668289 | -122.435934385359 | (37.746494668289, -122.435934385359) | 2 | 7 | 5 | 63 | 22 | |||
| 138145 | 138352 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2499 Bush St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6001715.4366 | 2114603.3734 | 37.7863941325812 | -122.437839612353 | (37.7863941325812, -122.437839612353) | 13 | 6 | 1 | 29490 | 27 | |||
| 147231 | 50471 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 3010X Lyon St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2003 12:00:00 AM | 5 | 3x3 | Permit Number 47106 | 5999184.20401146 | 2119093.85477845 | 37.7985795459747 | -122.446920252577 | (37.7985795459747, -122.446920252577) | 13 | 9 | 1 | 57 | 17 | |
| 151023 | 203227 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1575 07th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5993976.11047 | 2104705.81134 | 37.7587749306244 | -122.463896818706 | (37.7587749306244, -122.463896818706) | 1 | 5 | 4 | 56 | 12 | |||
| 171790 | 203640 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 216 Ralston St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 5ft | 5992221.60329 | 2089317.43063 | 37.7164210557753 | -122.468844858002 | (37.7164210557753, -122.468844858002) | 9 | 8 | 6 | 64 | 24 | |||
| 175410 | 50664 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1 Santa Ynez Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47244 | 6000978.87890111 | 2091807.60057831 | 37.7237605529163 | -122.43875382021 | (37.7237605529163, -122.43875382021) | 9 | 7 | 6 | 28861 | 25 | ||||
| 178294 | 859 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 400X Alemany Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3x3 | 6008091.17818 | 2095049.40427 | 37.7330639095777 | -122.414396992023 | (37.7330639095777, -122.414396992023) | 2 | 7 | 7 | 28859 | 2 | |||
| 182375 | 220052 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 50 Coleridge St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006851.99562 | 2099403.94647 | 37.7449508246175 | -122.418989930439 | (37.7449508246175, -122.418989930439) | 2 | 7 | 7 | 28859 | 2 | |||
| 185557 | 138347 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1770 SCOTT ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6001586.1357 | 2114554.9139 | 37.7862537218777 | -122.438283486898 | (37.7862537218777, -122.438283486898) | 13 | 6 | 1 | 29490 | 27 | |||
| 115064 | 188512 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 101 Pennsylvania Ave | 41 | Front Yard : Yard | Tree | Private 2 | 5 | 6014229.23402 | 2106696.64866 | 37.7653876762377 | -122.393991007905 | (37.7653876762377, -122.393991007905) | 14 | 3 | 8 | 28856 | 20 | ||||
| 2028 | 76748 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1501X 42nd Ave | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 7 | 3x12 | 5983093.5463 | 2104693.1195 | 37.7581069307926 | -122.501532189631 | (37.7581069307926, -122.501532189631) | 1 | 8 | 3 | 56 | 35 | ||
| 5053 | 247838 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 79 Nevada St | 4 | Front Yard : Yard | Tree | Private 2 | 4 | 6009045.88807 | 2098099.79815 | 37.7414932155318 | -122.411311709481 | (37.7414932155318, -122.411311709481) | 10 | 7 | 7 | 28859 | 2 | ||||
| 7171 | 203639 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 216 Ralston St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 5ft | 5992221.12373 | 2089294.63928 | 37.7163584485498 | -122.468844858017 | (37.7163584485498, -122.468844858017) | 9 | 8 | 6 | 64 | 24 | |||
| 13475 | 20057 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 15ST | |||||||||||||
| 16364 | 203625 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 15 Teresita Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5997311.4729 | 2099621.76413 | 37.7450070466421 | -122.451994860675 | (37.7450070466421, -122.451994860675) | 9 | 7 | 4 | 59 | 40 | |||
| 16743 | 50472 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 3010X Lyon St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2003 12:00:00 AM | 5 | 3x3 | Permit Number 47106 | 5999184.20401146 | 2119093.85477845 | 37.7985795459747 | -122.446920252577 | (37.7985795459747, -122.446920252577) | 13 | 9 | 1 | 57 | 17 | |
| 18917 | 220049 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 201 Rivoli St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 5997609 | 2105896 | 37.7622515762528 | -122.451418517771 | (37.7622515762528, -122.451418517771) | 15 | 5 | 11 | 29492 | 9 | |||
| 21787 | 32344 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1201 35th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | Permit Number 37068 | 5985179.95256355 | 2107022.76154853 | 37.7646257968319 | -122.494488338591 | (37.7646257968319, -122.494488338591) | 1 | 8 | 3 | 56 | 35 | ||
| 23452 | 85510 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1 Nebraska St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 49678 | 6009335 | 2098038 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | 10 | 7 | 7 | 28859 | 2 | ||||
| 24178 | 50663 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1 Santa Ynez Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47244 | 6000978.87890111 | 2091807.60057831 | 37.7237605529163 | -122.43875382021 | (37.7237605529163, -122.43875382021) | 9 | 7 | 6 | 28861 | 25 | ||||
| 30410 | 220059 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 3505 24th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006111.03304 | 2101975.99077 | 37.7519713192249 | -122.421734701821 | (37.7519713192249, -122.421734701821) | 2 | 4 | 5 | 28859 | 19 | |||
| 35601 | 39507 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 216 Jersey St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | Permit Number 40959 | 6003716.05884842 | 2101601.85489178 | 37.7508086831914 | -122.429990180024 | (37.7508086831914, -122.429990180024) | 2 | 4 | 5 | 28862 | 22 | ||
| 37421 | 37816 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 450X Moscow St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/07/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40134 | 6003955.66683 | 2090537.19552 | 37.720441203374 | -122.428373060073 | (37.720441203374, -122.428373060073) | 9 | 7 | 6 | 28861 | 5 |
| 41332 | 249768 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 266 Lombard St | 4 | Front Yard : Yard | Tree | Private 2 | 12 | Width 0ft | 6010977.12206 | 2120702.10235 | 37.8036620671076 | -122.406226211476 | (37.8036620671076, -122.406226211476) | 3 | 1 | 10 | 308 | 23 | |||
| 57640 | 103887 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1750 Fulton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 5999387.5565 | 2110861.3404 | 37.7759868308232 | -122.445624264682 | (37.7759868308232, -122.445624264682) | 15 | 5 | 11 | 29492 | 16 | |||
| 76610 | 138346 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1770 SCOTT ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6001590.3534 | 2114514.4235 | 37.7861427855089 | -122.438265993007 | (37.7861427855089, -122.438265993007) | 13 | 6 | 1 | 29490 | 27 | |||
| 80777 | 122010 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1342 Cabrillo St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5991362.52356 | 2110673.50037 | 37.7750096402296 | -122.473370979732 | (37.7750096402296, -122.473370979732) | 11 | 6 | 2 | 54 | 26 | |||
| 85691 | 49583 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 400REVISED Alemany Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2003 12:00:00 AM | Permit Number 46462 | 6008204.64175087 | 2095122.01632245 | 37.7332696598424 | -122.414009852171 | (37.7332696598424, -122.414009852171) | 2 | 7 | 7 | 28859 | 2 | |||
| 93718 | 203226 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1575 07th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 5993976.59011 | 2104728.66377 | 37.7588377051234 | -122.463896818678 | (37.7588377051234, -122.463896818678) | 1 | 5 | 4 | 56 | 12 | |||
| 101451 | 105175 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1601X Newcomb Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 10 | 3x3 | 6015153.3918 | 2095715.6028 | 37.7352873542424 | -122.390027366589 | (37.7352873542424, -122.390027366589) | 10 | 3 | 8 | 58 | 1 | |||
| 104939 | 203661 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 582 Mangels Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 10ft | 5997537.55728 | 2095290.58786 | 37.7331276310309 | -122.450900858796 | (37.7331276310309, -122.450900858796) | 9 | 7 | 4 | 59 | 40 | |||
| 118283 | 138351 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2499 Bush St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6001690.7359 | 2114600.4656 | 37.7863847439093 | -122.437924862001 | (37.7863847439093, -122.437924862001) | 13 | 6 | 1 | 29490 | 27 | |||
| 119130 | 188521 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 495 Connecticut St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6013271.44792 | 2104826.12778 | 37.7601983604744 | -122.397172617724 | (37.7601983604744, -122.397172617724) | 10 | 3 | 8 | 28856 | 29 | |||
| 123132 | 23675 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 319 Virginia Ave | 4 | Median : Cutout | Tree | DPW 1 | 6 | 12 | 6006936.2458165 | 2098250.5638735 | 37.741788638282 | -122.418616833275 | (37.741788638282, -122.418616833275) | 2 | 7 | 7 | 28859 | 2 | |||
| 134394 | 140719 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 556 SCOTT ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6002157.9056 | 2110466.8172 | 37.7750613439019 | -122.436012678697 | (37.7750613439019, -122.436012678697) | 15 | 5 | 11 | 29492 | 10 | |||
| 135042 | 50673 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 3305 Washington St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47252 | 5998970.56266258 | 2115921.05690667 | 37.7898556796393 | -122.447431022041 | (37.7898556796393, -122.447431022041) | 13 | 6 | 1 | 54 | 31 | ||||
| 155399 | 124761 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1055 Greenwich St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007856.93229 | 2119906.6476 | 37.8013029241584 | -122.416967423511 | (37.8013029241584, -122.416967423511) | 5 | 1 | 1 | 308 | 32 | |||
| 159060 | 85502 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1 Nebraska St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 6009335 | 2098038 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | 10 | 7 | 7 | 28859 | 2 | |||||
| 162082 | 218406 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 225 Castenada Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 0ft | 5994236.91998 | 2100511.76696 | 37.7472741826649 | -122.462690582315 | (37.7472741826649, -122.462690582315) | 1 | 8 | 4 | 29491 | 40 | |||
| 162982 | 19284 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1770 Scott St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/1998 12:00:00 AM | 9 | 3X3 | 6001619.01622 | 2114490.46983 | 37.786078645055 | -122.438165110876 | (37.786078645055, -122.438165110876) | 13 | 6 | 1 | 29490 | 27 | ||
| 164166 | 102849 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 31 Guy Pl | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 1x1 | 6014185 | 2114270 | 37.7861799368485 | -122.394674400267 | (37.7861799368485, -122.394674400267) | 6 | 2 | 9 | 28855 | 6 | |||
| 169039 | 85501 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1 Nebraska St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009335 | 2098038 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | 10 | 7 | 7 | 28859 | 2 | |||||
| 173447 | 220005 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2080 Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008062.79185 | 2106290.9953 | 37.7639292034025 | -122.415290650144 | (37.7639292034025, -122.415290650144) | 8 | 4 | 7 | 28859 | 19 | |||
| 177732 | 38051 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2700 Bush St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1998 12:00:00 AM | 0 | Permit Number 40248 | 6000571.40891222 | 2114495.1875697 | 37.7860319624569 | -122.441789880059 | (37.7860319624569, -122.441789880059) | 13 | 6 | 1 | 29490 | 27 | |
| 180634 | 137667 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1901 GOLDEN GATE AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6000415.6663 | 2111642.14 | 37.7781893511619 | -122.442123833863 | (37.7781893511619, -122.442123833863) | 15 | 5 | 11 | 29490 | 16 | |||
| 142879 | 203652 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 400x Marietta Dr | 38 | Median : Cutout | Tree | DPW 1 | 6 | Width 3ft | 5999131.48243 | 2096996.51385 | 37.7379028188638 | -122.445512879233 | (37.7379028188638, -122.445512879233) | 9 | 7 | 4 | 59 | 40 | |||
| 23139 | 188511 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 101 Pennsylvania Ave | 33 | Front Yard : Yard | Tree | Private 2 | 2 | 6014272.76615 | 2106665.73514 | 37.7653052137955 | -122.393838275126 | (37.7653052137955, -122.393838275126) | 14 | 3 | 8 | 310 | 29 | ||||
| 165333 | 188527 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1427x Innes Ave | 30 | Median : Yard | Tree | DPW 1 | 15 | 6016131.12478 | 2096760.51066 | 37.7382106379019 | -122.386719795784 | (37.7382106379019, -122.386719795784) | 10 | 3 | 8 | 58 | 1 | ||||
| 2449 | 220048 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 201 Rivoli St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 5997609 | 2105896 | 37.7622515762528 | -122.451418517771 | (37.7622515762528, -122.451418517771) | 15 | 5 | 11 | 29492 | 9 | |||
| 5032 | 85509 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1 Nebraska St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 49678 | 6009335 | 2098038 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | 10 | 7 | 7 | 28859 | 2 | ||||
| 8412 | 203659 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 628 Edna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5998583.28764 | 2094893.18321 | 37.7320962615306 | -122.447256912002 | (37.7320962615306, -122.447256912002) | 9 | 7 | 4 | 59 | 40 | |||
| 8576 | 32346 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1201 35th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | Permit Number 37068 | 5985179.95256355 | 2107022.76154853 | 37.7646257968319 | -122.494488338591 | (37.7646257968319, -122.494488338591) | 1 | 8 | 3 | 56 | 35 | ||
| 10056 | 188508 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 101 Pennsylvania Ave | 3 | Front Yard : Yard | Tree | Private 2 | 3 | 6014332.46782 | 2106283.64375 | 37.764259392178 | -122.393605035044 | (37.764259392178, -122.393605035044) | 14 | 3 | 8 | 310 | 29 | ||||
| 13029 | 20056 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 15ST | |||||||||||||
| 13298 | 75250 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 101 De Long St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5994476.95751 | 2086787.32717 | 37.7096040318843 | -122.460866039547 | (37.7096040318843, -122.460866039547) | 9 | 8 | 6 | 28861 | 25 | |||
| 23190 | 188515 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1401 25th St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 6014455.23285 | 2101981.54762 | 37.7524535851846 | -122.392879417078 | (37.7524535851846, -122.392879417078) | 10 | 3 | 8 | 28856 | 1 | ||||
| 24313 | 36920 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 699 Alvarado St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/27/1998 12:00:00 AM | Permit Number 39565 | 6001900 | 2102596 | 37.7534353511669 | -122.436341406283 | (37.7534353511669, -122.436341406283) | 2 | 4 | 5 | 28862 | 22 | ||
| 25803 | 35250 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1385 Greenwich St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/17/1998 12:00:00 AM | 8 | Permit Number 38738 | 6006287.30636 | 2119683.41372 | 37.8006015626823 | -122.42238315977 | (37.8006015626823, -122.42238315977) | 13 | 9 | 1 | 28858 | 32 | |
| 26523 | 40816 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1770 Scott St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/1999 12:00:00 AM | 8 | Permit Number 41760 | 6001593.7276 | 2114497.5525 | 37.7860966539785 | -122.438253110129 | (37.7860966539785, -122.438253110129) | 13 | 6 | 1 | 29490 | 27 | ||
| 28963 | 203665 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 123 Detroit St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5999403.44951 | 2093584.38933 | 37.7285494495997 | -122.444327421686 | (37.7285494495997, -122.444327421686) | 9 | 7 | 4 | 28861 | 40 | |||
| 34409 | 188513 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 55 Mississippi St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6013999.87449 | 2106891.97216 | 37.7659112417232 | -122.394797995654 | (37.7659112417232, -122.394797995654) | 14 | 3 | 8 | 28856 | 20 | |||
| 41138 | 188519 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1451 Rhode Island St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 6012046.50101 | 2101636.39558 | 37.7513717861857 | -122.401185012303 | (37.7513717861857, -122.401185012303) | 10 | 3 | 8 | 28856 | 29 | ||||
| 42163 | 29220 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1902X 41st Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 5983534.5176829 | 2102185.1808128 | 37.7512467209802 | -122.499821775189 | (37.7512467209802, -122.499821775189) | 1 | 8 | 3 | 29491 | 35 | |||
| 43532 | 250193 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 11 Alta St | 3 | Back Yard : Yard | Tree | Private 2 | 35 | Width 0ft | 6011782.39923 | 2119949.71509 | 37.8016412059365 | -122.403386530161 | (37.8016412059365, -122.403386530161) | 3 | 1 | 10 | 308 | 23 |
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) );