121 rows where qSpecies_id = 82 sorted by DBH

View and edit SQL

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)
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
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
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
175413 96996 Significant Tree 6 Malus :: Crab Apple 82 2451X Griffith St   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF         6015858.3 2090034.7 37.7197277910807 -122.387194089236 (37.7197277910807, -122.387194089236) 10 3 8 58 1
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
187344 177476 DPW Maintained 1 Malus :: Crab Apple 82 87 Cora St 1 Sidewalk: Curb side : Pot Tree Private 2     2 Width 3ft   6009578.57754 2087278.80094 37.7118108998241 -122.408706634324 (37.7118108998241, -122.408706634324) 9 7 8 309 39
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
13342 19760 DPW Maintained 1 Malus :: Crab Apple 82 100 STAIRWAY15 18 Sidewalk: Curb side : Cutout Tree DPW 1     3 20ST                      
17783 19925 DPW Maintained 1 Malus :: Crab Apple 82 100 STAIRWAY37 5 Sidewalk: Curb side : Cutout Tree DPW 1     3 20ST                      
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
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
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
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
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
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
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
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
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
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
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
173353 177472 DPW Maintained 1 Malus :: Crab Apple 82 1 Balhi Ct 2 Sidewalk: Curb side : Pot Tree Private 2     3 Width 1ft   6000768.04066 2090886.53495 37.7212195189404 -122.439416658362 (37.7212195189404, -122.439416658362) 9 7 6 28861 25
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
11647 19855 DPW Maintained 1 Malus :: Crab Apple 82 100 STAIRWAY29 5 Sidewalk: Curb side : Cutout Tree DPW 1     6 100ST                      
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
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
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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);