121 rows where qSpecies_id = 82 sorted by SiteOrder

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)
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
4797 19759 DPW Maintained 1 Malus :: Crab Apple 82 100 STAIRWAY15 17 Sidewalk: Curb side : Cutout Tree DPW 1     3 20ST                      
13342 19760 DPW Maintained 1 Malus :: Crab Apple 82 100 STAIRWAY15 18 Sidewalk: Curb side : Cutout Tree DPW 1     3 20ST                      
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
11647 19855 DPW Maintained 1 Malus :: Crab Apple 82 100 STAIRWAY29 5 Sidewalk: Curb side : Cutout Tree DPW 1     6 100ST                      
17783 19925 DPW Maintained 1 Malus :: Crab Apple 82 100 STAIRWAY37 5 Sidewalk: Curb side : Cutout Tree DPW 1     3 20ST                      
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
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

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