trees
1,977 rows where qSpecies_id = 41 sorted by qSiteInfo
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
70545 | 223736 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1760 Diamond St | 2 | Front Yard : Yard | Tree | Private 2 | 38 | 6002022.64455 | 2098766.1332 | 37.7429264111321 | -122.435643298224 | (37.7429264111321, -122.435643298224) | 2 | 7 | 5 | 63 | 22 | ||||
70978 | 253291 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 650 Peru Ave | 7 | Front Yard : Yard | Tree | Private 2 | 6005101.95698 | 2092563.19401 | 37.7260689503102 | -122.424554741032 | (37.7260689503102, -122.424554741032) | 9 | 7 | 6 | 28861 | 5 | |||||
72776 | 111589 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 730X Lake Merced Blvd | 5 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | Permit Number 774260 | 5987577.49507 | 2091187.90071 | 37.7212874908284 | -122.485034126397 | (37.7212874908284, -122.485034126397) | 1 | 8 | 4 | 64 | 14 | |||
73261 | 253779 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 90 Cuesta Ct | 3 | Front Yard : Yard | Tree | DPW 1 | 5999757 | 2101744 | 37.7509739685765 | -122.443691128062 | (37.7509739685765, -122.443691128062) | 2 | 5 | 5 | 63 | 38 | |||||
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 | |||||
74611 | 223781 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 4071 20th St | 2 | Front Yard : Yard | Tree | Private 2 | 5 | Width 3ft | 6003265.85281 | 2104155.21457 | 37.7577940967297 | -122.431729316456 | (37.7577940967297, -122.431729316456) | 2 | 4 | 5 | 28862 | 3 | |||
75016 | 98140 | Property Tree 8 | Cupressus macrocarpa :: Monterey Cypress 41 | 315 San Marcos Ave | Front Yard : Yard | Tree | Private 2 | 5992920.8 | 2100212.1 | 37.7463754865467 | -122.467219803339 | (37.7463754865467, -122.467219803339) | 1 | 8 | 4 | 29491 | 40 | ||||||
77239 | 223740 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1760 Diamond St | 6 | Front Yard : Yard | Tree | Private 2 | 18 | 6002036.21609 | 2098593.82428 | 37.7424540620024 | -122.435584047293 | (37.7424540620024, -122.435584047293) | 2 | 7 | 5 | 63 | 22 | ||||
80114 | 223752 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 3944 22nd St | 8 | Front Yard : Yard | Tree | Private 2 | 16 | 6002172.64124 | 2102975.10056 | 37.7544917583143 | -122.435425673069 | (37.7544917583143, -122.435425673069) | 2 | 4 | 5 | 28862 | 22 | ||||
80243 | 255324 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 852 Chenery St | 2 | Front Yard : Yard | Tree | Private 2 | 3X3 | 6001755.94767 | 2095865.71194 | 37.7349473777015 | -122.436357925586 | (37.7349473777015, -122.436357925586) | 2 | 7 | 5 | 63 | 7 | ||||
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 | ||||
80706 | 223693 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1501 San Jose Ave | 2 | Front Yard : Yard | Tree | Private 2 | 50 | 6004632.33856 | 2096219.10374 | 37.7360807303384 | -122.426438378246 | (37.7360807303384, -122.426438378246) | 2 | 7 | 5 | 28861 | 2 | ||||
81640 | 223707 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1200 San Jose Ave | 1 | Front Yard : Yard | Tree | Private 2 | 37 | 6004449.31264 | 2096325.41802 | 37.7363622972844 | -122.427078743207 | (37.7363622972844, -122.427078743207) | 2 | 7 | 5 | 63 | 7 | ||||
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 | ||
84261 | 251716 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 3929 19th St | 1 | Front Yard : Yard | Tree | Private 2 | 6003450 | 2104734 | 37.7593937399337 | -122.431133769968 | (37.7593937399337, -122.431133769968) | 2 | 4 | 5 | 28862 | 3 | |||||
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 | |||
86356 | 254240 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 47 Cole St | 5 | Front Yard : Yard | Tree | Private 2 | 5997708 | 2110435 | 37.7747201781994 | -122.451403505262 | (37.7747201781994, -122.451403505262) | 15 | 5 | 2 | 29492 | 16 | |||||
86542 | 223710 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1201 San Jose Ave | 13 | Front Yard : Yard | Tree | Private 2 | 67 | 6004258.36813 | 2095937.1689 | 37.7352854535516 | -122.427711264267 | (37.7352854535516, -122.427711264267) | 2 | 7 | 5 | 28861 | 2 | ||||
87860 | 223705 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1100 San Jose Ave | 79 | Front Yard : Yard | Tree | Private 2 | 50 | 6004537.44257 | 2096386.81209 | 37.7365358547364 | -122.426778411906 | (37.7365358547364, -122.426778411906) | 2 | 7 | 5 | 63 | 7 | ||||
88826 | 111588 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 730X Lake Merced Blvd | 4 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 48 | 5987577.49507 | 2091187.90071 | 37.7212874908284 | -122.485034126397 | (37.7212874908284, -122.485034126397) | 1 | 8 | 4 | 64 | 14 | |||
89210 | 217838 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2 Cranleigh Dr | 28 | Front Yard : Yard | Tree | Private 2 | 1 | 5991394.82586 | 2095823.85306 | 37.7342382748577 | -122.472176577298 | (37.7342382748577, -122.472176577298) | 1 | 8 | 4 | 64 | 40 | ||||
91893 | 223715 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1101 San Jose Ave | 10 | Front Yard : Yard | Tree | Private 2 | 17 | 6004750.57812 | 2096360.89303 | 37.7364767350963 | -122.426039666491 | (37.7364767350963, -122.426039666491) | 2 | 7 | 5 | 28859 | 2 | ||||
92137 | 223795 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 22 Saturn St | 1 | Front Yard : Yard | Tree | Private 2 | 47 | Width 3ft | 6000543.87273 | 2106026.13486 | 37.7627765144437 | -122.441277265741 | (37.7627765144437, -122.441277265741) | 15 | 5 | 5 | 28862 | 3 | |||
94784 | 253250 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 99X Lopez Ave | 1 | Front Yard : Yard | Tree | Private 2 | 01/09/2018 12:00:00 AM | 3 | 10x10 | Permit Number 780226 | 5994049 | 2100330 | 37.746764271907 | -122.463327202712 | (37.746764271907, -122.463327202712) | 1 | 8 | 4 | 29491 | 40 | |
94836 | 254241 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 47 Cole St | 6 | Front Yard : Yard | Tree | Private 2 | 5997708 | 2110435 | 37.7747201781994 | -122.451403505262 | (37.7747201781994, -122.451403505262) | 15 | 5 | 2 | 29492 | 16 | |||||
96259 | 249857 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 241 Greenwich St | 3 | Front Yard : Yard | Tree | Private 2 | 16 | Width 0ft | 6011495.8307 | 2120401.68392 | 37.8028661922948 | -122.404410025227 | (37.8028661922948, -122.404410025227) | 3 | 1 | 10 | 308 | 23 | |||
98293 | 205909 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 14 Martha Ave | 1 | Front Yard : Yard | Tree | Private 2 | 56 | 6000896.43949 | 2095509.31761 | 37.7339199265681 | -122.439304003884 | (37.7339199265681, -122.439304003884) | 9 | 7 | 5 | 63 | 40 | ||||
98332 | 93204 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 400 Masonic Ave | 1 | Front Yard : Yard | Tree | Private 2 | 02/24/2010 12:00:00 AM | Permit Number 53203 | 5999124.7 | 2111407.5 | 37.7774714343299 | -122.446572853901 | (37.7774714343299, -122.446572853901) | 15 | 5 | 11 | 29492 | 16 | |||
98635 | 105649 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 3 Gonzalez Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5990274.6 | 2090665.2 | 37.7200090188364 | -122.475672946469 | (37.7200090188364, -122.475672946469) | 1 | 8 | 4 | 64 | 14 | |||||
99001 | 223700 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1100 San Jose Ave | 37 | Front Yard : Yard | Tree | Private 2 | 32 | 6004786.16622 | 2096652.60405 | 37.7372797190785 | -122.425937382102 | (37.7372797190785, -122.425937382102) | 2 | 7 | 5 | 63 | 7 | ||||
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 | |||
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 | ||||
100730 | 217837 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2 Cranleigh Dr | 27 | Front Yard : Yard | Tree | Private 2 | 1 | 5991408.51822 | 2095817.51986 | 37.7342216778764 | -122.472128777417 | (37.7342216778764, -122.472128777417) | 1 | 8 | 4 | 64 | 40 | ||||
104636 | 223697 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1001 San Jose Ave | 50 | Front Yard : Yard | Tree | Private 2 | 50 | 6005304.12461 | 2097202.65687 | 37.7388192990629 | -122.424185667341 | (37.7388192990629, -122.424185667341) | 2 | 7 | 5 | 28859 | 2 | ||||
105567 | 126419 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 956 Vallejo St | 7 | Front Yard : Yard | Tree | Private 2 | 20 | 6008811.64334 | 2118703.95696 | 37.7980542914263 | -122.413578579305 | (37.7980542914263, -122.413578579305) | 3 | 1 | 10 | 308 | 21 | ||||
106429 | 105497 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 3929 19TH ST | 1 | Front Yard : Yard | Tree | Private 2 | 60 | 6003450.9 | 2104734.8 | 37.7593959875427 | -122.431130714429 | (37.7593959875427, -122.431130714429) | 2 | 4 | 5 | 28862 | 3 | ||||
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 | ||||
112172 | 101037 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1010X Portola Dr | 11 | Front Yard : Yard | Tree | DPW 1 | 5995923.3 | 2098391.5 | 37.7415494342357 | -122.45670592621 | (37.7415494342357, -122.45670592621) | 1 | 7 | 4 | 59 | 40 | |||||
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 | ||||
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 | |||
115496 | 223694 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1001 San Jose Ave | 8 | Front Yard : Yard | Tree | Private 2 | 65 | 6005104.45792 | 2096735.83838 | 37.7375262448502 | -122.424842819945 | (37.7375262448502, -122.424842819945) | 2 | 7 | 5 | 28859 | 2 | ||||
117214 | 249830 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 339 Greenwich St | 3 | Front Yard : Yard | Tree | Private 2 | 22 | Width 0ft | 6011191.13425 | 2120368.12029 | 37.8027570028825 | -122.405462071912 | (37.8027570028825, -122.405462071912) | 3 | 1 | 10 | 308 | 23 | |||
118136 | 223793 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 701 Church St | 29 | Front Yard : Yard | Tree | Private 2 | 28 | Width 3ft | 6004332.42346 | 2104590.86919 | 37.7590507014501 | -122.428071717046 | (37.7590507014501, -122.428071717046) | 2 | 4 | 5 | 28862 | 3 | |||
120316 | 106363 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 101 URBANO DR | 1 | Front Yard : Yard | Tree | Private 2 | 80 | 5993535.8 | 2092458.1 | 37.7251204132224 | -122.464530299025 | (37.7251204132224, -122.464530299025) | 9 | 8 | 4 | 59 | 40 | ||||
120750 | 223692 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 701 Church St | 44 | Front Yard : Yard | Tree | Private 2 | 13 | 6004344.5987 | 2104707.34802 | 37.7593712135304 | -122.428037909748 | (37.7593712135304, -122.428037909748) | 2 | 4 | 5 | 28862 | 3 | ||||
120814 | 223792 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 701 Church St | 28 | Front Yard : Yard | Tree | Private 2 | 33 | Width 3ft | 6004330.96009 | 2104564.96578 | 37.7589794940334 | -122.428074932123 | (37.7589794940334, -122.428074932123) | 2 | 4 | 5 | 28862 | 3 | |||
121657 | 249828 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 339 Greenwich St | 1 | Front Yard : Yard | Tree | Private 2 | 26 | Width 0ft | 6011201.53996 | 2120373.03951 | 37.8027710916682 | -122.405426409314 | (37.8027710916682, -122.405426409314) | 3 | 1 | 10 | 308 | 23 | |||
123289 | 252924 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 700 Sanchez St | 1 | Front Yard : Yard | Tree | DPW 1 | 6003672 | 2104202 | 37.757945572264 | -122.430328029181 | (37.757945572264, -122.430328029181) | 2 | 4 | 5 | 28862 | 3 | |||||
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 | |||
124704 | 253781 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 90 Cuesta Ct | 5 | Front Yard : Yard | Tree | DPW 1 | 5999757 | 2101744 | 37.7509739685765 | -122.443691128062 | (37.7509739685765, -122.443691128062) | 2 | 5 | 5 | 63 | 38 | |||||
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 | |||||
133288 | 205908 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 22 Martha Ave | 1 | Front Yard : Yard | Tree | Private 2 | 50 | 6000855.4988 | 2095527.04116 | 37.733966261424 | -122.439446818028 | (37.733966261424, -122.439446818028) | 9 | 7 | 5 | 63 | 40 | ||||
133457 | 223738 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1760 Diamond St | 4 | Front Yard : Yard | Tree | Private 2 | 40 | 6002028.66681 | 2098687.00139 | 37.7427094757629 | -122.435616814959 | (37.7427094757629, -122.435616814959) | 2 | 7 | 5 | 63 | 22 | ||||
136162 | 223782 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 4067 20th St | 1 | Front Yard : Yard | Tree | Private 2 | 18 | Width 3ft | 6003283.38954 | 2104156.06965 | 37.7577974386201 | -122.431668728247 | (37.7577974386201, -122.431668728247) | 2 | 4 | 5 | 28862 | 3 | |||
138202 | 223784 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 4053 20th St | 3 | Front Yard : Yard | Tree | Private 2 | 12 | Width 3ft | 6003311.94713 | 2104157.91434 | 37.7578041223787 | -122.431570095991 | (37.7578041223787, -122.431570095991) | 2 | 4 | 5 | 28862 | 3 | |||
139584 | 223717 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1101 San Jose Ave | 58 | Front Yard : Yard | Tree | Private 2 | 55 | 6005027.45143 | 2096662.24212 | 37.7373198162667 | -122.425103832873 | (37.7373198162667, -122.425103832873) | 2 | 7 | 5 | 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 | |||
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 | ||||
144280 | 253255 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 270 Castenada Ave | 2 | Front Yard : Yard | Tree | Private 2 | 01/09/2018 12:00:00 AM | 3 | 10x10 | Permit Number 780226 | 5994049 | 2100330 | 37.746764271907 | -122.463327202712 | (37.746764271907, -122.463327202712) | 1 | 8 | 4 | 29491 | 40 | |
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 | |||||
151814 | 249786 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 161 Chestnut St | 3 | Front Yard : Yard | Tree | Private 2 | 18 | Width 0ft | 6010943.97363 | 2121044.47732 | 37.8046002902368 | -122.406365062323 | (37.8046002902368, -122.406365062323) | 3 | 1 | 10 | 308 | 23 | |||
153798 | 103351 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 15X Highland Ave | 1 | Front Yard : Yard | Tree | DPW 1 | 18 | 6004989.3 | 2096795.8 | 37.7376843808497 | -122.42524524109 | (37.7376843808497, -122.42524524109) | 2 | 7 | 5 | 28859 | 7 | ||||
155980 | 223702 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1100 San Jose Ave | 76 | Front Yard : Yard | Tree | Private 2 | 26 | 6004596.80195 | 2096429.4382 | 37.7366562523786 | -122.426576215516 | (37.7366562523786, -122.426576215516) | 2 | 7 | 5 | 63 | 7 | ||||
156249 | 253288 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 650 Peru Ave | 4 | Front Yard : Yard | Tree | Private 2 | 6005101.95698 | 2092563.19401 | 37.7260689503102 | -122.424554741032 | (37.7260689503102, -122.424554741032) | 9 | 7 | 6 | 28861 | 5 | |||||
156801 | 223714 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1201 San Jose Ave | 82 | Front Yard : Yard | Tree | Private 2 | 34 | 6004606.42672 | 2096213.68372 | 37.7360643833694 | -122.426527580197 | (37.7360643833694, -122.426527580197) | 2 | 7 | 5 | 28861 | 2 | ||||
158156 | 93206 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 400 Masonic Ave | 4 | Front Yard : Yard | Tree | Private 2 | 02/24/2010 12:00:00 AM | Permit Number 53203 | 5999124.7 | 2111407.5 | 37.7774714343299 | -122.446572853901 | (37.7774714343299, -122.446572853901) | 15 | 5 | 11 | 29492 | 16 | |||
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 | |||
159510 | 251717 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1000X San Jose Ave | 1 | Front Yard : Yard | Tree | DPW 1 | 6004710 | 2096486 | 37.7368179571536 | -122.426188866367 | (37.7368179571536, -122.426188866367) | 2 | 7 | 5 | 28859 | 7 | |||||
159623 | 223794 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 701 Church St | 30 | Front Yard : Yard | Tree | Private 2 | 21 | Width 3ft | 6004330.71364 | 2104618.42618 | 37.7591262696742 | -122.42807959421 | (37.7591262696742, -122.42807959421) | 2 | 4 | 5 | 28862 | 3 | |||
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 | ||||
161611 | 223712 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1201 San Jose Ave | 75 | Front Yard : Yard | Tree | Private 2 | 59 | 6004557.86024 | 2096180.22234 | 37.7359697602838 | -122.426693112116 | (37.7359697602838, -122.426693112116) | 2 | 7 | 5 | 28861 | 2 | ||||
161867 | 253777 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 90 Cuesta Ct | 1 | Front Yard : Yard | Tree | DPW 1 | 5999757 | 2101744 | 37.7509739685765 | -122.443691128062 | (37.7509739685765, -122.443691128062) | 2 | 5 | 5 | 63 | 38 | |||||
162401 | 113064 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2X Cranleigh Dr | 5 | Front Yard : Yard | Tree | DPW 1 | 08/18/2016 09:54:00 AM | 3 | 5991370.3 | 2095943.7 | 37.7345659248964 | -122.472270103664 | (37.7345659248964, -122.472270103664) | 1 | 8 | 4 | 64 | 40 | |||
164086 | 105764 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 1X GONZALEZ DR | 1 | Front Yard : Yard | Tree | Private 2 | 5990111.8 | 2090190.8 | 37.7186969947407 | -122.476201051717 | (37.7186969947407, -122.476201051717) | 1 | 8 | 4 | 64 | 14 | |||||
164693 | 223713 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1201 San Jose Ave | 81 | Front Yard : Yard | Tree | Private 2 | 52 | 6004590.4575 | 2096203.60231 | 37.7360357993049 | -122.426582074619 | (37.7360357993049, -122.426582074619) | 2 | 7 | 5 | 28861 | 2 | ||||
164851 | 103422 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 1365 Portola Dr | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 769779 | 5993416.2 | 2097683.7 | 37.7394617231066 | -122.465323151466 | (37.7394617231066, -122.465323151466) | 1 | 8 | 4 | 59 | 40 | ||||
167754 | 107159 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 1000 ESMERALDA AVE | Front Yard : Yard | Tree | Private 2 | 6009839 | 2098688 | 37.7431527400861 | -122.408610872619 | (37.7431527400861, -122.408610872619) | 10 | 7 | 7 | 28859 | 2 | ||||||
168388 | 223783 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 4053 20th St | 2 | Front Yard : Yard | Tree | Private 2 | 19 | Width 3ft | 6003309.14673 | 2104160.40669 | 37.7578108070506 | -122.431579958864 | (37.7578108070506, -122.431579958864) | 2 | 4 | 5 | 28862 | 3 | |||
171450 | 206850 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2 Cranleigh Dr | 11 | Front Yard : Yard | Tree | Private 2 | 13 | Width 0ft | 5991355.50473 | 2095693.71529 | 37.7338786737585 | -122.472303038149 | (37.7338786737585, -122.472303038149) | 1 | 8 | 4 | 64 | 40 | |||
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 | |||||
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 | |||||
172353 | 99662 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 1337 Portola Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5993559.3 | 2097744.3 | 37.7396363671104 | -122.464832777968 | (37.7396363671104, -122.464832777968) | 1 | 8 | 4 | 59 | 40 | |||||
175942 | 249787 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 173 Chestnut St | 1 | Front Yard : Yard | Tree | Private 2 | 23 | Width 0ft | 6010924.52484 | 2121034.42071 | 37.8045715892836 | -122.40643165799 | (37.8045715892836, -122.40643165799) | 3 | 1 | 10 | 308 | 23 | |||
176180 | 223704 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1100 San Jose Ave | 78 | Front Yard : Yard | Tree | Private 2 | 40 | 6004560.21701 | 2096406.89693 | 37.7365922907993 | -122.426701100777 | (37.7365922907993, -122.426701100777) | 2 | 7 | 5 | 63 | 7 | ||||
179102 | 205907 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 30 Martha Ave | 1 | Front Yard : Yard | Tree | Private 2 | 34 | 6000842.20104 | 2095534.19328 | 37.7339851426839 | -122.439493304878 | (37.7339851426839, -122.439493304878) | 9 | 7 | 5 | 63 | 40 | ||||
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 | ||||
180298 | 93203 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 400 Masonic Ave | 2 | Front Yard : Yard | Tree | Private 2 | 02/24/2010 12:00:00 AM | Permit Number 53203 | 5999124.7 | 2111407.5 | 37.7774714343299 | -122.446572853901 | (37.7774714343299, -122.446572853901) | 15 | 5 | 11 | 29492 | 16 | |||
180396 | 223709 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1201 San Jose Ave | 12 | Front Yard : Yard | Tree | Private 2 | 24 | 6004249.02504 | 2095933.99045 | 37.7352761977326 | -122.427743340379 | (37.7352761977326, -122.427743340379) | 2 | 7 | 5 | 28861 | 2 | ||||
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 | |||||
185344 | 250204 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 206 Union St | 1 | Front Yard : Yard | Tree | Private 2 | 21 | Width 0ft | 6011843.53468 | 2119802.56119 | 37.8012405714539 | -122.403164615272 | (37.8012405714539, -122.403164615272) | 3 | 1 | 10 | 308 | 23 | |||
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 | |||||
188942 | 104888 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 146 Gonzalez Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5990401 | 2090562 | 37.7197329843514 | -122.475228499286 | (37.7197329843514, -122.475228499286) | 1 | 8 | 4 | 64 | 14 | |||||
189507 | 223695 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1001 San Jose Ave | 10 | Front Yard : Yard | Tree | Private 2 | 37 | 6005104.91543 | 2096758.07935 | 37.7375873393881 | -122.424842819957 | (37.7375873393881, -122.424842819957) | 2 | 7 | 5 | 28859 | 2 | ||||
189870 | 223696 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1001 San Jose Ave | 13 | Front Yard : Yard | Tree | Private 2 | 23 | 6005111.39586 | 2096784.72517 | 37.7376608688401 | -122.42482230912 | (37.7376608688401, -122.42482230912) | 2 | 7 | 5 | 28859 | 2 | ||||
191057 | 100769 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 3701 21st St | Front Yard : Yard | Tree | Private 2 | 55 | Street tree w/in RoW | 6003717 | 2103606 | 37.7563116466144 | -122.43012988292 | (37.7563116466144, -122.43012988292) | 2 | 4 | 5 | 28862 | 22 | ||||
192259 | 253780 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 90 Cuesta Ct | 4 | Front Yard : Yard | Tree | DPW 1 | 5999757 | 2101744 | 37.7509739685765 | -122.443691128062 | (37.7509739685765, -122.443691128062) | 2 | 5 | 5 | 63 | 38 | |||||
192549 | 98880 | Property Tree 8 | Cupressus macrocarpa :: Monterey Cypress 41 | 101 Lansdale Ave | 1 | Front Yard : Yard | Tree | Private 2 | 11 | 5994747.9 | 2097283.1 | 37.7384384842789 | -122.460689725403 | (37.7384384842789, -122.460689725403) | 9 | 7 | 4 | 59 | 40 | ||||
193245 | 254239 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 47 Cole St | 4 | Front Yard : Yard | Tree | Private 2 | 5997708 | 2110435 | 37.7747201781994 | -122.451403505262 | (37.7747201781994, -122.451403505262) | 15 | 5 | 2 | 29492 | 16 | |||||
193618 | 254237 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 47 Cole St | 2 | Front Yard : Yard | Tree | Private 2 | 5997708 | 2110435 | 37.7747201781994 | -122.451403505262 | (37.7747201781994, -122.451403505262) | 15 | 5 | 2 | 29492 | 16 |
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) );