trees
835 rows where qSpecies_id = 122 sorted by qCaretaker_id
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 594 | 20063 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 15ST | |||||||||||||
| 1577 | 19793 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY19 | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 20ST | |||||||||||||
| 2826 | 20064 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 15ST | |||||||||||||
| 3129 | 20059 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 15ST | |||||||||||||
| 3232 | 20054 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 15ST | |||||||||||||
| 3626 | 20062 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 15ST | |||||||||||||
| 5215 | 20061 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 15ST | |||||||||||||
| 5787 | 19577 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY3 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 15ST | |||||||||||||
| 10295 | 188526 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1427x Innes Ave | 12 | Median : Yard | Tree | DPW 1 | 13 | 6016254.90623 | 2096663.38381 | 37.7379507994938 | -122.386285047323 | (37.7379507994938, -122.386285047323) | 10 | 3 | 8 | 58 | 1 | ||||
| 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 | ||
| 12288 | 199070 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1130 Connecticut St | 2 | Sidewalk: Property side : Yard | Tree | DPW 1 | 0 | 6013384.89381 | 2101721.18884 | 37.7516791861622 | -122.3965626049 | (37.7516791861622, -122.3965626049) | 10 | 3 | 8 | 28856 | 29 | ||||
| 13029 | 20056 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 15ST | |||||||||||||
| 13475 | 20057 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 15ST | |||||||||||||
| 14833 | 20055 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 15ST | |||||||||||||
| 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 | |||||||||||||
| 19224 | 261621 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1821 25th St | 2 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3x3 | 6013134 | 2101730 | 37.751689413587 | -122.397430852298 | (37.751689413587, -122.397430852298) | 10 | 3 | 8 | 28856 | 29 | ||||
| 19563 | 261622 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1281x Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6012916 | 2101714 | 37.7516333407735 | -122.398183607514 | (37.7516333407735, -122.398183607514) | 10 | 3 | 8 | 28856 | 29 | ||||
| 20868 | 10688 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1221 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/1991 12:00:00 AM | 6 | 3X3 | 6002001.6656 | 2110480.73 | 37.7750906677438 | -122.43655414222 | (37.7750906677438, -122.43655414222) | 15 | 5 | 11 | 29492 | 10 | ||
| 25439 | 98708 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 105X Ord St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6000883.6 | 2105740.8 | 37.7620124016568 | -122.440081810476 | (37.7620124016568, -122.440081810476) | 15 | 5 | 5 | 28862 | 3 | |||||
| 35567 | 23660 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 305 Virginia Ave | 2 | Median : Cutout | Tree | DPW 1 | 12 | 12 | 6006899.0385805 | 2098362.9679323 | 37.7420951798748 | -122.418753453583 | (37.7420951798748, -122.418753453583) | 2 | 7 | 7 | 28859 | 2 | |||
| 37897 | 23663 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 311 Virginia Ave | 2 | Median : Cutout | Tree | DPW 1 | 12 | 12 | 6006938.1768512 | 2098312.3803834 | 37.7419584813283 | -122.41861453897 | (37.7419584813283, -122.41861453897) | 2 | 7 | 7 | 28859 | 2 | |||
| 39232 | 1377 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 65 Amethyst Way | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/10/1998 12:00:00 AM | 3 | 1X1 | 5998937.99517 | 2100006.33795 | 37.7461560249957 | -122.44639832203 | (37.7461560249957, -122.44639832203) | 2 | 7 | 5 | 63 | 22 | ||
| 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 | |||
| 59125 | 19282 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1770 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11 | 3X3 | 6001619.01622 | 2114490.46983 | 37.786078645055 | -122.438165110876 | (37.786078645055, -122.438165110876) | 13 | 6 | 1 | 29490 | 27 | |||
| 78564 | 220007 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 929 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/12/2015 03:22:00 PM | 1 | Width 3ft | Permit Number 24134 | 6006336.25046 | 2104153.43116 | 37.7579627654961 | -122.421110461684 | (37.7579627654961, -122.421110461684) | 2 | 4 | 7 | 28859 | 19 | |
| 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 | |||
| 90689 | 98707 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 105X Ord St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6000883.6 | 2105740.8 | 37.7620124016568 | -122.440081810476 | (37.7620124016568, -122.440081810476) | 15 | 5 | 5 | 28862 | 3 | ||||
| 93978 | 23671 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 317 Virginia Ave | 2 | Median : Cutout | Tree | DPW 1 | 6 | 12 | 6006937.9415449 | 2098264.8464559 | 37.7418279505329 | -122.41861198258 | (37.7418279505329, -122.41861198258) | 2 | 7 | 7 | 28859 | 2 | |||
| 96959 | 28134 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 400X Eugenia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/17/2016 12:00:00 AM | 3 | 6x9 | 6006749.04287 | 2098002.24216 | 37.7410962610784 | -122.41924650972 | (37.7410962610784, -122.41924650972) | 2 | 7 | 7 | 28859 | 2 | ||
| 102025 | 19281 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1770 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3X3 | 6001619.01622 | 2114490.46983 | 37.786078645055 | -122.438165110876 | (37.786078645055, -122.438165110876) | 13 | 6 | 1 | 29490 | 27 | |||
| 108665 | 19283 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1770 Scott St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3X3 | 6001619.01622 | 2114490.46983 | 37.786078645055 | -122.438165110876 | (37.786078645055, -122.438165110876) | 13 | 6 | 1 | 29490 | 27 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 123154 | 24819 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 400X Alemany Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/09/2001 12:00:00 AM | 18 | 3x3 | 6007950.68171 | 2094974.05944 | 37.7328491354706 | -122.414877396298 | (37.7328491354706, -122.414877396298) | 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 | |||
| 130218 | 17224 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1880X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X3 | 6001029.5778 | 2091188.70927 | 37.7220641019562 | -122.438534240876 | (37.7220641019562, -122.438534240876) | 9 | 7 | 6 | 28861 | 25 | |||
| 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 | |||
| 141309 | 23659 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 305 Virginia Ave | 1 | Median : Cutout | Tree | DPW 1 | 12 | 12 | 6006899.0385805 | 2098362.9679323 | 37.7420951798748 | -122.418753453583 | (37.7420951798748, -122.418753453583) | 2 | 7 | 7 | 28859 | 2 | |||
| 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 | |||
| 143240 | 116664 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 199x Esmeralda Ave | 18 | Unaccepted Street : Yard | Tree | DPW 1 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) | 2 | 7 | 7 | 28859 | 2 | |||||
| 144063 | 23666 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 313 Virginia Ave | 1 | Median : Cutout | Tree | DPW 1 | 12 | 12 | 6006939.3181056 | 2098298.0428385 | 37.7419191778851 | -122.418609576385 | (37.7419191778851, -122.418609576385) | 2 | 7 | 7 | 28859 | 2 | |||
| 147834 | 25177 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 3076 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/19/1996 12:00:00 AM | 30 | 3X3 | 6000054.6842234 | 2105404.3700399 | 37.7610414235505 | -122.442924538729 | (37.7610414235505, -122.442924538729) | 15 | 5 | 5 | 28862 | 3 | ||
| 152011 | 10209 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1301 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/17/1994 12:00:00 AM | 12 | 3X3PL | 6005849.39823 | 2101351.62015 | 37.7502421837319 | -122.4225951102 | (37.7502421837319, -122.4225951102) | 2 | 4 | 5 | 28859 | 19 | ||
| 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 | ||
| 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 | ||||
| 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 | |||
| 167911 | 116614 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 299X SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3x3 | 6007772 | 2106483 | 37.7644400562771 | -122.416310015149 | (37.7644400562771, -122.416310015149) | 8 | 4 | 7 | 28859 | 19 | |||
| 168418 | 220038 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 500x 27th St | 11 | Median : Cutout | Tree | DPW 1 | 1 | Width 4ft | 6002807.79997 | 2100063.23443 | 37.7465325135634 | -122.433021102638 | (37.7465325135634, -122.433021102638) | 2 | 7 | 5 | 63 | 22 | |||
| 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 | |||
| 178319 | 1378 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 65 Amethyst Way | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/10/1998 12:00:00 AM | 7 | 1X1 | 5998886.8781591 | 2099985.9166978 | 37.7460970335049 | -122.446573608518 | (37.7460970335049, -122.446573608518) | 2 | 7 | 5 | 63 | 22 | ||
| 188431 | 23664 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 311 Virginia Ave | 3 | Median : Cutout | Tree | DPW 1 | 12 | 12 | 6006938.1768512 | 2098312.3803834 | 37.7419584813283 | -122.41861453897 | (37.7419584813283, -122.41861453897) | 2 | 7 | 7 | 28859 | 2 | |||
| 193919 | 10634 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 830 Hayes St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/02/1990 12:00:00 AM | 12 | 3X3 | 6003840.507 | 2110782.2115 | 37.7760227838468 | -122.430214699132 | (37.7760227838468, -122.430214699132) | 7 | 9 | 11 | 29492 | 10 | ||
| 942 | 67185 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 154 Carmel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1992 12:00:00 AM | 12 | Permit Number 30632 | 5998076.31886872 | 2105384.33640813 | 37.7608734252807 | -122.449765371246 | (37.7608734252807, -122.449765371246) | 15 | 5 | 11 | 29492 | 12 | |
| 1329 | 124750 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 566 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6004650.035 | 2110687.35997 | 37.7758081630602 | -122.42740756863 | (37.7758081630602, -122.42740756863) | 7 | 9 | 11 | 28852 | 10 | |||
| 1353 | 203642 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 349x Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | Width 5ft | 5993150.97673 | 2103877.75625 | 37.7564537210662 | -122.466690296437 | (37.7564537210662, -122.466690296437) | 1 | 8 | 4 | 56 | 12 | |||
| 1532 | 219991 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 13 Bronte St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6009385.52811 | 2097403.78697 | 37.739601163374 | -122.410088220496 | (37.739601163374, -122.410088220496) | 10 | 7 | 7 | 28859 | 2 | |||
| 1762 | 30595 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 265 Walter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/1995 12:00:00 AM | Permit Number 34562 | |||||||||||||
| 1889 | 259158 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 475 Hickory St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x | 6004817 | 2110376 | 37.7749626863145 | -122.426807815207 | (37.7749626863145, -122.426807815207) | 7 | 9 | 11 | 28852 | 10 | ||||
| 2035 | 68350 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 535 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | 10 | Permit Number 32169 | 5989368.29935 | 2111675.70215 | 37.7776457288828 | -122.48034272561 | (37.7776457288828, -122.48034272561) | 11 | 6 | 2 | 55 | 26 | |
| 2364 | 38049 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2700 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/11/2005 12:00:00 AM | 9 | Permit Number 47797 | 6000509.1373 | 2114490.0048 | 37.7860141835177 | -122.442004950262 | (37.7860141835177, -122.442004950262) | 13 | 6 | 1 | 29490 | 27 | |
| 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 | |||
| 2461 | 73754 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1815 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6009969.6946 | 2120303.1237 | 37.8025101678048 | -122.409684302662 | (37.8025101678048, -122.409684302662) | 3 | 1 | 10 | 308 | 23 | |||
| 2542 | 32891 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1515 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/1996 12:00:00 AM | Permit Number 37234 | 5994269.30013039 | 2105266.22888454 | 37.7603305839468 | -122.462923499947 | (37.7603305839468, -122.462923499947) | 1 | 5 | 4 | 56 | 12 | ||
| 2756 | 39703 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 634 Edna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1999 12:00:00 AM | Permit Number 41088 | 5998596.64163755 | 2094795.02743762 | 37.7318275120035 | -122.4472036828 | (37.7318275120035, -122.4472036828) | 9 | 7 | 4 | 59 | 40 | ||
| 2797 | 220079 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 4021 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6003566.56829 | 2104171.42308 | 37.7578556427516 | -122.430690474488 | (37.7578556427516, -122.430690474488) | 2 | 4 | 5 | 28862 | 3 | |||
| 2860 | 78000 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2804 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5985608.4149 | 2096224.5025 | 37.735001786065 | -122.492211254352 | (37.735001786065, -122.492211254352) | 1 | 8 | 3 | 29491 | 35 | |||
| 3138 | 71805 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2451 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5987333.5642 | 2098599.3879 | 37.7416232962242 | -122.486421183565 | (37.7416232962242, -122.486421183565) | 1 | 8 | 3 | 29491 | 35 | |||
| 3321 | 220066 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1109 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6002537.11463 | 2102291.14962 | 37.7526344847082 | -122.434116340213 | (37.7526344847082, -122.434116340213) | 2 | 4 | 5 | 28862 | 22 | |||
| 3985 | 69145 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2419 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/18/1994 12:00:00 AM | 6 | Permit Number 33179 | 5983608.7607 | 2098659.5816 | 37.741570751884 | -122.499304541285 | (37.741570751884, -122.499304541285) | 1 | 8 | 3 | 29491 | 35 | |
| 4389 | 220051 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 399X Eugenia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006837 | 2098006 | 37.7411115324804 | -122.418942651587 | (37.7411115324804, -122.418942651587) | 2 | 7 | 7 | 28859 | 2 | |||
| 4487 | 259159 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 475 Hickory St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x | 6004817 | 2110376 | 37.7749626863145 | -122.426807815207 | (37.7749626863145, -122.426807815207) | 7 | 9 | 11 | 28852 | 10 | ||||
| 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 | ||||
| 4729 | 38050 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2700 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/11/2005 12:00:00 AM | 3 | Permit Number 47797 | 6000529.6397 | 2114492.1859 | 37.7860213405762 | -122.441934174319 | (37.7860213405762, -122.441934174319) | 13 | 6 | 1 | 29490 | 27 | |
| 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 | ||||
| 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 | ||||
| 5516 | 248395 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1655 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/1999 12:00:00 AM | 8 | Width 0ft | Permit Number 41881 | 5997659.0251 | 2108142.2349 | 37.7684220306889 | -122.451407517669 | (37.7684220306889, -122.451407517669) | 15 | 5 | 11 | 29492 | 9 | |
| 5666 | 81675 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 495 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6013305 | 2104816 | 37.7601724196148 | -122.397055866002 | (37.7601724196148, -122.397055866002) | 10 | 3 | 8 | 28856 | 29 | |||
| 5685 | 245867 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 419 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6005023.743 | 2110457.4751 | 37.7751980841556 | -122.426098447818 | (37.7751980841556, -122.426098447818) | 7 | 9 | 11 | 28852 | 10 | |||
| 6049 | 35103 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 786 Edinburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | Permit Number 38645 | 6001885.65115289 | 2089265.94057695 | 37.7168332689419 | -122.435437534334 | (37.7168332689419, -122.435437534334) | 9 | 7 | 6 | 28861 | 5 | ||
| 6360 | 83538 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 243 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6004140.21383 | 2089715.70651 | 37.7181960153187 | -122.427676641269 | (37.7181960153187, -122.427676641269) | 9 | 7 | 6 | 28861 | 5 | |||
| 6554 | 51248 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 684 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/17/2004 12:00:00 AM | Permit Number 47625 | 6007471.15651424 | 2105682.67696043 | 37.7622256337552 | -122.417293833991 | (37.7622256337552, -122.417293833991) | 8 | 4 | 7 | 28859 | 19 | ||
| 6622 | 124083 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 3434 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 5992631.55645 | 2110040.63137 | 37.7733453553708 | -122.468935093468 | (37.7733453553708, -122.468935093468) | 11 | 6 | 2 | 54 | 11 | |||
| 6630 | 30591 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 253 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/1995 12:00:00 AM | Permit Number 34560 | |||||||||||||
| 7013 | 220677 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 3625 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2020 12:00:00 AM | 3 | Width 3ft | 6006108.91147 | 2104316.67896 | 37.758398187544 | -122.421908293434 | (37.758398187544, -122.421908293434) | 2 | 4 | 5 | 28859 | 19 | ||
| 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 | |||
| 7229 | 73391 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 237 Theresa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6001816.88591 | 2094039.23102 | 37.7299357428343 | -122.43601658702 | (37.7299357428343, -122.43601658702) | 9 | 7 | 6 | 28861 | 25 | |||
| 7242 | 83227 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 495 Connecticut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6013273.66902 | 2104798.74295 | 37.7601232913798 | -122.397163015669 | (37.7601232913798, -122.397163015669) | 10 | 3 | 8 | 28856 | 29 | |||
| 7303 | 220693 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 3873 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6004694.52758 | 2100732.52355 | 37.7484770663623 | -122.426544650217 | (37.7484770663623, -122.426544650217) | 2 | 4 | 5 | 63 | 22 | |||
| 7577 | 248396 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1655 Waller St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/1999 12:00:00 AM | 7 | Width 0ft | Permit Number 41881 | 5997671.1383 | 2108143.749 | 37.7684268816356 | -122.451365728625 | (37.7684268816356, -122.451365728625) | 15 | 5 | 11 | 29492 | 9 | |
| 8295 | 70299 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 237 Theresa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6001826.35316 | 2094025.88285 | 37.7298996296434 | -122.435982902906 | (37.7298996296434, -122.435982902906) | 9 | 7 | 6 | 28861 | 25 | |||
| 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 | |||
| 8433 | 220003 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1001 Jarboe Ave | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | Width 8ft | 6009413 | 2096866 | 37.738126056693 | -122.40995527996 | (37.738126056693, -122.40995527996) | 10 | 7 | 7 | 28859 | 2 | |||
| 8463 | 203650 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1390 Monterey Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 3ft | 5993848.38247 | 2094813.02416 | 37.7316044735649 | -122.463620576647 | (37.7316044735649, -122.463620576647) | 9 | 8 | 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 | ||
| 8595 | 66640 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 2620 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1993 12:00:00 AM | Permit Number 32335 | 6010387.14006944 | 2103433.53881978 | 37.7562136300125 | -122.407049963033 | (37.7562136300125, -122.407049963033) | 10 | 4 | 7 | 28859 | 19 | ||
| 8738 | 44456 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 95 Winding Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 5 | Permit Number 43779 | 6002571.72829 | 2086874.98861 | 37.7103071803111 | -122.432895389109 | (37.7103071803111, -122.432895389109) | 9 | 7 | 6 | 28861 | 5 | |
| 9025 | 30594 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 265 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/1995 12:00:00 AM | Permit Number 34562 | |||||||||||||
| 9093 | 33190 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 76 Hernandez Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1996 12:00:00 AM | Permit Number 37397 | 5996015.45875929 | 2099706.92373099 | 37.7451665539633 | -122.456482373988 | (37.7451665539633, -122.456482373988) | 1 | 5 | 4 | 59 | 40 |
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) );