Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant, PlantDate, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1389 | 1389 | 251532 | Permitted Site 1 | :: 54 | 2100X 20th St | 4 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 05/15/2017 12:00:00 AM | 3 | 4x11 | |||||||
10093 | 10093 | 173849 | Permitted Site 1 | :: 54 | 450 Toland St | 4 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 01/27/2017 12:00:00 AM | 3 | 17.6x4 | 6012768.71675 | 2099101.44192 | 37.74445161113729 | -122.39850962968201 | (37.7444516111373, -122.398509629682) | ||
18412 | 18412 | 247322 | Undocumented 2 | :: 54 | 218 Pierce St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6002795.6845 | 2109344.9924 | 37.7720173021936 | -122.433726268045 | (37.7720173021936, -122.433726268045) | ||||
28842 | 28842 | 244343 | Undocumented 2 | :: 54 | 462 Steiner St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6003204.9743 | 2109911.1218 | 37.7735949699184 | -122.432350944562 | (37.7735949699184, -122.432350944562) | |||
30926 | 30926 | 245835 | Undocumented 2 | :: 54 | 451 Fell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6005269.6444 | 2110584.5711 | 37.7755609539167 | -122.42525686469999 | (37.7755609539167, -122.4252568647) | |||
33492 | 33492 | 185808 | Undocumented 2 | :: 54 | 1655 21st Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5989755.3501 | 2101698.7532 | 37.7502742090567 | -122.478274123288 | (37.7502742090567, -122.478274123288) | |||
33830 | 33830 | 244279 | Undocumented 2 | :: 54 | 585 Oak St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004230.7823 | 2110095.8419999997 | 37.7741602789386 | -122.42881569121799 | (37.7741602789386, -122.428815691218) | |||
35127 | 35127 | 185838 | Undocumented 2 | :: 54 | 2000 35th Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985430.142000001 | 2101125.3499 | 37.7484477718341 | -122.493188522588 | (37.7484477718341, -122.493188522588) | |||
35957 | 35957 | 183110 | Undocumented 2 | :: 54 | 3474 Santiago St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5982112.0542 | 2099478.6077 | 37.7437316497768 | -122.504540222201 | (37.7437316497768, -122.504540222201) | |||
36535 | 36535 | 139766 | Undocumented 2 | :: 54 | 1308 Laguna St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004662.1567 | 2113418.8231 | 37.7833087728144 | -122.427560280444 | (37.7833087728144, -122.427560280444) | |||
37787 | 37787 | 184683 | Undocumented 2 | :: 54 | 3343 Lawton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5983825.9671 | 2104243.1006 | 37.7569142945607 | -122.498965955362 | (37.7569142945607, -122.498965955362) | |||
43147 | 43147 | 138988 | Undocumented 2 | :: 54 | 661 FILLMORE ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6003478.1301 | 2110687.6732 | 37.775742673405205 | -122.43146150530701 | (37.7757426734052, -122.431461505307) | |||
44559 | 44559 | 141411 | Undocumented 2 | :: 54 | 530 IVY ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004748.0909 | 2111070.6139 | 37.776866029844996 | -122.42709567230601 | (37.776866029845, -122.427095672306) | |||
45274 | 45274 | 246179 | Undocumented 2 | :: 54 | 1588 Waller St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5997977.1471 | 2108227.9355 | 37.768675553750796 | -122.45031334601101 | (37.7686755537508, -122.450313346011) | |||
48216 | 48216 | 142535 | Undocumented 2 | :: 54 | 2100 POWELL ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6009442.0785 | 2120948.1005 | 37.8042515332642 | -122.411555719808 | (37.8042515332642, -122.411555719808) | |||
51060 | 51060 | 183255 | Undocumented 2 | :: 54 | 1300 La Playa | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5980911.3073 | 2106159.7216 | 37.762005388573606 | -122.509188082818 | (37.7620053885736, -122.509188082818) | |||
52327 | 52327 | 139022 | Undocumented 2 | :: 54 | 2557 SUTTER ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000419.2522 | 2114077.8239 | 37.784877318741 | -122.44228632704201 | (37.784877318741, -122.442286327042) | |||
55449 | 55449 | 183888 | Undocumented 2 | :: 54 | 1390 Quintara St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5988941.521000001 | 2101013.106 | 37.7483443270077 | -122.48103816738501 | (37.7483443270077, -122.481038167385) | |||
58153 | 58153 | 184163 | Undocumented 2 | :: 54 | 3544 Lawton St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5983184.3019 | 2104274.4825 | 37.756962801278206 | -122.501187358865 | (37.7569628012782, -122.501187358865) | |||
64050 | 64050 | 139028 | Undocumented 2 | :: 54 | 2501 SUTTER ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000547.3036 | 2114093.8303 | 37.7849285655089 | -122.44184446112301 | (37.7849285655089, -122.441844461123) | |||
67598 | 67598 | 183656 | Undocumented 2 | :: 54 | 4000 Kirkham St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5982355.2044 | 2104927.0637 | 37.758705882923 | -122.50410297872801 | (37.758705882923, -122.504102978728) | |||
68816 | 68816 | 140401 | Undocumented 2 | :: 54 | 650 WILLOW ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004290.5512 | 2113088.0425 | 37.7823795059387 | -122.428822298842 | (37.7823795059387, -122.428822298842) | |||
71462 | 71462 | 183935 | Undocumented 2 | :: 54 | 2101 24th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5988808.3679 | 2100849.1108 | 37.747886298336205 | -122.481486593386 | (37.7478862983362, -122.481486593386) | |||
73182 | 73182 | 245418 | Undocumented 2 | :: 54 | 2761 24th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6010213.0571 | 2102206.4482 | 37.7528345690624 | -122.407565491585 | (37.7528345690624, -122.407565491585) | |||
73932 | 73932 | 245458 | Undocumented 2 | :: 54 | 2800 16th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6007840.6133 | 2106809.0367 | 37.765339135235706 | -122.416095791627 | (37.7653391352357, -122.416095791627) | |||
74439 | 74439 | 187452 | Undocumented 2 | :: 54 | 5098 Mission St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 6000296.2838 | 2089278.8073 | 37.7167782039769 | -122.440932105905 | (37.7167782039769, -122.440932105905) | |||
76338 | 76338 | 184424 | Undocumented 2 | :: 54 | 3735 Quintara St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5981804.597999999 | 2100770.5329 | 37.7472608268582 | -122.50569906643601 | (37.7472608268582, -122.505699066436) | |||
76975 | 76975 | 184546 | Undocumented 2 | :: 54 | 3445 Moraga St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5983564.2693 | 2103555.7588 | 37.7550116923713 | -122.499820187022 | (37.7550116923713, -122.499820187022) | |||
77189 | 77189 | 181710 | Undocumented 2 | :: 54 | 3335 Lincoln Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5985330.8116 | 2107013.2752 | 37.764608577957794 | -122.49396586585699 | (37.7646085779578, -122.493965865857) | |||
77586 | 77586 | 121129 | Undocumented 2 | :: 54 | 201 Bemis St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/09/2016 12:00:00 AM | 3 | 3x3 | 6003216.0 | 2096386.0 | 37.7364588227531 | -122.431347141396 | (37.7364588227531, -122.431347141396) | ||
79062 | 79062 | 33409 | Permitted Site 1 | :: 54 | 100 Ulloa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1996 12:00:00 AM | Permit Number 37523 | 5996457.34152631 | 2099451.4193202 | 37.7444903608651 | -122.454935970247 | (37.7444903608651, -122.454935970247) | ||
80039 | 80039 | 114619 | Undocumented 2 | :: 54 | 2400X Post St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6000387.7 | 2114050.6 | 37.7848007706075 | -122.442393531976 | (37.7848007706075, -122.442393531976) | |||||
83697 | 83697 | 108792 | Permitted Site 1 | :: 54 | 201-299 University St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6008053.41125 | 2093004.09823 | 37.727445818429295 | -122.414382893832 | (37.7274458184293, -122.414382893832) | ||||
85903 | 85903 | 105084 | Significant Tree 6 | :: 54 | 344 Fulton St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006101.8 | 2111789.5 | 37.778916373563206 | -122.42246386857201 | (37.7789163735632, -122.422463868572) | |||||
89025 | 89025 | 36518 | Permitted Site 1 | :: 54 | 430 Crescent Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39394 | 6007460.82693634 | 2095697.00770714 | 37.7348066562255 | -122.416622148824 | (37.7348066562255, -122.416622148824) | ||
92935 | 92935 | 104156 | Permitted Site 1 | :: 54 | 525X Church St | 4 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | SFUSD 4 | DPW 4 | 5x20 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | |||
95183 | 95183 | 116324 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
97307 | 97307 | 109345 | Permitted Site 1 | :: 54 | 3211 Baker St | 4 | Sidewalk: Property side : Yard 9 | Landscaping 2 | Private 1 | 02/11/2015 12:00:00 AM | 3 | 8.75x13 | 5999315.1 | 2119860.5 | 37.8006920253414 | -122.446522498385 | (37.8006920253414, -122.446522498385) | ||
101195 | 101195 | 115894 | Permitted Site 1 | :: 54 | 1900X Kirkham St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/02/2016 12:00:00 AM | 3 | 5988841.66469 | 2105121.6083400003 | 37.75961937033 | -122.48168434385401 | (37.75961937033, -122.481684343854) | |||
101816 | 101816 | 31149 | Permitted Site 1 | :: 54 | 500 Hearst Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34853 | 5998089.630643 | 2094417.27408922 | 37.730761307799504 | -122.44892931603 | (37.7307613077995, -122.44892931603) | ||
102292 | 102292 | 33205 | Permitted Site 1 | :: 54 | 80 Ulloa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/1996 12:00:00 AM | Permit Number 37408 | 5996508.84910838 | 2099508.74034148 | 37.74465070488021 | -122.454762009134 | (37.7446507048802, -122.454762009134) | |||
106819 | 106819 | 105042 | Permitted Site 1 | :: 54 | 2660 Harrison St | 4 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 2x10 | 6008868.4 | 2102978.1 | 37.7548779915591 | -122.412270115586 | (37.7548779915591, -122.412270115586) | ||||
107142 | 107142 | 108804 | Undocumented 2 | :: 54 | 401-499 University St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008323.152369999 | 2092121.01007 | 37.7250361958168 | -122.413387969207 | (37.7250361958168, -122.413387969207) | |||||
112218 | 112218 | 109536 | Permitted Site 1 | :: 54 | 1234 Filbert St | 4 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | FUF 1 | 02/23/2015 12:00:00 AM | 3 | 1.5x2.4 | 6007007.9 | 2119506.8 | 37.800157248198296 | -122.419877066677 | (37.8001572481983, -122.419877066677) | |
115960 | 115960 | 38111 | Permitted Site 1 | :: 54 | 1296 29th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/1998 12:00:00 AM | Permit Number 40278 | 5987114.66231835 | 2106457.26685396 | 37.763186144894 | -122.48775523264901 | (37.763186144894, -122.487755232649) | ||
117089 | 117089 | 116277 | Undocumented 2 | :: 54 | 700X Greenwich St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.41122536090799 | (37.8021533125646, -122.411225360908) | |||||
117839 | 117839 | 106461 | Undocumented 2 | :: 54 | 701 Cortland Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6007932.0 | 2097222.5 | 37.739021812259104 | -122.415101080128 | (37.7390218122591, -122.415101080128) | |||||
122059 | 122059 | 108765 | Undocumented 2 | :: 54 | 500X Lathrop Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | ||||
124298 | 124298 | 109367 | Permitted Site 1 | :: 54 | 1205 Filbert St | 4 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | FUF 1 | 02/11/2015 12:00:00 AM | 3 | 4.5x6.5 | 6007075.4 | 2119431.2 | 37.7999534721279 | -122.419638123127 | (37.7999534721279, -122.419638123127) | |
126640 | 126640 | 108797 | Undocumented 2 | :: 54 | 501-599 University St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008503.45306 | 2091469.8325200002 | 37.7232583218261 | -122.412718672961 | (37.7232583218261, -122.412718672961) | |||||
132369 | 132369 | 181641 | Undocumented 2 | :: 54 | 2520 Irving St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5987893.3386 | 2106475.9106 | 37.7632827235336 | -122.48506345305599 | (37.7632827235336, -122.485063453056) | |||
135552 | 135552 | 140125 | Undocumented 2 | :: 54 | 1321 Divisadero St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6001271.8045 | 2112891.6174 | 37.7816688523257 | -122.43925172679899 | (37.7816688523257, -122.439251726799) | |||
138290 | 138290 | 39089 | Permitted Site 1 | :: 54 | 3140102 21st St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40782 | 6007340.78433039 | 2103849.3427132 | 37.757184385901496 | -122.41761479761601 | (37.7571843859015, -122.417614797616) | ||
142035 | 142035 | 31191 | Permitted Site 1 | :: 54 | 744 Shields St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34885 | 5992088.16257343 | 2089881.74957895 | 37.7179628280945 | -122.469347142572 | (37.7179628280945, -122.469347142572) | ||
144770 | 144770 | 115064 | DPW Maintained 3 | :: 54 | 70 Coral Rd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6012676.36761 | 2102522.24683 | 37.7538392609312 | -122.39906901845501 | (37.7538392609312, -122.399069018455) | |||||
145417 | 145417 | 115870 | Undocumented 2 | :: 54 | 84X Cordova St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | on Athens St. Frontage | 6001679.7 | 2087642.4 | 37.712363687575795 | -122.43603329568501 | (37.7123636875758, -122.436033295685) | ||||
150168 | 150168 | 182323 | Undocumented 2 | :: 54 | 2931 Kirkham St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5985702.3126 | 2104987.9378 | 37.7590692943081 | -122.49253179470502 | (37.7590692943081, -122.492531794705) | |||
158309 | 158309 | 142169 | Undocumented 2 | :: 54 | 1477 GROVE ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000761.182999999 | 2110657.0332 | 37.7755041822084 | -122.4408578836 | (37.7755041822084, -122.4408578836) | |||
163559 | 163559 | 182217 | Undocumented 2 | :: 54 | 2998 Lawton St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985040.9971 | 2104340.2555 | 37.7572522503219 | -122.49477115168999 | (37.7572522503219, -122.49477115169) | |||
168900 | 168900 | 139031 | Undocumented 2 | :: 54 | 1535 Broderick St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000623.856000001 | 2114017.2778 | 37.784722733809 | -122.441574119703 | (37.784722733809, -122.441574119703) | |||
169071 | 169071 | 185826 | Undocumented 2 | :: 54 | 2031 34th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5985688.7443 | 2101349.2146 | 37.7490775651475 | -122.492310775953 | (37.7490775651475, -122.492310775953) | |||
169590 | 169590 | 244368 | Undocumented 2 | :: 54 | 301 Octavia St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6005522.1928 | 2110360.9128 | 37.7749611068256 | -122.424367326274 | (37.7749611068256, -122.424367326274) | |||
170361 | 170361 | 246200 | Undocumented 2 | :: 54 | 737 Buena Vista Ave West | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5999871.6458 | 2107989.0034 | 37.7681277455177 | -122.443743277143 | (37.7681277455177, -122.443743277143) | |||
176249 | 176249 | 184692 | Undocumented 2 | :: 54 | 3545 Lawton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5983219.9396 | 2104221.872 | 37.7568204402945 | -122.50106022131 | (37.7568204402945, -122.50106022131) | |||
180411 | 180411 | 139043 | Undocumented 2 | :: 54 | 1434 BAKER ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000190.2907 | 2114006.1429 | 37.7846674491742 | -122.443073307519 | (37.7846674491742, -122.443073307519) | |||
184510 | 184510 | 244966 | Undocumented 2 | :: 54 | 250 Lily St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6005265.6412 | 2110100.505 | 37.7742315998648 | -122.42523625993401 | (37.7742315998648, -122.425236259934) | |||
185965 | 185965 | 140443 | Undocumented 2 | :: 54 | 1101 FILLMORE ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6003331.4074 | 2112177.9445 | 37.7798262712775 | -122.432075500833 | (37.7798262712775, -122.432075500833) | |||
186300 | 186300 | 183883 | Undocumented 2 | :: 54 | 2130 24th Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5988850.4477 | 2100968.5581 | 37.7482167156371 | -122.481349831083 | (37.7482167156371, -122.481349831083) | |||
187636 | 187636 | 183293 | Undocumented 2 | :: 54 | 1286 42nd Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5983075.6533 | 2106421.6609 | 37.76285196523921 | -122.50172195396401 | (37.7628519652392, -122.501721953964) |
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");