Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord ▼ | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27086 | 27086 | 225956 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 126 Fairmount St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004690.92985 | 2097272.0847099996 | 37.738975290087104 | -122.426310750952 | (37.7389752900871, -122.426310750952) | |||
| 84306 | 84306 | 60044 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 126 Fairmount St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2008 12:00:00 AM | 3x3 | Permit Number 51412 | 6004702.07588502 | 2097279.21146554 | 37.7389954885734 | -122.426272720335 | (37.7389954885734, -122.426272720335) | ||
| 56399 | 56399 | 219016 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 23 Gaviota Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5998493.11217 | 2097521.42795 | 37.7393076426268 | -122.447757806504 | (37.7393076426268, -122.447757806504) | |||
| 45304 | 45304 | 225930 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 269 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006712.58135 | 2098072.63553 | 37.7412874920181 | -122.41937757332899 | (37.7412874920181, -122.419377573329) | |||
| 44495 | 44495 | 225965 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 81 Bernal Heights Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009494.27227 | 2098224.22173 | 37.74185999325589 | -122.409770124916 | (37.7418599932559, -122.409770124916) | |||
| 164420 | 164420 | 225929 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 56 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6008145.90084 | 2098385.005 | 37.742225813165895 | -122.414443742389 | (37.7422258131659, -122.414443742389) | |||
| 123160 | 123160 | 94129 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 420 Holladay Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2010 12:00:00 AM | 3x3 | Permit Number 53495 | 6010221.9 | 2098587.9 | 37.7428993246027 | -122.407279845082 | (37.7428993246027, -122.407279845082) | ||
| 121526 | 121526 | 105214 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2400X 21ST AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 5989837.0 | 2098691.0 | 37.7420204448441 | -122.477771936587 | (37.7420204448441, -122.477771936587) | |||
| 128944 | 128944 | 105213 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2400X 21ST AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 5989837.0 | 2098691.0 | 37.7420204448441 | -122.477771936587 | (37.7420204448441, -122.477771936587) | |||
| 128600 | 128600 | 95394 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 208 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/2011 12:00:00 AM | 3x3 | Permit Number 767264 | 6004579.0 | 2098715.0 | 37.742930879183604 | -122.426800483584 | (37.7429308791836, -122.426800483584) | |
| 36653 | 36653 | 225927 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 172 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6004830.8864400005 | 2098735.49496 | 37.7430013921091 | -122.425930987935 | (37.7430013921091, -122.425930987935) | |||
| 158982 | 158982 | 225932 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 557 Peralta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6009854.01904 | 2098898.01508 | 37.743730236853 | -122.40857375230101 | (37.743730236853, -122.408573752301) | |||
| 122979 | 122979 | 37469 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 557 Peralta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1998 12:00:00 AM | Permit Number 39940 | 6009863.21581356 | 2098931.68283254 | 37.7438231962188 | -122.408544326388 | (37.7438231962188, -122.408544326388) | ||
| 110815 | 110815 | 42034 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 357 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50466 | 6004260.0 | 2098933.0 | 37.743511415711104 | -122.427919028307 | (37.7435114157111, -122.427919028307) | |
| 81707 | 81707 | 35398 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 540 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/16/1998 12:00:00 AM | Permit Number 38853 | 6003072.48314636 | 2098933.73753739 | 37.743446188104 | -122.43202521517 | (37.743446188104, -122.43202521517) | ||
| 148398 | 148398 | 225925 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 357 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004205.07883 | 2098948.09387 | 37.743549752810296 | -122.428110007472 | (37.7435497528103, -122.428110007472) | |||
| 9818 | 9818 | 46930 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1 Pacheco St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2016 12:00:00 AM | 3 | Permit Number 779184 | 5995168.47040897 | 2099126.50126016 | 37.743524195830396 | -122.459369067857 | (37.7435241958304, -122.459369067857) | |
| 9820 | 9820 | 46927 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1 Pacheco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2016 12:00:00 AM | 3 | Permit Number 779184 | 5995168.47040897 | 2099126.50126016 | 37.743524195830396 | -122.459369067857 | (37.7435241958304, -122.459369067857) | |
| 9821 | 9821 | 46929 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1 Pacheco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2016 12:00:00 AM | 3 | Permit Number 779184 | 5995168.47040897 | 2099126.50126016 | 37.743524195830396 | -122.459369067857 | (37.7435241958304, -122.459369067857) | |
| 9825 | 9825 | 46928 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1 Pacheco St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/2016 12:00:00 AM | 3 | Permit Number 779184 | 5995168.47040897 | 2099126.50126016 | 37.743524195830396 | -122.459369067857 | (37.7435241958304, -122.459369067857) | ||
| 76670 | 76670 | 225926 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 448 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6002953.29528 | 2099219.1530400002 | 37.7442231148112 | -122.43245771787 | (37.7442231148112, -122.43245771787) | |||
| 129939 | 129939 | 225921 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 300 Montcalm St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6009716.79458 | 2099617.55194 | 37.7456982412969 | -122.40909900491998 | (37.7456982412969, -122.40909900492) | |||
| 166957 | 166957 | 225920 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 300 Montcalm St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009736.52173 | 2099618.93286 | 37.74570313810779 | -122.409030888471 | (37.7457031381078, -122.409030888471) | |||
| 128111 | 128111 | 39576 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 300 Montcalm St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | Permit Number 40993 | 6009738.16770437 | 2099629.76502916 | 37.7457329730731 | -122.409025961078 | (37.7457329730731, -122.409025961078) | ||
| 40965 | 40965 | 225919 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1683 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6009340.70254 | 2099660.4482299997 | 37.745794948977 | -122.410402509267 | (37.745794948977, -122.410402509267) | |||
| 185415 | 185415 | 246444 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 467 Duncan St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 6003499.43256 | 2099785.6606799997 | 37.7458095674622 | -122.430609709989 | (37.7458095674622, -122.430609709989) | |||
| 101741 | 101741 | 95562 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 467 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767356 | 6003496.0 | 2099787.0 | 37.7458130504625 | -122.430621674841 | (37.7458130504625, -122.430621674841) | |
| 64675 | 64675 | 225922 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 22 Franconia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009935.78986 | 2099989.5983599997 | 37.7467320650326 | -122.40836798561199 | (37.7467320650326, -122.408367985612) | |||
| 98661 | 98661 | 45152 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1619 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/2001 12:00:00 AM | Permit Number 44005 | 6009316.84366878 | 2099994.11121489 | 37.7467097764312 | -122.410508567135 | (37.7467097764312, -122.410508567135) | ||
| 114440 | 114440 | 67087 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 2x FRANCONIA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1992 12:00:00 AM | Permit Number 30488 | 6009949.0 | 2099997.0 | 37.74675312806 | -122.40832282803001 | (37.74675312806, -122.40832282803) | ||
| 129299 | 129299 | 108168 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 2x FRANCONIA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6009949.0 | 2099997.0 | 37.74675312806 | -122.40832282803001 | (37.74675312806, -122.40832282803) | ||||
| 29070 | 29070 | 225918 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1619 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009320.793740001 | 2100001.018 | 37.746728962386705 | -122.41049539576001 | (37.7467289623867, -122.41049539576) | |||
| 92381 | 92381 | 108167 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 2x FRANCONIA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6009908.0 | 2100009.0 | 37.7467837814289 | -122.40846544893999 | (37.7467837814289, -122.40846544894) | ||||
| 127899 | 127899 | 36001 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 172 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | Permit Number 39150 | 6007547.55752373 | 2100224.75713647 | 37.7472437298861 | -122.41664293336001 | (37.7472437298861, -122.41664293336) | ||
| 90348 | 90348 | 36002 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 183 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | Permit Number 39151 | 6007567.43623945 | 2100291.02417946 | 37.747426802297 | -122.416578887563 | (37.747426802297, -122.416578887563) | ||
| 158445 | 158445 | 225966 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 183 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6007593.94414 | 2100298.1781200003 | 37.7474479361811 | -122.416487731444 | (37.7474479361811, -122.416487731444) | |||
| 178517 | 178517 | 225923 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1523 Florida St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6009609.76682 | 2100372.8440799997 | 37.7477661109153 | -122.409522389545 | (37.7477661109153, -122.409522389545) | |||
| 93780 | 93780 | 48957 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1521 Florida St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2002 12:00:00 AM | Permit Number 46145 | 6009607.60540748 | 2100518.70293664 | 37.7481664860313 | -122.40954015648 | (37.7481664860313, -122.40954015648) | |||
| 100066 | 100066 | 48959 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1521 Florida St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2002 12:00:00 AM | Permit Number 46145 | 6009607.60540748 | 2100518.70293664 | 37.7481664860313 | -122.40954015648 | (37.7481664860313, -122.40954015648) | |||
| 127688 | 127688 | 48958 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1521 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2002 12:00:00 AM | Permit Number 46145 | 6009607.60540748 | 2100518.70293664 | 37.7481664860313 | -122.40954015648 | (37.7481664860313, -122.40954015648) | |||
| 21782 | 21782 | 10227 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 1404 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3x3 | 6005821.31625 | 2100751.5734599996 | 37.7485930087737 | -122.422649583919 | (37.7485930087737, -122.422649583919) | |||
| 28449 | 28449 | 113387 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 185 CASTENADA AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 5994493.0 | 2100782.0 | 37.7480309194949 | -122.461824674651 | (37.7480309194949, -122.461824674651) | ||||
| 83902 | 83902 | 113388 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 185 CASTENADA AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 5994493.0 | 2100782.0 | 37.7480309194949 | -122.461824674651 | (37.7480309194949, -122.461824674651) | ||||
| 95528 | 95528 | 113389 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 185 CASTENADA AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 5994493.0 | 2100782.0 | 37.7480309194949 | -122.461824674651 | (37.7480309194949, -122.461824674651) | ||||
| 175971 | 175971 | 225905 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 3620 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6006092.03845 | 2100850.85024 | 37.7488808700704 | -122.421720479039 | (37.7488808700704, -122.421720479039) | |||
| 119140 | 119140 | 46336 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 3458 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/13/2002 12:00:00 AM | Permit Number 44586 | 6006755.84747481 | 2100893.1278825 | 37.7490343653145 | -122.41942802130501 | (37.7490343653145, -122.419428021305) | ||
| 18333 | 18333 | 27660 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 1360 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3x3 | 6005798.597080001 | 2101052.0301599996 | 37.7494167122272 | -122.42274949589199 | (37.7494167122272, -122.422749495892) | |||
| 136709 | 136709 | 225933 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1256 Treat Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008673.75291 | 2101213.6434299997 | 37.7500222662216 | -122.41281852357001 | (37.7500222662216, -122.41281852357) | |||
| 13344 | 13344 | 187697 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1256 Treat Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6008667.10840058 | 2101226.16540452 | 37.7500562758063 | -122.41284238591601 | (37.7500562758063, -122.412842385916) | ||||
| 94408 | 94408 | 69223 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1256 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1994 12:00:00 AM | Permit Number 33275 | 6008667.10840058 | 2101226.16540452 | 37.7500562758063 | -122.41284238591601 | (37.7500562758063, -122.412842385916) | ||
| 66184 | 66184 | 225934 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1256 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008672.01096 | 2101240.80305 | 37.7500967426882 | -122.412826467282 | (37.7500967426882, -122.412826467282) | |||
| 13345 | 13345 | 69222 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1250 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/15/2001 12:00:00 AM | 3x3 | Permit Number 33274 | 6008665.27491562 | 2101259.70225891 | 37.750148257591896 | -122.412851097008 | (37.7501482575919, -122.412851097008) | |
| 131309 | 131309 | 225935 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1250 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/2001 12:00:00 AM | 10 | Width 3ft | Permit Number 33274 | 6008670.4768900005 | 2101262.07632 | 37.7501550682215 | -122.412833276033 | (37.7501550682215, -122.412833276033) | |
| 116534 | 116534 | 69220 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1244 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1994 12:00:00 AM | 3x3 | Permit Number 33272 | 6008663.44143065 | 2101293.23911329 | 37.7502402393754 | -122.412859808121 | (37.7502402393754, -122.412859808121) | |
| 75984 | 75984 | 225936 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1232 Treat Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008666.40255 | 2101335.6889400003 | 37.7503569633096 | -122.412852569207 | (37.7503569633096, -122.412852569207) | |||
| 137432 | 137432 | 225937 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1232 Treat Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008665.07635 | 2101351.07554 | 37.7503991370286 | -122.412858243028 | (37.7503991370286, -122.412858243028) | |||
| 95785 | 95785 | 69219 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1232 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1994 12:00:00 AM | Permit Number 33271 | 6008659.77445957 | 2101360.31284296 | 37.7504242029934 | -122.412877230419 | (37.7504242029934, -122.412877230419) | ||
| 36558 | 36558 | 225906 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 3749 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6005541.4535 | 2101364.78602 | 37.750260956187404 | -122.423660939909 | (37.7502609561874, -122.423660939909) | |||
| 154308 | 154308 | 225938 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1232 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008664.0646 | 2101365.80196 | 37.7504395156908 | -122.41286278279101 | (37.7504395156908, -122.412862782791) | |||
| 181307 | 181307 | 225907 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 3749 25th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6005583.06138 | 2101365.98068 | 37.7502665850353 | -122.42351714192499 | (37.7502665850353, -122.423517141925) | |||
| 144912 | 144912 | 93025 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 3772 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6005372.0 | 2101391.0 | 37.7503233669919 | -122.424248785816 | (37.7503233669919, -122.424248785816) | |||||
| 39266 | 39266 | 225908 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 3772 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6005343.316000001 | 2101393.98229 | 37.7503299359862 | -122.424348189214 | (37.7503299359862, -122.424348189214) | |||
| 139759 | 139759 | 69160 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 3272 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1994 12:00:00 AM | Permit Number 33197 | 6007895.60997349 | 2101540.97783702 | 37.750877345046604 | -122.415532563624 | (37.7508773450466, -122.415532563624) | ||
| 260 | 260 | 221893 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 3164 25th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008601.79804 | 2101572.78068 | 37.751004337584796 | -122.41309273944599 | (37.7510043375848, -122.413092739446) | |||
| 256 | 256 | 221894 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 3164 25th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008618.9330400005 | 2101573.97925 | 37.75100859049479 | -122.41303356944799 | (37.7510085904948, -122.413033569448) | |||
| 140451 | 140451 | 75710 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1190 Treat Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1993 12:00:00 AM | 12 | 18x3 | 6008645.48606603 | 2101619.0486747 | 37.7511338315754 | -122.412944932355 | (37.7511338315754, -122.412944932355) | ||
| 129969 | 129969 | 225951 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 4401 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6000607.24532 | 2101675.7007299997 | 37.750834892731596 | -122.440746005644 | (37.7508348927316, -122.440746005644) | |||
| 21827 | 21827 | 26513 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 2864 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 6008948.96043 | 2101783.0813599997 | 37.7516012590109 | -122.41190707235701 | (37.7516012590109, -122.411907072357) | |||
| 181544 | 181544 | 225967 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 3599 24th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005877.128169999 | 2101963.64024 | 37.7519242145407 | -122.42254270219601 | (37.7519242145407, -122.422542702196) | |||
| 33404 | 33404 | 225968 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 3599 24th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6005865.3441 | 2101966.56287 | 37.751931574603894 | -122.422583660903 | (37.7519315746039, -122.422583660903) | |||
| 95415 | 95415 | 34747 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 2747 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38395 | 6008968.42681544 | 2102467.18370323 | 37.7534807427404 | -122.41188809190201 | (37.7534807427404, -122.411888091902) | ||
| 19723 | 19723 | 26529 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 2747 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3x3 | 6008970.13177 | 2102467.22828 | 37.75348096079001 | -122.41188219893101 | (37.75348096079, -122.411882198931) | |||
| 169108 | 169108 | 225946 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 3557 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6005893.76776 | 2102550.85426 | 37.7535375074585 | -122.422526882211 | (37.7535375074585, -122.422526882211) | |||
| 80611 | 80611 | 117516 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1115 YORK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6010054.0 | 2102576.0 | 37.753840371529705 | -122.40814160377899 | (37.7538403715297, -122.408141603779) | |||
| 27127 | 27127 | 225952 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 800 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6001178.257669999 | 2102625.59939 | 37.753475588250396 | -122.438839459988 | (37.7534755882504, -122.438839459988) | |||
| 73383 | 73383 | 225950 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 646 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6001193.5542 | 2102647.97152 | 37.7535378869843 | -122.438788164466 | (37.7535378869843, -122.438788164466) | |||
| 89137 | 89137 | 95571 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 960 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767362 | 6003109.0 | 2102648.0 | 37.753646751876296 | -122.43216414381901 | (37.7536467518763, -122.432164143819) | |
| 121618 | 121618 | 95169 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 195x BARTLETT ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 54079 | 6006751.0 | 2102668.0 | 37.7539074858503 | -122.41957069165701 | (37.7539074858503, -122.419570691657) | |||
| 178781 | 178781 | 225940 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 183 Bartlett St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6006723.95695 | 2102704.663 | 37.7540066307184 | -122.419666814188 | (37.7540066307184, -122.419666814188) | |||
| 20351 | 20351 | 10165 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 1019 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x4 | 6005763.39401 | 2102897.6669099997 | 37.7544824188306 | -122.423002391551 | (37.7544824188306, -122.423002391551) | |||
| 134868 | 134868 | 225912 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1048 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 6005698.159659999 | 2102902.03106 | 37.7544907204839 | -122.423228299447 | (37.7544907204839, -122.423228299447) | |||
| 81265 | 81265 | 10174 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 1038 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 2x2 | 6005692.3267338 | 2102916.9952861997 | 37.7545314795937 | -122.423249534916 | (37.7545314795937, -122.423249534916) | |||
| 31692 | 31692 | 219005 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1838 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5992852.04405 | 2102933.06242 | 37.7538425808737 | -122.467655401194 | (37.7538425808737, -122.467655401194) | |||
| 3164 | 3164 | 10171 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1032 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/23/2017 12:00:00 AM | 3 | 2x3 | Permit Number 779560 | 6005695.79144 | 2102951.17521 | 37.7546255252659 | -122.423239982539 | (37.7546255252659, -122.423239982539) | |
| 117714 | 117714 | 60139 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1825 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/28/1982 12:00:00 AM | Permit Number 19669 | 5991215.553912099 | 2102985.82371421 | 37.753892825076704 | -122.473318554461 | (37.7538928250767, -122.473318554461) | ||
| 76270 | 76270 | 67546 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1139 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/1992 12:00:00 AM | 19 | Permit Number 31092 | 6011964.43282 | 2103102.09088 | 37.755391686497205 | -122.40157181880501 | (37.7553916864972, -122.401571818805) | |
| 83663 | 83663 | 60140 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1807 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/28/1982 12:00:00 AM | Permit Number 19670 | 5991211.56683637 | 2103102.96288703 | 37.7542142276367 | -122.473340885597 | (37.7542142276367, -122.473340885597) | ||
| 159645 | 159645 | 225939 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1037 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6009456.84269 | 2103117.56685 | 37.75529393828 | -122.410244954342 | (37.75529393828, -122.410244954342) | |||
| 113830 | 113830 | 66548 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 3444 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/10/1991 12:00:00 AM | Permit Number 29730 | 6005443.81991983 | 2103160.76453772 | 37.755186785440294 | -122.42412627289801 | (37.7551867854403, -122.424126272898) | ||
| 147961 | 147961 | 67495 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1126 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/1992 12:00:00 AM | 18 | Permit Number 31020 | 6011901.71261 | 2103178.79248 | 37.755598792278796 | -122.40179411682301 | (37.7555987922788, -122.401794116823) | |
| 134421 | 134421 | 225909 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 99 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6005410.68329 | 2103188.80406 | 37.755261904439394 | -122.424242863321 | (37.7552619044394, -122.424242863321) | |||
| 44681 | 44681 | 225910 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 99 Fair Oaks St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6005408.28506 | 2103204.3544 | 37.7553044666341 | -122.42425226303101 | (37.7553044666341, -122.424252263031) | |||
| 150628 | 150628 | 67548 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1120 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/1992 12:00:00 AM | 16 | Permit Number 31094 | 6011900.0943 | 2103205.59495 | 37.755672295661505 | -122.401801597389 | (37.7556722956615, -122.401801597389) | |
| 19086 | 19086 | 10155 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 988 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2x2 | 6005676.86794 | 2103220.79798 | 37.7553647787894 | -122.423324590769 | (37.7553647787894, -122.423324590769) | |||
| 19073 | 19073 | 10152 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 981 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005742.33218 | 2103287.1896599997 | 37.7555507693625 | -122.42310291418801 | (37.7555507693625, -122.423102914188) | |||
| 114949 | 114949 | 60696 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 2839 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/05/1983 12:00:00 AM | Permit Number 20342 | 6009224.45070504 | 2103317.03242809 | 37.7558285965659 | -122.411062726793 | (37.7558285965659, -122.411062726793) | ||
| 95370 | 95370 | 72237 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 365 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/09/2009 12:00:00 AM | 3x3 | Permit Number 53060 | 6003968.6918684 | 2103317.11324706 | 37.7555326838578 | -122.429238846799 | (37.7555326838578, -122.429238846799) | ||
| 29808 | 29808 | 225970 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2846 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6009214.745180001 | 2103362.9385 | 37.7559541000213 | -122.411099534231 | (37.7559541000213, -122.411099534231) | |||
| 104406 | 104406 | 95583 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 320 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767373 | 6004245.0 | 2103375.0 | 37.7557072655698 | -122.428287412943 | (37.7557072655698, -122.428287412943) | |
| 153095 | 153095 | 219000 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1775 11th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 29 | Width 3ft | 5992776.7043 | 2103406.16926 | 37.7551372592989 | -122.467950350926 | (37.7551372592989, -122.467950350926) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");