1,977 rows where qSpecies_id = 41 sorted by Neighborhoods (old)

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) ▼
30658 190983 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2 Tulare St 20 Front Yard : Yard Tree Private 2     15     6016115.94828 2100251.37259 37.7477949890666 -122.387015672733 (37.7477949890666, -122.387015672733)   3 8 58 1
32972 190988 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 119 Lindsay Cir 1 Sidewalk: Curb side : Yard Tree Private 2     31 Width 5ft   6016552.3921 2095641.66161 37.7351618174613 -122.385185311358 (37.7351618174613, -122.385185311358) 10 3 8 58 1
37147 201718 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1 Hawkins Ln 3 Side Yard : Yard Tree Private 2     14     6017093.28201 2095356.32471 37.7344082458391 -122.383295385174 (37.7344082458391, -122.383295385174) 10 3 8 58 1
49827 53726 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 Topeka Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/07/1972 12:00:00 AM 8   Permit Number 9405 6012451.87174 2095251.14558 37.7338618519323 -122.399334980939 (37.7338618519323, -122.399334980939) 10 3 8 58 1
52013 190990 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 301x Cashmere St 9 Median : Yard Tree DPW 1     8     6016177.27303 2096204.98812 37.7366878401785 -122.386521512362 (37.7366878401785, -122.386521512362) 10 3 8 58 1
58228 201724 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1 Hawkins Ln 7 Side Yard : Yard Tree Private 2     28     6017165.24184 2095383.9343 37.7344880327856 -122.383048514986 (37.7344880327856, -122.383048514986) 10 3 8 58 1
58681 190979 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2 Tulare St 26 Front Yard : Yard Tree Private 2     10     6016095.64833 2100226.27382 37.7477249489626 -122.387084119257 (37.7477249489626, -122.387084119257)   3 8 58 1
65190 190989 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 301x Cashmere St 8 Median : Yard Tree DPW 1     17     6016178.92283 2096206.88071 37.7366931281786 -122.386515940161 (37.7366931281786, -122.386515940161) 10 3 8 58 1
73799 190980 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2 Tulare St 25 Front Yard : Yard Tree Private 2     13     6016106.6833 2100234.37898 37.7477478151042 -122.387046525793 (37.7477478151042, -122.387046525793)   3 8 58 1
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
90756 190991 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 301x Cashmere St 12 Median : Yard Tree DPW 1     12     6016140.77193 2096185.18124 37.7366314337791 -122.386646332879 (37.7366314337791, -122.386646332879) 10 3 8 58 1
108416 201716 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1 Hawkins Ln 1 Side Yard : Yard Tree Private 2     17     6017085.91329 2095352.6498 37.7343977480421 -122.38332060578 (37.7343977480421, -122.38332060578) 10 3 8 58 1
110903 201720 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1 Hawkins Ln 5 Side Yard : Yard Tree Private 2     17     6017109.38533 2095355.23584 37.7344061459337 -122.383239634411 (37.7344061459337, -122.383239634411) 10 3 8 58 1
119641 190993 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 301x Cashmere St 14 Median : Yard Tree DPW 1     27     6016127.05832 2096176.47009 37.7366067554984 -122.386693139892 (37.7366067554984, -122.386693139892) 10 3 8 58 1
119943 110264 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 220x CASHMERE ST 1 Median : Cutout Tree DPW 1       5x40   6015982.5 2095938 37.7359439605228 -122.387176315997 (37.7359439605228, -122.387176315997) 10 3 8 58 1
121032 190987 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 Topeka Ave 3 Sidewalk: Property side : Yard Tree Private 2     8 Width 5ft   6012468.98817 2095242.94143 37.7338402790006 -122.39927522817 (37.7338402790006, -122.39927522817) 10 3 8 58 1
129190 190981 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2 Tulare St 24 Front Yard : Yard Tree Private 2     17     6016079.67867 2100249.91321 37.7477889734994 -122.38714099059 (37.7477889734994, -122.38714099059)   3 8 58 1
137870 190994 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 50x Dedman Ct 1 Median : Yard Tree DPW 1     37     6016552.89235 2096279.67285 37.736913695911 -122.385228023775 (37.736913695911, -122.385228023775) 10 3 8 58 1
143641 201719 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1 Hawkins Ln 4 Side Yard : Yard Tree Private 2     15     6017095.79964 2095357.42104 37.7344113952763 -122.383286757105 (37.7344113952763, -122.383286757105) 10 3 8 58 1
144423 190984 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2 Tulare St 19 Front Yard : Yard Tree Private 2     17     6016127.79585 2100261.1881 37.7478225964477 -122.386975388525 (37.7478225964477, -122.386975388525)   3 8 58 1
146151 190992 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 301x Cashmere St 13 Median : Yard Tree DPW 1     14     6016132.65203 2096182.13487 37.7366226195253 -122.386674194759 (37.7366226195253, -122.386674194759) 10 3 8 58 1
152247 201723 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1 Hawkins Ln 6 Side Yard : Yard Tree Private 2     10     6017160.60225 2095378.34378 37.7344724259609 -122.383064166774 (37.7344724259609, -122.383064166774) 10 3 8 58 1
156131 201717 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1 Hawkins Ln 2 Side Yard : Yard Tree Private 2     24     6017089.1408 2095350.86435 37.7343930239173 -122.383309322872 (37.7343930239173, -122.383309322872) 10 3 8 58 1
161590 201721 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2 Lindsay Cir 2 Front Yard : Yard Tree Private 2     26     6016317.40109 2095614.08154 37.7350730858367 -122.385995846031 (37.7350730858367, -122.385995846031) 10 3 8 58 1
172024 190986 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2 Tulare St 16 Front Yard : Yard Tree Private 2     23     6016149.69105 2100259.24355 37.747818469462 -122.386899539706 (37.747818469462, -122.386899539706)   3 8 58 1
180052 109251 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 53X DEDMAN CT 1 Sidewalk: Curb side : Cutout Tree Private 2     36     6016647 2096311 37.7370049195852 -122.384904830601 (37.7370049195852, -122.384904830601) 10 3 8 58 1
185954 190982 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2 Tulare St 23 Front Yard : Yard Tree Private 2     34     6016087.28584 2100258.68622 37.7478134836207 -122.387115296958 (37.7478134836207, -122.387115296958)   3 8 58 1
191814 106757 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 999 Key Ave 1 Sidewalk: Curb side : Yard Tree Private 2   06/02/2014 12:00:00 AM 36     6013321.20233 2089752.82506 37.7188129925151 -122.395944254446 (37.7188129925151, -122.395944254446) 10 3 8 58 1
22976 103600 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 50X Hermann St 1 Front Yard : Yard Tree Private 2           6005031.0649 2108842.56611 37.7707643495235 -122.425958137982 (37.7707643495235, -122.425958137982) 7 9 5 28852 10
123912 123502 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2550 Fulton St 3 Sidewalk: Property side : Yard Tree Private 2     14 Width 1ft   5995414.62926 2110342.66795 37.7743350698735 -122.459329999259 (37.7743350698735, -122.459329999259) 11 6 2 54 11
141126 123503 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2550 Fulton St 2 Sidewalk: Property side : Yard Tree Private 2     11 Width 1ft   5995405.46264 2110341.74894 37.7743320194833 -122.459361641514 (37.7743320194833, -122.459361641514) 11 6 2 54 11
145718 123500 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2550 Fulton St 5 Sidewalk: Property side : Yard Tree Private 2     7 Width 1ft   5995440.159 2110347.24337 37.7743491005482 -122.459242019148 (37.7743491005482, -122.459242019148) 11 6 2 54 11
174748 123499 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2550 Fulton St 4 Sidewalk: Property side : Yard Tree Private 2     9 Width 1ft   5995451.11899 2110348.56887 37.7743533701225 -122.459204202763 (37.7743533701225, -122.459204202763) 11 6 2 54 11
13998 206803 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 300 Ortega St 1 Sidewalk: Curb side : Yard Tree Private 2     28     5993087.14993 2102582.23712 37.7528928770087 -122.466816856226 (37.7528928770087, -122.466816856226) 1 8 4 56 12
21226 206882 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 355 Parnassus Ave 10 Sidewalk: Property side : Yard Tree Private 2     24 Width 5ft   5996132.62288 2106470.43448 37.7637441750665 -122.456566260324 (37.7637441750665, -122.456566260324) 15 5 4 29492 12
21438 99445 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1601X 15th Ave 2 Median : Cutout Tree DPW 1           5991576.7 2104258.5 37.7574081656565 -122.472162400604 (37.7574081656565, -122.472162400604) 1 8 4 56 12
21700 206891 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1675x 15th Ave 1 Sidewalk: Property side : Cutout Tree DPW 1     24 Width 3ft   5991393.55964 2103864.47578 37.7563156787487 -122.472767037095 (37.7563156787487, -122.472767037095) 1 8 4 56 12
23686 206884 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 355 Parnassus Ave 8 Sidewalk: Property side : Yard Tree Private 2     20 Width 5ft   5996099.70651 2106459.36925 37.7637119028988 -122.456679306927 (37.7637119028988, -122.456679306927) 15 5 4 29492 12
25906 206883 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 355 Parnassus Ave 9 Sidewalk: Property side : Yard Tree Private 2     23 Width 5ft   5996116.5996 2106463.98861 37.7637255564024 -122.456621213396 (37.7637255564024, -122.456621213396) 15 5 4 29492 12
30129 206804 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 60X Aerial Way 1 Sidewalk: Property side : Yard Tree Private 2     30 Width 4ft   5992441 2102652 37.7530471147259 -122.469056420341 (37.7530471147259, -122.469056420341) 1 8 4 56 12
34251 253786 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1675X 15th Ave 2 Median : Cutout Tree DPW 1       3x3   5991390 2103897 37.7564047756354 -122.47278171886 (37.7564047756354, -122.47278171886) 1 8 4 56 12
40974 253789 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1651X 15th Ave 1 Median : Cutout Tree DPW 1       3x2   5991453 2104016 37.7567351651282 -122.472572520554 (37.7567351651282, -122.472572520554) 1 8 4 56 12
46471 253626 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 1671 Funston Ave 1 Back Yard : Yard Tree Private 2       10x10   5992125 2104081 37.7569525124502 -122.470253253306 (37.7569525124502, -122.470253253306) 1 8 4 56 12
49170 99447 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1601X 15th Ave 5 Median : Cutout Tree DPW 1           5991576.7 2104258.5 37.7574081656565 -122.472162400604 (37.7574081656565, -122.472162400604) 1 8 4 56 12
73512 206886 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 355 Parnassus Ave 6 Sidewalk: Property side : Yard Tree Private 2     22 Width 5ft   5996058.56562 2106445.76375 37.76367218344 -122.456820615576 (37.76367218344, -122.456820615576) 15 5 4 29492 12
83721 206802 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 Judah St 1 Sidewalk: Property side : Cutout Tree Private 2     13 Width 1ft   5994234.49251 2106025.56842 37.7624135282762 -122.463098978843 (37.7624135282762, -122.463098978843) 1 5 11 56 12
85466 223762 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 177 Twin Peaks Blvd 1 Sidewalk: Property side : Yard Tree Private 2     44 Width 10ft   5998552.86361 2104689.94598 37.7589940558555 -122.448067221836 (37.7589940558555, -122.448067221836) 15 5 5 28862 12
96354 99444 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1601X 15th Ave 1 Median : Cutout Tree DPW 1           5991576.7 2104258.5 37.7574081656565 -122.472162400604 (37.7574081656565, -122.472162400604) 1 8 4 56 12
97939 206878 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 15 Belmont Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   5996722.9126 2106147.11856 37.7628903047602 -122.454501283825 (37.7628903047602, -122.454501283825) 15 5 11 29492 12
98672 223724 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 190 Belgrave Ave 1 Sidewalk: Property side : Yard Tree Private 2     66 Width 2ft   5997664.737 2104901.53877 37.7595242277824 -122.451154026041 (37.7595242277824, -122.451154026041) 15 5 11 29492 12
108458 251599 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 740 Moraga St 1 Front Yard : Yard Tree Private 2       3x3   5992006 2103899 37.7564459074564 -122.470651540396 (37.7564459074564, -122.470651540396) 1 8 4 56 12
111584 173599 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100X Warren Dr 1 Sidewalk: Curb side : Cutout Tree Private 2     20 3x3   5995367 2102770 37.7535397418859 -122.458946354326 (37.7535397418859, -122.458946354326) 1 5 4 63 12
114677 206879 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 15 Belmont Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   5996709.23846 2106155.10613 37.7629114523342 -122.454549154716 (37.7629114523342, -122.454549154716) 15 5 11 29492 12
115931 253790 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1651X 15th Ave 2 Median : Cutout Tree DPW 1       3x2   5991453 2104016 37.7567351651282 -122.472572520554 (37.7567351651282, -122.472572520554) 1 8 4 56 12
120303 206890 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1651x 15th Ave 1 Median : Cutout Tree DPW 1     11 Width 3ft   5991488.45245 2104026.50267 37.7567660547203 -122.472450679848 (37.7567660547203, -122.472450679848) 1 8 4 56 12
125983 253784 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1709X 15th Ave 1 Median : Cutout Tree DPW 1       3x2   5991403 2103783 37.7560925141719 -122.472728448949 (37.7560925141719, -122.472728448949) 1 8 4 56 12
127814 99448 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1601X 15th Ave 6 Median : Cutout Tree DPW 1           5991576.7 2104258.5 37.7574081656565 -122.472162400604 (37.7574081656565, -122.472162400604) 1 8 4 56 12
133599 206887 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 355 Parnassus Ave 4 Sidewalk: Property side : Yard Tree Private 2     24 Width 5ft   5996038.42979 2106438.04795 37.7636498416029 -122.456889700613 (37.7636498416029, -122.456889700613) 15 5 4 29492 12
135864 206881 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 355 Parnassus Ave 12 Sidewalk: Property side : Yard Tree Private 2     21 Width 5ft   5996153.64709 2106477.22779 37.7637640347956 -122.456494035775 (37.7637640347956, -122.456494035775) 15 5 4 29492 12
146981 256571 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 66 Aerial Way 5 Sidewalk: Property side : Yard Tree Private 2       Width 4ft   5992257.72323 2102553.22068 37.7527653009777 -122.469683030659 (37.7527653009777, -122.469683030659) 1 8 4 56 12
147828 206889 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1646x 15th Ave 1 Median : Cutout Tree DPW 1     13 Width 3ft   5991480.90681 2104023.08965 37.7567562467267 -122.472476526376 (37.7567562467267, -122.472476526376) 1 8 4 56 12
152466 99446 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1601X 15th Ave 3 Median : Cutout Tree DPW 1           5991576.7 2104258.5 37.7574081656565 -122.472162400604 (37.7574081656565, -122.472162400604) 1 8 4 56 12
156459 103648 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 500X Oak Park Dr 3 Sidewalk: Property side : Yard Tree Private 2     14 3x10   5994983.3 2103652.8 37.7559416221353 -122.460337221652 (37.7559416221353, -122.460337221652) 1 5 4 63 12
161514 253207 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 89 Woodhaven Ct 1 Back Yard : Cutout Tree Private 2       3x3   5996069 2103645 37.7559825991437 -122.456581972884 (37.7559825991437, -122.456581972884) 1 5 4 63 12
161592 206880 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 355 Parnassus Ave 13 Sidewalk: Property side : Yard Tree Private 2     26 Width 5ft   5996174.6335 2106482.2136 37.7637789293792 -122.456421811215 (37.7637789293792, -122.456421811215) 15 5 4 29492 12
168009 254385 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 178X Warren Dr 1 Side Yard : Yard Tree Private 2       3x3   5995100 2102878 37.7538209308694 -122.459877514706 (37.7538209308694, -122.459877514706) 1 5 4 63 12
173828 205876 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 9 Locksley Ave 3 Sidewalk: Curb side : Yard Tree Private 2     43 Width 3ft   5994093.62789 2104819.10263 37.7590927708292 -122.463498614174 (37.7590927708292, -122.463498614174) 1 5 4 56 12
177432 102706 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 1342 Funston Ave 1 Back Yard : Yard Tree Private 2           5992135.4 2106294.8 37.7630316255695 -122.470378504645 (37.7630316255695, -122.470378504645) 1 8 11 56 12
180131 115391 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 21X BELMONT AVE 1 Front Yard : Yard Tree Private 2     48     5996611 2106266 37.7632103037359 -122.454896938495 (37.7632103037359, -122.454896938495) 15 5 11 29492 12
183855 206885 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 355 Parnassus Ave 11 Sidewalk: Property side : Yard Tree Private 2     28 Width 5ft   5996145.42285 2106474.68713 37.76375658663 -122.456522296986 (37.76375658663, -122.456522296986) 15 5 4 29492 12
185053 99826 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 1 Cascade Walk 1 Front Yard : Yard Tree Private 2           5992183.1 2103187.3 37.7545020044945 -122.469987253468 (37.7545020044945, -122.469987253468) 1 8 4 56 12
185756 206888 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 449 Parnassus Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     28 Width 3ft   5995669.52074 2106315.57274 37.7632923655851 -122.458156768919 (37.7632923655851, -122.458156768919) 15 5 4 63 12
190415 206805 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 68 Aerial Way 1 Sidewalk: Property side : Yard Tree Private 2     20 Width 2ft   5992337.85259 2102586.33778 37.7528608629412 -122.469408341716 (37.7528608629412, -122.469408341716) 1 8 4 56 12
191822 40713 Permitted Site 7 Cupressus macrocarpa :: Monterey Cypress 41 2 Crown Ter 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 41692 5998528.84920016 2104703.4154957 37.7590296670037 -122.448151244492 (37.7590296670037, -122.448151244492) 15 5 5 28862 12
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
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
7283 176114 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 10 Zoo Rd 1 Front Yard : Yard Tree Private 2     24 Width 10ft   5982696.49512 2094384.4536 37.7297788507039 -122.502142508582 (37.7297788507039, -122.502142508582) 1 8 4 64 14
8004 176122 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 3500 Great Hwy 9 Median : Tree Private 2     3 Width 0ft   5982330.17471 2092783.08412 37.7253603924579 -122.503290375351 (37.7253603924579, -122.503290375351) 1 8 4 64 14
9303 259269 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3580X 19th Ave 7 Sidewalk: Property side : Yard Tree Private 2       3x3   5990529 2092111 37.723993571379 -122.474899060099 (37.723993571379, -122.474899060099) 9 8 4 64 14
10140 106278 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 200X VIDAL DR 2 Median : Cutout Tree DPW 1     60     5987624 2090693 37.7199313280832 -122.484837086298 (37.7199313280832, -122.484837086298) 1 8 4 64 14
11254 259267 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3580X 19th Ave 5 Sidewalk: Property side : Yard Tree Private 2       3x3   5990529 2092111 37.723993571379 -122.474899060099 (37.723993571379, -122.474899060099) 9 8 4 64 14
14861 176144 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 10 Lake Merced Blvd 5 : Tree Private 2     39 Width 0ft   5987593.26623 2090234.31177 37.7186700965335 -122.484909687836 (37.7186700965335, -122.484909687836) 1 8 4 64 14
15055 259264 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3580X 19th Ave 2 Sidewalk: Property side : Yard Tree Private 2       3x3   5990529 2092111 37.723993571379 -122.474899060099 (37.723993571379, -122.474899060099) 9 8 4 64 14
21901 12497 Permitted Site 7 Cupressus macrocarpa :: Monterey Cypress 41 307 Lake Merced Blvd 42 Sidewalk: Curb side : Cutout Tree PUC 8     12 90M   5985224.7663097 2094165.6248747 37.7293262181041 -122.49338600271 (37.7293262181041, -122.49338600271) 1 8 4 64 14
22522 176121 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 3500 Great Hwy 8 Median : Tree Private 2     6 Width 0ft   5982310.61133 2092790.70938 37.7253801793381 -122.503358567347 (37.7253801793381, -122.503358567347) 1 8 4   14
24527 114055 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 700X LAKE MERCED BLVD 1 Median : Cutout Tree Private 2     50     5987837 2092819 37.7257811856502 -122.484256664993 (37.7257811856502, -122.484256664993) 1 8 4 64 14
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
28931 111586 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 730X Lake Merced Blvd 2 Sidewalk: Property side : Yard Tree DPW 1     48     5987577.49507 2091187.90071 37.7212874908284 -122.485034126397 (37.7212874908284, -122.485034126397) 1 8 4 64 14
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
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
31631 12498 Permitted Site 7 Cupressus macrocarpa :: Monterey Cypress 41 307 Lake Merced Blvd 43 Sidewalk: Curb side : Cutout Tree PUC 8     12 90M   5985224.7663097 2094165.6248747 37.7293262181041 -122.49338600271 (37.7293262181041, -122.49338600271) 1 8 4 64 14
33619 12466 Permitted Site 7 Cupressus macrocarpa :: Monterey Cypress 41 307 Lake Merced Blvd 11 Sidewalk: Curb side : Cutout Tree PUC 8     6 90M   5985224.7663097 2094165.6248747 37.7293262181041 -122.49338600271 (37.7293262181041, -122.49338600271) 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
36507 176151 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 10 Lake Merced Blvd 12 : Tree Private 2     28 Width 0ft   5987601.77319 2090779.60025 37.7201678157831 -122.484920265686 (37.7201678157831, -122.484920265686) 1 8 4 64 14
37295 12460 Permitted Site 7 Cupressus macrocarpa :: Monterey Cypress 41 307 Lake Merced Blvd 5 Sidewalk: Curb side : Cutout Tree PUC 8     6 90M   5985224.7663097 2094165.6248747 37.7293262181041 -122.49338600271 (37.7293262181041, -122.49338600271) 1 8 4 64 14
39401 12484 Permitted Site 7 Cupressus macrocarpa :: Monterey Cypress 41 307 Lake Merced Blvd 29 Sidewalk: Curb side : Cutout Tree PUC 8     12 90M   5985224.7663097 2094165.6248747 37.7293262181041 -122.49338600271 (37.7293262181041, -122.49338600271) 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
41437 12469 Permitted Site 7 Cupressus macrocarpa :: Monterey Cypress 41 307 Lake Merced Blvd 14 Sidewalk: Curb side : Cutout Tree PUC 8     6 90M   5985224.7663097 2094165.6248747 37.7293262181041 -122.49338600271 (37.7293262181041, -122.49338600271) 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
42366 114061 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 700X LAKE MERCED BLVD 7 Median : Cutout Tree Private 2     52     5987837 2092819 37.7257811856502 -122.484256664993 (37.7257811856502, -122.484256664993) 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)
);