1,977 rows where qSpecies_id = 41 sorted by Latitude

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)
101411 176137 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 800 John Muir Dr 5 : Tree Private 2     11 Width 0ft   5987255.345 2086484.45942 37.708354258405 -122.485802654386 (37.708354258405, -122.485802654386) 1 8 4 64 14
178909 176103 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 50 Kelloch Ave 1 Sidewalk: Curb side : Pot Tree Private 2     14 Width 6ft   6008313.99103 2086238.62297 37.7088838754685 -122.413003909814 (37.7088838754685, -122.413003909814) 9 7 8 309 39
62452 176111 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 520 Carter St 4 Sidewalk: Curb side : Yard Tree Private 2     64     6005239.18473 2086329.30196 37.7089597755375 -122.423637326411 (37.7089597755375, -122.423637326411) 9 7 8 309 5
87265 86903 Permitted Site 7 Cupressus macrocarpa :: Monterey Cypress 41 233 Drake St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/30/2007 12:00:00 AM   3x3 Permit Number 49863 6001780 2086418 37.7090074518569 -122.435599089406 (37.7090074518569, -122.435599089406) 9 7 6 28861 5
73365 176102 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 62 Tomaso Ct 5 Front Yard : Yard Tree Private 2     20 Width 8ft   6009173.04361 2086270.92749 37.7090207630614 -122.410037170481 (37.7090207630614, -122.410037170481) 9 7 8 309 39
161125 176110 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 520 Carter St 3 Sidewalk: Curb side : Yard Tree Private 2     47     6005248.37143 2086351.63031 37.7090216030216 -122.423607162245 (37.7090216030216, -122.423607162245) 9 7 8 309 5
92013 176112 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 35 Tomaso Ct 4 Side Yard : Yard Tree Private 2     15 Width 3ft   6009187.4096 2086275.44759 37.7090339795175 -122.409987838189 (37.7090339795175, -122.409987838189) 9 7 8 309 39
140987 176113 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1 Santa Barbara Ave 5 Sidewalk: Property side : Yard Tree Private 2     1 Width 8ft   5993424.30452 2086604.0814 37.709040256765 -122.464490865868 (37.709040256765, -122.464490865868) 9 8 6 28861 25
160925 176109 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 520 Carter St 2 Sidewalk: Curb side : Yard Tree Private 2     15     6005252.95246 2086362.20208 37.7090508894465 -122.423592080633 (37.7090508894465, -122.423592080633) 9 7 8 309 5
191786 176108 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 520 Carter St 1 Sidewalk: Curb side : Yard Tree Private 2     25     6005255.13814 2086372.03343 37.7090780076251 -122.4235852251 (37.7090780076251, -122.4235852251) 9 7 8 309 5
171687 251422 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 480x De Long St   Front Yard : Yard Tree Private 2       3x3   5992963 2086633 37.709093057148 -122.466087289133 (37.709093057148, -122.466087289133) 9 8 6 28861 25
29536 12500 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1200X Lake Merced Blvd 2 Median : Cutout Tree DPW 1     6 8   5987438.4549992 2087542.2692131 37.7112694082243 -122.485247377649 (37.7112694082243, -122.485247377649) 1 8 4 64 14
70270 12501 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1200X Lake Merced Blvd 3 Median : Cutout Tree DPW 1     6 8   5987438.4549992 2087542.2692131 37.7112694082243 -122.485247377649 (37.7112694082243, -122.485247377649) 1 8 4 64 14
78647 12502 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1200X Lake Merced Blvd 4 Median : Cutout Tree DPW 1     12 8   5987438.4549992 2087542.2692131 37.7112694082243 -122.485247377649 (37.7112694082243, -122.485247377649) 1 8 4 64 14
79130 206846 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 10 Brotherhood Way 1 Side Yard : Cutout Tree Private 2     25 Width 0ft   5993694.0595 2087568.46764 37.7117037797802 -122.463628505047 (37.7117037797802, -122.463628505047) 9 8 4 64 24
164123 206848 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 10 Brotherhood Way 3 : Tree Private 2     11 Width 0ft   5993673.9414 2087579.01676 37.7117315859181 -122.46369880328 (37.7117315859181, -122.46369880328) 9 8 4 64 24
115250 206847 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 10 Brotherhood Way 2 : Tree Private 2     16 Width 0ft   5993688.70591 2087590.28087 37.7117633652539 -122.463648590504 (37.7117633652539, -122.463648590504) 9 8 4 64 24
171327 111287 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 450 ROLPH ST 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6002226 2087613 37.7123139824471 -122.434143019741 (37.7123139824471, -122.434143019741) 9 7 6 28861 5
137083 106962 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 218 SADOWA ST 3 Sidewalk: Property side : Cutout Tree Private 2     22     5994814 2087793.9 37.7123872323548 -122.459774032106 (37.7123872323548, -122.459774032106) 9 8 6 28861 24
27394 251152 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 625 Brotherhood Way 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5991521 2087959 37.7126506341802 -122.471167551627 (37.7126506341802, -122.471167551627) 9 8 4 64 24
27900 251155 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 625 Brotherhood Way 8 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5991521 2087959 37.7126506341802 -122.471167551627 (37.7126506341802, -122.471167551627) 9 8 4 64 24
42203 251150 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 625 Brotherhood Way 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5991521 2087959 37.7126506341802 -122.471167551627 (37.7126506341802, -122.471167551627) 9 8 4 64 24
43971 251151 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 625 Brotherhood Way 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5991521 2087959 37.7126506341802 -122.471167551627 (37.7126506341802, -122.471167551627) 9 8 4 64 24
62262 251148 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 625 Brotherhood Way 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5991521 2087959 37.7126506341802 -122.471167551627 (37.7126506341802, -122.471167551627) 9 8 4 64 24
75890 251156 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 625 Brotherhood Way 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5991521 2087959 37.7126506341802 -122.471167551627 (37.7126506341802, -122.471167551627) 9 8 4 64 24
93298 251153 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 625 Brotherhood Way 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5991521 2087959 37.7126506341802 -122.471167551627 (37.7126506341802, -122.471167551627) 9 8 4 64 24
110996 251149 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 625 Brotherhood Way 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5991521 2087959 37.7126506341802 -122.471167551627 (37.7126506341802, -122.471167551627) 9 8 4 64 24
156007 251154 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 625 Brotherhood Way 7 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5991521 2087959 37.7126506341802 -122.471167551627 (37.7126506341802, -122.471167551627) 9 8 4 64 24
169721 251159 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 625 Brotherhood Way 12 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5991521 2087959 37.7126506341802 -122.471167551627 (37.7126506341802, -122.471167551627) 9 8 4 64 24
171756 251158 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 625 Brotherhood Way 11 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5991521 2087959 37.7126506341802 -122.471167551627 (37.7126506341802, -122.471167551627) 9 8 4 64 24
192415 251157 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 625 Brotherhood Way 10 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5991521 2087959 37.7126506341802 -122.471167551627 (37.7126506341802, -122.471167551627) 9 8 4 64 24
139557 2290 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 600X Brotherhood Way 5 Median : Cutout Tree DPW 1   08/30/2016 12:00:00 AM 3 14M Permit Number 777532 5991856 2088020 37.7128374968227 -122.470014135427 (37.7128374968227, -122.470014135427) 9 8 6 64 24
151272 2289 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 600X Brotherhood Way 4 Median : Cutout Tree DPW 1   08/30/2016 12:00:00 AM 3 14M Permit Number 777532 5991856 2088020 37.7128374968227 -122.470014135427 (37.7128374968227, -122.470014135427) 9 8 6 64 24
27736 2271 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 700X Brotherhood Way 5 Median : Cutout Tree DPW 1     25 14M   5990752.82343 2088228.49759 37.7133461459728 -122.473842234135 (37.7133461459728, -122.473842234135) 1 8 4 64 14
50924 2270 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 700X Brotherhood Way 4 Median : Cutout Tree DPW 1     6 14M   5990735.60667 2088236.94426 37.7133683412468 -122.473902356505 (37.7133683412468, -122.473902356505) 1 8 4 64 14
50382 2269 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 700X Brotherhood Way 3 Median : Cutout Tree DPW 1     6 14M   5990714.96133 2088247.7727 37.7133968776506 -122.473974502829 (37.7133968776506, -122.473974502829) 1 8 4 64 14
131894 2256 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 700X Brotherhood Way 2 Median : Cutout Tree DPW 1     15     5990689.72825 2088261.00769 37.7134317560555 -122.474062681368 (37.7134317560555, -122.474062681368) 1 8 4 64 14
185567 2255 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 700X Brotherhood Way 1 Median : Cutout Tree DPW 1     17     5990660.02895 2088282.42041 37.7134888297138 -122.474166893001 (37.7134888297138, -122.474166893001) 1 8 4 64 14
10153 262205 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 2 Lois Ln 1 Back Yard : Yard Tree Private 2       3x3   6012244 2087959 37.7138275196569 -122.39954186434 (37.7138275196569, -122.39954186434) 10 3 8 309 1
105177 176138 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 10 Lake Merced Blvd 1 : Tree Private 2     16 Width 0ft   5987453.76086 2088540.35852 37.7140108025207 -122.485267666593 (37.7140108025207, -122.485267666593) 1 8 4 64 14
56871 176139 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 10 Lake Merced Blvd 2 : Tree Private 2     10 Width 0ft   5987453.25598 2088569.38174 37.7140904635658 -122.485271539962 (37.7140904635658, -122.485271539962) 1 8 4 64 14
56804 176140 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 10 Lake Merced Blvd 3 : Tree Private 2     15 Width 0ft   5987455.89858 2088588.29538 37.7141425496068 -122.485263793215 (37.7141425496068, -122.485263793215) 1 8 4 64 14
6706 255369 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 800X Brotherhood Way 4 Median : Cutout Tree DPW 1       14x10   5990271 2088582 37.7142888575797 -122.475533361779 (37.7142888575797, -122.475533361779) 1 8 4 64 14
33801 114265 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 800x BROTHERHOOD WAY 6 Front Yard : Cutout Tree Private 2     26     5990271 2088582 37.7142888575797 -122.475533361779 (37.7142888575797, -122.475533361779) 1 8 4 64 14
47800 255367 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 800X Brotherhood Way 2 Median : Cutout Tree DPW 1       14x10   5990271 2088582 37.7142888575797 -122.475533361779 (37.7142888575797, -122.475533361779) 1 8 4 64 14
64580 114269 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 800x BROTHERHOOD WAY 10 Front Yard : Yard Tree Private 2     38     5990271 2088582 37.7142888575797 -122.475533361779 (37.7142888575797, -122.475533361779) 1 8 4 64 14
80560 114268 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 800x BROTHERHOOD WAY 9 Front Yard : Yard Tree Private 2     30     5990271 2088582 37.7142888575797 -122.475533361779 (37.7142888575797, -122.475533361779) 1 8 4 64 14
143168 114267 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 800x BROTHERHOOD WAY 8 Front Yard : Yard Tree Private 2     50     5990271 2088582 37.7142888575797 -122.475533361779 (37.7142888575797, -122.475533361779) 1 8 4 64 14
171754 2292 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 800X Brotherhood Way 1 Median : Cutout Tree DPW 1     45 14x10   5990271 2088582 37.7142888575797 -122.475533361779 (37.7142888575797, -122.475533361779) 1 8 4 64 14
55368 109658 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 800X BROTHERHOOD WAY 29 Median : Cutout Tree DPW 1           5990271.4 2088582.7 37.7142908027957 -122.475532030318 (37.7142908027957, -122.475532030318) 1 8 4 64 14
84888 109654 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 800X BROTHERHOOD WAY 25 Median : Cutout Tree DPW 1           5990271.4 2088582.7 37.7142908027957 -122.475532030318 (37.7142908027957, -122.475532030318) 1 8 4 64 14
85555 109655 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 800X BROTHERHOOD WAY 26 Median : Cutout Tree DPW 1           5990271.4 2088582.7 37.7142908027957 -122.475532030318 (37.7142908027957, -122.475532030318) 1 8 4 64 14
95002 109656 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 800X BROTHERHOOD WAY 8 Median : Cutout Tree DPW 1   02/27/2015 10:16:00 AM 3     5990271.4 2088582.7 37.7142908027957 -122.475532030318 (37.7142908027957, -122.475532030318) 1 8 4 64 14
100770 109653 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 800X BROTHERHOOD WAY 6 Median : Cutout Tree DPW 1           5990271.4 2088582.7 37.7142908027957 -122.475532030318 (37.7142908027957, -122.475532030318) 1 8 4 64 14
107479 109648 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 800X BROTHERHOOD WAY 1 Median : Cutout Tree DPW 1           5990271.4 2088582.7 37.7142908027957 -122.475532030318 (37.7142908027957, -122.475532030318) 1 8 4 64 14
123780 109649 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 800X BROTHERHOOD WAY 2 Median : Cutout Tree DPW 1           5990271.4 2088582.7 37.7142908027957 -122.475532030318 (37.7142908027957, -122.475532030318) 1 8 4 64 14
134843 109659 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 800X BROTHERHOOD WAY 30 Median : Cutout Tree DPW 1           5990271.4 2088582.7 37.7142908027957 -122.475532030318 (37.7142908027957, -122.475532030318) 1 8 4 64 14
141356 109657 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 800X BROTHERHOOD WAY 28 Median : Cutout Tree DPW 1           5990271.4 2088582.7 37.7142908027957 -122.475532030318 (37.7142908027957, -122.475532030318) 1 8 4 64 14
142400 109650 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 800X BROTHERHOOD WAY 21 Median : Cutout Tree DPW 1           5990271.4 2088582.7 37.7142908027957 -122.475532030318 (37.7142908027957, -122.475532030318) 1 8 4 64 14
174778 109652 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 800X BROTHERHOOD WAY 23 Median : Cutout Tree DPW 1           5990271.4 2088582.7 37.7142908027957 -122.475532030318 (37.7142908027957, -122.475532030318) 1 8 4 64 14
193545 109651 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 800X BROTHERHOOD WAY 22 Median : Cutout Tree DPW 1           5990271.4 2088582.7 37.7142908027957 -122.475532030318 (37.7142908027957, -122.475532030318) 1 8 4 64 14
158539 176158 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 825 Brotherhood Way 2 Front Yard : Yard Tree Private 2     27 Width 0ft   5989484.91598 2088634.67131 37.7143878792713 -122.478254194772 (37.7143878792713, -122.478254194772) 1 8 4 64 14
99429 176157 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 999 Brotherhood Way 2 Front Yard : Yard Tree Private 2     25 Width 0ft   5988327.50042 2088688.82584 37.714469318273 -122.482258598878 (37.714469318273, -122.482258598878) 1 8 4 64 14
116862 2287 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 800X Brotherhood Way 2 Median : Cutout Tree DPW 1   08/30/2016 12:00:00 AM 3 14M Permit Number 777532 5989126.18342 2088688.61813 37.7145151729252 -122.47949804711 (37.7145151729252, -122.47949804711) 1 8 4 64 14
113562 176162 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 301 Naglee Ave 1 Front Yard : Yard Tree Private 2     30 Width 10ft   5997669.17463 2088536.73972 37.7145906808916 -122.449959233558 (37.7145906808916, -122.449959233558) 9 7 6 28861 25
108697 178286 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 900 Brotherhood Way 15 Median : Cutout Tree Private 2     3 10x10   5988409.28705 2088731.80807 37.7145920937141 -122.48197906171 (37.7145920937141, -122.48197906171) 1 8 4 64 14
189392 178285 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 900 Brotherhood Way 14 Median : Cutout Tree Private 2     18 10x10   5988379.49875 2088734.13698 37.7145967558101 -122.482082191442 (37.7145967558101, -122.482082191442) 1 8 4 64 14
123739 178284 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 900 Brotherhood Way 13 Median : Cutout Tree Private 2     25 10x10   5988329.29529 2088738.596 37.7146060790912 -122.482256039396 (37.7146060790912, -122.482256039396) 1 8 4 64 14
69289 176156 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 900 Brotherhood Way 10 : Tree Private 2     31 Width 0ft   5988097.71547 2088752.84117 37.7146317196604 -122.483057507098 (37.7146317196604, -122.483057507098) 1 8 4 64 14
172 176155 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 900X Brotherhood Way 9 Median : Cutout Tree DPW 1     25 10x10   5988860 2088745 37.7146545182747 -122.480422197946 (37.7146545182747, -122.480422197946) 1 8 4 64 14
159267 176154 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 900 Brotherhood Way 4 : Tree Private 2     20 Width 0ft   5987807.09848 2088773.10862 37.7146704534573 -122.484063470778 (37.7146704534573, -122.484063470778) 1 8 4 64 14
703 262210 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 2011 Bay Shore Blvd 1 Front Yard : Yard Tree Private 2       3x3   6012422 2088364 37.7149494891568 -122.398955034798 (37.7149494891568, -122.398955034798) 10 3 8 309 1
57945 206843 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2 Lobos St 4 Sidewalk: Curb side : Yard Tree Private 2     12     5996870.71882 2088697.52039 37.7149864275584 -122.452730603229 (37.7149864275584, -122.452730603229) 9 8 6 28861 24
107133 173877 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2651 San Jose Ave 1 Side Yard : Cutout Tree Private 2       3x3   5997397 2088796 37.7152869722449 -122.450918658158 (37.7152869722449, -122.450918658158) 9 8 6 28861 24
166359 176099 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 491 La Grande Ave 1 : Yard Tree Private 2     43     6004400.95401 2089156.27858 37.716674693347 -122.4267355565 (37.716674693347, -122.4267355565) 9 7 8 309 18
97386 176141 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 10 Lake Merced Blvd 1 : Tree Private 2     48 Width 0ft   5987562.65817 2089512.73136 37.7166870365437 -122.484962576069 (37.7166870365437, -122.484962576069) 1 8 4 64 14
73082 176100 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 491 La Grande Ave 2 : Yard Tree Private 2     19     6004405.40903 2089175.08917 37.7167265950249 -122.426721496498 (37.7167265950249, -122.426721496498) 9 7 8 309 18
121300 176101 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 491 La Grande Ave 3 : Yard Tree Private 2     26     6004411.36222 2089192.97967 37.7167760550358 -122.426702192554 (37.7167760550358, -122.426702192554) 9 7 8 309 18
145874 176096 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 184 Mount Vernon Ave 5 Side Yard : Yard Tree Private 2     15     5998966.43073 2089373.6298 37.7169627336137 -122.445535550248 (37.7169627336137, -122.445535550248) 9 7 6 28861 25
90110 176097 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 184 Mount Vernon Ave 6 Side Yard : Yard Tree Private 2     12     5998962.66324 2089377.08137 37.7169719957498 -122.445548820645 (37.7169719957498, -122.445548820645) 9 7 6 28861 25
169908 176098 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 184 Mount Vernon Ave 8 Side Yard : Yard Tree Private 2     6     5998949.65718 2089392.42013 37.7170133699507 -122.445594878527 (37.7170133699507, -122.445594878527) 9 7 6 28861 25
30007 114128 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 1200X JUNIPERO SERRA BLVD 21 Sidewalk: Property side : Yard Tree Private 2     18     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
39547 114133 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 1200X JUNIPERO SERRA BLVD 26 Sidewalk: Property side : Yard Tree Private 2     28     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
42100 114131 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 1200X JUNIPERO SERRA BLVD 24 Sidewalk: Property side : Yard Tree Private 2     30     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
53564 114125 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 1200X JUNIPERO SERRA BLVD 18 Sidewalk: Property side : Yard Tree Private 2     18     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
83754 114130 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 1200X JUNIPERO SERRA BLVD 23 Sidewalk: Property side : Yard Tree Private 2     24     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
99825 114135 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 1200X JUNIPERO SERRA BLVD 30 Sidewalk: Property side : Yard Tree Private 2     28     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
105357 114127 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 1200X JUNIPERO SERRA BLVD 20 Sidewalk: Property side : Yard Tree Private 2     36     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
139497 114126 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 1200X JUNIPERO SERRA BLVD 19 Sidewalk: Property side : Yard Tree Private 2     36     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
143142 114132 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 1200X JUNIPERO SERRA BLVD 25 Sidewalk: Property side : Yard Tree Private 2     36     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
158608 114129 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 1200X JUNIPERO SERRA BLVD 22 Sidewalk: Property side : Yard Tree Private 2     36     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
186966 114134 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 1200X JUNIPERO SERRA BLVD 28 Sidewalk: Property side : Yard Tree Private 2     36     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
112546 176142 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 10 Lake Merced Blvd 2 : Tree Private 2     38 Width 0ft   5987571.34971 2089706.0579 37.7172183686082 -122.48494670935 (37.7172183686082, -122.48494670935) 1 8 4 64 14
82162 109453 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 951 GILMAN AVE 1 Front Yard : Yard Tree Rec/Park 5   03/24/2015 12:00:00 AM 3   Permit Number 774986 6015934 2089205 37.7174537876507 -122.386874585955 (37.7174537876507, -122.386874585955) 10 3 8 58 1
65257 206841 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 246 Thrift St 2 Sidewalk: Property side : Yard Tree Private 2     17     5994549.17298 2089660.24802 37.7174965486989 -122.460824523252 (37.7174965486989, -122.460824523252) 9 8 6 28861 24
164419 176160 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 0 Gonzalez Dr 2 Sidewalk: Curb side : Yard Tree Private 2     2     5990378.89561 2089837.21304 37.7177416175535 -122.475252019477 (37.7177416175535, -122.475252019477) 1 8 4 64 14
194291 264997 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 909 Shields St 1 Sidewalk: Property side : Cutout Tree Private 2       3x9   5991621 2089826 37.7177827456648 -122.470957844969 (37.7177827456648, -122.470957844969) 9 8 6 64 24
129760 176143 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 10 Lake Merced Blvd 4 : Tree Private 2     60 Width 0ft   5987585.53383 2089941.92941 37.7178668382624 -122.484914976762 (37.7178668382624, -122.484914976762) 1 8 4 64 14
69790 206845 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 401 Victoria St 1 Sidewalk: Property side : Yard Tree Private 2     30 Width 5ft   5993220.45249 2089938.0951 37.7181829076919 -122.465437434707 (37.7181829076919, -122.465437434707) 9 8 6 64 24
127159 115835 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 900X LAKE MERCED BLVD 3 Median : Cutout Tree Private 2   08/30/2016 12:00:00 AM 3 10x100   5987646 2090104 37.7183153647657 -122.484717856844 (37.7183153647657, -122.484717856844) 1 8 4 64 14

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