Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantDate, PlotSize, PermitNotes
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4735 | 4735 | 226781 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 466 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 7x8 | 6003584.13439 | 2105555.33075 | 37.7616565176582 | -122.430728478955 | (37.7616565176582, -122.430728478955) | |||
13590 | 13590 | 122711 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 225 Arkansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6012928.83224 | 2105933.48701 | 37.763219845153706 | -122.398435273093 | (37.7632198451537, -122.398435273093) | |||
19790 | 19790 | 53252 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 18 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/1969 12:00:00 AM | 7 | Permit Number 6139 | 6004056.10022951 | 2102948.9340362 | 37.754526698445 | -122.428910313961 | (37.754526698445, -122.428910313961) | ||
25893 | 25893 | 226384 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 15 Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007204.63358 | 2097592.3752900003 | 37.7399965053243 | -122.417642194748 | (37.7399965053243, -122.417642194748) | |||
25940 | 25940 | 226434 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 106 Bartlett St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006662.06006 | 2103117.82252 | 37.7551375848404 | -122.419910185127 | (37.7551375848404, -122.419910185127) | |||
27605 | 27605 | 39569 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 806 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | 7 | Permit Number 40988 | 6011543.776869999 | 2104583.27285 | 37.7594352029858 | -122.40313076567101 | (37.7594352029858, -122.403130765671) | |
33023 | 33023 | 229856 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 119 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6005420.32438 | 2102982.74414 | 37.7546966562501 | -122.42419486740299 | (37.7546966562501, -122.424194867403) | |||
33217 | 33217 | 247662 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 108 Divisadero St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6001959.68947 | 2108344.83823 | 37.769223654362605 | -122.436546435187 | (37.7692236543626, -122.436546435187) | |||
33332 | 33332 | 226355 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2175 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008795.60516 | 2105650.73446 | 37.7622123526471 | -122.412710792894 | (37.7622123526471, -122.412710792894) | |||
34320 | 34320 | 190702 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 648 Carolina St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6012372.026430001 | 2104905.9974700003 | 37.760367552645704 | -122.40028892061899 | (37.7603675526457, -122.400288920619) | |||
36119 | 36119 | 226431 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 106 Bartlett St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006664.9239300005 | 2103021.2685 | 37.7548726310745 | -122.419893429847 | (37.7548726310745, -122.419893429847) | |||
38255 | 38255 | 229744 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1 27th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006129.97006 | 2100227.1008099997 | 37.747170335258204 | -122.421545017711 | (37.7471703352582, -122.421545017711) | |||
40061 | 40061 | 226772 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 580 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6002600.09968 | 2103291.6140799997 | 37.7553850962495 | -122.433970034883 | (37.7553850962495, -122.433970034883) | |||
41064 | 41064 | 226779 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3974 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003146.2455400005 | 2105369.3554599998 | 37.76112105592 | -122.432229675877 | (37.76112105592, -122.432229675877) | |||
42197 | 42197 | 226381 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 60 Nebraska St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 6009264.00065 | 2097705.48363 | 37.740422744414396 | -122.410529710297 | (37.7404227444144, -122.410529710297) | |||
43399 | 43399 | 226803 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 4187 20th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6002522.14485 | 2104118.46632 | 37.7576510101026 | -122.434298737121 | (37.7576510101026, -122.434298737121) | |||
48315 | 48315 | 190746 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1725 Newcomb Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 6014545.668430001 | 2096162.71895 | 37.7364813198484 | -122.392159766062 | (37.7364813198484, -122.392159766062) | |||
50747 | 50747 | 229889 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 77 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008249.8814900005 | 2099665.88685 | 37.7457486716635 | -122.414174809135 | (37.7457486716635, -122.414174809135) | |||
53105 | 53105 | 47677 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 442 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/2002 12:00:00 AM | 7 | 6x7 | Permit Number 45461 | 6014320.2471199995 | 2105057.7059400002 | 37.7608925552604 | -122.39356149707301 | (37.7608925552604, -122.393561497073) |
56206 | 56206 | 226427 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 106 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006674.0476 | 2102914.93571 | 37.7545811796958 | -122.419854332733 | (37.7545811796958, -122.419854332733) | |||
57747 | 57747 | 248027 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 423 Franconia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6009988.36995 | 2098561.68629 | 37.7428142746487 | -122.40808548247 | (37.7428142746487, -122.40808548247) | |||
57922 | 57922 | 226353 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3027 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6009058.07626 | 2100853.8453 | 37.7490559051208 | -122.41146409148999 | (37.7490559051208, -122.41146409149) | |||
58077 | 58077 | 226413 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1420 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6009277.36888 | 2100886.8777799997 | 37.7491589026595 | -122.41070810519 | (37.7491589026595, -122.41070810519) | |||
59686 | 59686 | 226329 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 351 Shotwell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007821.99816 | 2105868.6324299998 | 37.7627559568505 | -122.416093572069 | (37.7627559568505, -122.416093572069) | |||
60214 | 60214 | 229847 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3494 21st St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6005127.97551 | 2103724.2468 | 37.756716137850795 | -122.42525865118999 | (37.7567161378508, -122.42525865119) | |||
62717 | 62717 | 78495 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1300 Rhode Island St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/2000 12:00:00 AM | 7 | 6011953.72275 | 2102256.16538 | 37.7530683626141 | -122.40154940677401 | (37.7530683626141, -122.401549406774) | ||
63739 | 63739 | 39570 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 806 Kansas St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | 7 | Permit Number 40988 | 6011544.20572 | 2104572.19135 | 37.759404799599 | -122.403128503001 | (37.759404799599, -122.403128503001) | |
65742 | 65742 | 105894 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 635 Texas St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6013871.777480001 | 2104094.2415400003 | 37.758222162353704 | -122.395045082568 | (37.7582221623537, -122.395045082568) | |||
73438 | 73438 | 190716 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 333 Arkansas St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 6012961.26572 | 2105490.25457 | 37.7620046335244 | -122.398291995789 | (37.7620046335244, -122.398291995789) | |||
75690 | 75690 | 229799 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 69 Lapidge St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006019.542880001 | 2105120.91089 | 37.7606013799572 | -122.422274509073 | (37.7606013799572, -122.422274509073) | |||
76385 | 76385 | 58933 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1330 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/1980 12:00:00 AM | 7 | Permit Number 18211 | 6011958.83687 | 2102173.2877700003 | 37.752841084147704 | -122.401525896729 | (37.7528410841477, -122.401525896729) | ||
76600 | 76600 | 226396 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1483 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008038.2899400005 | 2099516.86307 | 37.7453275982942 | -122.41489591881 | (37.7453275982942, -122.41489591881) | |||
90724 | 90724 | 226444 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3184 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008475.72782 | 2101569.16263 | 37.750987325127 | -122.413528448383 | (37.750987325127, -122.413528448383) | |||
132037 | 132037 | 226447 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3170 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007854.47288 | 2102702.51383 | 37.7540643473922 | -122.415757056543 | (37.7540643473922, -122.415757056543) | |||
132827 | 132827 | 190721 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2200 Alameda St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6010462.79733 | 2107890.40635 | 37.7684554148125 | -122.40710245603901 | (37.7684554148125, -122.407102456039) | |||
133554 | 133554 | 190713 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 529 Texas St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6013844.9587900005 | 2104593.96331 | 37.759592798384105 | -122.395172837551 | (37.7595927983841, -122.395172837551) | |||
134772 | 134772 | 229800 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 230 Lexington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006477.6106 | 2104743.99354 | 37.75959228038 | -122.42066350043899 | (37.75959228038, -122.420663500439) | |||
136393 | 136393 | 226440 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 501 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006828.6728300005 | 2100820.93756 | 37.748840248593396 | -122.419171070095 | (37.7488402485934, -122.419171070095) | |||
137231 | 137231 | 229818 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 990 Treat Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6008585.67153 | 2102788.11843 | 37.7543404761497 | -122.41323443932801 | (37.7543404761497, -122.413234439328) | |||
139792 | 139792 | 104962 | Private 5 | Jacaranda mimosifolia :: Jacaranda 52 | 1474X SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 74 Aztec St. | 6008023.0 | 2099506.0 | 37.7452969115591 | -122.414948020341 | (37.7452969115591, -122.414948020341) | ||
147318 | 147318 | 226768 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 508 Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6001810.12784 | 2102797.39865 | 37.7539832366425 | -122.436666617866 | (37.7539832366425, -122.436666617866) | |||
147445 | 147445 | 226428 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 106 Bartlett St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006671.335630001 | 2102940.18758 | 37.7546503627401 | -122.419865503217 | (37.7546503627401, -122.419865503217) | |||
147455 | 147455 | 226787 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 166 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6002663.06838 | 2104932.4361099997 | 37.7598939732341 | -122.43386954555001 | (37.7598939732341, -122.43386954555) | |||
147524 | 147524 | 226349 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3169 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008560.82259 | 2101530.27945 | 37.7508853383864 | -122.413231431983 | (37.7508853383864, -122.413231431983) | |||
147956 | 147956 | 48401 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1170 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2008 12:00:00 AM | 7 | 3x3 | Permit Number 50635 | 6011912.33745 | 2102971.80272 | 37.7550310367587 | -122.40174282399799 | (37.7550310367587, -122.401742823998) | |
150086 | 150086 | 190727 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2211 Alameda St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6010484.13409 | 2107848.45184 | 37.768341411351706 | -122.407025696183 | (37.7683414113517, -122.407025696183) | |||
154047 | 154047 | 226354 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2531 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008912.12857 | 2103526.86687 | 37.756387235107496 | -122.41215767113998 | (37.7563872351075, -122.41215767114) | |||
155639 | 155639 | 226379 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 424 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008895.67252 | 2096317.34788 | 37.736590569490104 | -122.41170519075199 | (37.7365905694901, -122.411705190752) | |||
156104 | 156104 | 226423 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 582 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007852.94487 | 2104547.46953 | 37.7591300882142 | -122.415892978285 | (37.7591300882142, -122.415892978285) | |||
159380 | 159380 | 248006 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 444 Franconia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6009948.03902 | 2098416.30132 | 37.7424128208876 | -122.408214684483 | (37.7424128208876, -122.408214684483) | |||
160629 | 160629 | 228542 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1465 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 6ft | 6009587.77635 | 2100703.29886 | 37.748672234533295 | -122.409621752043 | (37.7486722345333, -122.409621752043) | |||
161626 | 161626 | 226818 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 272 Corbett Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | Width 3ft | 5999639.14958 | 2105380.58985 | 37.7609524294432 | -122.44435997895599 | (37.7609524294432, -122.444359978956) | |||
161657 | 161657 | 39574 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 863 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | 7 | Permit Number 40991 | 6011617.31177 | 2104338.8923 | 37.758768294548105 | -122.402859256767 | (37.7587682945481, -122.402859256767) | |
162626 | 162626 | 226330 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 351 Shotwell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007820.8839300005 | 2105900.2229299997 | 37.7628426343977 | -122.416099663169 | (37.7628426343977, -122.416099663169) | |||
162916 | 162916 | 229857 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 119 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6005419.16743 | 2102997.26245 | 37.754736454825704 | -122.42419990093 | (37.7547364548257, -122.42419990093) | |||
162976 | 162976 | 248227 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 38 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007014.76999 | 2099297.76945 | 37.7446684509831 | -122.418419557911 | (37.7446684509831, -122.418419557911) | |||
164194 | 164194 | 229821 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 862 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6009901.39603 | 2104182.38613 | 37.758242602143795 | -122.40878266838001 | (37.7582426021438, -122.40878266838) | |||
165182 | 165182 | 226799 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 701 Sanchez St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 6003733.12478 | 2104096.2711400003 | 37.7576587280713 | -122.43010909155899 | (37.7576587280713, -122.430109091559) | |||
166188 | 166188 | 226807 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 48 Henry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003212.25535 | 2107433.99017 | 37.7667937860223 | -122.432148823236 | (37.7667937860223, -122.432148823236) | |||
168009 | 168009 | 49995 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 908@ 20TH ST Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2003 12:00:00 AM | 7 | Permit Number 46738 | 6011567.9770599995 | 2104146.58896 | 37.7582375173758 | -122.403016353927 | (37.7582375173758, -122.403016353927) | |
168280 | 168280 | 138954 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 719 Buchanan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6004474.5770000005 | 2110934.0085 | 37.7764754744029 | -122.42803210297501 | (37.7764754744029, -122.428032102975) | |||
170050 | 170050 | 228547 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1325 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6009559.03474 | 2101249.47013 | 37.7501702892497 | -122.409759687354 | (37.7501702892497, -122.409759687354) | |||
172206 | 172206 | 226451 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3070 23rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008441.9337 | 2102736.37343 | 37.7541903253234 | -122.41372786314501 | (37.7541903253234, -122.413727863145) | |||
181234 | 181234 | 226785 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3894 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003780.43348 | 2104817.05272 | 37.75964050202929 | -122.429996893968 | (37.7596405020293, -122.429996893968) | |||
181725 | 181725 | 70134 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 342-344 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1994 12:00:00 AM | 7 | 6010584.92199 | 2106684.72003 | 37.7651517084965 | -122.40659506122499 | (37.7651517084965, -122.406595061225) | ||
182992 | 182992 | 190692 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1007 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6015546.55953 | 2104430.7549099997 | 37.7592391453969 | -122.38927640559099 | (37.7592391453969, -122.389276405591) | |||
184211 | 184211 | 190717 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1150 19th St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 6014133.64605 | 2105280.55607 | 37.7614940829991 | -122.39422247538401 | (37.7614940829991, -122.394222475384) | |||
184718 | 184718 | 229816 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 990 Treat Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6008580.21051 | 2102912.8481900003 | 37.7546826492875 | -122.41326214475299 | (37.7546826492875, -122.413262144753) |
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");