trees
161 rows where qSpecies_id = 96 sorted by SiteOrder
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5537 | 222985 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 517 Day St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 28 | Width 10ft | 6002550.62453 | 2098561.77605 | 37.7423952688291 | -122.433803088343 | (37.7423952688291, -122.433803088343) | 2 | 7 | 5 | 63 | 7 | |||
7476 | 246435 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 501 Duncan St | 1 | Front Yard : Yard | Tree | Private 2 | 5 | Width 5ft | 6003234.36598 | 2099765.52854 | 37.7457392692468 | -122.431524834927 | (37.7457392692468, -122.431524834927) | 2 | 7 | 5 | 63 | 22 | |||
16595 | 206473 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 55 Melrose Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 10ft | 5999743.81209 | 2095477.4356 | 37.7337667261604 | -122.443286685744 | (37.7337667261604, -122.443286685744) | 9 | 7 | 4 | 63 | 40 | |||
20410 | 126359 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 1100 Filbert St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 4ft | 6007620.5753 | 2119577.58313 | 37.8003860977102 | -122.417761987128 | (37.8003860977102, -122.417761987128) | 5 | 1 | 1 | 28858 | 32 | |||
21004 | 223014 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 130 Berkeley Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6000989.36557 | 2097560.44411 | 37.7395571289679 | -122.439129688289 | (37.7395571289679, -122.439129688289) | 2 | 7 | 5 | 63 | 7 | |||
21176 | 190910 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 1802 Shoup Ave | 1 | Front Yard : Yard | Tree | Private 2 | 25 | 6013180.92489 | 2093690.47467 | 37.7296171768863 | -122.396705035035 | (37.7296171768863, -122.396705035035) | 10 | 3 | 8 | 58 | 1 | ||||
40608 | 190911 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 1980 Revere Ave | 1 | Front Yard : Yard | Tree | Private 2 | 9 | 6013087.19308 | 2095914.17172 | 37.7357177729638 | -122.397184944736 | (37.7357177729638, -122.397184944736) | 10 | 3 | 8 | 58 | 1 | ||||
43929 | 222986 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 502 28th St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 21 | 6002638.36895 | 2099488.81638 | 37.7449456841067 | -122.433565931724 | (37.7449456841067, -122.433565931724) | 2 | 7 | 5 | 63 | 22 | ||||
49356 | 206465 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 423 Mangels Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 10ft | 5998611.46189 | 2095226.73921 | 37.7330137372936 | -122.447183504829 | (37.7330137372936, -122.447183504829) | 9 | 7 | 4 | 59 | 40 | |||
59140 | 206442 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 488 Arch St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | Width 6ft | 5992758.93765 | 2090436.99405 | 37.719526135091 | -122.467068932605 | (37.719526135091, -122.467068932605) | 9 | 8 | 6 | 64 | 24 | |||
60282 | 246768 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 99 Waltham St | 1 | Side Yard : Yard | Tree | Private 2 | 13 | 6009274.77295 | 2098916.84453 | 37.7437494805599 | -122.410577984112 | (37.7437494805599, -122.410577984112) | 2 | 7 | 7 | 28859 | 2 | ||||
67912 | 176067 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 700x Mansell St | 1 | Median : Cutout | Tree | DPW 1 | 22 | Width 0ft | 6009780.98423 | 2090145.56651 | 37.719693784023 | -122.408209118574 | (37.719693784023, -122.408209118574) | 9 | 3 | 8 | 309 | 18 | |||
70399 | 121205 | Significant Tree 6 | Cotoneaster SPP :: Cotoneaster 96 | 930 Chestnut St | 1 | Front Yard : Yard | Tree | Private 2 | 20 | 3x3 | 6007386.5238 | 2120591.43483 | 37.8031567047665 | -122.418643837145 | (37.8031567047665, -122.418643837145) | 5 | 1 | 1 | 28858 | 32 | |||
73660 | 223002 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 256 Bemis St | 1 | Front Yard : Yard | Tree | Private 2 | 23 | 6003028.50594 | 2096309.11502 | 37.736237086475 | -122.431989898622 | (37.736237086475, -122.431989898622) | 2 | 7 | 5 | 63 | 7 | ||||
79562 | 190920 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 895 Vermont St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 6011337.392 | 2104186.31719 | 37.7583337232325 | -122.403816617445 | (37.7583337232325, -122.403816617445) | 10 | 3 | 8 | 28856 | 29 | ||||
81196 | 250505 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 55 27th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 21 | 5987243.87038 | 2115583.56444 | 37.7882519230241 | -122.487978957983 | (37.7882519230241, -122.487978957983) | 11 | 6 | 1 | 55 | 33 | ||||
81437 | 206434 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 2466 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5992373.85184 | 2098639.0417 | 37.7420246816026 | -122.468996609624 | (37.7420246816026, -122.468996609624) | 1 | 8 | 4 | 29491 | 40 | |||
87397 | 206443 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 581 Head St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 6ft | 5993478.4128 | 2089802.60481 | 37.7178257581409 | -122.464535950688 | (37.7178257581409, -122.464535950688) | 9 | 8 | 6 | 64 | 24 | |||
96964 | 126366 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 99 MacOndray Ln | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 56 | 6008010.57204 | 2119080.43937 | 37.7990430042822 | -122.416377206564 | (37.7990430042822, -122.416377206564) | 5 | 1 | 10 | 308 | 32 | ||||
99009 | 206464 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 171 Burnside Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 6001095.15632 | 2095353.35883 | 37.7335030062632 | -122.438605809815 | (37.7335030062632, -122.438605809815) | 9 | 7 | 5 | 63 | 40 | |||
105109 | 206441 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 45 Margaret Ave | 1 | : | Tree | Private 2 | 3 | Width 3ft | 5997090.05868 | 2089794.46291 | 37.7180109429363 | -122.45205157193 | (37.7180109429363, -122.45205157193) | 9 | 8 | 6 | 28861 | 24 | |||
112914 | 206435 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 2330 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 5992341.16366 | 2099574.90495 | 37.7445924349065 | -122.469177732164 | (37.7445924349065, -122.469177732164) | 1 | 8 | 4 | 29491 | 40 | |||
122853 | 113495 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 200x Mansell St | 1 | Median : Cutout | Tree | DPW 1 | 29 | 3x3 | 6011252.2338 | 2090588.80879 | 37.7209931092197 | -122.403154667852 | (37.7209931092197, -122.403154667852) | 10 | 3 | 7 | 309 | 28 | |||
129392 | 187578 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 211 Elliot St | 1 | Side Yard : Yard | Tree | Private 2 | 38 | 6009088.83114 | 2088896.19011 | 37.7162244747635 | -122.410513477532 | (37.7162244747635, -122.410513477532) | 9 | 7 | 8 | 309 | 39 | ||||
129437 | 206444 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 75 Ralston St | 1 | Back Yard : Yard | Tree | Private 2 | 23 | 5992169.96835 | 2088350.86546 | 37.7137641184938 | -122.468953032063 | (37.7137641184938, -122.468953032063) | 9 | 8 | 6 | 64 | 24 | ||||
139921 | 206439 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 171 Flood Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 8ft | 5999612.35761 | 2094047.36229 | 37.7298325825057 | -122.443638462765 | (37.7298325825057, -122.443638462765) | 9 | 7 | 4 | 63 | 40 | |||
141062 | 206431 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 951 Noriega St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 5990974.62554 | 2103115.26643 | 37.7542342869058 | -122.474161176918 | (37.7542342869058, -122.474161176918) | 1 | 8 | 4 | 56 | 12 | |||
141205 | 176071 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 1x Tioga Ave | 1 | Median : Cutout | Tree | DPW 1 | 30 | Width 0ft | 6011377.48313 | 2088627.04086 | 37.7156134870441 | -122.402583833071 | (37.7156134870441, -122.402583833071) | 9 | 7 | 8 | 309 | 39 | |||
142959 | 206474 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 230 Edna St | 1 | Side Yard : Yard | Tree | Private 2 | 13 | 5998806.12443 | 2095305.20487 | 37.7332403061898 | -122.446516151203 | (37.7332403061898, -122.446516151203) | 9 | 7 | 4 | 59 | 40 | ||||
148002 | 222984 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 4699 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6000341.30715 | 2101074.37399 | 37.7491686459265 | -122.441622492977 | (37.7491686459265, -122.441622492977) | 2 | 4 | 5 | 28862 | 22 | |||
151500 | 247902 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 377 Mayflower St | 1 | Side Yard : Yard | Tree | Private 2 | 13 | 6009819.79405 | 2098407.16553 | 37.7423805541222 | -122.408657474665 | (37.7423805541222, -122.408657474665) | 10 | 7 | 7 | 28859 | 2 | ||||
161187 | 206466 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 747 Detroit St | 1 | Side Yard : Yard | Tree | Private 2 | 7 | 5999436.63595 | 2095454.00589 | 37.7336848725516 | -122.444346998137 | (37.7336848725516, -122.444346998137) | 9 | 7 | 4 | 59 | 40 | ||||
165925 | 108733 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 12X MacOndray Ln | 1 | Front Yard : Yard | Tree | Private 2 | 6 | 6008571.72163 | 2119174.99094 | 37.7993341588901 | -122.41444212811 | (37.7993341588901, -122.41444212811) | 5 | 1 | 10 | 308 | 32 | ||||
174251 | 126357 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 53 Priest St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 10ft | 6008293.62277 | 2117215.49565 | 37.79393824372 | -122.41526566339 | (37.79393824372, -122.41526566339) | 5 | 1 | 10 | 28858 | 21 | |||
175491 | 206447 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 193 Bright St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 6ft | 5993726.91575 | 2088448.649 | 37.7141224416834 | -122.46357878423 | (37.7141224416834, -122.46357878423) | 9 | 8 | 6 | 64 | 24 | |||
176244 | 190912 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 649 Delancey St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6015785.04565 | 2113121.03731 | 37.7831139729835 | -122.389058364068 | (37.7831139729835, -122.389058364068) | 6 | 2 | 9 | 28856 | 6 | |||
180988 | 222997 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 3955 21st St | 1 | Front Yard : Yard | Tree | Private 2 | 3 | 6002162.22875 | 2103520.28848 | 37.7559881222676 | -122.435500681007 | (37.7559881222676, -122.435500681007) | 2 | 4 | 5 | 28862 | 22 | ||||
188863 | 222983 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 90 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007949.21318 | 2098212.09839 | 37.7417399985009 | -122.415111593326 | (37.7417399985009, -122.415111593326) | 2 | 7 | 7 | 28859 | 2 | |||
160993 | 206482 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 50 Garcia Ave | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 3ft | 5995108.20456 | 2099311.1994 | 37.7440278657044 | -122.459590825184 | (37.7440278657044, -122.459590825184) | 1 | 8 | 4 | 59 | 40 | |||
50925 | 206457 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 900 Junipero Serra Blvd | 104 | : | Tree | Private 2 | 10 | Width 0ft | 5991133.57353 | 2090407.88322 | 37.719352251183 | -122.472685046772 | (37.719352251183, -122.472685046772) | 9 | 8 | 4 | 64 | 40 | |||
55887 | 206458 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 900 Junipero Serra Blvd | 105 | : | Tree | Private 2 | 8 | Width 0ft | 5991134.51165 | 2090396.03266 | 37.7193197667672 | -122.472680940494 | (37.7193197667672, -122.472680940494) | 9 | 8 | 4 | 64 | 40 | |||
39535 | 206483 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 50 Garcia Ave | 11 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 3ft | 5995097.24504 | 2099302.48565 | 37.7440033097179 | -122.459628089474 | (37.7440033097179, -122.459628089474) | 1 | 8 | 4 | 59 | 40 | |||
120594 | 223008 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 1201 San Jose Ave | 11 | Front Yard : Yard | Tree | Private 2 | 4 | 6004238.84554 | 2095923.20533 | 37.7352460083923 | -122.427777766445 | (37.7352460083923, -122.427777766445) | 2 | 7 | 5 | 28861 | 2 | ||||
121273 | 206470 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 747 Detroit St | 11 | Side Yard : Yard | Tree | Private 2 | 1 | 5999427.71603 | 2095403.50686 | 37.7335457051627 | -122.444374208926 | (37.7335457051627, -122.444374208926) | 9 | 7 | 4 | 59 | 40 | ||||
193215 | 206472 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 714 Detroit St | 11 | Side Yard : Yard | Tree | Private 2 | 7 | 5999457.34155 | 2095426.05031 | 37.7336092944368 | -122.444273404802 | (37.7336092944368, -122.444273404802) | 9 | 7 | 4 | 63 | 40 | ||||
70341 | 223006 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 1001 San Jose Ave | 12 | Front Yard : Yard | Tree | Private 2 | 14 | 6005181.63876 | 2096892.75966 | 37.7379614744429 | -122.424587128296 | (37.7379614744429, -122.424587128296) | 2 | 7 | 5 | 28859 | 2 | ||||
46352 | 176065 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 300x Mansell St | 13 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6010824.42328 | 2090455.49566 | 37.7206031577782 | -122.404624109729 | (37.7206031577782, -122.404624109729) | 10 | 7 | 7 | 309 | 28 | |||
124388 | 206484 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 50 Garcia Ave | 13 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5995031.51325 | 2099251.39623 | 37.7438592509066 | -122.459851673524 | (37.7438592509066, -122.459851673524) | 1 | 8 | 4 | 59 | 40 | |||
154268 | 206451 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 500 Junipero Serra Blvd | 13 | : | Tree | Private 2 | 33 | Width 0ft | 5991343.11877 | 2093722.6763 | 37.7284659790048 | -122.472202232259 | (37.7284659790048, -122.472202232259) | 9 | 8 | 4 | 64 | 40 | |||
6438 | 29970 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 500X Junipero Serra Blvd | 14 | Median : Cutout | Tree | DPW 1 | 04/01/2007 12:00:00 AM | 3 | 3x3 | 5991349.07674 | 2093718.94394 | 37.7284560756763 | -122.472181363504 | (37.7284560756763, -122.472181363504) | 9 | 8 | 4 | 64 | 40 | ||
124782 | 206485 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 50 Garcia Ave | 14 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 5995003.2981 | 2099247.81347 | 37.7438477908555 | -122.459948974773 | (37.7438477908555, -122.459948974773) | 1 | 8 | 4 | 59 | 40 | |||
159085 | 176068 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 700x Mansell St | 14 | Median : Cutout | Tree | DPW 1 | 13 | Width 0ft | 6009458.20535 | 2090043.50806 | 37.7193954735114 | -122.409317656201 | (37.7193954735114, -122.409317656201) | 9 | 3 | 8 | 309 | 18 | |||
153035 | 29606 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 900X Junipero Serra Blvd | 15 | Median : Cutout | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991168.88017 | 2091040.07708 | 37.7210901433828 | -122.472609073864 | (37.7210901433828, -122.472609073864) | 9 | 8 | 4 | 64 | 40 | ||
186299 | 206486 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 50 Garcia Ave | 15 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 3ft | 5994998.43576 | 2099244.33833 | 37.743837969341 | -122.459965535799 | (37.743837969341, -122.459965535799) | 1 | 8 | 4 | 59 | 40 | |||
101689 | 223013 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 400 Prospect Ave | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 6006209.38075 | 2097598.06666 | 37.7399560781032 | -122.421083777917 | (37.7399560781032, -122.421083777917) | 2 | 7 | 7 | 28859 | 2 | ||||
95292 | 176064 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 200x Mansell St | 18 | Median : Cutout | Tree | DPW 1 | 8 | Width 0ft | 6011103.67645 | 2090538.55711 | 37.7208468308864 | -122.403664655405 | (37.7208468308864, -122.403664655405) | 10 | 7 | 7 | 309 | 28 | |||
112935 | 206487 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 50 Garcia Ave | 18 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 3ft | 5994954.72324 | 2099244.06144 | 37.7438346949325 | -122.46011666235 | (37.7438346949325, -122.46011666235) | 1 | 8 | 4 | 59 | 40 | |||
40874 | 206488 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 50 Garcia Ave | 19 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 3ft | 5994928.93938 | 2099242.2168 | 37.7438281469548 | -122.460205682656 | (37.7438281469548, -122.460205682656) | 1 | 8 | 4 | 59 | 40 | |||
129949 | 206476 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 200x Terrace Dr | 19 | Median : Yard | Tree | DPW 1 | 16 | 5993821.62847 | 2096518.98246 | 37.7362870716885 | -122.463836850114 | (37.7362870716885, -122.463836850114) | 1 | 8 | 4 | 59 | 40 | ||||
9746 | 233891 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 255 Grand View Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6000523.6418 | 2102837.35853 | 37.7540197626178 | -122.441118447281 | (37.7540197626178, -122.441118447281) | 2 | 4 | 5 | 28862 | 22 | ||||
12496 | 259559 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 100 Public Park | 2 | Unaccepted Street : Yard | Tree | Private 2 | 3x3 | 5994005 | 2098340 | 37.7412976975938 | -122.463334966929 | (37.7412976975938, -122.463334966929) | 1 | 8 | 4 | 59 | 40 | ||||
22261 | 246436 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 498 Duncan St | 2 | Front Yard : Yard | Tree | Private 2 | 16 | Width 3ft | 6003348.10613 | 2099802.17179 | 37.7458463290596 | -122.431134153243 | (37.7458463290596, -122.431134153243) | 2 | 7 | 5 | 63 | 22 | |||
25308 | 176072 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 653 Peru Ave | 2 | Side Yard : Yard | Tree | Private 2 | 6 | 6005100.84385 | 2092592.61654 | 37.7261496752474 | -122.424560681043 | (37.7261496752474, -122.424560681043) | 9 | 7 | 6 | 28861 | 5 | ||||
26558 | 222998 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 3955 21st St | 2 | Front Yard : Yard | Tree | Private 2 | 28 | 6002164.76896 | 2103518.38211 | 37.7559830321046 | -122.435491759762 | (37.7559830321046, -122.435491759762) | 2 | 4 | 5 | 28862 | 22 | ||||
55033 | 206433 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 401x Ortega St | 2 | Median : Cutout | Tree | DPW 1 | 7 | Width 2ft | 5992711.67251 | 2102602.15843 | 37.7529258983243 | -122.468116765071 | (37.7529258983243, -122.468116765071) | 1 | 8 | 4 | 56 | 12 | |||
93688 | 126367 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 12 MacOndray Ln | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 6008558.64868 | 2119172.9159 | 37.7993277269402 | -122.414487218323 | (37.7993277269402, -122.414487218323) | 5 | 1 | 10 | 308 | 32 | ||||
102644 | 256153 | Undocumented 4 | Cotoneaster SPP :: Cotoneaster 96 | 80X Peralta Ave | 2 | Median : Cutout | Tree | Private 2 | 3x3 | 6010428 | 2100359 | 37.747773912222 | -122.406691992098 | (37.747773912222, -122.406691992098) | 2 | 7 | 7 | 28859 | 2 | ||||
119785 | 223000 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 3949 21st St | 2 | Front Yard : Yard | Tree | Private 2 | 8 | 6002182.77981 | 2103520.33537 | 37.7559894181953 | -122.435429612092 | (37.7559894181953, -122.435429612092) | 2 | 4 | 5 | 28862 | 22 | ||||
121991 | 247635 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 351 Bradford St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 6009489.54624 | 2096539.61504 | 37.7372341639148 | -122.409667589601 | (37.7372341639148, -122.409667589601) | 10 | 7 | 7 | 28859 | 2 | ||||
128445 | 246631 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 3320 Harrison St | 2 | Front Yard : Yard | Tree | Private 2 | 5 | 6009034.5576 | 2099266.31462 | 37.7446955781356 | -122.411433278945 | (37.7446955781356, -122.411433278945) | 2 | 7 | 7 | 28859 | 2 | ||||
150537 | 206432 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 1501 16th Ave | 2 | Side Yard : Yard | Tree | Private 2 | 5 | Width 6ft | 5991165.77974 | 2105142.87216 | 37.7598126286617 | -122.473648022834 | (37.7598126286617, -122.473648022834) | 1 | 8 | 4 | 56 | 12 | |||
151568 | 126358 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 2700 Larkin St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6006530.21172 | 2120848.51447 | 37.803814332215 | -122.421625403593 | (37.803814332215, -122.421625403593) | 5 | 9 | 1 | 28858 | 32 | |||
189006 | 246769 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 99 Waltham St | 2 | Side Yard : Yard | Tree | Private 2 | 13 | 6009290.58304 | 2098917.85967 | 37.7437531542765 | -122.410523388038 | (37.7437531542765, -122.410523388038) | 2 | 7 | 7 | 28859 | 2 | ||||
191212 | 126360 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 1100 Filbert St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 4ft | 6007607.19826 | 2119575.42635 | 37.8003794229421 | -122.41780812417 | (37.8003794229421, -122.41780812417) | 5 | 1 | 1 | 28858 | 32 | |||
41713 | 206477 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 200x Terrace Dr | 20 | Median : Yard | Tree | DPW 1 | 5 | 5993822.05067 | 2096524.01563 | 37.7363009158535 | -122.463835755623 | (37.7363009158535, -122.463835755623) | 1 | 8 | 4 | 59 | 40 | ||||
163793 | 206489 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 50 Garcia Ave | 20 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 5994901.42281 | 2099243.38936 | 37.7438297837176 | -122.460300912772 | (37.7438297837176, -122.460300912772) | 1 | 8 | 4 | 59 | 40 | |||
116071 | 206490 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 50 Garcia Ave | 21 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 3ft | 5994866.12622 | 2099244.72495 | 37.743831420489 | -122.460423055998 | (37.743831420489, -122.460423055998) | 1 | 8 | 4 | 59 | 40 | |||
133342 | 206478 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 200x Terrace Dr | 21 | Median : Yard | Tree | DPW 1 | 6 | 5993823.40178 | 2096528.08405 | 37.7363121645844 | -122.463831379524 | (37.7363121645844, -122.463831379524) | 1 | 8 | 4 | 59 | 40 | ||||
47071 | 206479 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 200x Terrace Dr | 23 | Median : Yard | Tree | DPW 1 | 13 | 5993821.59658 | 2096532.53346 | 37.7363242775317 | -122.463837943662 | (37.7363242775317, -122.463837943662) | 1 | 8 | 4 | 59 | 40 | ||||
84078 | 222979 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 1001 San Jose Ave | 23 | Front Yard : Yard | Tree | Private 2 | 15 | 6005237.0546 | 2097014.53451 | 37.7382989702268 | -122.424404187313 | (37.7382989702268, -122.424404187313) | 2 | 7 | 5 | 28859 | 2 | ||||
90839 | 223009 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 1201 San Jose Ave | 25 | Front Yard : Yard | Tree | Private 2 | 4 | 6004330.29442 | 2095981.98056 | 37.7354125646335 | -122.427465779924 | (37.7354125646335, -122.427465779924) | 2 | 7 | 5 | 28861 | 2 | ||||
149617 | 176069 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 700x Mansell St | 27 | Median : Cutout | Tree | DPW 1 | 28 | Width 0ft | 6009294.57289 | 2089991.02465 | 37.7192421957421 | -122.409879572386 | (37.7192421957421, -122.409879572386) | 9 | 3 | 8 | 309 | 18 | |||
15365 | 223010 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 1201 San Jose Ave | 28 | Front Yard : Yard | Tree | Private 2 | 5 | 6004358.20734 | 2096003.62684 | 37.7354735791371 | -122.427370816017 | (37.7354735791371, -122.427370816017) | 2 | 7 | 5 | 28861 | 2 | ||||
9822 | 16139 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 370 Monterey Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 5999751.27991 | 2094724.82015 | 37.7317006461585 | -122.443206831334 | (37.7317006461585, -122.443206831334) | 9 | 7 | 4 | 63 | 40 | |||
9896 | 222994 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 500x 27th St | 3 | Median : Cutout | Tree | DPW 1 | 8 | Width 4ft | 6002676.05036 | 2100055.6268 | 37.746504150749 | -122.433476134415 | (37.746504150749, -122.433476134415) | 2 | 7 | 5 | 63 | 22 | |||
23423 | 206445 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 53 Ralston St | 3 | Back Yard : Yard | Tree | Private 2 | 15 | 5992171.9093 | 2088272.93373 | 37.7135502489179 | -122.46894065561 | (37.7135502489179, -122.46894065561) | 9 | 8 | 6 | 64 | 24 | ||||
25208 | 223005 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 246 Bemis St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | 6003031.63093 | 2096309.97053 | 37.7362396126721 | -122.431979155322 | (37.7362396126721, -122.431979155322) | 2 | 7 | 5 | 63 | 7 | ||||
29884 | 246437 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 498 Duncan St | 3 | Front Yard : Yard | Tree | Private 2 | 18 | Width 3ft | 6003348.65362 | 2099794.40948 | 37.7458250465875 | -122.431131706158 | (37.7458250465875, -122.431131706158) | 2 | 7 | 5 | 63 | 22 | |||
64051 | 222987 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 502 28th St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | 6002610.5339 | 2099487.49124 | 37.7449404662242 | -122.433662085451 | (37.7449404662242, -122.433662085451) | 2 | 7 | 5 | 63 | 22 | ||||
75124 | 126356 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 101 Marina Blvd | 3 | Front Yard : Yard | Tree | Private 2 | 8 | 6002934.90654 | 2121377.37848 | 37.8050630669581 | -122.434104982679 | (37.8050630669581, -122.434104982679) | 13 | 9 | 1 | 57 | 17 | ||||
75541 | 253981 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 433 Detroit St | 3 | Unaccepted Street : Yard | Tree | Private 2 | Width 10ft | 5999422.35392 | 2094544.1981 | 37.7311859389748 | -122.444331015365 | (37.7311859389748, -122.444331015365) | 9 | 7 | 4 | 59 | 40 | ||||
108052 | 190921 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 875 Vermont St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 2ft | 6011349.18047 | 2104266.91512 | 37.7585556858022 | -122.403781518727 | (37.7585556858022, -122.403781518727) | 10 | 3 | 8 | 28856 | 29 | |||
114113 | 126361 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 1100 Filbert St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 6007604.93039 | 2119574.72474 | 37.8003773688712 | -122.417815922163 | (37.8003773688712, -122.417815922163) | 5 | 1 | 1 | 28858 | 32 | |||
162272 | 222999 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 3955 21st St | 3 | Front Yard : Yard | Tree | Private 2 | 53 | 6002171.06087 | 2103519.51853 | 37.7559865097873 | -122.435470081578 | (37.7559865097873, -122.435470081578) | 2 | 4 | 5 | 28862 | 22 | ||||
172680 | 206449 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 3020 19th Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 5990639.74875 | 2095092.07511 | 37.7321852719367 | -122.4747337006 | (37.7321852719367, -122.4747337006) | 1 | 8 | 4 | 64 | 40 | |||
192482 | 126369 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 1306x Montgomery St | 30 | Median : Yard | Tree | DPW 1 | 8 | Width 8ft | 6011435.17205 | 2120070.79941 | 37.8019542743222 | -122.404596630044 | (37.8019542743222, -122.404596630044) | 3 | 1 | 10 | 308 | 23 | |||
52277 | 126370 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 1306x Montgomery St | 31 | Median : Yard | Tree | DPW 1 | 10 | Width 8ft | 6011433.37611 | 2120083.33032 | 37.801988580771 | -122.404603727506 | (37.801988580771, -122.404603727506) | 3 | 1 | 10 | 308 | 23 | |||
184063 | 176070 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 700x Mansell St | 34 | Median : Cutout | Tree | DPW 1 | 14 | Width 0ft | 6009191.21918 | 2089961.56598 | 37.7191555154919 | -122.410234749751 | (37.7191555154919, -122.410234749751) | 9 | 3 | 8 | 309 | 18 | |||
17076 | 126371 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 1306x Montgomery St | 37 | Median : Yard | Tree | DPW 1 | 4 | Width 8ft | 6011427.3089 | 2120158.66 | 37.8021950785935 | -122.404630029046 | (37.8021950785935, -122.404630029046) | 3 | 1 | 10 | 308 | 23 | |||
139941 | 206452 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 500 Junipero Serra Blvd | 37 | : | Tree | Private 2 | 12 | Width 0ft | 5991336.42216 | 2093557.70772 | 37.7280126289541 | -122.472213362281 | (37.7280126289541, -122.472213362281) | 9 | 8 | 4 | 64 | 40 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );