Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant
PlotSize ✖
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) | |
19697 | 19697 | 85509 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1 Nebraska St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 49678 | 6009335.0 | 2098038.0 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | ||||
77508 | 77508 | 85510 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1 Nebraska St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 49678 | 6009335.0 | 2098038.0 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | ||||
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) | |||||
117346 | 117346 | 85502 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1 Nebraska St | 4 | Sidewalk: Property side : Yard 9 | 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 | ||||||||
45189 | 45189 | 220002 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1001 Jarboe Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 8ft | 6009383.355930001 | 2096884.0702099998 | 37.7381740121064 | -122.4100590501 | (37.7381740121064, -122.4100590501) | |||
178540 | 178540 | 220003 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1001 Jarboe Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 8ft | 6009365.07591 | 2096886.4272 | 37.738179459299296 | -122.410122419925 | (37.7381794592993, -122.410122419925) | |||
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) | |||
42028 | 42028 | 188510 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 101 Pennsylvania Ave | 25 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6014318.1653 | 2106535.6894400003 | 37.76495065967789 | -122.39367214607401 | (37.7649506596779, -122.393672146074) | ||||
55738 | 55738 | 188509 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 101 Pennsylvania Ave | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6014325.646980001 | 2106424.64729 | 37.7646461780098 | -122.393638496141 | (37.7646461780098, -122.393638496141) | ||||
60414 | 60414 | 188512 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 101 Pennsylvania Ave | 41 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6014229.234019999 | 2106696.64866 | 37.7653876762377 | -122.393991007905 | (37.7653876762377, -122.393991007905) | ||||
169866 | 169866 | 188508 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 101 Pennsylvania Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6014332.46782 | 2106283.64375 | 37.764259392178005 | -122.393605035044 | (37.764259392178, -122.393605035044) | ||||
177773 | 177773 | 188511 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 101 Pennsylvania Ave | 33 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6014272.76615 | 2106665.73514 | 37.7653052137955 | -122.393838275126 | (37.7653052137955, -122.393838275126) | ||||
54358 | 54358 | 219993 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 101 Prospect Ave | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | 6006993.27252 | 2098944.7494 | 37.7436979269164 | -122.418468865069 | (37.7436979269164, -122.418468865069) | ||||
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) | ||
38639 | 38639 | 174959 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 103 De Long St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 10ft | 5994397.11424 | 2086788.06602 | 37.709601466104104 | -122.461142043293 | (37.7096014661041, -122.461142043293) | |||
156503 | 156503 | 174960 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 103 De Long St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 10ft | 5994409.5991400005 | 2086788.1181299998 | 37.709602327657706 | -122.461098897396 | (37.7096023276577, -122.461098897396) | |||
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) | |
24822 | 24822 | 250192 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 11 Alta St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | Width 0ft | 6011786.88966 | 2119947.0785 | 37.8016342173021 | -122.403370805543 | (37.8016342173021, -122.403370805543) | |||
47761 | 47761 | 250191 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 11 Alta St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 11 | Width 0ft | 6011795.08799 | 2119945.2148 | 37.8016295579248 | -122.40334230423099 | (37.8016295579248, -122.403342304231) | |||
135843 | 135843 | 250193 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 11 Alta St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 35 | Width 0ft | 6011782.399230001 | 2119949.71509 | 37.8016412059365 | -122.403386530161 | (37.8016412059365, -122.403386530161) | |||
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) | |
12540 | 12540 | 108677 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 11 Otsego Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | Permit Number 773206 | 6000966.57436 | 2092971.8241299998 | 37.7269565451936 | -122.438879746024 | (37.7269565451936, -122.438879746024) | |
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) | |
168971 | 168971 | 220018 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1129 Douglass St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 6001364.34858 | 2100418.37342 | 37.7474256590636 | -122.43803782498999 | (37.7474256590636, -122.43803782499) | |||
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) |
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");