Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13147 | 13147 | 24862 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2626 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2015 12:00:00 AM | 4 | 3x3 | 6011036.3806 | 2093380.4977 | 37.728646452424705 | -122.40409718178101 | (37.7286464524247, -122.404097181781) | ||
14383 | 14383 | 118374 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 340 Fremont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 4x6 | 6014693.17098 | 2114681.8097099997 | 37.787338911495 | -122.392945071183 | (37.787338911495, -122.392945071183) | |||
15549 | 15549 | 8265 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1555 Galvez Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/19/2004 12:00:00 AM | 4 | 3x3 | 6016061.13265 | 2097468.88208 | 37.7401518065476 | -122.387011187809 | (37.7401518065476, -122.387011187809) | ||
24181 | 24181 | 125409 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 680 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6005915.1308699995 | 2112115.06535 | 37.7797997643918 | -122.42313277978 | (37.7797997643918, -122.42313277978) | |||
24244 | 24244 | 187915 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 5 Natoma St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6013761.85881 | 2115378.38602 | 37.7891997734024 | -122.396216078116 | (37.7891997734024, -122.396216078116) | |||
25016 | 25016 | 220501 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 14 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003128.49952 | 2108178.20652 | 37.768832473561794 | -122.432491682542 | (37.7688324735618, -122.432491682542) | |||
28374 | 28374 | 175143 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 199 Hamilton St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 6009125.76929 | 2093634.7983 | 37.729237769091505 | -122.41072025595 | (37.7292377690915, -122.41072025595) | |||
32027 | 32027 | 187962 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 787 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6011933.30583 | 2110670.66458 | 37.7761715530167 | -122.402211564127 | (37.7761715530167, -122.402211564127) | |||
34402 | 34402 | 203409 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1945 08th Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 6ft | 5993779.2225 | 2102246.7483099997 | 37.7520116286371 | -122.46439920245399 | (37.7520116286371, -122.464399202454) | |||
34428 | 34428 | 187860 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1000 22nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6014887.824680001 | 2103924.74261 | 37.7578132028277 | -122.391519270711 | (37.7578132028277, -122.391519270711) | |||
34534 | 34534 | 220499 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 12 Walter St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003128.23781 | 2108216.38247 | 37.768937280547796 | -122.432495314901 | (37.7689372805478, -122.432495314901) | |||
35251 | 35251 | 121502 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 299 Fremont St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 4 | 10x4 | 6014428.99687 | 2115060.94265 | 37.7883652457059 | -122.393885614549 | (37.7883652457059, -122.393885614549) | |||
38296 | 38296 | 220467 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2104 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6009541.05061 | 2104932.28838 | 37.7602814740251 | -122.41008184609699 | (37.7602814740251, -122.410081846097) | |||
39146 | 39146 | 199868 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1601 Jennings St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6016299.0692 | 2093761.868 | 37.729986262675396 | -122.385930158914 | (37.7299862626754, -122.385930158914) | |||
39772 | 39772 | 187904 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 167 Jessie St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6011967.30497 | 2114536.3793599997 | 37.7867878051538 | -122.402365823018 | (37.7867878051538, -122.402365823018) | |||
42447 | 42447 | 42181 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 649 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | 4 | Permit Number 42465 | 6012754.97243 | 2111452.86272 | 37.778365119997204 | -122.399424104664 | (37.7783651199972, -122.399424104664) | |
43888 | 43888 | 187906 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 167 Jessie St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6011990.7752 | 2114556.67649 | 37.7868448464448 | -122.402286048678 | (37.7868448464448, -122.402286048678) | |||
44821 | 44821 | 189058 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 811 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6011753.69364 | 2110494.1907 | 37.7756769690586 | -122.402820480686 | (37.7756769690586, -122.402820480686) | |||
46595 | 46595 | 203410 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1945 08th Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 6ft | 5993793.04129 | 2102233.18002 | 37.7519751701323 | -122.464350430425 | (37.7519751701323, -122.464350430425) | |||
46703 | 46703 | 220409 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1504 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009386.52953 | 2107743.37871 | 37.7679914221935 | -122.410814800755 | (37.7679914221935, -122.410814800755) | |||
49678 | 49678 | 220455 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2125 Bryant St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009601.34044 | 2104903.8675599997 | 37.7602068159157 | -122.409871324719 | (37.7602068159157, -122.409871324719) | |||
52366 | 52366 | 187913 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 5 Natoma St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6013740.8132 | 2115359.33428 | 37.7891462907102 | -122.396287558027 | (37.7891462907102, -122.396287558027) | |||
55050 | 55050 | 66327 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1231 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1991 12:00:00 AM | 4 | Permit Number 29446 | 5987052.1054 | 2106857.6987 | 37.7642819711606 | -122.48800101763901 | (37.7642819711606, -122.488001017639) | |
56914 | 56914 | 220415 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1601 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009485.58878 | 2106996.6595099997 | 37.7659466570249 | -122.410419431833 | (37.7659466570249, -122.410419431833) | |||
59216 | 59216 | 185222 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2507 34th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5985796.7937 | 2098135.752 | 37.740260579141 | -122.491700620712 | (37.740260579141, -122.491700620712) | |||
60498 | 60498 | 175129 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 211 Hanover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6000010.16428 | 2086668.02018 | 37.7095932687863 | -122.441733813766 | (37.7095932687863, -122.441733813766) | |||
60711 | 60711 | 187936 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 255 Fremont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6014368.82149 | 2115126.24847 | 37.7885412160406 | -122.394098386929 | (37.7885412160406, -122.394098386929) | |||
60824 | 60824 | 121501 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 299 Fremont St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 4 | 10x4 | 6014441.60375 | 2115047.86993 | 37.7883300516388 | -122.39384108102101 | (37.7883300516388, -122.393841081021) | |||
61836 | 61836 | 81719 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 998 Indiana St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/27/2004 12:00:00 AM | 4 | 6014948.610719999 | 2104053.54358 | 37.7581702363807 | -122.391318049186 | (37.7581702363807, -122.391318049186) | ||
63579 | 63579 | 220446 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2429 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6009737.03412 | 2103201.22316 | 37.7555393416751 | -122.409281867669 | (37.7555393416751, -122.409281867669) | |||
64431 | 64431 | 203399 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1898 08th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5993788.70878 | 2102627.32377 | 37.7530571381766 | -122.464394026856 | (37.7530571381766, -122.464394026856) | |||
66162 | 66162 | 220451 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2339 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009708.84031 | 2103735.16133 | 37.7570038363854 | -122.409417051059 | (37.7570038363854, -122.409417051059) | |||
67269 | 67269 | 187864 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 801 Arkansas St | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6013072.09173 | 2103413.5567099997 | 37.7563086487315 | -122.397763018152 | (37.7563086487315, -122.397763018152) | ||||
67330 | 67330 | 220407 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1320 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009368.17271 | 2108071.27488 | 37.7688907199643 | -122.410901456736 | (37.7688907199643, -122.410901456736) | |||
70825 | 70825 | 189066 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 521 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6013735.14278 | 2112387.07191 | 37.7809848280366 | -122.396098793052 | (37.7809848280366, -122.396098793052) | |||
73338 | 73338 | 187861 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1000 22nd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6014851.37518 | 2103923.26798 | 37.7578071306235 | -122.391645226173 | (37.7578071306235, -122.391645226173) | |||
77000 | 77000 | 220420 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1601 Bryant St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009463.61799 | 2107301.1800599997 | 37.766781568731 | -122.410516930005 | (37.766781568731, -122.410516930005) | |||
78007 | 78007 | 121222 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 690 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6007452.0 | 2105652.0 | 37.7621403241605 | -122.417357915219 | (37.7621403241605, -122.417357915219) | |||
87619 | 87619 | 8233 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1500X Galvez Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/17/2008 12:00:00 AM | 4 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.739696749128896 | -122.385840466933 | (37.7396967491289, -122.385840466933) | ||
117008 | 117008 | 102934 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 801X Church St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6004394.3 | 2104124.7 | 37.757774211767796 | -122.427824502367 | (37.7577742117678, -122.427824502367) | |||
132233 | 132233 | 187912 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 5 Natoma St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6013728.03817 | 2115347.11788 | 37.7891120364521 | -122.396330901758 | (37.7891120364521, -122.396330901758) | |||
132408 | 132408 | 175130 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 10 Watt Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6000121.603519999 | 2086651.0077400003 | 37.7095529054216 | -122.441347441633 | (37.7095529054216, -122.441347441633) | |||
134499 | 134499 | 125410 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 680 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6005899.660080001 | 2112113.57436 | 37.77979479743679 | -122.423186194101 | (37.7797947974368, -122.423186194101) | |||
134712 | 134712 | 220465 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1900 Bryant St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009493.16635 | 2105815.19005 | 37.7627030371354 | -122.410309795471 | (37.7627030371354, -122.410309795471) | |||
136152 | 136152 | 220418 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1601 Bryant St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009481.19591 | 2107096.90885 | 37.7662216724125 | -122.410441705317 | (37.7662216724125, -122.410441705317) | |||
136381 | 136381 | 220447 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2417 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009734.77872 | 2103242.6417 | 37.755652941341296 | -122.409292590292 | (37.7556529413413, -122.409292590292) | |||
141528 | 141528 | 244919 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 250x Divisadero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 6001806.9408 | 2109318.1774 | 37.7718875210524 | -122.437144482547 | (37.7718875210524, -122.437144482547) | |||
147401 | 147401 | 220473 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 346 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6005455.91389 | 2101699.1842400003 | 37.7511743076669 | -122.42398051849399 | (37.7511743076669, -122.423980518494) | |||
150548 | 150548 | 140191 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 282 Shrader St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5997398.2687 | 2109611.1769 | 37.772440432665604 | -122.452415461613 | (37.7724404326656, -122.452415461613) | |||
152287 | 152287 | 244924 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 250x Divisadero St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 6001808.976 | 2109286.2928 | 37.771800089557296 | -122.4371351594 | (37.7718000895573, -122.4371351594) | |||
152412 | 152412 | 189068 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 521 Bryant St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6013786.48532 | 2112440.07138 | 37.781133208981295 | -122.39592488753401 | (37.7811332089813, -122.395924887534) | |||
159682 | 159682 | 220457 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1801 Bryant St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6009539.42698 | 2106062.60789 | 37.7633849831425 | -122.410167264604 | (37.7633849831425, -122.410167264604) | |||
160703 | 160703 | 220463 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1890 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009480.69909 | 2106047.03533 | 37.763338932471704 | -122.41036928652201 | (37.7633389324717, -122.410369286522) | |||
162622 | 162622 | 112592 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1200M Divisadero St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | 3x3 | 6001349.3031 | 2112591.7757 | 37.7808499730483 | -122.438962124144 | (37.7808499730483, -122.438962124144) | |||
162704 | 162704 | 175142 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 199 Hamilton St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 6009135.1326 | 2093603.39042 | 37.7291520547186 | -122.41068566890499 | (37.7291520547186, -122.410685668905) | |||
163928 | 163928 | 187917 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 5 Natoma St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6013888.85856 | 2115506.90932 | 37.7895597342357 | -122.395785680575 | (37.7895597342357, -122.395785680575) | |||
165796 | 165796 | 187862 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1000 22nd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6014817.13681 | 2103921.30652 | 37.7577998442984 | -122.391763500508 | (37.7577998442984, -122.391763500508) | |||
166881 | 166881 | 220441 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2601 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009797.097580001 | 2102115.80725 | 37.75256239684371 | -122.408997567676 | (37.7525623968437, -122.408997567676) | |||
167179 | 167179 | 220466 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2044 Bryant St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009529.8002 | 2105117.4753400004 | 37.7607893248 | -122.410133830538 | (37.7607893248, -122.410133830538) | |||
169734 | 169734 | 189064 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 521 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6013706.30121 | 2112357.56717 | 37.7809022100091 | -122.39619650258801 | (37.7809022100091, -122.396196502588) | |||
173706 | 173706 | 203398 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1898 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5993787.6735 | 2102657.11631 | 37.753138881175 | -122.464399769949 | (37.753138881175, -122.464399769949) | |||
174214 | 174214 | 141990 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 780 FULTON ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6004028.4702 | 2111508.2869 | 37.778027052231394 | -122.42961628033301 | (37.7780270522314, -122.429616280333) | |||
175529 | 175529 | 220429 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1401 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009431.37889 | 2107954.66245 | 37.7685740731712 | -122.41067459375499 | (37.7685740731712, -122.410674593755) | |||
177219 | 177219 | 187863 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1000 22nd St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6014779.35542 | 2103919.85891 | 37.7577937720836 | -122.391894064084 | (37.7577937720836, -122.391894064084) | |||
177732 | 177732 | 123077 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 723 12th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992233.23043 | 2110491.18489 | 37.774559431962 | -122.47034576378599 | (37.774559431962, -122.470345763786) | |||
177808 | 177808 | 112591 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1200X Divisadero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | 3x3 | 6001352.6873 | 2112575.8699 | 37.7808064923129 | -122.438949276348 | (37.7808064923129, -122.438949276348) | |||
181050 | 181050 | 220417 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1601 Bryant St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009481.38524 | 2107076.14024 | 37.7661646571972 | -122.41043958382099 | (37.7661646571972, -122.410439583821) | |||
181583 | 181583 | 187905 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 167 Jessie St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6011979.98788 | 2114548.14877 | 37.786820829172704 | -122.402322770701 | (37.7868208291727, -122.402322770701) | |||
182213 | 182213 | 125408 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 830 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6006361.841019999 | 2113219.81406 | 37.7828583334858 | -122.42166589828001 | (37.7828583334858, -122.42166589828) | |||
183883 | 183883 | 187930 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 111 Spear St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6015248.50297 | 2115743.86859 | 37.790285912521 | -122.391097985077 | (37.790285912521, -122.391097985077) | |||
185558 | 185558 | 220438 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2814 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6009797.76242 | 2100932.26628 | 37.749312693037 | -122.40891177146001 | (37.749312693037, -122.40891177146) | |||
187818 | 187818 | 81723 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 998 Indiana St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/27/2004 12:00:00 AM | 4 | 6014945.424980001 | 2104137.64024 | 37.7584009709475 | -122.39133494566201 | (37.7584009709475, -122.391334945662) |
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");