trees
1,977 rows where qSpecies_id = 41 sorted by Supervisor Districts descending
This data as json, CSV (advanced)
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 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );