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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6002 | 6002 | 95174 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 999 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6001433.5416 | 2111715.5330000003 | 37.7784488251579 | -122.43860789955099 | (37.7784488251579, -122.438607899551) | |||
| 6004 | 6004 | 23524 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2775 Van Ness Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6005640.65577 | 2119801.11522 | 37.800888242254096 | -122.42462921477 | (37.8008882422541, -122.42462921477) | |||
| 6038 | 6038 | 103363 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1171X Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Rec/Park 7 | 12 | 3x3 | 6009142.2805 | 2116694.47646 | 37.79255531122121 | -122.412292370693 | (37.7925553112212, -122.412292370693) | ||
| 6040 | 6040 | 3101 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3044 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5999787.3994 | 2115096.67375 | 37.7876387832368 | -122.444545577416 | (37.7876387832368, -122.444545577416) | |||
| 6047 | 6047 | 2853 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1308 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 6008034.06257 | 2116243.44683 | 37.7912546460273 | -122.41609489677 | (37.7912546460273, -122.41609489677) | |||
| 6062 | 6062 | 3195 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3700X California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3X3 | 5996565.7886 | 2114644.13956 | 37.7862118928056 | -122.45565893343901 | (37.7862118928056, -122.455658933439) | |||
| 6077 | 6077 | 100804 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2429 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6002544.40656 | 2116747.89129 | 37.7923295328255 | -122.435125029709 | (37.7923295328255, -122.435125029709) | |||
| 6079 | 6079 | 3075 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2890 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6000556.19534 | 2115204.1036900003 | 37.787977595635205 | -122.441893414666 | (37.7879775956352, -122.441893414666) | |||
| 6124 | 6124 | 100807 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2401 Jackson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002634.35526 | 2116761.0817299997 | 37.7923708575934 | -122.4348147492 | (37.7923708575934, -122.4348147492) | |||
| 6137 | 6137 | 25721 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 759 Grove St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6004181.0849 | 2111131.7312 | 37.7770017633365 | -122.429061476555 | (37.7770017633365, -122.429061476555) | |||
| 6150 | 6150 | 2899 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1650 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6006450.082230001 | 2116024.17637 | 37.790563396529606 | -122.421559855625 | (37.7905633965296, -122.421559855625) | |||
| 6153 | 6153 | 23261 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 799 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6006565.26272 | 2113169.5548 | 37.7827318024749 | -122.420958573403 | (37.7827318024749, -122.420958573403) | |||
| 6188 | 6188 | 108162 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2559 Van Ness Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2014 12:00:00 AM | 3 | 3x3 | Permit Number 770697 | 6005732.0605 | 2119159.71246 | 37.799132275489505 | -122.424267271834 | (37.7991322754895, -122.424267271834) | |
| 6199 | 6199 | 2940 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1915 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3x3 | 6005167.0236 | 2115779.1152 | 37.789818090233204 | -122.42598171365499 | (37.7898180902332, -122.425981713655) | |||
| 6205 | 6205 | 3110 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3102 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5999466.00709 | 2115051.6328 | 37.7874967686175 | -122.445654287738 | (37.7874967686175, -122.445654287738) | |||
| 6215 | 6215 | 2859 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1350 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3X3 | 6007903.12411 | 2116224.84833 | 37.791196216175706 | -122.41654662355499 | (37.7911962161757, -122.416546623555) | |||
| 6220 | 6220 | 5248 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1135 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/2001 12:00:00 AM | 6 | 3X3 | 6001354.2102 | 2112285.6732 | 37.7800097725211 | -122.438923205225 | (37.7800097725211, -122.438923205225) | ||
| 6224 | 6224 | 2995 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2295 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 6003466.6985 | 2115540.8379 | 37.7890675998104 | -122.43184765502899 | (37.7890675998104, -122.431847655029) | |||
| 6227 | 6227 | 113069 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3108 Fillmore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6002430.41421 | 2118968.02976 | 37.7984189836099 | -122.43567835378 | (37.7984189836099, -122.43567835378) | |||
| 6245 | 6245 | 100808 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2401 Jackson St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002651.17595 | 2116762.40631 | 37.7923754495237 | -122.43475664402399 | (37.7923754495237, -122.434756644024) | |||
| 6269 | 6269 | 5238 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1100 Divisadero St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6001413.0956 | 2112340.8359 | 37.7801645854296 | -122.43872344847 | (37.7801645854296, -122.43872344847) | |||
| 6274 | 6274 | 2837 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1240 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6008427.79674 | 2116298.62891 | 37.7914282925179 | -122.414736489715 | (37.7914282925179, -122.414736489715) | |||
| 6279 | 6279 | 2846 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1270 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 65 | 3X3 | 6008288.14408 | 2116278.11526 | 37.791364119607294 | -122.415218234034 | (37.7913641196073, -122.415218234034) | |||
| 6291 | 6291 | 23262 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 799 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 4X4 | 6006566.1057 | 2113138.6433900003 | 37.782646974809104 | -122.420953461644 | (37.7826469748091, -122.420953461644) | |||
| 6298 | 6298 | 18990 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2961X Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6000644.47898 | 2115503.35818 | 37.7888043010138 | -122.441609453736 | (37.7888043010138, -122.441609453736) | |||
| 6327 | 6327 | 3093 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2996X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6000048.35988 | 2115133.94656 | 37.78775601166729 | -122.44364538665 | (37.7877560116673, -122.44364538665) | |||
| 6346 | 6346 | 23483 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2465 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3X3 | 6005770.57716 | 2118858.36871 | 37.7983070369076 | -122.424112548875 | (37.7983070369076, -122.424112548875) | |||
| 6420 | 6420 | 3031 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2565 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 6002089.0526 | 2115351.2102 | 37.7884687389972 | -122.436600546059 | (37.7884687389972, -122.436600546059) | |||
| 6422 | 6422 | 2980 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2202 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 75 | 3X3 | 6003749.924 | 2115648.7026400003 | 37.789379820361795 | -122.430875432649 | (37.7893798203618, -122.430875432649) | |||
| 6438 | 6438 | 113068 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3108 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6002431.85216 | 2118952.17162 | 37.7983755229712 | -122.43567224288799 | (37.7983755229712, -122.435672242888) | |||
| 6464 | 6464 | 2886 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1520 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 65 | 3X3 | 6007072.466130001 | 2116107.2924 | 37.7908266865378 | -122.41941233843399 | (37.7908266865378, -122.419412338434) | |||
| 6467 | 6467 | 2977 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2199 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003898.3939 | 2115597.6386 | 37.78924802248971 | -122.43035809911301 | (37.7892480224897, -122.430358099113) | |||
| 6502 | 6502 | 110596 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 624 Taylor St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/12/2015 12:00:00 AM | 3 | 2x2 | 6009279.98912 | 2115129.5633 | 37.7882661656083 | -122.411705268989 | (37.7882661656083, -122.411705268989) | ||
| 6516 | 6516 | 27500 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3490X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5997748.10146 | 2114811.12098 | 37.7867381571747 | -122.451580509748 | (37.7867381571747, -122.451580509748) | |||
| 6532 | 6532 | 3197 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3700X California St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5996503.71439 | 2114636.52511 | 37.7861874231568 | -122.455873142035 | (37.7861874231568, -122.455873142035) | |||
| 6551 | 6551 | 3088 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2963 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 75 | 3X3 | 6000170.7975 | 2115085.6403 | 37.78763035756629 | -122.44321830622299 | (37.7876303575663, -122.443218306223) | |||
| 6556 | 6556 | 3062 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2786 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3X3 | 6001055.54335 | 2115274.27531 | 37.7881987101484 | -122.44017079833701 | (37.7881987101484, -122.440170798337) | |||
| 6569 | 6569 | 108165 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1501X Filbert St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2014 12:00:00 AM | 3 | 3x3 | Permit Number 770697 | 6005657.427130001 | 2119250.96257 | 37.799378610588995 | -122.42453202325001 | (37.799378610589, -122.42453202325) | |
| 6619 | 6619 | 103073 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 251 Broadway | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/2014 12:00:00 AM | 3 | 6x6 | Permit Number 769997 | 6012370.75078 | 2118785.2796099996 | 37.798476790218004 | -122.401268678 | (37.798476790218, -122.401268678) | |
| 6622 | 6622 | 103365 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1171X Sacramento St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Rec/Park 7 | 12 | 3x3 | 6009208.54849 | 2116702.7837799997 | 37.7925818394263 | -122.412063667702 | (37.7925818394263, -122.412063667702) | ||
| 6629 | 6629 | 100806 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2401 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6002616.18496 | 2116759.45065 | 37.7923653474383 | -122.434877502118 | (37.7923653474383, -122.434877502118) | |||
| 6638 | 6638 | 2796 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6009497.37807 | 2116449.99792 | 37.7919039520553 | -122.411046440041 | (37.7919039520553, -122.411046440041) | |||
| 6643 | 6643 | 23470 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2340 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2008 12:00:00 AM | 5 | 3x3 | 6005933.96137 | 2118436.7072799997 | 37.7971584848355 | -122.42351719587 | (37.7971584848355, -122.42351719587) | ||
| 6646 | 6646 | 7751 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 400X Franklin St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6006365.37099 | 2111653.13717 | 37.7785568194698 | -122.421542382692 | (37.7785568194698, -122.421542382692) | |||
| 6662 | 6662 | 3109 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3101 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 5999491.6257 | 2114988.3354 | 37.7873244331103 | -122.44556109943998 | (37.7873244331103, -122.44556109944) | |||
| 6677 | 6677 | 121686 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1653 Grant Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6010468.2399 | 2120204.652 | 37.8022677132519 | -122.4079521316 | (37.8022677132519, -122.4079521316) | |||
| 6695 | 6695 | 3002 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2355 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 6003097.9481 | 2115489.4247 | 37.7889055217665 | -122.43311980791599 | (37.7889055217665, -122.433119807916) | |||
| 6725 | 6725 | 2959 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2075 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3X3 | 6004469.1622 | 2115680.873 | 37.78950887720121 | -122.428389244025 | (37.7895088772012, -122.428389244025) | |||
| 6726 | 6726 | 2942 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1943 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3x3 | 6005069.5954 | 2115765.5835 | 37.7897754288934 | -122.42631784247601 | (37.7897754288934, -122.426317842476) | |||
| 6728 | 6728 | 2800 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000X California St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 6009359.64856 | 2116429.6762900003 | 37.7918404293366 | -122.411521550081 | (37.7918404293366, -122.411521550081) | |||
| 6744 | 6744 | 2841 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1255 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3X3 | 6008333.84916 | 2116220.33733 | 37.7912080440698 | -122.415056003557 | (37.7912080440698, -122.415056003557) | |||
| 6759 | 6759 | 23299 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 920 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3X3 | 6006593.47238 | 2113691.16609 | 37.7841656096114 | -122.420898024741 | (37.7841656096114, -122.420898024741) | |||
| 6766 | 6766 | 33092 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
| 6771 | 6771 | 18877 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2300X Sacramento St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/1991 12:00:00 AM | 6 | 4x4 | 6003641.48898 | 2115967.7688700003 | 37.7902497507679 | -122.43127338985501 | (37.7902497507679, -122.431273389855) | ||
| 6789 | 6789 | 3104 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3066 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x2 | 5999678.80765 | 2115082.09673 | 37.7875925616812 | -122.44492023407899 | (37.7875925616812, -122.444920234079) | |||
| 6798 | 6798 | 109547 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300x Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6006862.63225 | 2111739.40495 | 37.7788217156763 | -122.419828285662 | (37.7788217156763, -122.419828285662) | |||
| 6802 | 6802 | 94826 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2195 Green St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/09/2010 12:00:00 AM | 14 | Permit Number 53924 | 6002581.43638 | 2118129.72292 | 37.7961257879313 | -122.435095781947 | (37.7961257879313, -122.435095781947) | ||
| 6829 | 6829 | 23484 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2465 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3X3 | 6005779.73707 | 2118786.08972 | 37.7981090943189 | -122.42407570994301 | (37.7981090943189, -122.424075709943) | |||
| 6831 | 6831 | 101231 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3575 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | 3x3 | Permit Number 779254 | 5997777.0237 | 2115106.06857 | 37.7875496613457 | -122.451501728247 | (37.7875496613457, -122.451501728247) | ||
| 6848 | 6848 | 100798 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2469 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6002394.5470900005 | 2116728.58205 | 37.7922680039076 | -122.435642164168 | (37.7922680039076, -122.435642164168) | |||
| 6849 | 6849 | 3196 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3700X California St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 5996534.33799 | 2114642.16942 | 37.7862046784438 | -122.45576760121 | (37.7862046784438, -122.45576760121) | |||
| 6902 | 6902 | 2997 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2309 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6003229.3093 | 2115506.4757 | 37.7889597900585 | -122.432666534901 | (37.7889597900585, -122.432666534901) | |||
| 6909 | 6909 | 24621 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1008 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/21/1997 12:00:00 AM | 3 | 3X3 | 6001472.5955 | 2111901.4195 | 37.778961444031296 | -122.43848611948299 | (37.7789614440313, -122.438486119483) | ||
| 6916 | 6916 | 102685 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2138 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 4x4 | 6001402.82307 | 2115865.31916 | 37.7898413290661 | -122.43901164686399 | (37.7898413290661, -122.439011646864) | |||
| 6924 | 6924 | 2878 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1468 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/1995 12:00:00 AM | 13 | 3X3 | 6007323.82553 | 2116144.11795 | 37.7909419544596 | -122.41854525707701 | (37.7909419544596, -122.418545257077) | ||
| 7030 | 7030 | 2797 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000X California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6009460.44317 | 2116444.9215599997 | 37.7918879423249 | -122.411173876682 | (37.7918879423249, -122.411173876682) | |||
| 7050 | 7050 | 18876 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2300X Sacramento St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/1991 12:00:00 AM | 6 | 4x4 | 6003660.28862 | 2115969.84784 | 37.790256524463395 | -122.431208492971 | (37.7902565244634, -122.431208492971) | ||
| 7071 | 7071 | 7761 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 455 Franklin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1992 12:00:00 AM | 6 | 3X3 | 6006315.524130001 | 2111641.08677 | 37.778520921234296 | -122.421713966152 | (37.7785209212343, -122.421713966152) | ||
| 7073 | 7073 | 112426 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2811 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6000627.2120900005 | 2116484.87099 | 37.7914982957465 | -122.441739663868 | (37.7914982957465, -122.441739663868) | |||
| 7075 | 7075 | 12429 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1730 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 1X3 | 6004456.1009 | 2114839.3914 | 37.7871976412731 | -122.42837443441002 | (37.7871976412731, -122.42837443441) | |||
| 7091 | 7091 | 95186 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401X Divisadero St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6001227.8097 | 2113222.9324 | 37.7825760551772 | -122.43942768433 | (37.7825760551772, -122.43942768433) | |||
| 7134 | 7134 | 18875 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2300X Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/1991 12:00:00 AM | 6 | 4x4 | 6003680.5328 | 2115973.3067099997 | 37.7902671688355 | -122.431138696607 | (37.7902671688355, -122.431138696607) | ||
| 7142 | 7142 | 23167 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 200X Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2008 12:00:00 AM | 3 | 3X3 | 6006935.04297 | 2111239.87591 | 37.7774542083836 | -122.419542338124 | (37.7774542083836, -122.419542338124) | ||
| 7147 | 7147 | 102684 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2100 Scott St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 4x4 | 6001417.230930001 | 2115753.64679 | 37.78953552537921 | -122.438953790804 | (37.7895355253792, -122.438953790804) | |||
| 7197 | 7197 | 24646 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401X Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/1995 12:00:00 AM | 3 | 3X3 | 6001197.0133 | 2113404.3265 | 37.7830723643512 | -122.439547234041 | (37.7830723643512, -122.439547234041) | ||
| 7246 | 7246 | 2827 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1100X California St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6008639.6141099995 | 2116329.28167 | 37.791524356309296 | -122.414005772556 | (37.7915243563093, -122.414005772556) | |||
| 7284 | 7284 | 99715 | Private 5 | Platanus x hispanica :: Sycamore: London Plane 15 | 1415 Scott St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6001690.8553 | 2113503.3994 | 37.7833724872506 | -122.43784584376199 | (37.7833724872506, -122.437845843762) | |||
| 7296 | 7296 | 21617 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1570 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6005089.0881 | 2114777.2927 | 37.7870629314626 | -122.42618001121299 | (37.7870629314626, -122.426180011213) | |||
| 7297 | 7297 | 95175 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 919 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6001447.2358 | 2111620.4342 | 37.7781884868855 | -122.43855371063299 | (37.7781884868855, -122.438553710633) | |||
| 7330 | 7330 | 95183 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401X Divisadero St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6001216.3034 | 2113289.6015 | 37.782758456667 | -122.439472271703 | (37.782758456667, -122.439472271703) | |||
| 7337 | 7337 | 106720 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1447 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5999672.1743 | 2113882.1261 | 37.7842973761464 | -122.44485689337401 | (37.7842973761464, -122.444856893374) | |||
| 7346 | 7346 | 3205 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3733 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 5996654.5467 | 2114596.0788 | 37.7860850238796 | -122.45534838076999 | (37.7860850238796, -122.45534838077) | |||
| 7411 | 7411 | 23441 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2100x Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3X3 | 6006042.25764 | 2117640.51694 | 37.7949784589386 | -122.423085842334 | (37.7949784589386, -122.423085842334) | |||
| 7456 | 7456 | 111007 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 600X Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/2015 12:00:00 AM | 3 | Permit Number 776001 | 6007258.06948 | 2121954.7995599997 | 37.8068929247227 | -122.41918512469299 | (37.8068929247227, -122.419185124693) | ||
| 7471 | 7471 | 3100 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3030 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X2 | 5999839.21306 | 2115102.42809 | 37.7876575395151 | -122.444366726567 | (37.7876575395151, -122.444366726567) | |||
| 7510 | 7510 | 2857 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1337 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3x3 | 6007952.28971 | 2116165.43785 | 37.7910358544775 | -122.41637230166401 | (37.7910358544775, -122.416372301664) | |||
| 7556 | 7556 | 115529 | Planning Code 138.1 required 4 | Platanus x hispanica :: Sycamore: London Plane 15 | 101 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2016 12:00:00 AM | 3 | 4x4 | Permit Number 770842 | 6007327.31765 | 2111347.52577 | 37.777771876795 | -122.418192961161 | (37.777771876795, -122.418192961161) | |
| 7557 | 7557 | 7337 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2388X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3X3 | 6002954.00239 | 2115537.8859200003 | 37.7890304175535 | -122.43362130478 | (37.7890304175535, -122.43362130478) | |||
| 7569 | 7569 | 109555 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300x Van Ness Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6006838.40571 | 2111934.91947 | 37.7793571864361 | -122.419925972721 | (37.7793571864361, -122.419925972721) | |||
| 7580 | 7580 | 33091 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
| 7617 | 7617 | 3122 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3171 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 5999239.7647 | 2114955.904 | 37.787221003016 | -122.44643014826 | (37.787221003016, -122.44643014826) | |||
| 7627 | 7627 | 33085 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
| 7629 | 7629 | 109558 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300x Van Ness Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6006832.29827 | 2111978.39553 | 37.779476217093396 | -122.419950186976 | (37.7794762170934, -122.419950186976) | |||
| 7641 | 7641 | 24622 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1008 Divisadero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6001471.5811 | 2111916.8889 | 37.7790038613884 | -122.43849073733699 | (37.7790038613884, -122.438490737337) | |||
| 7643 | 7643 | 3187 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3633 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 5997052.1923 | 2114651.58 | 37.7862602231647 | -122.453976650752 | (37.7862602231647, -122.453976650752) | |||
| 7668 | 7668 | 2815 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1100X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6009039.2714599995 | 2116385.35959 | 37.7917007709177 | -122.4126269248 | (37.7917007709177, -122.4126269248) | |||
| 7690 | 7690 | 2931 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1834 California St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 75 | 3X3 | 6005504.99786 | 2115891.9333200003 | 37.790146955562896 | -122.424820382781 | (37.7901469555629, -122.424820382781) | |||
| 7716 | 7716 | 3095 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3006 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X2 | 5999935.5701 | 2115117.74796 | 37.7877051010601 | -122.444034452234 | (37.7877051010601, -122.444034452234) | |||
| 7741 | 7741 | 100803 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2441 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6002520.83682 | 2116745.03397 | 37.7923203489543 | -122.43520637698299 | (37.7923203489543, -122.435206376983) | |||
| 7750 | 7750 | 33087 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 |
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");