Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▼ | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28 | 28 | 21823 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2741 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2006 12:00:00 AM | 3 | 4x4 | 6008229.33947 | 2122327.41953 | 37.8079706947476 | -122.415850241604 | (37.8079706947476, -122.415850241604) | ||
33 | 33 | 2889 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1545 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 65 | 3X3 | 6006951.47041 | 2116025.01423 | 37.79059395549061 | -122.419825138035 | (37.7905939554906, -122.419825138035) | |||
55 | 55 | 2909 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1700 California St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 4X4 | 6006037.49643 | 2115968.63965 | 37.7903876339283 | -122.422983431149 | (37.7903876339283, -122.422983431149) | |||
75 | 75 | 138824 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 729 GROVE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6004305.1004 | 2111150.1162 | 37.77705926326529 | -122.428633779399 | (37.7770592632653, -122.428633779399) | |||
111 | 111 | 7749 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 400X Franklin St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3X3 | 6006371.15759 | 2111615.2483900003 | 37.7784531123456 | -122.421519673008 | (37.7784531123456, -122.421519673008) | |||
157 | 157 | 3193 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3698 California St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3X3 | 5996969.37189 | 2114704.2549799997 | 37.7864001056199 | -122.454266992435 | (37.7864001056199, -122.454266992435) | |||
180 | 180 | 18700 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100X Richardson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5999457.6873699995 | 2119517.78462 | 37.799759164102895 | -122.44600442526199 | (37.7997591641029, -122.446004425262) | |||
356 | 356 | 5230 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1051 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/2004 12:00:00 AM | 3 | 4x4 | 6001389.4157 | 2112056.3671 | 37.7793821590717 | -122.43878497743201 | (37.7793821590717, -122.438784977432) | ||
408 | 408 | 23369 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1350 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 4x4 | 6006387.07969 | 2115184.64805 | 37.788254707334 | -122.421718185767 | (37.788254707334, -122.421718185767) | |||
423 | 423 | 109554 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300x Van Ness Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6006839.87541 | 2111919.81075 | 37.7793157843461 | -122.41991981597201 | (37.7793157843461, -122.419919815972) | |||
425 | 425 | 251299 | Planning Code 138.1 required 4 | Platanus x hispanica :: Sycamore: London Plane 15 | 2190X Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4X4 | 6003624.7851 | 2107240.8343 | 37.766286807234295 | -122.430708166736 | (37.7662868072343, -122.430708166736) | ||||
431 | 431 | 251298 | Planning Code 138.1 required 4 | Platanus x hispanica :: Sycamore: London Plane 15 | 2190X Market St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4X4 | 6003624.7851 | 2107240.8343 | 37.766286807234295 | -122.430708166736 | (37.7662868072343, -122.430708166736) | ||||
432 | 432 | 251297 | Planning Code 138.1 required 4 | Platanus x hispanica :: Sycamore: London Plane 15 | 2190X Market St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4X4 | 6003624.7851 | 2107240.8343 | 37.766286807234295 | -122.430708166736 | (37.7662868072343, -122.430708166736) | ||||
435 | 435 | 95185 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401X Divisadero St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6001223.4102 | 2113260.1588 | 37.78267801898829 | -122.43944557401699 | (37.7826780189883, -122.439445574017) | |||
446 | 446 | 251296 | Planning Code 138.1 required 4 | Platanus x hispanica :: Sycamore: London Plane 15 | 2190X Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4X4 | 6003624.7851 | 2107240.8343 | 37.766286807234295 | -122.430708166736 | (37.7662868072343, -122.430708166736) | ||||
488 | 488 | 2821 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1100X California St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 6008831.67633 | 2116355.92064 | 37.7916082855564 | -122.41334312239701 | (37.7916082855564, -122.413343122397) | |||
521 | 521 | 5204 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 777 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 04/21/2016 12:00:00 AM | 3 | 4X4 | 6001528.9942 | 2111019.6475 | 37.7765435284866 | -122.438227828795 | (37.7765435284866, -122.438227828795) | |
534 | 534 | 2998 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2314 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 6003265.59996 | 2115577.92692 | 37.7891580349704 | -122.43254607984501 | (37.7891580349704, -122.432546079845) | |||
537 | 537 | 195070 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1532 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008830.0 | 2108632.0 | 37.7704001487298 | -122.41280261366998 | (37.7704001487298, -122.41280261367) | |||
550 | 550 | 3006 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2380 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 75 | 3X3 | 6002989.49365 | 2115542.57517 | 37.7890453067372 | -122.433498845012 | (37.7890453067372, -122.433498845012) | |||
567 | 567 | 195068 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1532 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008830.0 | 2108632.0 | 37.7704001487298 | -122.41280261366998 | (37.7704001487298, -122.41280261367) | |||
612 | 612 | 23503 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2550 Van Ness Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6005820.29029 | 2119236.56275 | 37.7993482683535 | -122.42396743424999 | (37.7993482683535, -122.42396743425) | |||
777 | 777 | 234744 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2455 15th St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12 | Width 3ft | 6001486.4222099995 | 2107220.2274599997 | 37.766108846174795 | -122.438102867577 | (37.7661088461748, -122.438102867577) | |||
861 | 861 | 109545 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300x Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6006870.4118800005 | 2111707.44564 | 37.778734401395205 | -122.419799104459 | (37.7787344013952, -122.419799104459) | |||
997 | 997 | 95184 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401X Divisadero St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6001220.026000001 | 2113275.7262 | 37.7827205704951 | -122.439458398161 | (37.7827205704951, -122.439458398161) | |||
1085 | 1085 | 245467 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3286 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/10/2004 12:00:00 AM | 6 | Width 0ft | 6006306.9956 | 2099162.9834 | 37.7442584900037 | -122.42085734017799 | (37.7442584900037, -122.420857340178) | ||
1115 | 1115 | 2987 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2266X California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 6003539.7936 | 2115618.85396 | 37.7892859554236 | -122.431600327591 | (37.7892859554236, -122.431600327591) | |||
1136 | 1136 | 3286 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 4620 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5993188.57682 | 2114188.1560400003 | 37.784765502430794 | -122.467309935148 | (37.7847655024308, -122.467309935148) | |||
1198 | 1198 | 3004 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2361 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 6003049.1023 | 2115481.5645 | 37.788881168762295 | -122.433288245694 | (37.7888811687623, -122.433288245694) | |||
1318 | 1318 | 100805 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2429 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6002563.2899400005 | 2116751.5140400003 | 37.79234055221529 | -122.43505995207899 | (37.7923405522153, -122.435059952079) | |||
1319 | 1319 | 23465 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2305 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3X3 | 6005845.91849 | 2118326.2505200002 | 37.796850228717105 | -122.42381398834699 | (37.7968502287171, -122.423813988347) | |||
1429 | 1429 | 102682 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2100 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 4x4 | 6001423.65551 | 2115717.83054 | 37.7894375487454 | -122.438928994703 | (37.7894375487454, -122.438928994703) | |||
1478 | 1478 | 2891 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1555 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 65 | 3x3 | 6006907.6574099995 | 2116020.89539 | 37.7905801778777 | -122.419976436385 | (37.7905801778777, -122.419976436385) | |||
1506 | 1506 | 3068 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2848 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6000738.310819999 | 2115229.75603 | 37.788058406004296 | -122.441265170758 | (37.7880584060043, -122.441265170758) | |||
1584 | 1584 | 3173 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3506 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/01/1992 12:00:00 AM | 6 | 3X3 | 5997608.68374 | 2114790.70836 | 37.786674124564 | -122.45206138623301 | (37.786674124564, -122.452061386233) | ||
1685 | 1685 | 251478 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2x Virginia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 02/21/2004 12:00:00 AM | 3x3 | 6006146.0 | 2098692.0 | 37.7429562000135 | -122.42138058886101 | (37.7429562000135, -122.421380588861) | ||
1692 | 1692 | 2957 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2045 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6004590.8896 | 2115694.3359 | 37.7895527302687 | -122.427969040021 | (37.7895527302687, -122.427969040021) | |||
1721 | 1721 | 23308 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/1998 12:00:00 AM | 5 | 3X3 | 6006538.20918 | 2114040.94612 | 37.785122904641796 | -122.42111406077 | (37.7851229046418, -122.42111406077) | ||
1733 | 1733 | 200858 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1133 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6008786.0 | 2112009.0 | 37.7796701249263 | -122.413193644333 | (37.7796701249263, -122.413193644333) | |||
1740 | 1740 | 200859 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1133 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6008786.0 | 2112009.0 | 37.7796701249263 | -122.413193644333 | (37.7796701249263, -122.413193644333) | |||
1753 | 1753 | 134350 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 838 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6010747.0 | 2114018.0 | 37.7852962621335 | -122.40655126994301 | (37.7852962621335, -122.406551269943) | |||
1888 | 1888 | 100797 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2471 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002362.24857 | 2116725.90576 | 37.7922588209311 | -122.435753725979 | (37.7922588209311, -122.435753725979) | |||
1925 | 1925 | 2958 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2055 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6004523.0139999995 | 2115687.6045 | 37.7895304073237 | -122.428203402517 | (37.7895304073237, -122.428203402517) | |||
1989 | 1989 | 133618 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 150 Richardson Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 5999272.2292 | 2119684.41545 | 37.8002060956892 | -122.446658172159 | (37.8002060956892, -122.446658172159) | |||
2070 | 2070 | 109552 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300x Van Ness Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6006854.31545 | 2111807.2543900004 | 37.7790075453087 | -122.419861872643 | (37.7790075453087, -122.419861872643) | |||
2088 | 2088 | 3013 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2450 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6002627.84431 | 2115492.11411 | 37.7888862283618 | -122.43474649336599 | (37.7888862283618, -122.434746493366) | |||
2096 | 2096 | 200850 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1411 Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6007584.0 | 2110630.0 | 37.77581616716321 | -122.417254147161 | (37.7758161671632, -122.417254147161) | |||
2108 | 2108 | 98580 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 370 Drumm St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2017 12:00:00 AM | 3 | 3x3 | 6013585.68076 | 2118314.1263900003 | 37.7972508218322 | -122.397031561762 | (37.7972508218322, -122.397031561762) | ||
2114 | 2114 | 107983 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 2405x Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6001231.007069999 | 2116743.47753 | 37.7922427464694 | -122.43966909537599 | (37.7922427464694, -122.439669095376) | |||
2167 | 2167 | 3158 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3410 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5998012.98689 | 2114846.6357400003 | 37.7868508368504 | -122.45066663485201 | (37.7868508368504, -122.450666634852) | |||
2205 | 2205 | 123677 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 4308 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 5994223.96504 | 2114319.57116 | 37.7851860492976 | -122.46373740171002 | (37.7851860492976, -122.46373740171) | |||
2299 | 2299 | 253020 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 760 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004216.0 | 2110862.0 | 37.7762631241711 | -122.42892145951299 | (37.7762631241711, -122.428921459513) | ||||
2306 | 2306 | 195019 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X 02nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6013637.791730001 | 2113971.74755 | 37.785330566207705 | -122.396546695873 | (37.7853305662077, -122.396546695873) | |||
2315 | 2315 | 195022 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X 02nd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6013709.75083 | 2113894.09551 | 37.785121356022394 | -122.39629229296001 | (37.7851213560224, -122.39629229296) | |||
2335 | 2335 | 195021 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X 02nd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6013679.6407 | 2113928.34961 | 37.7852137343684 | -122.396398867136 | (37.7852137343684, -122.396398867136) | |||
2336 | 2336 | 195020 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X 02nd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6013662.142659999 | 2113947.50545 | 37.785265358143896 | -122.39646074858601 | (37.7852653581439, -122.396460748586) | |||
2343 | 2343 | 195028 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X 02nd St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6013774.91802 | 2113824.49769 | 37.7849338824287 | -122.396061954106 | (37.7849338824287, -122.396061954106) | |||
2347 | 2347 | 195023 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X 02nd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6013717.57682 | 2113887.99977 | 37.785105053996396 | -122.396264789902 | (37.7851050539964, -122.396264789902) | |||
2352 | 2352 | 195026 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X 02nd St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6013748.5801800005 | 2113848.78027 | 37.7849990913834 | -122.39615477762301 | (37.7849990913834, -122.396154777623) | |||
2355 | 2355 | 195025 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X 02nd St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6013739.901380001 | 2113861.81988 | 37.7850344122501 | -122.396185717917 | (37.7850344122501, -122.396185717917) | |||
2358 | 2358 | 195024 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X 02nd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6013723.336209999 | 2113877.98804 | 37.785077884566604 | -122.39624416214 | (37.7850778845666, -122.39624416214) | |||
2359 | 2359 | 195027 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X 02nd St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6013762.26581 | 2113837.6181400004 | 37.784969204212295 | -122.396106646824 | (37.7849692042123, -122.396106646824) | |||
2622 | 2622 | 238126 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3388 17th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2017 02:38:00 PM | 3 | Width 3ft | 6006363.87344 | 2106134.73006 | 37.7634045065344 | -122.421155613935 | (37.7634045065344, -122.421155613935) | ||
2686 | 2686 | 234760 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 252 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6004468.902369999 | 2109137.1444099997 | 37.77154140335671 | -122.427923663451 | (37.7715414033567, -122.427923663451) | |||
2690 | 2690 | 126183 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1451 Bay St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6003793.92894 | 2120715.46368 | 37.803294337014606 | -122.431084963893 | (37.8032943370146, -122.431084963893) | |||
2730 | 2730 | 7762 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 455 Franklin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6006322.26322 | 2111614.07343 | 37.7784471291735 | -122.421688733864 | (37.7784471291735, -122.421688733864) | |||
2733 | 2733 | 253189 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 99x The Embarcadero | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014645.0 | 2117171.0 | 37.794170975650296 | -122.393285986986 | (37.7941709756503, -122.393285986986) | ||||
2735 | 2735 | 253188 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 99x The Embarcadero | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014645.0 | 2117171.0 | 37.794170975650296 | -122.393285986986 | (37.7941709756503, -122.393285986986) | ||||
2737 | 2737 | 253186 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 99x The Embarcadero | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014645.0 | 2117171.0 | 37.794170975650296 | -122.393285986986 | (37.7941709756503, -122.393285986986) | ||||
2738 | 2738 | 253184 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 99x The Embarcadero | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014645.0 | 2117171.0 | 37.794170975650296 | -122.393285986986 | (37.7941709756503, -122.393285986986) | ||||
2739 | 2739 | 253185 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 99x The Embarcadero | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014645.0 | 2117171.0 | 37.794170975650296 | -122.393285986986 | (37.7941709756503, -122.393285986986) | ||||
2741 | 2741 | 253190 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 99x The Embarcadero | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014645.0 | 2117171.0 | 37.794170975650296 | -122.393285986986 | (37.7941709756503, -122.393285986986) | ||||
2744 | 2744 | 253187 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 99x The Embarcadero | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014645.0 | 2117171.0 | 37.794170975650296 | -122.393285986986 | (37.7941709756503, -122.393285986986) | ||||
2810 | 2810 | 23452 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2209 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6005880.951090001 | 2118079.82441 | 37.796175582497504 | -122.423675237326 | (37.7961755824975, -122.423675237326) | |||
2877 | 2877 | 2888 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1541 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 65 | 3X3 | 6007004.32462 | 2116031.27674 | 37.7906141281881 | -122.41964270965201 | (37.7906141281881, -122.419642709652) | |||
2892 | 2892 | 99717 | Private 5 | Platanus x hispanica :: Sycamore: London Plane 15 | 1415 Scott St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6001694.9164 | 2113468.8804 | 37.7832779377979 | -122.437829320807 | (37.7832779377979, -122.437829320807) | |||
2942 | 2942 | 95170 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1306 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/2015 12:00:00 AM | 3 | 3x3 | 6001329.6747 | 2112935.9507 | 37.781793873207 | -122.439054702012 | (37.781793873207, -122.439054702012) | ||
3160 | 3160 | 109437 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 940 Grove St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 4x6 | 6003136.3777 | 2111029.1486 | 37.7766609049 | -122.432668109569 | (37.7766609049, -122.432668109569) | |||
3185 | 3185 | 3123 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3195 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X2 | 5999194.2227 | 2114949.0037 | 37.787199455340705 | -122.44658721654801 | (37.7871994553407, -122.446587216548) | |||
3277 | 3277 | 3186 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3633 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 5997046.4391 | 2114650.2263 | 37.7862561763922 | -122.45399645741999 | (37.7862561763922, -122.45399645742) | |||
3301 | 3301 | 3014 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2450 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | 3X3 | 6002569.4448 | 2115483.65814 | 37.7888596947603 | -122.43494794241501 | (37.7888596947603, -122.434947942415) | |||
3391 | 3391 | 2983 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2226 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6003696.67837 | 2115640.99047 | 37.7893556277051 | -122.431059105706 | (37.7893556277051, -122.431059105706) | |||
3442 | 3442 | 2868 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1389 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6007715.890269999 | 2116130.82655 | 37.790927523941704 | -122.417187783496 | (37.7909275239417, -122.417187783496) | |||
3452 | 3452 | 2818 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1100X California St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6008957.0218 | 2116372.57941 | 37.79166106316271 | -122.412910605154 | (37.7916610631627, -122.412910605154) | |||
3454 | 3454 | 23347 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1245 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 0 | 6006327.19373 | 2114871.36437 | 37.7873911306548 | -122.421903118752 | (37.7873911306548, -122.421903118752) | |||
3460 | 3460 | 249511 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1243 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6006333.62129 | 2114827.84877 | 37.7872720100542 | -122.421877788428 | (37.7872720100542, -122.421877788428) | |||
3638 | 3638 | 2840 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1255 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6008320.47773 | 2116218.27733 | 37.7912016363983 | -122.41510212258301 | (37.7912016363983, -122.415102122583) | |||
3673 | 3673 | 3073 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2880 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/12/1998 12:00:00 AM | 3 | 3X3 | 6000583.9217 | 2115208.18648 | 37.7879903857924 | -122.44179777983999 | (37.7879903857924, -122.44179777984) | ||
3722 | 3722 | 2900 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1675 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6006330.22809 | 2115940.35545 | 37.7903264863286 | -122.4219685876 | (37.7903264863286, -122.4219685876) | |||
3836 | 3836 | 3098 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3014 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 5999901.41366 | 2115112.8463 | 37.7876896938595 | -122.444152274206 | (37.7876896938595, -122.444152274206) | |||
3891 | 3891 | 2801 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000X California St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3X3 | 6009324.7749 | 2116423.80567 | 37.791822353872796 | -122.411641798449 | (37.7918223538728, -122.411641798449) | |||
4013 | 4013 | 253610 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1075 Mission St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 4ft | 6009725.02676 | 2112060.52163 | 37.7798642637711 | -122.40994876804 | (37.7798642637711, -122.40994876804) | ||||
4313 | 4313 | 2803 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1055 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3X3 | 6009318.69522 | 2116357.3469700003 | 37.791639533399795 | -122.41165813642999 | (37.7916395333998, -122.41165813643) | |||
4339 | 4339 | 3082 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2913 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 6000319.2838 | 2115099.7465 | 37.7876775552832 | -122.442705587482 | (37.7876775552832, -122.442705587482) | |||
4361 | 4361 | 2887 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1530 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 65 | 3x3 | 6007023.220480001 | 2116101.4928900003 | 37.7908079887437 | -122.41958231479401 | (37.7908079887437, -122.419582314794) | |||
4471 | 4471 | 100799 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2455 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6002438.67863 | 2116735.02721 | 37.7922882071812 | -122.435489929626 | (37.7922882071812, -122.435489929626) | |||
4495 | 4495 | 2802 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1055 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3X3 | 6009267.5769 | 2116351.4322900004 | 37.7916204254988 | -122.411834587904 | (37.7916204254988, -122.411834587904) | |||
4567 | 4567 | 109546 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300x Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6006868.4272 | 2111721.79621 | 37.778773692788 | -122.419806988803 | (37.778773692788, -122.419806988803) | |||
4621 | 4621 | 122573 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2014 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | 6003898.8446 | 2115409.2515 | 37.7887307847056 | -122.430343093484 | (37.7887307847056, -122.430343093484) | |||
4628 | 4628 | 3096 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3003 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 5999955.8775 | 2115049.7006 | 37.787519419160795 | -122.443959301682 | (37.7875194191608, -122.443959301682) |
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");