1,977 rows where qSpecies_id = 41 sorted by Supervisor Districts descending

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)
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
9730 190968 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 800 Vermont St 8 Sidewalk: Curb side : Yard Tree Private 2     39     6011276.3148 2104337.18505 37.7587445605265 -122.404038467608 (37.7587445605265, -122.404038467608) 10 3 8 28856 29
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
13759 190995 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 10x Cashmere St 3 Median : Yard Tree DPW 1     28     6017237.22965 2095860.87095 37.7358015834667 -122.382832806316 (37.7358015834667, -122.382832806316) 10 3 8 58 1
21639 190969 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 800 Vermont St 9 Sidewalk: Curb side : Yard Tree Private 2     14     6011271.58164 2104330.23228 37.7587252053147 -122.404054347838 (37.7587252053147, -122.404054347838) 10 3 8 28856 29
25939 190985 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2 Tulare St 17 Front Yard : Yard Tree Private 2     13     6016130.05616 2100249.95648 37.747791881903 -122.386966789196 (37.747791881903, -122.386966789196)   3 8 58 1
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
33593 190974 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 800 Vermont St 22 Sidewalk: Curb side : Yard Tree Private 2     20     6011278.73233 2104250.41369 37.7585064407439 -122.404024000205 (37.7585064407439, -122.404024000205) 10 3 8 28856 29
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
47684 190971 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 800 Vermont St 11 Sidewalk: Curb side : Yard Tree Private 2     42     6011272.24417 2104307.20268 37.7586620081736 -122.404050435791 (37.7586620081736, -122.404050435791) 10 3 8 28856 29
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
54335 176106 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 700x Mansell St 38 Median : Cutout Tree DPW 1     12 Width 0ft   6009144.0469 2089931.11882 37.7190692696122 -122.410395658243 (37.7190692696122, -122.410395658243) 9 3 8 309 18
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
61008 190970 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 800 Vermont St 10 Sidewalk: Curb side : Yard Tree Private 2     24     6011272.79136 2104320.91829 37.7586996987603 -122.40404950858 (37.7586996987603, -122.40404950858) 10 3 8 28856 29
62210 190967 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 800 Vermont St 6 Sidewalk: Curb side : Yard Tree Private 2     43     6011275.2709 2104408.12846 37.7589392970181 -122.404047070529 (37.7589392970181, -122.404047070529) 10 3 8 28856 29
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
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
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
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
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
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
107448 190976 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 800 Vermont St 25 Sidewalk: Curb side : Yard Tree Private 2     18     6011280.21235 2104227.17617 37.7584427183717 -122.404017246303 (37.7584427183717, -122.404017246303) 10 3 8 28856 29
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
115534 190966 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1912 23rd St 1 Sidewalk: Property side : Yard Tree Private 2     45     6012683.0695 2102873.5527 37.7548042439346 -122.399070498401 (37.7548042439346, -122.399070498401) 10 3 8 28856 29
115981 190973 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 800 Vermont St 20 Sidewalk: Curb side : Yard Tree Private 2     35     6011275.27355 2104274.28266 37.7585717863791 -122.404037642038 (37.7585717863791, -122.404037642038) 10 3 8 28856 29
116643 176105 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 700x Mansell St 29 Median : Cutout Tree DPW 1     105 Width 0ft   6009225.48687 2089982.90412 37.7192160263732 -122.410117804609 (37.7192160263732, -122.410117804609) 9 3 8 309 18
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
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
123634 190965 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1 24th St 17 : Yard Tree Private 2     6     6017293.94065 2102634.43336 37.7544035402038 -122.383108032109 (37.7544035402038, -122.383108032109) 10 3 8 28856 29
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
143153 190977 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 800 Vermont St 26 Sidewalk: Curb side : Yard Tree Private 2     50     6011279.98561 2104216.03333 37.7584121099421 -122.404017246318 (37.7584121099421, -122.404017246318) 10 3 8 28856 29
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
147755 190972 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 800 Vermont St 12 Sidewalk: Curb side : Yard Tree Private 2     19     6011274.67248 2104298.88872 37.758639315564 -122.404041452454 (37.758639315564, -122.404041452454) 10 3 8 28856 29
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
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
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
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
165813 190978 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1429 Rhode Island St 4 Sidewalk: Curb side : Yard Tree Private 2     30     6012034.10728 2101710.80673 37.7515754115935 -122.401233099922 (37.7515754115935, -122.401233099922) 10 3 8 28856 29
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
168975 190823 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 184 Hooper St 5 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 8ft   6012465.24563 2107532.99928 37.7675859124819 -122.400151016782 (37.7675859124819, -122.400151016782) 14 3 8 28856 20
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
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
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
180987 176104 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 700x Mansell St 19 Median : Cutout Tree DPW 1     26 Width 0ft   6009423.26816 2090026.7428 37.7193474820922 -122.409437239052 (37.7193474820922, -122.409437239052) 9 3 8 309 18
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
187529 176107 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 700x Mansell St 46 Median : Cutout Tree DPW 1     61 Width 0ft   6008982.60232 2089910.35131 37.7190031946297 -122.410952245957 (37.7190031946297, -122.410952245957) 9 3 8 309 18
189908 190975 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 800 Vermont St 23 Sidewalk: Curb side : Yard Tree Private 2     28     6011275.59974 2104245.89235 37.7584938511263 -122.40403451598 (37.7584938511263, -122.40403451598) 10 3 8 28856 29
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
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
3038 248184 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 216 Esmeralda Ave 3 Side Yard : Yard Tree Private 2     28     6007432.52043 2098714.89498 37.7430915158666 -122.416933765486 (37.7430915158666, -122.416933765486) 2 7 7 28859 2
10605 260507 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 50X Carver St 1 Median : Cutout Tree DPW 1 Private     3x3   6009420 2098346 37.742190207281 -122.410035530349 (37.742190207281, -122.410035530349) 10 7 7 28859 2
12689 22877 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 951X Mansell St 4 Median : Cutout Tree DPW 1     6 3X100   6009106.075934 2090003.4402519 37.7192657205166 -122.410532013931 (37.7192657205166, -122.410532013931) 9 3 7 309 28
13593 247903 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 582 Esmeralda Ave 1 Side Yard : Yard Tree Private 2     31     6009830.823 2098729.70619 37.7432667982256 -122.408642088157 (37.7432667982256, -122.408642088157) 10 7 7 28859 2
20540 247989 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 130 Mullen Ave 1 Front Yard : Yard Tree Private 2     15 Width 10ft   6009899.29934 2099821.33089 37.7462679959733 -122.408482299339 (37.7462679959733, -122.408482299339) 2 7 7 28859 2
28109 223768 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 340 Shotwell St 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6007779.74156 2105912.97739 37.762875341838 -122.41624286402 (37.762875341838, -122.41624286402) 8 4 7 28859 19
30966 112739 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 444 Franconia St 3 Unaccepted Street : Yard Tree Private 2     30     6009949.70212209 2098546.33795552 37.7427699663381 -122.408218103257 (37.7427699663381, -122.408218103257) 10 7 7 28859 2
32016 223722 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 201 College Ave 1 Front Yard : Yard Tree Private 2     13 Width 2ft   6005269.83523 2095874.10119 37.7351694473011 -122.424209762894 (37.7351694473011, -122.424209762894) 2 7 7 28859 2
32139 112726 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 40x BERNAL HEIGHTS BLVD 2 Sidewalk: Curb side : Cutout Tree Private 2     30 3x3   6009324 2098099 37.7415066181332 -122.410350033668 (37.7415066181332, -122.410350033668) 10 7 7 28859 2
35838 247988 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 124 Mullen Ave 2 Front Yard : Yard Tree Private 2     29 Width 10ft   6009878.9446 2099816.70211 37.7462541464208 -122.408552357412 (37.7462541464208, -122.408552357412) 2 7 7 28859 2
41898 223727 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 295 Coso Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 4ft   6007771.677 2099478.19016 37.7452064263402 -122.415815087109 (37.7452064263402, -122.415815087109) 2 7 7 28859 2
42938 112725 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 40x BERNAL HEIGHTS BLVD 1 Sidewalk: Curb side : Cutout Tree Private 2     30 3x3   6009324 2098099 37.7415066181332 -122.410350033668 (37.7415066181332, -122.410350033668) 10 7 7 28859 2
45889 223720 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 10 Crescent Ave 3 Side Yard : Yard Tree Private 2     15 Width 3ft   6005295.72226 2095902.89747 37.7352499770995 -122.424122309196 (37.7352499770995, -122.424122309196) 2 7 7 28859 2
50957 223726 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 107 Elsie St 1 Sidewalk: Curb side : Pot Tree Private 2     32 Width 7ft   6007259.15325 2098682.19853 37.7429919851951 -122.41753090725 (37.7429919851951, -122.41753090725) 2 7 7 28859 2
56525 122494 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 69x Bonview St 10 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6007716 2099172 37.7443625662885 -122.415985930063 (37.7443625662885, -122.415985930063) 2 7 7 28859 2
58208 248051 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 25 Rutledge St 1 Front Yard : Yard Tree Private 2     24     6010607.15124 2099382.29757 37.7451021220724 -122.406003697633 (37.7451021220724, -122.406003697633) 2 7 7 28859 2
67575 223732 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 201 College Ave 2 Sidewalk: Property side : Yard Tree Private 2     18 Width 2ft   6005270.68564 2095872.41003 37.7351648517715 -122.424206702478 (37.7351648517715, -122.424206702478) 2 7 7 28859 2
72041 253876 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 56x Ellsworth St 1 Side Yard : Yard Tree DPW 1       3x3   6008136 2098387 37.7422307347858 -122.414478117675 (37.7422307347858, -122.414478117675) 2 7 7 28859 2
79818 251517 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 145 Bonview St 1 Back Yard : Yard Tree Private 2       3x3   6007188 2098162 37.7415596321362 -122.417740072125 (37.7415596321362, -122.417740072125) 2 7 7 28859 2
85900 247990 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 130 Mullen Ave 2 Front Yard : Yard Tree Private 2     21 Width 10ft   6009904.82703 2099823.31957 37.7462737660155 -122.408463325425 (37.7462737660155, -122.408463325425) 2 7 7 28859 2
93124 223769 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 340 Shotwell St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6007778.5816 2105921.91586 37.7628998195803 -122.416247509035 (37.7628998195803, -122.416247509035) 8 4 7 28859 19
94042 246716 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1 Bonview St 22 Sidewalk: Curb side : Yard Tree Private 2     45     6007832.06726 2099366.51815 37.7449031947197 -122.415598362177 (37.7449031947197, -122.415598362177) 2 7 7 28859 2
94207 223767 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 35 MacEdonia St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6010370.7257 2099718.90612 37.7460131497042 -122.406844938766 (37.7460131497042, -122.406844938766) 2 7 7 28859 2
97581 248059 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 18 Rutledge St 1 Side Yard : Yard Tree Private 2     41     6010698.28988 2099365.54136 37.7450612101031 -122.405687374593 (37.7450612101031, -122.405687374593) 2 7 7 28859 2
99911 223708 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 220 Coso Ave 1 Front Yard : Yard Tree Private 2     17     6007533.84485 2099558.41005 37.7454133189685 -122.416643154074 (37.7454133189685, -122.416643154074) 2 7 7 28859 2
102777 223725 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 109 Elsie St 1 Sidewalk: Curb side : Pot Tree Private 2     34 Width 10ft   6007250.83201 2098665.28415 37.7429450738598 -122.417558481357 (37.7429450738598, -122.417558481357) 2 7 7 28859 2
107236 223770 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 340 Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6007775.55004 2105926.88107 37.7629132824304 -122.416258345863 (37.7629132824304, -122.416258345863) 8 4 7 28859 19
112679 106961 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 325 DWIGHT ST   Sidewalk: Curb side : Yard Tree Private 2           6010604 2091349 37.7230442144558 -122.405448941518 (37.7230442144558, -122.405448941518) 10 3 7 309 28
113212 256719 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 129X Manchester St 1 Front Yard : Yard Tree DPW 1       3x3   6008266 2099329 37.7448245605916 -122.414095244275 (37.7448245605916, -122.414095244275) 2 7 7 28859 2
116416 223719 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 10 Crescent Ave 4 Side Yard : Yard Tree Private 2     6 Width 3ft   6005300.64092 2095902.62438 37.7352495049691 -122.424105284154 (37.7352495049691, -122.424105284154) 2 7 7 28859 2
117507 247911 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 399 Franconia St 2 Side Yard : Yard Tree Private 2     39     6009944.29918 2098783.53182 37.7434209465163 -122.408253510886 (37.7434209465163, -122.408253510886) 2 7 7 28859 2
123774 223721 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 201 College Ave 2 Front Yard : Yard Tree Private 2     18 Width 2ft   6005265.62157 2095876.84541 37.7351767443941 -122.424224526166 (37.7351767443941, -122.424224526166) 2 7 7 28859 2
140081 247991 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 130 Mullen Ave 3 Front Yard : Yard Tree Private 2     25 Width 10ft   6009914.62518 2099827.74346 37.7462864617583 -122.408429756449 (37.7462864617583, -122.408429756449) 2 7 7 28859 2
142056 116669 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 100 Esmeralda Ave 6 Unaccepted Street : Yard Tree DPW 1     20     6006917.38983 2098966.37493 37.7437530336215 -122.41873278304 (37.7437530336215, -122.41873278304) 2 7 7 28859 2
142469 117064 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 257 PERALTA AVE 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   6009832 2099662 37.745826739133 -122.408703774946 (37.745826739133, -122.408703774946) 2 7 7 28859 2
147794 115388 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 169x BOCANA ST 1 Front Yard : Cutout Tree Private 2     25 40x50   6007278 2097999 37.7411171346524 -122.417417333034 (37.7411171346524, -122.417417333034) 2 7 7 28859 2
151719 22878 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 951X Mansell St 5 Median : Cutout Tree DPW 1   06/10/1992 12:00:00 AM 3 3X100   6009106.075934 2090003.4402519 37.7192657205166 -122.410532013931 (37.7192657205166, -122.410532013931) 9 3 7 309 28
154478 96856 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 324X Alemany Blvd 1 Median : Cutout Tree DPW 1     36 410x30   6008894.01857 2095530.1163 37.7344289090546 -122.4116553033 (37.7344289090546, -122.4116553033) 10 7 7 28859 2
160950 246711 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1 Bonview St 17 Sidewalk: Curb side : Yard Tree Private 2     15     6007747.55824 2099198.25056 37.7444364187148 -122.415878666471 (37.7444364187148, -122.415878666471) 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)
);