trees
121 rows where qSpecies_id = 82 sorted by YCoord descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
190936 | 131018 | DPW Maintained 1 | Malus :: Crab Apple 82 | 3262 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6003319.94778 | 2119547.11819 | 37.8000594954142 | -122.432641684079 | (37.8000594954142, -122.432641684079) | 13 | 9 | 1 | 57 | 17 | |||
150502 | 97162 | Property Tree 8 | Malus :: Crab Apple 82 | 478 10th Ave | Back Yard : Yard | Tree | Private 2 | Tree in backyard on private property; not significant. | 5992861.5 | 2112216.7 | 37.7793335349967 | -122.468298031686 | (37.7793335349967, -122.468298031686) | 11 | 6 | 2 | 54 | 11 | |||||
62542 | 124516 | DPW Maintained 1 | Malus :: Crab Apple 82 | 2636 McAllister St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 5996532.8589 | 2110816.50404 | 37.7757003280561 | -122.455496112673 | (37.7757003280561, -122.455496112673) | 11 | 6 | 2 | 54 | 16 | |||
108554 | 16982 | DPW Maintained 1 | Malus :: Crab Apple 82 | 845 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/18/2002 12:00:00 AM | 2 | 3X3 | 6002950.3496 | 2109907.5532 | 37.7735707302623 | -122.433231473927 | (37.7735707302623, -122.433231473927) | 15 | 5 | 11 | 29492 | 9 | ||
58094 | 244485 | DPW Maintained 1 | Malus :: Crab Apple 82 | 201 Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6001267.601 | 2109451.913 | 37.7722240530146 | -122.43901967935 | (37.7722240530146, -122.43901967935) | 15 | 5 | 11 | 29492 | 9 | |||
31426 | 244062 | DPW Maintained 1 | Malus :: Crab Apple 82 | 1666 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5998622.1807 | 2109013.5796 | 37.7708696265101 | -122.448138811863 | (37.7708696265101, -122.448138811863) | 15 | 5 | 11 | 29492 | 9 | |||
143487 | 247172 | DPW Maintained 1 | Malus :: Crab Apple 82 | 145 Buena Vista Ave East | 3 | : | Tree | Private 2 | 1 | Width 4ft | 6001372.05344 | 2108496.34434 | 37.7696062421579 | -122.438589890015 | (37.7696062421579, -122.438589890015) | 15 | 5 | 5 | 29492 | 9 | |||
113849 | 117297 | Undocumented 4 | Malus :: Crab Apple 82 | 801X DUBOCE AVE | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 12 | 3x3 | 6001906 | 2108188 | 37.7687899642453 | -122.436720915521 | (37.7687899642453, -122.436720915521) | 15 | 5 | 5 | 29492 | 3 | |||
76311 | 108272 | Undocumented 4 | Malus :: Crab Apple 82 | 1800x ALAMEDA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011533 | 2107928 | 37.7686184708296 | -122.403403344125 | (37.7686184708296, -122.403403344125) | 8 | 2 | 8 | 28853 | 20 | ||||
90573 | 108273 | Undocumented 4 | Malus :: Crab Apple 82 | 1800x ALAMEDA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011533 | 2107928 | 37.7686184708296 | -122.403403344125 | (37.7686184708296, -122.403403344125) | 8 | 2 | 8 | 28853 | 20 | ||||
126435 | 108271 | Undocumented 4 | Malus :: Crab Apple 82 | 1800x ALAMEDA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6011533 | 2107928 | 37.7686184708296 | -122.403403344125 | (37.7686184708296, -122.403403344125) | 8 | 2 | 8 | 28853 | 20 | |||
192547 | 108274 | Undocumented 4 | Malus :: Crab Apple 82 | 1800x ALAMEDA ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011533 | 2107928 | 37.7686184708296 | -122.403403344125 | (37.7686184708296, -122.403403344125) | 8 | 2 | 8 | 28853 | 20 | ||||
155688 | 248559 | DPW Maintained 1 | Malus :: Crab Apple 82 | 776 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5998007.1271 | 2107705.5553 | 37.7672429465083 | -122.450171990254 | (37.7672429465083, -122.450171990254) | 15 | 5 | 11 | 29492 | 9 | |||
275 | 193456 | DPW Maintained 1 | Malus :: Crab Apple 82 | 185 Hampshire St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 5ft | 6010023.67884 | 2107445.71101 | 37.76720979983 | -122.40858996078 | (37.76720979983, -122.40858996078) | 8 | 4 | 8 | 28853 | 19 | |||
17133 | 183310 | DPW Maintained 1 | Malus :: Crab Apple 82 | 1278 42nd Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 0ft | 5983073.0612 | 2106470.9099 | 37.762987036737 | -122.501734562858 | (37.762987036737, -122.501734562858) | 1 | 8 | 3 | 56 | 35 | |||
68050 | 183309 | DPW Maintained 1 | Malus :: Crab Apple 82 | 1278 42nd Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 0ft | 5983073.9761 | 2106459.9318 | 37.7629569477354 | -122.501730586329 | (37.7629569477354, -122.501730586329) | 1 | 8 | 3 | 56 | 35 | |||
31702 | 193449 | DPW Maintained 1 | Malus :: Crab Apple 82 | 2000 18th St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6011690.74691 | 2105621.1854 | 37.7622932862384 | -122.402695459648 | (37.7622932862384, -122.402695459648) | 8 | 3 | 8 | 28856 | 29 | ||||
90212 | 193450 | DPW Maintained 1 | Malus :: Crab Apple 82 | 2000 18th St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6011681.52321 | 2105621.1617 | 37.7622927061762 | -122.40272735948 | (37.7622927061762, -122.40272735948) | 8 | 3 | 8 | 28856 | 29 | ||||
163573 | 193444 | DPW Maintained 1 | Malus :: Crab Apple 82 | 800 19th St | 22 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 6014945.20165 | 2105329.27451 | 37.7616729293835 | -122.391419022363 | (37.7616729293835, -122.391419022363) | 10 | 3 | 8 | 28856 | 29 | |||
63848 | 231474 | DPW Maintained 1 | Malus :: Crab Apple 82 | 2044 Bryant St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009525.85119 | 2105200.14517 | 37.7610160960274 | -122.410153325135 | (37.7610160960274, -122.410153325135) | 2 | 4 | 7 | 28859 | 19 | |||
53601 | 184211 | DPW Maintained 1 | Malus :: Crab Apple 82 | 1483 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5984010.2855 | 2105077.6933 | 37.7592166624085 | -122.498390165683 | (37.7592166624085, -122.498390165683) | 1 | 8 | 3 | 56 | 35 | |||
170891 | 231476 | DPW Maintained 1 | Malus :: Crab Apple 82 | 3343 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6007269.01195 | 2104967.01304 | 37.760249211764 | -122.417942242758 | (37.760249211764, -122.417942242758) | 2 | 4 | 7 | 28859 | 19 | |||
122356 | 193445 | DPW Maintained 1 | Malus :: Crab Apple 82 | 545 Wisconsin St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 6012707.67421 | 2104954.65178 | 37.7605198573339 | -122.399131478736 | (37.7605198573339, -122.399131478736) | 10 | 3 | 8 | 28856 | 29 | |||
80759 | 193451 | DPW Maintained 1 | Malus :: Crab Apple 82 | 760 De Haro St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 9ft | 6012093.60455 | 2104911.13829 | 37.7603661389049 | -122.401252219518 | (37.7603661389049, -122.401252219518) | 10 | 3 | 8 | 28856 | 29 | |||
148705 | 193448 | DPW Maintained 1 | Malus :: Crab Apple 82 | 763 De Haro St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 3ft | 6012158.68635 | 2104851.39826 | 37.7602057367258 | -122.40102293287 | (37.7602057367258, -122.40102293287) | 10 | 3 | 8 | 28856 | 29 | |||
88897 | 193452 | DPW Maintained 1 | Malus :: Crab Apple 82 | 760 San Bruno Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6010967.34674 | 2104724.5547 | 37.7597909235418 | -122.405134303232 | (37.7597909235418, -122.405134303232) | 10 | 3 | 8 | 28856 | 29 | ||||
145908 | 193453 | DPW Maintained 1 | Malus :: Crab Apple 82 | 760 San Bruno Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6010968.44294 | 2104719.45404 | 37.7597769795522 | -122.405130152829 | (37.7597769795522, -122.405130152829) | 10 | 3 | 8 | 28856 | 29 | ||||
181280 | 117508 | Undocumented 4 | Malus :: Crab Apple 82 | 21 MOUNTAIN SPRING AVE | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 9 | 3x10 | Permit Number 778424 | 5997487 | 2104391 | 37.7581122388252 | -122.451731896555 | (37.7581122388252, -122.451731896555) | 15 | 5 | 4 | 28862 | 38 | ||
69983 | 193454 | DPW Maintained 1 | Malus :: Crab Apple 82 | 1751 22nd St | 4 | Side Yard : Yard | Tree | Private 2 | 5 | Width 4ft | 6012836.35508 | 2103764.61447 | 37.7572594461968 | -122.398602916587 | (37.7572594461968, -122.398602916587) | 10 | 3 | 8 | 28856 | 29 | |||
156246 | 193455 | DPW Maintained 1 | Malus :: Crab Apple 82 | 801 Arkansas St | 21 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 6013064.65639 | 2103684.54152 | 37.7570522999402 | -122.397807739653 | (37.7570522999402, -122.397807739653) | 10 | 3 | 8 | 28856 | 29 | ||||
24034 | 231489 | DPW Maintained 1 | Malus :: Crab Apple 82 | 3931 21st St | 5 | Front Yard : Yard | Tree | Private 2 | 10 | 6002270.32487 | 2103522.49736 | 37.7560003260644 | -122.435127007321 | (37.7560003260644, -122.435127007321) | 2 | 4 | 5 | 28862 | 22 | ||||
161676 | 231488 | DPW Maintained 1 | Malus :: Crab Apple 82 | 215 Grand View Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 5ft | 6000742.39523 | 2103201.26061 | 37.7550314072854 | -122.44038804397 | (37.7550314072854, -122.44038804397) | 2 | 4 | 5 | 28862 | 22 | |||
145597 | 193447 | DPW Maintained 1 | Malus :: Crab Apple 82 | 2 Coral Rd | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6012664.55802 | 2102543.04273 | 37.7538957038432 | -122.399111318627 | (37.7538957038432, -122.399111318627) | 10 | 3 | 8 | 28856 | 29 | ||||
1678 | 193446 | DPW Maintained 1 | Malus :: Crab Apple 82 | 2 Coral Rd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 6012678.27331 | 2102537.38996 | 37.7538809468742 | -122.399063490894 | (37.7538809468742, -122.399063490894) | 10 | 3 | 8 | 28856 | 29 | ||||
154390 | 208873 | DPW Maintained 1 | Malus :: Crab Apple 82 | 1915 11th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 5992820.79743 | 2102456.25278 | 37.7525315806908 | -122.46772878318 | (37.7525315806908, -122.46772878318) | 1 | 8 | 4 | 29491 | 12 | |||
60016 | 231480 | DPW Maintained 1 | Malus :: Crab Apple 82 | 20 Elizabeth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006079.38915 | 2102310.97252 | 37.752889317507 | -122.421867923781 | (37.752889317507, -122.421867923781) | 2 | 4 | 5 | 28859 | 19 | |||
62127 | 99799 | Undocumented 4 | Malus :: Crab Apple 82 | 795-797 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001281 | 2102008 | 37.7517856535599 | -122.438439910597 | (37.7517856535599, -122.438439910597) | 2 | 4 | 5 | 28862 | 22 | ||||
142217 | 231484 | DPW Maintained 1 | Malus :: Crab Apple 82 | 404 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6002495.98347 | 2101529.71627 | 37.7505414349405 | -122.4342041491 | (37.7505414349405, -122.4342041491) | 2 | 4 | 5 | 28862 | 22 | |||
106376 | 231485 | DPW Maintained 1 | Malus :: Crab Apple 82 | 404 Jersey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6002474.61105 | 2101529.22297 | 37.7505388673945 | -122.434278021237 | (37.7505388673945, -122.434278021237) | 2 | 4 | 5 | 28862 | 22 | |||
158629 | 231486 | DPW Maintained 1 | Malus :: Crab Apple 82 | 404 Jersey St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6002461.69092 | 2101528.78881 | 37.7505369419476 | -122.434322668959 | (37.7505369419476, -122.434322668959) | 2 | 4 | 5 | 28862 | 22 | |||
170388 | 208874 | DPW Maintained 1 | Malus :: Crab Apple 82 | 88 Sotelo Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5993686.48009 | 2101413.58216 | 37.7497186209261 | -122.464659422191 | (37.7497186209261, -122.464659422191) | 1 | 8 | 4 | 29491 | 40 | |||
61035 | 208875 | DPW Maintained 1 | Malus :: Crab Apple 82 | 24 Sotelo Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5993958.96858 | 2101016.35827 | 37.7486436504797 | -122.463688327067 | (37.7486436504797, -122.463688327067) | 1 | 8 | 4 | 29491 | 40 | |||
122425 | 208876 | DPW Maintained 1 | Malus :: Crab Apple 82 | 24 Sotelo Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5993960.68043 | 2101012.29566 | 37.7486325942246 | -122.463682112736 | (37.7486325942246, -122.463682112736) | 1 | 8 | 4 | 29491 | 40 | |||
38391 | 56772 | Permitted Site 7 | Malus :: Crab Apple 82 | 4147 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2016 12:00:00 AM | 3 | Permit Number 777832 | 6002943.47271565 | 2100629.70644343 | 37.7480956077539 | -122.432592417618 | (37.7480956077539, -122.432592417618) | 2 | 4 | 5 | 63 | 22 | ||
140393 | 231479 | DPW Maintained 1 | Malus :: Crab Apple 82 | 600x San Jose Ave | 3 | Median : Yard | Tree | DPW 1 | 4 | Width 8ft | 6005963.86198 | 2099704.0736 | 37.7457248540265 | -122.422082256503 | (37.7457248540265, -122.422082256503) | 2 | 7 | 5 | 28859 | 22 | |||
190735 | 231478 | DPW Maintained 1 | Malus :: Crab Apple 82 | 600x San Jose Ave | 2 | Median : Yard | Tree | DPW 1 | 4 | Width 8ft | 6005969.94367 | 2099650.47553 | 37.745578028917 | -122.422057419928 | (37.745578028917, -122.422057419928) | 2 | 7 | 5 | 28859 | 2 | |||
35381 | 231477 | DPW Maintained 1 | Malus :: Crab Apple 82 | 600x San Jose Ave | 1 | Median : Yard | Tree | DPW 1 | 4 | Width 8ft | 6005974.01132 | 2099648.68915 | 37.7455733533412 | -122.422043227715 | (37.7455733533412, -122.422043227715) | 2 | 7 | 5 | 28859 | 2 | |||
188003 | 246802 | DPW Maintained 1 | Malus :: Crab Apple 82 | 369 Mullen Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 6ft | 6010622.51697 | 2099596.58355 | 37.7456913641809 | -122.405965658085 | (37.7456913641809, -122.405965658085) | 2 | 7 | 7 | 28859 | 2 | |||
35497 | 208885 | DPW Maintained 1 | Malus :: Crab Apple 82 | 175 Vasquez Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5994860.83688 | 2099398.63743 | 37.7442537214346 | -122.460452495288 | (37.7442537214346, -122.460452495288) | 1 | 8 | 4 | 59 | 40 | |||
144029 | 11192 | DPW Maintained 1 | Malus :: Crab Apple 82 | 156 Idora Ave | 1 | Median : Cutout | Tree | DPW 1 | 12 | 8 | 5995565.7362355 | 2099396.4910429 | 37.7442883537687 | -122.458014965266 | (37.7442883537687, -122.458014965266) | 1 | 8 | 4 | 59 | 40 | |||
156327 | 246661 | DPW Maintained 1 | Malus :: Crab Apple 82 | 3301 Harrison St | 1 | Side Yard : Yard | Tree | Private 2 | 4 | Width 3ft | 6009058.25509 | 2099385.89739 | 37.7450252552125 | -122.411359783627 | (37.7450252552125, -122.411359783627) | 2 | 7 | 7 | 28859 | 2 | |||
173142 | 4977 | DPW Maintained 1 | Malus :: Crab Apple 82 | 5200X Diamond Heights Blvd | 13 | Median : Cutout | Tree | DPW 1 | 12 | 12 | 6000986.47805 | 2099376.03086 | 37.7445421376042 | -122.439269772981 | (37.7445421376042, -122.439269772981) | 2 | 7 | 5 | 63 | 7 | |||
37326 | 231483 | DPW Maintained 1 | Malus :: Crab Apple 82 | 1604 Diamond St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 6002002.63462 | 2099363.53444 | 37.7445655982382 | -122.435755219736 | (37.7445655982382, -122.435755219736) | 2 | 7 | 5 | 63 | 22 | |||
20999 | 231487 | DPW Maintained 1 | Malus :: Crab Apple 82 | 2119 Castro St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | Width 8ft | 6002708.75912 | 2099359.82748 | 37.7445955042953 | -122.433313320275 | (37.7445955042953, -122.433313320275) | 2 | 7 | 5 | 63 | 22 | |||
131950 | 11189 | DPW Maintained 1 | Malus :: Crab Apple 82 | 130 Idora Ave | 1 | Median : Cutout | Tree | DPW 1 | 6 | 8 | 5995756.5668063 | 2099351.3416202 | 37.7441753471304 | -122.457351852348 | (37.7441753471304, -122.457351852348) | 1 | 8 | 4 | 59 | 40 | |||
14757 | 208879 | DPW Maintained 1 | Malus :: Crab Apple 82 | 100x Idora Ave | 19 | Median : Yard | Tree | DPW 1 | 7 | Width 9ft | 5995727.40355 | 2099320.34097 | 37.7440885519582 | -122.457450449475 | (37.7440885519582, -122.457450449475) | 1 | 8 | 4 | 59 | 40 | |||
191249 | 208880 | DPW Maintained 1 | Malus :: Crab Apple 82 | 331 Kensington Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5994249.09162 | 2099012.51392 | 37.7431583121036 | -122.462539760623 | (37.7431583121036, -122.462539760623) | 1 | 8 | 4 | 59 | 40 | |||
73376 | 181939 | DPW Maintained 1 | Malus :: Crab Apple 82 | 2435 33rd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 0ft | 5986090.3717 | 2098658.104 | 37.7417119717507 | -122.490723983614 | (37.7417119717507, -122.490723983614) | 1 | 8 | 3 | 29491 | 35 | |||
93944 | 183470 | DPW Maintained 1 | Malus :: Crab Apple 82 | 2535 26th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 0ft | 5988285.2504 | 2098036.7141 | 37.7401337687504 | -122.483089381496 | (37.7401337687504, -122.483089381496) | 1 | 8 | 3 | 29491 | 35 | |||
66097 | 231471 | DPW Maintained 1 | Malus :: Crab Apple 82 | 200 Kingston St | 8 | Front Yard : Yard | Tree | Private 2 | 6 | Width 8ft | 6006257.11637 | 2098029.51803 | 37.7411434377107 | -122.42094935264 | (37.7411434377107, -122.42094935264) | 2 | 7 | 7 | 28859 | 2 | |||
148199 | 231472 | DPW Maintained 1 | Malus :: Crab Apple 82 | 200 Kingston St | 9 | Front Yard : Yard | Tree | Private 2 | 4 | Width 8ft | 6006266.14334 | 2098022.56531 | 37.7411248559331 | -122.420917647057 | (37.7411248559331, -122.420917647057) | 2 | 7 | 7 | 28859 | 2 | |||
141816 | 231495 | DPW Maintained 1 | Malus :: Crab Apple 82 | 339 Addison St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 5ft | 6002243.19948 | 2097700.16893 | 37.7400120465212 | -122.434804469057 | (37.7400120465212, -122.434804469057) | 2 | 7 | 5 | 63 | 7 | |||
119727 | 231493 | DPW Maintained 1 | Malus :: Crab Apple 82 | 339 Addison St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 6002237.63018 | 2097698.28157 | 37.7400065480711 | -122.434823590441 | (37.7400065480711, -122.434823590441) | 2 | 7 | 5 | 63 | 7 | |||
30178 | 231494 | DPW Maintained 1 | Malus :: Crab Apple 82 | 339 Addison St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 6002235.98479 | 2097691.64052 | 37.7399882198726 | -122.434828804717 | (37.7399882198726, -122.434828804717) | 2 | 7 | 5 | 63 | 7 | |||
129380 | 231473 | DPW Maintained 1 | Malus :: Crab Apple 82 | 400 Prospect Ave | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6006235.9692 | 2097629.5715 | 37.7400440821557 | -122.420994082235 | (37.7400440821557, -122.420994082235) | 2 | 7 | 7 | 28859 | 2 | ||||
14342 | 185383 | DPW Maintained 1 | Malus :: Crab Apple 82 | 2611 45th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 0ft | 5982402.2599 | 2097319.6826 | 37.7378209010805 | -122.503376950994 | (37.7378209010805, -122.503376950994) | 1 | 8 | 3 | 29491 | 35 | |||
152179 | 231490 | DPW Maintained 1 | Malus :: Crab Apple 82 | 144 Fairmount St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6004625.22033 | 2097267.44339 | 37.7389588315807 | -122.42653761393 | (37.7389588315807, -122.42653761393) | 2 | 7 | 5 | 63 | 7 | |||
188281 | 208877 | DPW Maintained 1 | Malus :: Crab Apple 82 | 136 Casitas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5995442.32442 | 2097008.84044 | 37.7377253637243 | -122.458268913495 | (37.7377253637243, -122.458268913495) | 9 | 7 | 4 | 59 | 40 | |||
36698 | 231475 | DPW Maintained 1 | Malus :: Crab Apple 82 | 107 Bronte St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6009335.06778 | 2096837.2879 | 37.7380428514016 | -122.410222705119 | (37.7380428514016, -122.410222705119) | 10 | 7 | 7 | 28859 | 2 | |||
22243 | 231467 | DPW Maintained 1 | Malus :: Crab Apple 82 | 1100 San Jose Ave | 54 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6004723.8665 | 2096633.35194 | 37.7372233360818 | -122.426151410869 | (37.7372233360818, -122.426151410869) | 2 | 7 | 5 | 63 | 7 | ||||
116776 | 231468 | DPW Maintained 1 | Malus :: Crab Apple 82 | 1100 San Jose Ave | 55 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6004726.49867 | 2096628.95996 | 37.7372114254688 | -122.426141997667 | (37.7372114254688, -122.426141997667) | 2 | 7 | 5 | 63 | 7 | ||||
47430 | 231469 | DPW Maintained 1 | Malus :: Crab Apple 82 | 1100 San Jose Ave | 56 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6004732.5768 | 2096627.96754 | 37.7372090440461 | -122.426120912148 | (37.7372090440461, -122.426120912148) | 2 | 7 | 5 | 63 | 7 | ||||
166690 | 208878 | DPW Maintained 1 | Malus :: Crab Apple 82 | 430 Lansdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5995998.78542 | 2096380.30117 | 37.7360315086418 | -122.456299537593 | (37.7360315086418, -122.456299537593) | 9 | 7 | 4 | 59 | 40 | |||
36495 | 193460 | DPW Maintained 1 | Malus :: Crab Apple 82 | 1501 Quint St | 7 | Front Yard : Yard | Tree | Private 2 | 5 | Width 4ft | 6013283.26948 | 2096377.10518 | 37.736999805981 | -122.396539468037 | (37.736999805981, -122.396539468037) | 10 | 3 | 8 | 58 | 1 | |||
152545 | 193459 | DPW Maintained 1 | Malus :: Crab Apple 82 | 1501 Quint St | 6 | Front Yard : Yard | Tree | Private 2 | 3 | Width 4ft | 6013276.74454 | 2096368.79771 | 37.7369766322662 | -122.396561445667 | (37.7369766322662, -122.396561445667) | 10 | 3 | 8 | 58 | 1 | |||
104038 | 193458 | DPW Maintained 1 | Malus :: Crab Apple 82 | 1501 Quint St | 5 | Front Yard : Yard | Tree | Private 2 | 3 | Width 4ft | 6013271.57889 | 2096363.22177 | 37.7369610344099 | -122.396578915001 | (37.7369610344099, -122.396578915001) | 10 | 3 | 8 | 58 | 1 | |||
114857 | 193457 | DPW Maintained 1 | Malus :: Crab Apple 82 | 1501 Quint St | 4 | Front Yard : Yard | Tree | Private 2 | 4 | Width 4ft | 6013271.29091 | 2096357.05994 | 37.7369440992788 | -122.396579478874 | (37.7369440992788, -122.396579478874) | 10 | 3 | 8 | 58 | 1 | |||
108858 | 231491 | DPW Maintained 1 | Malus :: Crab Apple 82 | 231 Surrey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6001952.57165 | 2096161.99375 | 37.7357720695123 | -122.435699318774 | (37.7357720695123, -122.435699318774) | 2 | 7 | 5 | 63 | 7 | |||
36521 | 231492 | DPW Maintained 1 | Malus :: Crab Apple 82 | 118 Saint Marys Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 6003928.90104 | 2095975.35964 | 37.7353716742659 | -122.428853075008 | (37.7353716742659, -122.428853075008) | 2 | 7 | 5 | 63 | 7 | |||
142430 | 231470 | DPW Maintained 1 | Malus :: Crab Apple 82 | 200 Saint Marys Ave | 4 | Side Yard : Yard | Tree | Private 2 | 5 | Width 2ft | 6003936.80205 | 2095969.7041 | 37.7353565926307 | -122.42882535522 | (37.7353565926307, -122.42882535522) | 2 | 7 | 5 | 63 | 7 | |||
107357 | 208890 | DPW Maintained 1 | Malus :: Crab Apple 82 | 843 Detroit St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 5ft | 5999418.03526 | 2095622.98585 | 37.734147790474 | -122.444423445903 | (37.734147790474, -122.444423445903) | 9 | 7 | 4 | 59 | 40 | |||
15570 | 208891 | DPW Maintained 1 | Malus :: Crab Apple 82 | 843 Detroit St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 5ft | 5999418.11372 | 2095604.85507 | 37.7340980120977 | -122.444421872075 | (37.7340980120977, -122.444421872075) | 9 | 7 | 4 | 59 | 40 | |||
21017 | 111270 | DPW Maintained 1 | Malus :: Crab Apple 82 | 700X BOSWORTH ST | 8 | Front Yard : Yard | Tree | DPW 1 | 10 | 6002150 | 2095428 | 37.7337679036822 | -122.434964255854 | (37.7337679036822, -122.434964255854) | 2 | 7 | 5 | 63 | 7 | ||||
190829 | 208889 | DPW Maintained 1 | Malus :: Crab Apple 82 | 714 Detroit St | 10 | Side Yard : Yard | Tree | Private 2 | 6 | 5999450.60571 | 2095416.85302 | 37.7335836565405 | -122.444296031762 | (37.7335836565405, -122.444296031762) | 9 | 7 | 4 | 63 | 40 | ||||
127109 | 208887 | DPW Maintained 1 | Malus :: Crab Apple 82 | 747 Detroit St | 9 | Side Yard : Yard | Tree | Private 2 | 5 | 5999422.56432 | 2095411.39604 | 37.7335670730599 | -122.444392586573 | (37.7335670730599, -122.444392586573) | 9 | 7 | 4 | 59 | 40 | ||||
36965 | 208888 | DPW Maintained 1 | Malus :: Crab Apple 82 | 747 Detroit St | 10 | Side Yard : Yard | Tree | Private 2 | 1 | 5999417.48531 | 2095405.5962 | 37.7335508582727 | -122.444409729441 | (37.7335508582727, -122.444409729441) | 9 | 7 | 4 | 59 | 40 | ||||
108991 | 231481 | DPW Maintained 1 | Malus :: Crab Apple 82 | 60 Murray St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 8ft | 6004906.20838 | 2095274.16541 | 37.7335016194909 | -122.425424273006 | (37.7335016194909, -122.425424273006) | 2 | 7 | 7 | 28861 | 2 | |||
73687 | 231482 | DPW Maintained 1 | Malus :: Crab Apple 82 | 60 Murray St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 8ft | 6004917.71249 | 2095272.09944 | 37.7334965967716 | -122.425384353019 | (37.7334965967716, -122.425384353019) | 2 | 7 | 7 | 28861 | 2 | |||
79973 | 208886 | DPW Maintained 1 | Malus :: Crab Apple 82 | 100 Joost Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 6001302.89972 | 2094970.3961 | 37.7324632946503 | -122.437860163028 | (37.7324632946503, -122.437860163028) | 9 | 7 | 5 | 63 | 40 | |||
119762 | 208892 | DPW Maintained 1 | Malus :: Crab Apple 82 | 501 Joost Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 10ft | 5998746.62253 | 2094953.78578 | 37.7322719935398 | -122.446696588498 | (37.7322719935398, -122.446696588498) | 9 | 7 | 4 | 59 | 40 | |||
32185 | 208893 | DPW Maintained 1 | Malus :: Crab Apple 82 | 326 Detroit St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 7ft | 5999451.44674 | 2094281.11232 | 37.7304652267742 | -122.444211538625 | (37.7304652267742, -122.444211538625) | 9 | 7 | 4 | 63 | 40 | |||
131051 | 208881 | DPW Maintained 1 | Malus :: Crab Apple 82 | 298 Staples Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 5998181.94254 | 2093824.01975 | 37.7291376502845 | -122.448567470638 | (37.7291376502845, -122.448567470638) | 9 | 7 | 4 | 28861 | 40 | ||||
135468 | 208894 | DPW Maintained 1 | Malus :: Crab Apple 82 | 279 Staples Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 5998236.07882 | 2093773.59941 | 37.7290023032069 | -122.448376688427 | (37.7290023032069, -122.448376688427) | 9 | 7 | 4 | 28861 | 40 | ||||
78883 | 202162 | DPW Maintained 1 | Malus :: Crab Apple 82 | 10 Kalmanovitz St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 2ft | 6013172.6175 | 2093312.6442 | 37.7285792692962 | -122.396707277937 | (37.7285792692962, -122.396707277937) | 10 | 3 | 8 | 58 | 1 | |||
187628 | 177483 | DPW Maintained 1 | Malus :: Crab Apple 82 | 37 Vienna St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 6005099.05752 | 2093268.21852 | 37.7280046286024 | -122.424614893969 | (37.7280046286024, -122.424614893969) | 9 | 7 | 6 | 28861 | 5 | ||||
59272 | 177484 | DPW Maintained 1 | Malus :: Crab Apple 82 | 214 Athens St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6004659.61687 | 2092165.75361 | 37.7249526758206 | -122.426055604304 | (37.7249526758206, -122.426055604304) | 9 | 7 | 6 | 28861 | 5 | ||||
166119 | 177481 | DPW Maintained 1 | Malus :: Crab Apple 82 | 498 Capistrano Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 6000793.16636 | 2092058.90584 | 37.7244400127919 | -122.439413801227 | (37.7244400127919, -122.439413801227) | 9 | 7 | 6 | 28861 | 25 | |||
124887 | 177482 | DPW Maintained 1 | Malus :: Crab Apple 82 | 498 Capistrano Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 6000792.34501 | 2092048.92501 | 37.7244125609655 | -122.439415925402 | (37.7244125609655, -122.439415925402) | 9 | 7 | 6 | 28861 | 25 | |||
12683 | 30939 | DPW Maintained 1 | Malus :: Crab Apple 82 | 1106 Plymouth Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/13/1995 12:00:00 AM | 2 | 3x32l | Permit Number 34749 | 5995956.73481 | 2091308.07941 | 37.7221019930946 | -122.456078325968 | (37.7221019930946, -122.456078325968) | 9 | 8 | 4 | 28861 | 24 | |
180403 | 208883 | DPW Maintained 1 | Malus :: Crab Apple 82 | 350 Faxon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5994771.01328 | 2090927.26714 | 37.7209882430054 | -122.460149470526 | (37.7209882430054, -122.460149470526) | 9 | 8 | 6 | 28861 | 24 |
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) );