trees
121 rows where qSpecies_id = 82 sorted by qSpecies_id 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
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 | ||||
4797 | 19759 | DPW Maintained 1 | Malus :: Crab Apple 82 | 100 STAIRWAY15 | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 20ST | |||||||||||||
10841 | 177480 | DPW Maintained 1 | Malus :: Crab Apple 82 | 289 Flournoy St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | 5993810.32054 | 2086750.18301 | 37.7094636621006 | -122.463167341725 | (37.7094636621006, -122.463167341725) | 9 | 8 | 6 | 28861 | 25 | ||||
11647 | 19855 | DPW Maintained 1 | Malus :: Crab Apple 82 | 100 STAIRWAY29 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 100ST | |||||||||||||
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 | |
13342 | 19760 | DPW Maintained 1 | Malus :: Crab Apple 82 | 100 STAIRWAY15 | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 20ST | |||||||||||||
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 | |||
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 | |||
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 | |||
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 | |||
17783 | 19925 | DPW Maintained 1 | Malus :: Crab Apple 82 | 100 STAIRWAY37 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 20ST | |||||||||||||
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 | |||
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 | ||||
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 | ||||
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 | ||||
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 | |||
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 | |||
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 | ||||
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 | |||
32566 | 208882 | DPW Maintained 1 | Malus :: Crab Apple 82 | 322 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5994766.71833 | 2090736.01345 | 37.7204628590582 | -122.460150467892 | (37.7204628590582, -122.460150467892) | 9 | 8 | 6 | 28861 | 24 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||||
37159 | 177479 | DPW Maintained 1 | Malus :: Crab Apple 82 | 275 De Long St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 10ft | 5993713.98854 | 2086795.12422 | 37.7095815101473 | -122.463503537957 | (37.7095815101473, -122.463503537957) | 9 | 8 | 6 | 28861 | 25 | |||
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 | |||
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 | ||
46699 | 177474 | DPW Maintained 1 | Malus :: Crab Apple 82 | 700x Mansell St | 3 | Median : Cutout | Tree | DPW 1 | 11 | Width 0ft | 6009738.6483 | 2090119.17864 | 37.7196189577185 | -122.408353599158 | (37.7196189577185, -122.408353599158) | 9 | 3 | 8 | 309 | 18 | |||
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 | ||||
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 | |||
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 | |||
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 | ||||
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 | |||
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 | |||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||||
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 | |||
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 | |||
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 | |||
84907 | 208884 | DPW Maintained 1 | Malus :: Crab Apple 82 | 450 Bright St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 4ft | 5993793.06593 | 2090164.68597 | 37.7188380799952 | -122.46347460498 | (37.7188380799952, -122.46347460498) | 9 | 8 | 6 | 64 | 24 | |||
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 | ||||
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 | ||||
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 | ||||
90684 | 177478 | DPW Maintained 1 | Malus :: Crab Apple 82 | 87 Cora St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 3ft | 6009587.04075 | 2087300.588 | 37.7118711966627 | -122.408678919018 | (37.7118711966627, -122.408678919018) | 9 | 7 | 8 | 309 | 39 | |||
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 | |||
102324 | 44446 | DPW Maintained 1 | Malus :: Crab Apple 82 | 59 Winding Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2015 12:00:00 AM | 1 | 3x3 | Permit Number 776702 | 6002663.70845 | 2086958.55404 | 37.7105418493914 | -122.432583452082 | (37.7105418493914, -122.432583452082) | 9 | 7 | 6 | 28861 | 5 | |
104025 | 177473 | DPW Maintained 1 | Malus :: Crab Apple 82 | 661 London St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | 6001084.39959 | 2089950.75515 | 37.7186680775449 | -122.438256094064 | (37.7186680775449, -122.438256094064) | 9 | 7 | 6 | 28861 | 5 | ||||
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 | |||
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 | |||
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 | |||
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 | ||
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 | |||
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 | |||
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 | |||
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 | |||
115277 | 177471 | DPW Maintained 1 | Malus :: Crab Apple 82 | 184 Mount Vernon Ave | 3 | Side Yard : Yard | Tree | Private 2 | 9 | 5998983.26506 | 2089357.76175 | 37.7169201246297 | -122.445476221974 | (37.7169201246297, -122.445476221974) | 9 | 7 | 6 | 28861 | 25 | ||||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
124211 | 114679 | DPW Maintained 1 | Malus :: Crab Apple 82 | 836 Brussels St | 1 | Front Yard : Cutout | Tree | Private 2 | 12/01/2015 12:00:00 AM | 1 | Permit Number 774714 | 6011176.24092 | 2090873.36995 | 37.7217702116011 | -122.403437363447 | (37.7217702116011, -122.403437363447) | 10 | 3 | 7 | 309 | 28 | ||
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 | |||
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 | |||
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 | ||||
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 | ||||
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 | ||||
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 | |||
134041 | 177470 | DPW Maintained 1 | Malus :: Crab Apple 82 | 184 Mount Vernon Ave | 2 | Side Yard : Yard | Tree | Private 2 | 9 | 5998987.4843 | 2089354.3008 | 37.7169108625194 | -122.445461389446 | (37.7169108625194, -122.445461389446) | 9 | 7 | 6 | 28861 | 25 | ||||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||||
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 | ||||
146342 | 177469 | DPW Maintained 1 | Malus :: Crab Apple 82 | 200 Rome St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5998624.12491 | 2088874.96347 | 37.7155739618475 | -122.44668287204 | (37.7155739618475, -122.44668287204) | 9 | 7 | 6 | 28861 | 25 | |||
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 | |||
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 | |||
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 | |||||
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 | |||
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 | |||
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 | |||
154600 | 177475 | DPW Maintained 1 | Malus :: Crab Apple 82 | 631 Campbell Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009520.83405 | 2088792.43347 | 37.7159637900627 | -122.409012944318 | (37.7159637900627, -122.409012944318) | 9 | 7 | 8 | 309 | 39 | |||
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 | |||
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 | ||||
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 | |||
158247 | 177477 | DPW Maintained 1 | Malus :: Crab Apple 82 | 87 Cora St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 3ft | 6009582.84307 | 2087291.35745 | 37.7118456163483 | -122.408692776665 | (37.7118456163483, -122.408692776665) | 9 | 7 | 8 | 309 | 39 |
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) );