Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlotSize
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
103 | 103 | 117428 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2016 12:00:00 AM | 3 | Permit Number 776915 | ||||||||
122863 | 122863 | 50817 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/18/2004 12:00:00 AM | Permit Number 47340 | 5995605.94135709 | 2094497.43585496 | 37.7308390591092 | -122.457521563876 | (37.7308390591092, -122.457521563876) | ||||
40186 | 40186 | 218289 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1 Woodacre Dr | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | 5991265.0261699995 | 2095485.2551900002 | 37.7333010580894 | -122.472600653515 | (37.7333010580894, -122.472600653515) | ||||
53381 | 53381 | 217850 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1 Woodacre Dr | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | 5991375.86862 | 2095660.38148 | 37.7337883260711 | -122.47223020566999 | (37.7337883260711, -122.47223020567) | ||||
55201 | 55201 | 218280 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1 Woodacre Dr | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 30 | 5991369.16642 | 2095649.3447099999 | 37.7337576340075 | -122.47225257269301 | (37.7337576340075, -122.472252572693) | ||||
136052 | 136052 | 218293 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1 Woodacre Dr | 17 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 22 | 5991192.67429 | 2095369.91493 | 37.7329801745819 | -122.47284238406799 | (37.7329801745819, -122.472842384068) | ||||
171868 | 171868 | 218294 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1 Woodacre Dr | 18 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 5991183.55146 | 2095353.09261 | 37.7329334566034 | -122.472872697534 | (37.7329334566034, -122.472872697534) | ||||
95944 | 95944 | 116681 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 100 Esmeralda Ave | 20 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 6006917.389830001 | 2098966.37493 | 37.7437530336215 | -122.41873278303999 | (37.7437530336215, -122.41873278304) | |||||
122500 | 122500 | 115975 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 100 SAN JOSE AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6006168.0 | 2102576.0 | 37.7536220187283 | -122.421580311855 | (37.7536220187283, -122.421580311855) | |||
24466 | 24466 | 207106 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 100 Tara St | 2 | : 4 | Tree 1 | Private 1 | 20 | Width 0ft | 5998100.60654 | 2090923.0946 | 37.7211677377768 | -122.448639805789 | (37.7211677377768, -122.448639805789) | |||
37269 | 37269 | 227675 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1000 San Jose Ave | 104 | Front Yard : Yard 7 | Tree 1 | Private 1 | 27 | 6005040.407269999 | 2096975.5643799999 | 37.7381808604543 | -122.425081325568 | (37.7381808604543, -122.425081325568) | ||||
74734 | 74734 | 227671 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1000 San Jose Ave | 60 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6005087.18528 | 2097058.7145599998 | 37.738411814457706 | -122.42492550452101 | (37.7384118144577, -122.424925504521) | ||||
148496 | 148496 | 227674 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1000 San Jose Ave | 83 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6005065.1015800005 | 2097012.05309 | 37.7382824451638 | -122.42499854026899 | (37.7382824451638, -122.424998540269) | ||||
150938 | 150938 | 227672 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1000 San Jose Ave | 62 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6005095.2123 | 2097053.48648 | 37.7383979127325 | -122.42489737911801 | (37.7383979127325, -122.424897379118) | ||||
178085 | 178085 | 227673 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1000 San Jose Ave | 64 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6005078.09924 | 2097049.5351099998 | 37.738386096529204 | -122.424956266738 | (37.7383860965292, -122.424956266738) | ||||
101609 | 101609 | 43632 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1001 Portola Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50556 | 5996213.47474732 | 2098545.79305022 | 37.7419897418411 | -122.455713757113 | (37.7419897418411, -122.455713757113) | ||
32798 | 32798 | 227686 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1001 Shrader St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5997629.48637 | 2107046.8431599997 | 37.7654126728718 | -122.45143067278299 | (37.7654126728718, -122.451430672783) | |||
77293 | 77293 | 227685 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1001 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5997626.030809999 | 2107071.20572 | 37.765479368391 | -122.45144438204599 | (37.765479368391, -122.451444382046) | |||
44170 | 44170 | 227687 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1003 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5997630.84664 | 2107024.34604 | 37.7653509793933 | -122.45142434518401 | (37.7653509793933, -122.451424345184) | |||
95391 | 95391 | 113478 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 100x ESMERALDA AVE | 5 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 8 | 6006917.0 | 2098966.0 | 37.7437519821991 | -122.418734104398 | (37.7437519821991, -122.418734104398) | ||||
1699 | 1699 | 237552 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 102 Hancock St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779869 | 6003566.97457 | 2105097.88602 | 37.7603995118464 | -122.430755182518 | (37.7603995118464, -122.430755182518) | |
1709 | 1709 | 237551 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 102 Hancock St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779869 | 6003586.068 | 2105101.14828 | 37.760409550968205 | -122.430689380017 | (37.7604095509682, -122.430689380017) | |
43299 | 43299 | 129476 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1077 Front St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | 6012591.305319999 | 2120127.94056 | 37.8021757161919 | -122.4005998549 | (37.8021757161919, -122.4005998549) | ||||
74619 | 74619 | 129475 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1077 Front St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | 6012586.0999300005 | 2120128.51859 | 37.8021770130129 | -122.40061790879999 | (37.8021770130129, -122.4006179088) | ||||
152713 | 152713 | 129469 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1085 Vallejo St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6008359.28826 | 2118585.88506 | 37.7977046844857 | -122.415135501808 | (37.7977046844857, -122.415135501808) | |||
26252 | 26252 | 227697 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 109 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003800.52049 | 2108768.8119 | 37.7704922173631 | -122.430209350707 | (37.7704922173631, -122.430209350707) | |||
132469 | 132469 | 129472 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 11 Filbert St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6012528.94679 | 2120206.6635 | 37.8023883923599 | -122.400821180758 | (37.8023883923599, -122.400821180758) | ||||
137937 | 137937 | 129474 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 11 Filbert St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | 6012536.27851 | 2120200.91706 | 37.8023730229664 | -122.400795405292 | (37.8023730229664, -122.400795405292) | ||||
147602 | 147602 | 129471 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 11 Filbert St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 6012526.59847 | 2120207.76193 | 37.8023912773999 | -122.40082938436701 | (37.8023912773999, -122.400829384367) | ||||
174070 | 174070 | 129473 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 11 Filbert St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | 6012532.2991 | 2120205.0438900003 | 37.8023841322847 | -122.400809466192 | (37.8023841322847, -122.400809466192) | ||||
171814 | 171814 | 129480 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 11 Greenwich St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | 6012320.77236 | 2120522.45554 | 37.8032438670795 | -122.401563778859 | (37.8032438670795, -122.401563778859) | ||||
175563 | 175563 | 129481 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 11 Greenwich St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6012317.54236 | 2120532.7765200003 | 37.8032720257522 | -122.401575682271 | (37.8032720257522, -122.401575682271) | ||||
176379 | 176379 | 129482 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 11 Greenwich St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6012315.37501 | 2120537.75286 | 37.803285568636 | -122.401583532467 | (37.803285568636, -122.401583532467) | ||||
96489 | 96489 | 50428 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 11 Lee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2003 12:00:00 AM | Permit Number 47081 | 5996479.47890892 | 2089951.8399168998 | 37.7184080697361 | -122.454173429085 | (37.7184080697361, -122.454173429085) | ||
93390 | 93390 | 33301 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1120 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | Permit Number 37453 | 6009052.27411403 | 2116787.86536385 | 37.7928066833324 | -122.412610401728 | (37.7928066833324, -122.412610401728) | ||
144076 | 144076 | 889 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1136X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6003353.033430001 | 2094335.58352 | 37.7308366096666 | -122.43072708407401 | (37.7308366096666, -122.430727084074) | |||
11074 | 11074 | 882 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1138X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2016 12:00:00 AM | 28 | 3x3 | 6003576.60001 | 2094409.9739299999 | 37.7310535326811 | -122.429959483056 | (37.7310535326811, -122.429959483056) | ||
119851 | 119851 | 34725 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 114 Sutro Heights Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38379 | 5981286.97907127 | 2111325.91865707 | 37.776212402307 | -122.508272287748 | (37.776212402307, -122.508272287748) | ||
11146 | 11146 | 890 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1146 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 4X4 | 6003547.94647 | 2094400.70663 | 37.7310264639915 | -122.430057882374 | (37.7310264639915, -122.430057882374) | |||
137835 | 137835 | 129468 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1151 Lombard St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 6006718.96895 | 2120094.36111 | 37.8017542606157 | -122.420918621021 | (37.8017542606157, -122.420918621021) | ||||
143078 | 143078 | 121420 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1155x Prague St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 6000780.0 | 2086820.0 | 37.7100544057225 | -122.439084019343 | (37.7100544057225, -122.439084019343) | ||||
90495 | 90495 | 49718 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1195 Fitzgerald Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2003 12:00:00 AM | Permit Number 46529 | 6014698.72785663 | 2090465.4227663002 | 37.7208461876659 | -122.39123244275801 | (37.7208461876659, -122.391232442758) | |||
39739 | 39739 | 129479 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 12 Filbert St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 6012506.1322099995 | 2120230.97584 | 37.8024538756 | -122.400901840066 | (37.8024538756, -122.400901840066) | ||||
64529 | 64529 | 129477 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 12 Filbert St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 6012514.7758 | 2120236.23138 | 37.8024687881724 | -122.40087229823901 | (37.8024687881724, -122.400872298239) | ||||
152532 | 152532 | 129478 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 12 Filbert St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | 6012509.68294 | 2120230.66756 | 37.80245322719529 | -122.400889531035 | (37.8024532271953, -122.400889531035) | ||||
43545 | 43545 | 129484 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 12 Greenwich St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | 6012303.2887699995 | 2120555.11364 | 37.8033325627054 | -122.401626578498 | (37.8033325627054, -122.401626578498) | ||||
53774 | 53774 | 129486 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 12 Greenwich St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 6012297.60436 | 2120565.6201 | 37.803361093695 | -122.40164698862199 | (37.803361093695, -122.401646988622) | ||||
166033 | 166033 | 129485 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 12 Greenwich St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 6012301.33061 | 2120559.21941 | 37.803343726885 | -122.40163364357099 | (37.803343726885, -122.401633643571) | ||||
186348 | 186348 | 129483 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 12 Greenwich St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | 6012307.75016 | 2120551.4086599997 | 37.8033226386787 | -122.401610879045 | (37.8033226386787, -122.401610879045) | ||||
24102 | 24102 | 186759 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1200 Sunset Blvd | 25 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5984850.1974 | 2106711.7495 | 37.7637525404811 | -122.495605915184 | (37.7637525404811, -122.495605915184) | |||
36675 | 36675 | 186762 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1200 Sunset Blvd | 28 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 0ft | 5984853.5932 | 2106716.1156 | 37.7637647274179 | -122.49559449238701 | (37.7637647274179, -122.495594492387) | |||
44625 | 44625 | 186760 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1200 Sunset Blvd | 26 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5984860.8701 | 2106711.7495 | 37.7637531654529 | -122.495569002148 | (37.7637531654529, -122.495569002148) | |||
45882 | 45882 | 186748 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1200 Sunset Blvd | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 0ft | 5984868.1469 | 2106676.3356 | 37.7636563549354 | -122.495541222153 | (37.7636563549354, -122.495541222153) | |||
50007 | 50007 | 186756 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1200 Sunset Blvd | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 0ft | 5984857.4742 | 2106702.5322 | 37.7637276584797 | -122.495580067458 | (37.7637276584797, -122.495580067458) | |||
66007 | 66007 | 186752 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1200 Sunset Blvd | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5984851.1676 | 2106688.9488 | 37.7636899929755 | -122.49560087776399 | (37.7636899929755, -122.495600877764) | |||
70133 | 70133 | 186750 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1200 Sunset Blvd | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5984851.1676 | 2106678.2761 | 37.763660688738206 | -122.49560009051399 | (37.7636606887382, -122.495600090514) | |||
73459 | 73459 | 186747 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1200 Sunset Blvd | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5984869.1172 | 2106666.6331 | 37.76362977141179 | -122.495537150576 | (37.7636297714118, -122.495537150576) | |||
151432 | 151432 | 186745 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1200 Sunset Blvd | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984852.3804 | 2106661.5394 | 37.763614805479 | -122.495594661337 | (37.763614805479, -122.495594661337) | |||
156319 | 156319 | 186749 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1200 Sunset Blvd | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 0ft | 5984860.385 | 2106678.2761 | 37.7636612284897 | -122.495568210877 | (37.7636612284897, -122.495568210877) | |||
184000 | 184000 | 186754 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1200 Sunset Blvd | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 0ft | 5984863.7808 | 2106693.8 | 37.763704051609004 | -122.49555761110202 | (37.763704051609, -122.495557611102) | |||
12047 | 12047 | 909 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1217 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 6003163.68633 | 2094174.8948400002 | 37.7303846655151 | -122.431370220756 | (37.7303846655151, -122.431370220756) | |||
120269 | 120269 | 85386 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1239 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 49657 | 5981144.8 | 2106623.2 | 37.7632917298848 | -122.508414943002 | (37.7632917298848, -122.508414943002) | ||||
127237 | 127237 | 50114 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1252 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2003 12:00:00 AM | Permit Number 46839 | 5992244.12505327 | 2098460.15223335 | 37.7415260004029 | -122.469432140867 | (37.7415260004029, -122.469432140867) | ||
41740 | 41740 | 183278 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1255 42nd Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5983028.2339 | 2106536.9311 | 37.7631656789881 | -122.50189448779601 | (37.7631656789881, -122.501894487796) | |||
154916 | 154916 | 37082 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1268 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/15/2002 12:00:00 AM | 6 | Permit Number 44549 | 5982146.28824129 | 2106471.58463776 | 37.762934408685396 | -122.504939947841 | (37.7629344086854, -122.504939947841) | |
9386 | 9386 | 926 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1278 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3x3 | 6002807.701830001 | 2094157.47604 | 37.7303166558715 | -122.432599664217 | (37.7303166558715, -122.432599664217) | |||
172032 | 172032 | 176987 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1278 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | Width 5ft | 6002815.8897 | 2094148.3870700002 | 37.7302921639516 | -122.43257070868799 | (37.7302921639516, -122.432570708688) | |||
84780 | 84780 | 33391 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 129 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | Permit Number 37510 | 5993545.21642202 | 2093774.31911417 | 37.7287349718633 | -122.464593277929 | (37.7287349718633, -122.464593277929) | ||
52773 | 52773 | 183252 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1300 La Playa | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5980914.4873 | 2106074.2169999997 | 37.761770805091096 | -122.50917073482799 | (37.7617708050911, -122.509170734828) | |||
93638 | 93638 | 31942 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1300 La Playa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | Permit Number 39715 | 5980916.9213303 | 2106151.77480086 | 37.761983899941 | -122.50916807626999 | (37.761983899941, -122.50916807627) | ||
31036 | 31036 | 181438 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1319 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5981181.6009 | 2106068.5638 | 37.761771027502 | -122.508246492496 | (37.761771027502, -122.508246492496) | |||
37042 | 37042 | 207101 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1325 18th Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5990477.30542 | 2106226.48097 | 37.7627480320102 | -122.476108237903 | (37.7627480320102, -122.476108237903) | |||
69434 | 69434 | 207099 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1325 18th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5990478.55232 | 2106260.78747 | 37.7628423007597 | -122.476106431162 | (37.7628423007597, -122.476106431162) | |||
161309 | 161309 | 207102 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1325 18th Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5990480.890819999 | 2106148.89617 | 37.7625352128593 | -122.476090170539 | (37.7625352128593, -122.476090170539) | |||
174088 | 174088 | 207100 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1325 18th Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5990476.61635 | 2106239.9997799997 | 37.762785111079396 | -122.476111608564 | (37.7627851110794, -122.476111608564) | |||
40391 | 40391 | 129467 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1331 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 4ft | 6006504.317480001 | 2119710.78815 | 37.8006889650949 | -122.42163415671301 | (37.8006889650949, -122.421634156713) | |||
167106 | 167106 | 47850 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1342 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/14/2002 12:00:00 AM | 7 | Permit Number 45609 | 5983405.04544412 | 2106002.56953842 | 37.7617206013965 | -122.50055173019501 | (37.7617206013965, -122.500551730195) | |
46923 | 46923 | 50575 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1347 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/06/2003 12:00:00 AM | 0 | Permit Number 47190 | 5983353.97136461 | 2105974.76120709 | 37.7616412492229 | -122.50072631562 | (37.7616412492229, -122.50072631562) | |
103188 | 103188 | 32605 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1370 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37071 | 5984960.54583105 | 2105873.44387063 | 37.7614572492102 | -122.49516243722 | (37.7614572492102, -122.49516243722) | ||
155355 | 155355 | 32594 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1379 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/1996 12:00:00 AM | 1 | Permit Number 37062 | 5985531.05347187 | 2105840.85496484 | 37.76140115330671 | -122.49318691517 | (37.7614011533067, -122.49318691517) | |
29234 | 29234 | 186513 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1400 Lower Great Hwy | 14 | unknown : Yard 19 | Tree 1 | Private 1 | 5 | Width 0ft | 5980894.1374 | 2105147.1675 | 37.759224194224 | -122.509172270667 | (37.759224194224, -122.509172270667) | |||
50995 | 50995 | 186509 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1400 Lower Great Hwy | 10 | unknown : Yard 19 | Tree 1 | Private 1 | 7 | Width 0ft | 5980901.3856 | 2105130.6001 | 37.759179132228 | -122.509145973072 | (37.759179132228, -122.509145973072) | |||
66913 | 66913 | 186510 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1400 Lower Great Hwy | 11 | unknown : Yard 19 | Tree 1 | Private 1 | 5 | Width 0ft | 5980902.4211 | 2105136.8129 | 37.759196251841395 | -122.509142853237 | (37.7591962518414, -122.509142853237) | |||
182655 | 182655 | 186512 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1400 Lower Great Hwy | 13 | unknown : Yard 19 | Tree 1 | Private 1 | 5 | Width 0ft | 5980899.8324 | 2105147.1675 | 37.7592245299801 | -122.509152574968 | (37.7592245299801, -122.509152574968) | |||
30866 | 30866 | 200618 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1400x La Salle Ave | 59 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6016445.2081 | 2095088.6176 | 37.733637339432 | -122.38551735943399 | (37.733637339432, -122.385517359434) | |||
38728 | 38728 | 200604 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1400x La Salle Ave | 61 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 6016455.981000001 | 2095075.886 | 37.7336029770488 | -122.385479227084 | (37.7336029770488, -122.385479227084) | |||
72294 | 72294 | 200614 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1400x La Salle Ave | 55 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6016432.4764 | 2095111.6325 | 37.73369982930821 | -122.385562980445 | (37.7336998293082, -122.385562980445) | |||
76333 | 76333 | 200612 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1400x La Salle Ave | 53 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 6016428.558999999 | 2095128.7713 | 37.7337466722751 | -122.385577718213 | (37.7337466722751, -122.385577718213) | |||
76733 | 76733 | 200616 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1400x La Salle Ave | 57 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6016436.8835 | 2095099.8803 | 37.7336678039609 | -122.385546924914 | (37.7336678039609, -122.385546924914) | |||
137132 | 137132 | 200619 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1400x La Salle Ave | 60 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 6016453.0429 | 2095085.1899 | 37.733628361140106 | -122.38549003320101 | (37.7336283611401, -122.385490033201) | |||
130969 | 130969 | 250332 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 141 27th Ave | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5987387.77846 | 2115003.34197 | 37.786667192588894 | -122.487438428541 | (37.7866671925889, -122.487438428541) | |||
99862 | 99862 | 67131 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1439 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/1992 12:00:00 AM | Permit Number 30551 | 5994253.6761319 | 2105720.38065143 | 37.761576666998295 | -122.463010486718 | (37.7615766669983, -122.463010486718) | ||
130724 | 130724 | 227681 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 145 Alma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 5997959.25406 | 2106183.4369900003 | 37.7630608557823 | -122.450227846644 | (37.7630608557823, -122.450227846644) | |||
109767 | 109767 | 47881 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1454 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50547 | 5982810.24276317 | 2105223.95269531 | 37.759547805419004 | -122.50255124802099 | (37.759547805419, -122.502551248021) | ||
133901 | 133901 | 51414 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1531 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/2004 12:00:00 AM | 0 | Permit Number 47738 | 5988357.88494646 | 2104888.81015522 | 37.7589520258954 | -122.48334041038 | (37.7589520258954, -122.48334041038) | |
185081 | 185081 | 227680 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1541 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6003988.609540001 | 2099295.3111900003 | 37.7444908816604 | -122.428883253577 | (37.7444908816604, -122.428883253577) | |||
57032 | 57032 | 30756 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1547 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 1 | Permit Number 34637 | 6015015.9888 | 2093715.5638 | 37.729788030208795 | -122.390362726863 | (37.7297880302088, -122.390362726863) | |
129429 | 129429 | 100423 | Significant Tree 6 | Leptospermum laevigatum :: Australian Tea Tree 38 | 155 Winston Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990788.0 | 2093142.6 | 37.7268410933597 | -122.474078979965 | (37.7268410933597, -122.474078979965) | |||||
23861 | 23861 | 184307 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1553 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5982166.1739 | 2104530.0154 | 37.7576045827244 | -122.50472730219 | (37.7576045827244, -122.50472730219) | |||
94127 | 94127 | 30765 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1593 Underwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | Permit Number 34646 | 6014616.43299999 | 2093667.83534348 | 37.729634805621096 | -122.391740711397 | (37.7296348056211, -122.391740711397) |
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");