Data source: data.sfgov.org
This data as json, CSV (advanced)
These facets timed out: qSiteInfo
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 45531 | 45531 | 220666 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1 Dorland St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6005487.19676 | 2105743.72088 | 37.7622814268651 | -122.42415994852199 | (37.7622814268651, -122.424159948522) | |||
| 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) | |||
| 43560 | 43560 | 67530 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/22/1992 12:00:00 AM | 12 | Permit Number 31068 | 6013998.45944 | 2106956.61768 | 37.766088665392296 | -122.394807417822 | (37.7660886653923, -122.394807417822) | |
| 108504 | 108504 | 85500 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1 Nebraska St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009335.0 | 2098038.0 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | |||||
| 118346 | 118346 | 85501 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1 Nebraska St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009335.0 | 2098038.0 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | |||||
| 88925 | 88925 | 50661 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1 Santa Ynez Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47244 | 6000978.87890111 | 2091807.60057831 | 37.723760552916296 | -122.43875382021002 | (37.7237605529163, -122.43875382021) | ||||
| 125783 | 125783 | 50663 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1 Santa Ynez Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47244 | 6000978.87890111 | 2091807.60057831 | 37.723760552916296 | -122.43875382021002 | (37.7237605529163, -122.43875382021) | ||||
| 140001 | 140001 | 50664 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1 Santa Ynez Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47244 | 6000978.87890111 | 2091807.60057831 | 37.723760552916296 | -122.43875382021002 | (37.7237605529163, -122.43875382021) | ||||
| 145318 | 145318 | 50662 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1 Santa Ynez Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47244 | 6000978.87890111 | 2091807.60057831 | 37.723760552916296 | -122.43875382021002 | (37.7237605529163, -122.43875382021) | ||||
| 151048 | 151048 | 220044 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 10 Arbor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6002160.56118 | 2096968.3315700002 | 37.7379978987733 | -122.43503787010201 | (37.7379978987733, -122.435037870102) | |||
| 34993 | 34993 | 188525 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 10 Bell Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 6016572.5482 | 2095212.67149 | 37.7339850114017 | -122.38508574382799 | (37.7339850114017, -122.385085743828) | |||
| 41095 | 41095 | 220673 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 100 Alemany Blvd | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6009345.21028 | 2095878.12902 | 37.735409776738294 | -122.410119940478 | (37.7354097767383, -122.410119940478) | |||
| 156715 | 156715 | 220671 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 100 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6009657.24605 | 2096276.1729599999 | 37.7365202047272 | -122.409069188799 | (37.7365202047272, -122.409069188799) | |||
| 75622 | 75622 | 203667 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 100 Judson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5999360.3584 | 2093511.22392 | 37.7283460957947 | -122.444471133337 | (37.7283460957947, -122.444471133337) | |||
| 83688 | 83688 | 42111 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 100 Judson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42411 | 5999403.96940848 | 2093509.81726433 | 37.7283447217324 | -122.444320267584 | (37.7283447217324, -122.444320267584) | ||
| 7439 | 7439 | 19729 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 100 STAIRWAY14 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 40ST | ||||||||
| 10291 | 10291 | 19793 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 100 STAIRWAY19 | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 20ST | ||||||||
| 8932 | 8932 | 19577 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 100 STAIRWAY3 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 15ST | ||||||||
| 1434 | 1434 | 20063 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 100 STAIRWAY54 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 15ST | ||||||||
| 3716 | 3716 | 20054 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 100 STAIRWAY54 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 15ST | ||||||||
| 6851 | 6851 | 20056 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 100 STAIRWAY54 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 15ST | ||||||||
| 7770 | 7770 | 20060 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 100 STAIRWAY54 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 15ST | ||||||||
| 11185 | 11185 | 20057 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 100 STAIRWAY54 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 15ST | ||||||||
| 15210 | 15210 | 20061 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 100 STAIRWAY54 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 15ST | ||||||||
| 15394 | 15394 | 20062 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 100 STAIRWAY54 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 15ST | ||||||||
| 15903 | 15903 | 20055 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 100 STAIRWAY54 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 15ST | ||||||||
| 16172 | 16172 | 20064 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 100 STAIRWAY54 | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 15ST | ||||||||
| 16839 | 16839 | 20059 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 100 STAIRWAY54 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 15ST | ||||||||
| 108526 | 108526 | 67589 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1005 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/1992 12:00:00 AM | Permit Number 31156 | 6015546.93269222 | 2104381.58378925 | 37.7591041527051 | -122.38927168143199 | (37.7591041527051, -122.389271681432) | ||
| 90886 | 90886 | 42110 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 100@ Detroit Judson Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42411 | 5999403.96940848 | 2093509.81726433 | 37.7283447217324 | -122.444320267584 | (37.7283447217324, -122.444320267584) | ||
| 102717 | 102717 | 42112 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 100@ Detroit Judson Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42411 | 5999403.96940848 | 2093509.81726433 | 37.7283447217324 | -122.444320267584 | (37.7283447217324, -122.444320267584) | ||
| 74240 | 74240 | 141691 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 101 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5996753.535 | 2112367.4021 | 37.7799713474759 | -122.45484482437 | (37.7799713474759, -122.45484482437) | |||
| 135030 | 135030 | 75408 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 101 De Long St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 5 | 5994441.08765 | 2086786.6315099997 | 37.7096000577555 | -122.460989960739 | (37.7096000577555, -122.460989960739) | ||
| 149098 | 149098 | 75250 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 101 De Long St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 6 | 5994476.95751 | 2086787.3271700002 | 37.7096040318843 | -122.460866039547 | (37.7096040318843, -122.460866039547) | ||
| 176496 | 176496 | 75331 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 101 De Long St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 6 | 5994458.53323 | 2086786.7483599999 | 37.709601382461294 | -122.460929674682 | (37.7096013824613, -122.460929674682) | ||
| 25732 | 25732 | 220090 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 101 Ord Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6000882.83826 | 2105748.10477 | 37.7620324153945 | -122.44008496885401 | (37.7620324153945, -122.440084968854) | |||
| 58566 | 58566 | 220089 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 101 Ord Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6000884.7117 | 2105729.84303 | 37.7619823797984 | -122.44007717983101 | (37.7619823797984, -122.440077179831) | |||
| 89457 | 89457 | 113028 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 101 WINFIELD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 5x5 | 6007142.0 | 2098801.0 | 37.7433115947954 | -122.417944411944 | (37.7433115947954, -122.417944411944) | |||
| 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) | |||
| 86515 | 86515 | 48833 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1019 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/07/2002 12:00:00 AM | Permit Number 46053 | 6002516.40077061 | 2102618.9246623 | 37.7535333013465 | -122.43421140278099 | (37.7535333013465, -122.434211402781) | |||
| 51120 | 51120 | 66858 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 103 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/15/1991 12:00:00 AM | 9 | Permit Number 30164 | 5998644.5770000005 | 2110362.2819 | 37.774574098301294 | -122.448158471707 | (37.7745740983013, -122.448158471707) | ||
| 94760 | 94760 | 67088 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 104 Peralta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1992 12:00:00 AM | Permit Number 30490 | 6010217.49465897 | 2100245.63061 | 37.7474508447186 | -122.407411920985 | (37.7474508447186, -122.407411920985) | ||
| 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) | |||
| 53161 | 53161 | 67491 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1053 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/1992 12:00:00 AM | 11 | Permit Number 31016 | 6011662.712180001 | 2103457.28078 | 37.7563501191849 | -122.402640243074 | (37.7563501191849, -122.402640243074) | |
| 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) | |||
| 93774 | 93774 | 98707 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 105X Ord St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6000883.6 | 2105740.8 | 37.7620124016568 | -122.440081810476 | (37.7620124016568, -122.440081810476) | ||||
| 124870 | 124870 | 98708 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 105X Ord St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6000883.6 | 2105740.8 | 37.7620124016568 | -122.440081810476 | (37.7620124016568, -122.440081810476) | |||||
| 99531 | 99531 | 37020 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1061 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | Permit Number 39632 | 6008655.69574399 | 2102373.47059511 | 37.7532058777371 | -122.412962961361 | (37.7532058777371, -122.412962961361) | ||
| 110343 | 110343 | 67563 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1067 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/1992 12:00:00 AM | Permit Number 31115 | 6011664.16143038 | 2103412.99241656 | 37.7562285940169 | -122.40263211667299 | (37.7562285940169, -122.402632116673) | ||
| 161456 | 161456 | 78061 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 107 Cambridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/16/2000 12:00:00 AM | 8 | 6006671.077740001 | 2094291.78297 | 37.730903769473706 | -122.41925294078699 | (37.7309037694737, -122.419252940787) | ||
| 177746 | 177746 | 67583 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1081 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/1992 12:00:00 AM | 10 | Permit Number 31148 | 6011670.3331699995 | 2103332.09659 | 37.756006816477104 | -122.40260508405198 | (37.7560068164771, -122.402605084052) | |
| 110886 | 110886 | 62618 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 11 Brewster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/1988 12:00:00 AM | Permit Number 25075 | 6010492.04482679 | 2099848.37661279 | 37.7463754350507 | -122.40643455260201 | (37.7463754350507, -122.406434552602) | ||
| 1536 | 1536 | 251472 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 11 Hiliritas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780012 | 6001589.0 | 2096875.0 | 37.7377091611847 | -122.437007355935 | (37.7377091611847, -122.437007355935) | |
| 114454 | 114454 | 108678 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 11 Otsego Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773206 | 6000980.19802 | 2092997.8380200001 | 37.727028748485395 | -122.43883451276501 | (37.7270287484854, -122.438834512765) |
| 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) | |||
| 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) | |||
| 88872 | 88872 | 84017 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1109 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2008 12:00:00 AM | 3x3 | Permit Number 50426 | 6002531.06648038 | 2102355.71188239 | 37.7528114140683 | -122.43414187071899 | (37.7528114140683, -122.434141870719) | ||
| 130712 | 130712 | 67547 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1125 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/1992 12:00:00 AM | 9 | Permit Number 31093 | 6011962.71401 | 2103154.98207 | 37.75553681818771 | -122.40158148021798 | (37.7555368181877, -122.401581480218) | |
| 111062 | 111062 | 37754 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1138 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/01/1998 12:00:00 AM | Permit Number 40101 | 6008628.86236582 | 2101910.8796111 | 37.7519342006623 | -122.413023051242 | (37.7519342006623, -122.413023051242) | ||
| 162381 | 162381 | 40685 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 114 Ney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/1999 12:00:00 AM | 6 | Permit Number 41668 | 6004151.556609999 | 2094012.13266 | 37.7299936942445 | -122.42794342066001 | (37.7299936942445, -122.42794342066) | |
| 33499 | 33499 | 174962 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 114 Santa Ynez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6000450.3974 | 2092235.26707 | 37.724904747337106 | -122.440611347459 | (37.7249047473371, -122.440611347459) | |||
| 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) | |||
| 85747 | 85747 | 39220 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1143 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1999 12:00:00 AM | Permit Number 41443 | 6005801.05573922 | 2102320.92573379 | 37.752900946135604 | -122.422831161336 | (37.7529009461356, -122.422831161336) | ||
| 125085 | 125085 | 39221 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1143 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1999 12:00:00 AM | Permit Number 41443 | 6005801.05573922 | 2102320.92573379 | 37.752900946135604 | -122.422831161336 | (37.7529009461356, -122.422831161336) | ||
| 144860 | 144860 | 69216 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1144 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1994 12:00:00 AM | Permit Number 33267 | 6008630.78048604 | 2101877.2067938 | 37.751841850344704 | -122.41301403743401 | (37.7518418503447, -122.413014037434) | ||
| 90206 | 90206 | 51723 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1148 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/02/2005 12:00:00 AM | Permit Number 47992 | 6008632.05923166 | 2101854.75826991 | 37.7517802835227 | -122.41300802824699 | (37.7517802835227, -122.413008028247) | ||
| 26472 | 26472 | 220689 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 119 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004994.550369999 | 2099284.37518 | 37.744517739909 | -122.42540413451401 | (37.744517739909, -122.425404134514) | |||
| 68717 | 68717 | 203626 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 12 Juanita Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5997325.36011 | 2099393.7124400004 | 37.7443816679834 | -122.451930391889 | (37.7443816679834, -122.451930391889) | |||
| 112951 | 112951 | 65654 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 12 Juanita Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/2008 12:00:00 AM | 3x3 | Permit Number 51556 | 5997336.22410326 | 2099411.42392563 | 37.744430921643 | -122.451894104171 | (37.744430921643, -122.451894104171) | ||
| 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) | |||
| 64061 | 64061 | 32346 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1201 35th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37068 | 5985179.95256355 | 2107022.76154853 | 37.7646257968319 | -122.494488338591 | (37.7646257968319, -122.494488338591) | ||
| 78102 | 78102 | 32344 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1201 35th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37068 | 5985179.95256355 | 2107022.76154853 | 37.7646257968319 | -122.494488338591 | (37.7646257968319, -122.494488338591) | ||
| 107835 | 107835 | 32345 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1201 35th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37068 | 5985179.95256355 | 2107022.76154853 | 37.7646257968319 | -122.494488338591 | (37.7646257968319, -122.494488338591) | ||
| 135969 | 135969 | 32347 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1201 35th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 10 | Permit Number 37068 | 5985187.3443 | 2106976.3651 | 37.764498837803394 | -122.494459352499 | (37.7644988378034, -122.494459352499) | |
| 154995 | 154995 | 32348 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1201 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 9 | Permit Number 37068 | 5985188.5725 | 2106987.4184 | 37.764529258945 | -122.49445591941799 | (37.764529258945, -122.494455919418) | |
| 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) | |||
| 101299 | 101299 | 39622 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1201 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41021 | 5997705.33041065 | 2106460.2771729 | 37.7638064542355 | -122.451126043319 | (37.7638064542355, -122.451126043319) | ||
| 109830 | 109830 | 39623 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1201 Shrader St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41021 | 5997705.33041065 | 2106460.2771729 | 37.7638064542355 | -122.451126043319 | (37.7638064542355, -122.451126043319) | ||
| 2164 | 2164 | 10688 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 1221 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/18/1991 12:00:00 AM | 6 | 3X3 | 6002001.6656 | 2110480.73 | 37.7750906677438 | -122.43655414222 | (37.7750906677438, -122.43655414222) | ||
| 30832 | 30832 | 203666 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 123 Detroit St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5999405.93855 | 2093561.74161 | 37.728487406244604 | -122.44431719010001 | (37.7284874062446, -122.4443171901) | |||
| 41668 | 41668 | 203664 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 123 Detroit St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5999403.203369999 | 2093610.5277599997 | 37.7286212055976 | -122.444330150233 | (37.7286212055976, -122.444330150233) | |||
| 42347 | 42347 | 203665 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 123 Detroit St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5999403.44951 | 2093584.38933 | 37.728549449599704 | -122.444327421686 | (37.7285494495997, -122.444327421686) | |||
| 105423 | 105423 | 41830 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1232 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/2001 12:00:00 AM | Permit Number 42216 | 5991454.19182704 | 2107029.2184828 | 37.765008732916705 | -122.472788101582 | (37.7650087329167, -122.472788101582) | ||
| 5792 | 5792 | 10690 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1233 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6001959.267000001 | 2110474.8139 | 37.7750720141838 | -122.43670038449801 | (37.7750720141838, -122.436700384498) | |||
| 77854 | 77854 | 63851 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1233 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/16/1987 12:00:00 AM | Permit Number 24548 | 6001965.88884277 | 2110471.51360831 | 37.775063328726 | -122.43667724183999 | (37.775063328726, -122.43667724184) | ||
| 113556 | 113556 | 45337 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1239 17th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | Permit Number 44167 | 6013665.22038022 | 2106606.66789645 | 37.7651092465016 | -122.39593550872 | (37.7651092465016, -122.39593550872) | ||
| 125120 | 125120 | 68814 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 125 Brompton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/30/1993 12:00:00 AM | Permit Number 32757 | 6002131.57604717 | 2095277.55167817 | 37.7333537609923 | -122.435017196532 | (37.7333537609923, -122.435017196532) | ||
| 136405 | 136405 | 203653 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 125 Brompton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6002114.00252 | 2095255.92738 | 37.733293387768995 | -122.435076406948 | (37.733293387769, -122.435076406948) | |||
| 82846 | 82846 | 63850 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1259 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/16/1987 12:00:00 AM | Permit Number 24547 | 6001845.15733033 | 2110454.5773622 | 37.7750099641834 | -122.437093665021 | (37.7750099641834, -122.437093665021) | ||
| 371 | 371 | 8188 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1272 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/1997 12:00:00 AM | 10 | 3X4 | 6001679.2828 | 2111174.9406 | 37.7769784708042 | -122.437719062833 | (37.7769784708042, -122.437719062833) | ||
| 135271 | 135271 | 35351 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1274 De Haro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | 11 | 5x5 | Permit Number 38813 | 6012220.8536 | 2102461.75759 | 37.7536477760478 | -122.400640051912 | (37.7536477760478, -122.400640051912) |
| 40646 | 40646 | 219991 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 13 Bronte St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6009385.52811 | 2097403.7869700002 | 37.739601163374 | -122.41008822049601 | (37.739601163374, -122.410088220496) | |||
| 92747 | 92747 | 61034 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 130 Swiss Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/2011 12:00:00 AM | 3x5 | Permit Number 768338 | 6001256.29714973 | 2096400.69751215 | 37.736387920753295 | -122.43812370070101 | (37.7363879207533, -122.438123700701) | |
| 21207 | 21207 | 10209 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 1301 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/17/1994 12:00:00 AM | 12 | 3X3PL | 6005849.39823 | 2101351.62015 | 37.7502421837319 | -122.4225951102 | (37.7502421837319, -122.4225951102) | ||
| 102710 | 102710 | 43223 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1303 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/2004 12:00:00 AM | Permit Number 44301 | 6009289.62355935 | 2101563.81507978 | 37.7510183090213 | -122.410713527989 | (37.7510183090213, -122.410713527989) | ||
| 50358 | 50358 | 35258 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1304 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1998 12:00:00 AM | 11 | Permit Number 38744 | 6006066.5782 | 2120048.78389 | 37.8015923223752 | -122.42317295609199 | (37.8015923223752, -122.423172956092) | |
| 124022 | 124022 | 37952 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1308 Mariposa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | Permit Number 40191 | 6013419.73141926 | 2106176.98186548 | 37.763915762931106 | -122.396754475262 | (37.7639157629311, -122.396754475262) | ||
| 32980 | 32980 | 30799 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 131 Brompton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1995 12:00:00 AM | 8 | Permit Number 34665 | 6002107.114019999 | 2095231.84638 | 37.733226875715296 | -122.43509850062 | (37.7332268757153, -122.43509850062) |
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");