Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH
| Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 56688 | 56688 | 122010 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1342 Cabrillo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5991362.52356 | 2110673.50037 | 37.775009640229605 | -122.473370979732 | (37.7750096402296, -122.473370979732) | |||
| 136845 | 136845 | 124750 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 566 Linden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6004650.035 | 2110687.35997 | 37.775808163060205 | -122.42740756863 | (37.7758081630602, -122.42740756863) | |||
| 152034 | 152034 | 124751 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 566 Linden St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004689.62752 | 2110692.77739 | 37.775825277144705 | -122.427270993988 | (37.7758252771447, -122.427270993988) | |||
| 65145 | 65145 | 124758 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1513 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006956.23003 | 2117363.82528 | 37.79427026621129 | -122.419903713582 | (37.7942702662113, -122.419903713582) | |||
| 34990 | 34990 | 124760 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1055 Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007817.3795 | 2119902.3991900003 | 37.8012890341312 | -122.417103992782 | (37.8012890341312, -122.417103992782) | |||
| 74967 | 74967 | 124761 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1055 Greenwich St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007856.93229 | 2119906.6476 | 37.8013029241584 | -122.41696742351101 | (37.8013029241584, -122.416967423511) | |||
| 185661 | 185661 | 124762 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1055 Greenwich St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007906.12641 | 2119914.20021 | 37.8013264288216 | -122.416797725058 | (37.8013264288216, -122.416797725058) | |||
| 148974 | 148974 | 174958 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 60 Onondaga Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6000890.31977 | 2091107.65045 | 37.7218336102096 | -122.439009814053 | (37.7218336102096, -122.439009814053) | |||
| 34582 | 34582 | 174966 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 44 Hamilton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6009006.884330001 | 2093841.0199900002 | 37.729797343475596 | -122.411145814235 | (37.7297973434756, -122.411145814235) | |||
| 130794 | 130794 | 188513 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 55 Mississippi St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6013999.87449 | 2106891.97216 | 37.7659112417232 | -122.39479799565399 | (37.7659112417232, -122.394797995654) | |||
| 23746 | 23746 | 188514 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1 Mississippi St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6013990.927619999 | 2106981.7626099996 | 37.7661572890446 | -122.394835230264 | (37.7661572890446, -122.394835230264) | |||
| 136032 | 136032 | 188517 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2000 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6012457.67401 | 2102853.6351799998 | 37.7547369917341 | -122.399848584652 | (37.7547369917341, -122.399848584652) | |||
| 45041 | 45041 | 188518 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 805 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6011322.68807 | 2104548.86682 | 37.75932838242 | -122.403892982475 | (37.75932838242, -122.403892982475) | |||
| 68064 | 68064 | 188520 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 495 Connecticut St | 2 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6013272.40757 | 2104812.59187 | 37.7601612472551 | -122.397168349564 | (37.7601612472551, -122.397168349564) | |||
| 69010 | 69010 | 188521 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 495 Connecticut St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6013271.447919999 | 2104826.1277799997 | 37.7601983604744 | -122.397172617724 | (37.7601983604744, -122.397172617724) | |||
| 187683 | 187683 | 188523 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 65 Whitney Young Cir | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6017281.36531 | 2094970.41702 | 37.733359012210606 | -122.382618269437 | (37.7333590122106, -122.382618269437) | |||
| 178617 | 178617 | 188524 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 65 Whitney Young Cir | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6017319.36932 | 2094988.95682 | 37.7334120182438 | -122.38248816719299 | (37.7334120182438, -122.382488167193) | |||
| 179662 | 179662 | 203222 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 120 Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5993081.79545 | 2099194.6713799997 | 37.7435911783029 | -122.466589164064 | (37.7435911783029, -122.466589164064) | |||
| 27343 | 27343 | 203223 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 25 Upland Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5994463.96401 | 2093754.2883099997 | 37.7287328942013 | -122.461415680898 | (37.7287328942013, -122.461415680898) | |||
| 133071 | 133071 | 203620 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 358 Pacheco St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5994207.97815 | 2101247.70705 | 37.7492932209146 | -122.46284404261101 | (37.7492932209146, -122.462844042611) | |||
| 151042 | 151042 | 203622 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 15 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5997339.998380001 | 2099579.33016 | 37.7448921672303 | -122.45189316446002 | (37.7448921672303, -122.45189316446) | |||
| 93809 | 93809 | 203623 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 15 Teresita Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5997330.81089 | 2099592.0734900003 | 37.744926631064 | -122.45192585212 | (37.744926631064, -122.45192585212) | |||
| 43667 | 43667 | 203624 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 15 Teresita Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5997319.6106 | 2099609.0427 | 37.7449725828299 | -122.45196580449199 | (37.7449725828299, -122.451965804492) | |||
| 59298 | 59298 | 203625 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 15 Teresita Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5997311.4729 | 2099621.76413 | 37.7450070466421 | -122.45199486067499 | (37.7450070466421, -122.451994860675) | |||
| 173115 | 173115 | 203638 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 750 Grafton Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5994537.11563 | 2090599.0913099998 | 37.720073694513104 | -122.46093420637101 | (37.7200736945131, -122.460934206371) | |||
| 165659 | 165659 | 203641 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 608 Garfield St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 5992400.09934 | 2090515.7050700001 | 37.7197215370907 | -122.468315017932 | (37.7197215370907, -122.468315017932) | |||
| 169675 | 169675 | 203643 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2479 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5991370.41192 | 2098543.97685 | 37.7417056300124 | -122.47245922253201 | (37.7417056300124, -122.472459222532) | |||
| 152749 | 152749 | 203644 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2450 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5991098.76282 | 2098712.81343 | 37.742153485208796 | -122.47341079698799 | (37.7421534852088, -122.473410796988) | |||
| 32938 | 32938 | 203645 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2450 17th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5991098.28096 | 2098726.3101 | 37.7421905156936 | -122.473413447294 | (37.7421905156936, -122.473413447294) | |||
| 62900 | 62900 | 203646 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 45 Dorantes Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5994072.18954 | 2100047.28757 | 37.745989350944 | -122.463226505408 | (37.745989350944, -122.463226505408) | |||
| 149197 | 149197 | 203647 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 70 Manor Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 5993596.72892 | 2093377.0999599998 | 37.7276472749004 | -122.46438636913099 | (37.7276472749004, -122.464386369131) | |||
| 62851 | 62851 | 203648 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1907 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5993437.25696 | 2102479.71785 | 37.7526315852957 | -122.46559868313 | (37.7526315852957, -122.46559868313) | |||
| 178200 | 178200 | 203649 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1390 Monterey Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 5993852.26622 | 2094804.8663700002 | 37.731582298063394 | -122.46360655802201 | (37.7315822980634, -122.463606558022) | |||
| 157925 | 157925 | 203650 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1390 Monterey Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 3ft | 5993848.38247 | 2094813.0241599998 | 37.7316044735649 | -122.46362057664699 | (37.7316044735649, -122.463620576647) | |||
| 151268 | 151268 | 203651 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1390 Monterey Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 5993846.97887 | 2094818.6059299998 | 37.731619718855704 | -122.46362583408701 | (37.7316197188557, -122.463625834087) | |||
| 154734 | 154734 | 203652 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 400x Marietta Dr | 38 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 3ft | 5999131.48243 | 2096996.51385 | 37.737902818863795 | -122.445512879233 | (37.7379028188638, -122.445512879233) | |||
| 132310 | 132310 | 203658 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 531 Foerster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5998103.1876300005 | 2095162.16833 | 37.732807386054795 | -122.448936084745 | (37.7328073860548, -122.448936084745) | |||
| 166210 | 166210 | 203659 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 628 Edna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5998583.28764 | 2094893.18321 | 37.7320962615306 | -122.44725691200199 | (37.7320962615306, -122.447256912002) | |||
| 179419 | 179419 | 203660 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 634 Edna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5998582.52704 | 2094910.5588200002 | 37.732143927389295 | -122.44726079165399 | (37.7321439273893, -122.447260791654) | |||
| 2852 | 2852 | 215287 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 335 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | Permit Number 780412 | 5992944.71929 | 2103190.50616 | 37.7545548052666 | -122.46735363008301 | (37.7545548052666, -122.467353630083) | ||
| 170961 | 170961 | 219988 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 936 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5998797.49873 | 2106712.69483 | 37.7645619996538 | -122.447366750686 | (37.7645619996538, -122.447366750686) | |||
| 53649 | 53649 | 219989 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 936 Clayton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5998793.85425 | 2106724.38466 | 37.7645938887298 | -122.447380197361 | (37.7645938887298, -122.447380197361) | |||
| 185230 | 185230 | 219990 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 151 Delmar St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5999384.54447 | 2107324.60583 | 37.766275682101 | -122.445380326357 | (37.766275682101, -122.445380326357) | |||
| 161989 | 161989 | 219992 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 101 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007124.70017 | 2098812.5831299997 | 37.7433424258272 | -122.41800505138501 | (37.7433424258272, -122.418005051385) | |||
| 67828 | 67828 | 219994 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 49 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007506.429690001 | 2099145.6461 | 37.7442784195283 | -122.41670871553801 | (37.7442784195283, -122.416708715538) | |||
| 135734 | 135734 | 219995 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1426 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007991.10477 | 2099694.15634 | 37.745811754609896 | -122.415071624753 | (37.7458117546099, -122.415071624753) | |||
| 152367 | 152367 | 219998 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 60 Santa Marina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6005981.24616 | 2097649.7003900004 | 37.7400849896219 | -122.421876240696 | (37.7400849896219, -122.421876240696) | |||
| 47962 | 47962 | 219999 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 62 Santa Marina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6005999.49716 | 2097639.92479 | 37.740059177277004 | -122.421812441905 | (37.740059177277, -122.421812441905) | |||
| 162065 | 162065 | 220000 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 62 Santa Marina St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006013.90538 | 2097631.08265 | 37.7400357112669 | -122.421761996217 | (37.7400357112669, -122.421761996217) | |||
| 33112 | 33112 | 220001 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 88 Santa Marina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006158.19776 | 2097552.9133 | 37.7398292116563 | -122.4212575422 | (37.7398292116563, -122.4212575422) | |||
| 185361 | 185361 | 220004 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1142 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008637.13035 | 2101883.29537 | 37.751858924657796 | -122.412992509104 | (37.7518589246578, -122.412992509104) | |||
| 186338 | 186338 | 220005 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2080 Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008062.79185 | 2106290.9953 | 37.7639292034025 | -122.415290650144 | (37.7639292034025, -122.415290650144) | |||
| 185029 | 185029 | 220006 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 887 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6007588.24314 | 2104555.6978700003 | 37.75913779629921 | -122.41680902861602 | (37.7591377962992, -122.416809028616) | |||
| 117 | 117 | 220007 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 929 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/12/2015 03:22:00 PM | 1 | Width 3ft | Permit Number 24134 | 6006336.25046 | 2104153.4311599997 | 37.7579627654961 | -122.421110461684 | (37.7579627654961, -122.421110461684) | |
| 72259 | 72259 | 220008 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3447 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006809.37202 | 2101432.95646 | 37.7505196263839 | -122.419281221778 | (37.7505196263839, -122.419281221778) | |||
| 167885 | 167885 | 220009 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3447 25th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006820.56616 | 2101433.2332200003 | 37.750521016743896 | -122.419242531131 | (37.7505210167439, -122.419242531131) | |||
| 72341 | 72341 | 220010 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3561 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6006555.55006 | 2104341.3837900003 | 37.758491199927 | -122.420365369767 | (37.758491199927, -122.420365369767) | |||
| 58771 | 58771 | 220011 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 110 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006153.26604 | 2102345.16587 | 37.7529873705964 | -122.421614871629 | (37.7529873705964, -122.421614871629) | |||
| 158356 | 158356 | 220012 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 30 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006012.224219999 | 2102309.19405 | 37.7528806462302 | -122.42210006667601 | (37.7528806462302, -122.422100066676) | |||
| 155839 | 155839 | 220013 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 58 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6005865.660759999 | 2102301.94093 | 37.7528524632741 | -122.42260639578998 | (37.7528524632741, -122.42260639579) | |||
| 53977 | 53977 | 220014 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 60 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6005833.61465 | 2102298.65201 | 37.7528416246662 | -122.422716983617 | (37.7528416246662, -122.422716983617) | |||
| 67963 | 67963 | 220015 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 70 Quartz Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5998973.5201 | 2099794.49518 | 37.745576384946 | -122.44626024553601 | (37.745576384946, -122.446260245536) | |||
| 47237 | 47237 | 220016 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 70 Quartz Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5998965.77386 | 2099787.09557 | 37.74555562500829 | -122.44628649854201 | (37.7455556250083, -122.446286498542) | |||
| 185200 | 185200 | 220017 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 78 Berkeley Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6001185.230140001 | 2097348.08527 | 37.7389851844145 | -122.438437264296 | (37.7389851844145, -122.438437264296) | |||
| 172135 | 172135 | 220019 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 4326 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001759.60763 | 2100322.6693 | 37.747185348536895 | -122.436664198694 | (37.7471853485369, -122.436664198694) | |||
| 173012 | 173012 | 220020 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1334 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6001963.20475 | 2100104.97494 | 37.7465991794258 | -122.435944602583 | (37.7465991794258, -122.435944602583) | |||
| 33357 | 33357 | 220021 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1334 Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001964.613530001 | 2100084.23013 | 37.7465422991033 | -122.435938247064 | (37.7465422991033, -122.435938247064) | |||
| 188982 | 188982 | 220022 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1334 Diamond St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001965.3710900005 | 2100066.86744 | 37.746494668288996 | -122.435934385359 | (37.746494668289, -122.435934385359) | |||
| 162456 | 162456 | 220024 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 4273 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6002125.33793 | 2101175.24323 | 37.749547092337 | -122.435460513693 | (37.749547092337, -122.435460513693) | |||
| 38287 | 38287 | 220026 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 685 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6001902.38031 | 2102621.8344 | 37.753506421492 | -122.436335023459 | (37.753506421492, -122.436335023459) | |||
| 130349 | 130349 | 220027 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 685 Alvarado St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001922.66093 | 2102622.7782400004 | 37.7535101653675 | -122.43626495635701 | (37.7535101653675, -122.436264956357) | |||
| 129705 | 129705 | 220028 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 685 Alvarado St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001938.58535 | 2102624.90259 | 37.7535169030985 | -122.436210038379 | (37.7535169030985, -122.436210038379) | |||
| 188075 | 188075 | 220035 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1711 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6002636.34581 | 2100467.82106 | 37.7476336866458 | -122.433642882219 | (37.7476336866458, -122.433642882219) | |||
| 49170 | 49170 | 220036 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1711 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6002636.29383 | 2100481.40221 | 37.747670974341396 | -122.43364403244 | (37.7476709743414, -122.43364403244) | |||
| 53663 | 53663 | 220045 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 160 Marview Way | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5998323.68704 | 2103258.27383 | 37.755049936933 | -122.448756699664 | (37.755049936933, -122.448756699664) | |||
| 76199 | 76199 | 220046 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 170 Saint Germain Ave | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5997546.7288 | 2104141.22433 | 37.7574298380281 | -122.451507313917 | (37.7574298380281, -122.451507313917) | |||
| 58064 | 58064 | 220047 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1201 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5997716.00381 | 2106428.96316 | 37.7637210849721 | -122.451086869165 | (37.7637210849721, -122.451086869165) | |||
| 129876 | 129876 | 220050 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 301 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006755.518130001 | 2098027.45978 | 37.741165867704 | -122.41922590896799 | (37.741165867704, -122.419225908968) | |||
| 135277 | 135277 | 220051 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 501 Eugenia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006788.71567 | 2098008.71009 | 37.741116254798605 | -122.419109793907 | (37.7411162547986, -122.419109793907) | |||
| 53857 | 53857 | 220052 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 50 Coleridge St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006851.995619999 | 2099403.94647 | 37.7449508246175 | -122.418989930439 | (37.7449508246175, -122.418989930439) | |||
| 50333 | 50333 | 220053 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 50 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006880.915569999 | 2099461.25928 | 37.7451098211639 | -122.418893994368 | (37.7451098211639, -122.418893994368) | |||
| 30672 | 30672 | 220054 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 300 Virginia Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 6006920.61613 | 2098340.82095 | 37.742035584087795 | -122.418677274846 | (37.7420355840878, -122.418677274846) | |||
| 171522 | 171522 | 220055 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 32 Elsie St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007497.36019 | 2099175.1634299997 | 37.7443589574154 | -122.416742166726 | (37.7443589574154, -122.416742166726) | |||
| 47068 | 47068 | 220057 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 938 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007984.69118 | 2102236.05472 | 37.752790875909 | -122.41527371052099 | (37.752790875909, -122.415273710521) | |||
| 48670 | 48670 | 220058 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 564 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6007852.78726 | 2104670.9495900003 | 37.7594691272161 | -122.415902267384 | (37.7594691272161, -122.415902267384) | |||
| 176834 | 176834 | 220059 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3505 24th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006111.03304 | 2101975.99077 | 37.75197131922489 | -122.42173470182101 | (37.7519713192249, -122.421734701821) | |||
| 147911 | 147911 | 220060 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3505 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006048.59787 | 2101976.73727 | 37.751969847944295 | -122.42195066499599 | (37.7519698479443, -122.421950664996) | |||
| 175760 | 175760 | 220061 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 496 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006778.4719 | 2100919.5429 | 37.749108169217294 | -122.41935165935101 | (37.7491081692173, -122.419351659351) | |||
| 31819 | 31819 | 220062 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 430 College Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 6005376.5701 | 2095055.5296099999 | 37.7329278583224 | -122.423782556133 | (37.7329278583224, -122.423782556133) | |||
| 63361 | 63361 | 220063 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 930 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003095.90411 | 2102839.48353 | 37.75417177772871 | -122.432223106309 | (37.7541717777287, -122.432223106309) | |||
| 42523 | 42523 | 220064 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 4086 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6002590.76073 | 2102413.7777400003 | 37.7529742368948 | -122.43393958746701 | (37.7529742368948, -122.433939587467) | |||
| 53450 | 53450 | 220065 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 561 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6002722.15364 | 2102085.17478 | 37.7520794267235 | -122.43346172547501 | (37.7520794267235, -122.433461725475) | |||
| 44341 | 44341 | 220066 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1109 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002537.114630001 | 2102291.1496200003 | 37.7526344847082 | -122.434116340213 | (37.7526344847082, -122.434116340213) | |||
| 47075 | 47075 | 220067 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3781 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003185.70208 | 2103572.60316 | 37.756189841101296 | -122.431964909158 | (37.7561898411013, -122.431964909158) | |||
| 68889 | 68889 | 220068 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3749 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6003417.1638 | 2103582.09113 | 37.756229011985 | -122.43116511330601 | (37.756229011985, -122.431165113306) | |||
| 59933 | 59933 | 220069 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1047 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6003827.33604 | 2102174.6628400004 | 37.7523877808826 | -122.42964622220501 | (37.7523877808826, -122.429646222205) | |||
| 75192 | 75192 | 220070 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 410 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003569.73703 | 2105814.1279 | 37.762366296795996 | -122.43079674288 | (37.762366296796, -122.43079674288) | |||
| 153239 | 153239 | 220071 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3854 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003950.57262 | 2104825.46317 | 37.7596732292507 | -122.429409067394 | (37.7596732292507, -122.429409067394) | |||
| 162807 | 162807 | 220072 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 60 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6002632.838880001 | 2105513.14285 | 37.7614867382526 | -122.434015605341 | (37.7614867382526, -122.434015605341) | |||
| 45254 | 45254 | 220074 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 148 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6002660.22221 | 2105037.36162 | 37.7601819118789 | -122.43388688897 | (37.7601819118789, -122.43388688897) |
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");