Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qCaretaker, PlantDate, PlotSize, PermitNotes
Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
188593 | 188593 | 249830 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 339 Greenwich St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | Width 0ft | 6011191.13425 | 2120368.12029 | 37.8027570028825 | -122.405462071912 | (37.8027570028825, -122.405462071912) | |||
185302 | 185302 | 223737 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1760 Diamond St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 6002025.38373 | 2098740.99425 | 37.7428575410441 | -122.43563202880699 | (37.7428575410441, -122.435632028807) | ||||
183568 | 183568 | 176102 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 62 Tomaso Ct | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | Width 8ft | 6009173.04361 | 2086270.9274900001 | 37.709020763061396 | -122.41003717048099 | (37.7090207630614, -122.410037170481) | |||
182837 | 182837 | 223781 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 4071 20th St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 3ft | 6003265.85281 | 2104155.2145700003 | 37.757794096729704 | -122.431729316456 | (37.7577940967297, -122.431729316456) | |||
182295 | 182295 | 249826 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 391 Filbert St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 41 | Width 0ft | 6011015.83097 | 2120024.81975 | 37.8018045803872 | -122.406044514263 | (37.8018045803872, -122.406044514263) | |||
181738 | 181738 | 223705 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1100 San Jose Ave | 79 | Front Yard : Yard 7 | Tree 1 | Private 1 | 50 | 6004537.44257 | 2096386.8120900001 | 37.7365358547364 | -122.426778411906 | (37.7365358547364, -122.426778411906) | ||||
179027 | 179027 | 205907 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 30 Martha Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 34 | 6000842.20104 | 2095534.19328 | 37.7339851426839 | -122.439493304878 | (37.7339851426839, -122.439493304878) | ||||
178194 | 178194 | 217837 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Cranleigh Dr | 27 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 5991408.51822 | 2095817.51986 | 37.7342216778764 | -122.472128777417 | (37.7342216778764, -122.472128777417) | ||||
176669 | 176669 | 223743 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 65 Zircon Pl | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 45 | 6002363.70914 | 2098682.85125 | 37.7427171047157 | -122.434458039421 | (37.7427171047157, -122.434458039421) | ||||
170501 | 170501 | 205908 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 22 Martha Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 50 | 6000855.4988 | 2095527.0411599998 | 37.733966261424 | -122.43944681802799 | (37.733966261424, -122.439446818028) | ||||
170407 | 170407 | 223738 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1760 Diamond St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 40 | 6002028.666809999 | 2098687.0013900003 | 37.742709475762894 | -122.43561681495899 | (37.7427094757629, -122.435616814959) | ||||
170171 | 170171 | 223739 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1760 Diamond St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 6002032.6649400005 | 2098618.50085 | 37.7425216163939 | -122.43559809108 | (37.7425216163939, -122.43559809108) | ||||
168599 | 168599 | 176157 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 999 Brotherhood Way | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | Width 0ft | 5988327.5004199995 | 2088688.82584 | 37.714469318273004 | -122.482258598878 | (37.714469318273, -122.482258598878) | |||
168070 | 168070 | 250204 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 206 Union St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 21 | Width 0ft | 6011843.5346800005 | 2119802.5611900003 | 37.8012405714539 | -122.403164615272 | (37.8012405714539, -122.403164615272) | |||
167641 | 167641 | 190982 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Tulare St | 23 | Front Yard : Yard 7 | Tree 1 | Private 1 | 34 | 6016087.28584 | 2100258.68622 | 37.7478134836207 | -122.387115296958 | (37.7478134836207, -122.387115296958) | ||||
166986 | 166986 | 223780 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 4071 20th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 28 | Width 3ft | 6003254.362819999 | 2104156.16383 | 37.757796051860296 | -122.431769121362 | (37.7577960518603, -122.431769121362) | |||
166767 | 166767 | 223718 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1101 San Jose Ave | 59 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6005036.8773300005 | 2096676.581 | 37.7373597200698 | -122.42507226308999 | (37.7373597200698, -122.42507226309) | ||||
166536 | 166536 | 223783 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 4053 20th St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 19 | Width 3ft | 6003309.14673 | 2104160.40669 | 37.7578108070506 | -122.431579958864 | (37.7578108070506, -122.431579958864) | |||
161565 | 161565 | 206849 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Cranleigh Dr | 14 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Width 0ft | 5991370.13316 | 2095847.8474599998 | 37.7343027283865 | -122.47226369552601 | (37.7343027283865, -122.472263695526) | |||
160228 | 160228 | 223792 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 701 Church St | 28 | Front Yard : Yard 7 | Tree 1 | Private 1 | 33 | Width 3ft | 6004330.96009 | 2104564.9657799997 | 37.7589794940334 | -122.428074932123 | (37.7589794940334, -122.428074932123) | |||
160062 | 160062 | 176162 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 301 Naglee Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 30 | Width 10ft | 5997669.17463 | 2088536.7397200002 | 37.7145906808916 | -122.449959233558 | (37.7145906808916, -122.449959233558) | |||
159881 | 159881 | 190980 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Tulare St | 25 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6016106.6833 | 2100234.37898 | 37.747747815104205 | -122.387046525793 | (37.7477478151042, -122.387046525793) | ||||
159461 | 159461 | 223702 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1100 San Jose Ave | 76 | Front Yard : Yard 7 | Tree 1 | Private 1 | 26 | 6004596.80195 | 2096429.4382 | 37.7366562523786 | -122.426576215516 | (37.7366562523786, -122.426576215516) | ||||
159135 | 159135 | 217841 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Cranleigh Dr | 31 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 5991404.95504 | 2095888.4488 | 37.7344162246301 | -122.472146264739 | (37.7344162246301, -122.472146264739) | ||||
158990 | 158990 | 190984 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Tulare St | 19 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 6016127.79585 | 2100261.1881 | 37.747822596447705 | -122.38697538852502 | (37.7478225964477, -122.386975388525) | ||||
157706 | 157706 | 190985 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Tulare St | 17 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6016130.05616 | 2100249.9564799997 | 37.747791881903 | -122.386966789196 | (37.747791881903, -122.386966789196) | ||||
157577 | 157577 | 126419 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 956 Vallejo St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 6008811.64334 | 2118703.9569599996 | 37.7980542914263 | -122.413578579305 | (37.7980542914263, -122.413578579305) | ||||
153445 | 153445 | 223711 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1201 San Jose Ave | 43 | Front Yard : Yard 7 | Tree 1 | Private 1 | 27 | 6004453.96026 | 2096061.62765 | 37.7356382512944 | -122.42704389176201 | (37.7356382512944, -122.427043891762) | ||||
152844 | 152844 | 223706 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1100 San Jose Ave | 80 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6004536.52923 | 2096375.8684900003 | 37.736505754442504 | -122.42678079059999 | (37.7365057544425, -122.4267807906) | ||||
152523 | 152523 | 223698 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1100 San Jose Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 151 | 6004903.42732 | 2096771.39372 | 37.7376125150086 | -122.42554040785801 | (37.7376125150086, -122.425540407858) | ||||
150471 | 150471 | 201721 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Lindsay Cir | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 26 | 6016317.40109 | 2095614.0815400002 | 37.7350730858367 | -122.385995846031 | (37.7350730858367, -122.385995846031) | ||||
149694 | 149694 | 223692 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 701 Church St | 44 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6004344.5987 | 2104707.34802 | 37.7593712135304 | -122.428037909748 | (37.7593712135304, -122.428037909748) | ||||
148628 | 148628 | 248051 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 25 Rutledge St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 6010607.1512400005 | 2099382.29757 | 37.745102122072396 | -122.406003697633 | (37.7451021220724, -122.406003697633) | ||||
148452 | 148452 | 247988 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 124 Mullen Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 29 | Width 10ft | 6009878.9446 | 2099816.70211 | 37.746254146420796 | -122.40855235741199 | (37.7462541464208, -122.408552357412) | |||
147608 | 147608 | 223786 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 4053 20th St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 31 | Width 3ft | 6003330.94018 | 2104170.0994700002 | 37.7578386563428 | -122.43150528004401 | (37.7578386563428, -122.431505280044) | |||
146111 | 146111 | 223697 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1001 San Jose Ave | 50 | Front Yard : Yard 7 | Tree 1 | Private 1 | 50 | 6005304.12461 | 2097202.65687 | 37.738819299062904 | -122.424185667341 | (37.7388192990629, -122.424185667341) | ||||
145874 | 145874 | 100769 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 3701 21st St | Front Yard : Yard 7 | Tree 1 | Private 1 | 55 | Street tree w/in RoW | 6003717.0 | 2103606.0 | 37.7563116466144 | -122.43012988292 | (37.7563116466144, -122.43012988292) | ||||
145393 | 145393 | 98880 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 101 Lansdale Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 5994747.9 | 2097283.1 | 37.738438484278895 | -122.460689725403 | (37.7384384842789, -122.460689725403) | ||||
144598 | 144598 | 99662 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 1337 Portola Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5993559.3 | 2097744.3 | 37.7396363671104 | -122.46483277796801 | (37.7396363671104, -122.464832777968) | |||||
143237 | 143237 | 104888 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 146 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
140312 | 140312 | 115391 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 21X BELMONT AVE | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 48 | 5996611.0 | 2106266.0 | 37.7632103037359 | -122.45489693849501 | (37.7632103037359, -122.454896938495) | ||||
139692 | 139692 | 99826 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Cascade Walk | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5992183.1 | 2103187.3 | 37.7545020044945 | -122.469987253468 | (37.7545020044945, -122.469987253468) | |||||
139394 | 139394 | 93203 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 400 Masonic Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/24/2010 12:00:00 AM | Permit Number 53203 | 5999124.7 | 2111407.5 | 37.777471434329904 | -122.446572853901 | (37.7774714343299, -122.446572853901) | |||
138302 | 138302 | 113064 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2X Cranleigh Dr | 5 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 08/18/2016 09:54:00 AM | 3 | 5991370.3 | 2095943.7 | 37.734565924896394 | -122.472270103664 | (37.7345659248964, -122.472270103664) | |||
137917 | 137917 | 223789 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 190 Storrie St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | Width 3ft | 6000719.29532 | 2105252.42792 | 37.7606620968006 | -122.44061504455401 | (37.7606620968006, -122.440615044554) | |||
137779 | 137779 | 223717 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1101 San Jose Ave | 58 | Front Yard : Yard 7 | Tree 1 | Private 1 | 55 | 6005027.45143 | 2096662.24212 | 37.737319816266705 | -122.425103832873 | (37.7373198162667, -122.425103832873) | ||||
137317 | 137317 | 223704 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1100 San Jose Ave | 78 | Front Yard : Yard 7 | Tree 1 | Private 1 | 40 | 6004560.21701 | 2096406.8969299998 | 37.7365922907993 | -122.426701100777 | (37.7365922907993, -122.426701100777) | ||||
137161 | 137161 | 249710 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2901 Broadway | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 5999603.39885 | 2116998.0274799997 | 37.7928489002955 | -122.44531894132099 | (37.7928489002955, -122.445318941321) | ||||
135900 | 135900 | 223793 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 701 Church St | 29 | Front Yard : Yard 7 | Tree 1 | Private 1 | 28 | Width 3ft | 6004332.42346 | 2104590.86919 | 37.7590507014501 | -122.428071717046 | (37.7590507014501, -122.428071717046) | |||
135849 | 135849 | 223784 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 4053 20th St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | Width 3ft | 6003311.94713 | 2104157.91434 | 37.7578041223787 | -122.431570095991 | (37.7578041223787, -122.431570095991) | |||
135517 | 135517 | 249787 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 173 Chestnut St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | Width 0ft | 6010924.52484 | 2121034.4207099997 | 37.8045715892836 | -122.40643165799 | (37.8045715892836, -122.40643165799) | |||
135200 | 135200 | 223752 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 3944 22nd St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 6002172.64124 | 2102975.1005599997 | 37.754491758314295 | -122.435425673069 | (37.7544917583143, -122.435425673069) | ||||
132735 | 132735 | 223694 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1001 San Jose Ave | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 65 | 6005104.45792 | 2096735.8383799999 | 37.7375262448502 | -122.424842819945 | (37.7375262448502, -122.424842819945) | ||||
131626 | 131626 | 206850 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Cranleigh Dr | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | Width 0ft | 5991355.50473 | 2095693.7152900002 | 37.733878673758504 | -122.472303038149 | (37.7338786737585, -122.472303038149) | |||
131402 | 131402 | 190979 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Tulare St | 26 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6016095.64833 | 2100226.2738200002 | 37.747724948962606 | -122.387084119257 | (37.7477249489626, -122.387084119257) | ||||
131336 | 131336 | 223709 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1201 San Jose Ave | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 6004249.02504 | 2095933.99045 | 37.7352761977326 | -122.42774334037901 | (37.7352761977326, -122.427743340379) | ||||
130214 | 130214 | 249786 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 161 Chestnut St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | Width 0ft | 6010943.97363 | 2121044.47732 | 37.8046002902368 | -122.406365062323 | (37.8046002902368, -122.406365062323) | |||
126172 | 126172 | 223721 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 201 College Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | Width 2ft | 6005265.6215699995 | 2095876.8454099998 | 37.7351767443941 | -122.424224526166 | (37.7351767443941, -122.424224526166) | |||
125813 | 125813 | 103600 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 50X Hermann St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6005031.0649 | 2108842.56611 | 37.7707643495235 | -122.42595813798201 | (37.7707643495235, -122.425958137982) | |||||
124189 | 124189 | 113065 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2X Cranleigh Dr | 6 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 08/18/2016 09:51:00 AM | 3 | 5991370.3 | 2095943.7 | 37.734565924896394 | -122.472270103664 | (37.7345659248964, -122.472270103664) | |||
122936 | 122936 | 107159 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 1000 ESMERALDA AVE | Front Yard : Yard 7 | Tree 1 | Private 1 | 6009839.0 | 2098688.0 | 37.7431527400861 | -122.408610872619 | (37.7431527400861, -122.408610872619) | ||||||
122020 | 122020 | 223736 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1760 Diamond St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 38 | 6002022.64455 | 2098766.1332 | 37.7429264111321 | -122.435643298224 | (37.7429264111321, -122.435643298224) | ||||
120332 | 120332 | 103422 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 1365 Portola Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 769779 | 5993416.2 | 2097683.7 | 37.7394617231066 | -122.46532315146601 | (37.7394617231066, -122.465323151466) | ||||
118374 | 118374 | 93206 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 400 Masonic Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/24/2010 12:00:00 AM | Permit Number 53203 | 5999124.7 | 2111407.5 | 37.777471434329904 | -122.446572853901 | (37.7774714343299, -122.446572853901) | |||
117533 | 117533 | 105764 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1X GONZALEZ DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990111.8 | 2090190.8 | 37.718696994740704 | -122.476201051717 | (37.7186969947407, -122.476201051717) | |||||
116468 | 116468 | 103351 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 15X Highland Ave | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 18 | 6004989.3 | 2096795.8 | 37.73768438084971 | -122.42524524109 | (37.7376843808497, -122.42524524109) | ||||
115560 | 115560 | 109453 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 951 GILMAN AVE | 1 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 03/24/2015 12:00:00 AM | 3 | Permit Number 774986 | 6015934.0 | 2089205.0 | 37.717453787650705 | -122.38687458595501 | (37.7174537876507, -122.386874585955) | ||
114769 | 114769 | 114267 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800x BROTHERHOOD WAY | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 50 | 5990271.0 | 2088582.0 | 37.7142888575797 | -122.475533361779 | (37.7142888575797, -122.475533361779) | ||||
108351 | 108351 | 106363 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 101 URBANO DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 80 | 5993535.8 | 2092458.1 | 37.7251204132224 | -122.464530299025 | (37.7251204132224, -122.464530299025) | ||||
103620 | 103620 | 93204 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 400 Masonic Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/24/2010 12:00:00 AM | Permit Number 53203 | 5999124.7 | 2111407.5 | 37.777471434329904 | -122.446572853901 | (37.7774714343299, -122.446572853901) | |||
102194 | 102194 | 101037 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1010X Portola Dr | 11 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 5995923.3 | 2098391.5 | 37.7415494342357 | -122.45670592621 | (37.7415494342357, -122.45670592621) | |||||
98711 | 98711 | 105649 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990274.6 | 2090665.2 | 37.7200090188364 | -122.475672946469 | (37.7200090188364, -122.475672946469) | |||||
98176 | 98176 | 105497 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3929 19TH ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 60 | 6003450.9 | 2104734.8 | 37.7593959875427 | -122.431130714429 | (37.7593959875427, -122.431130714429) | ||||
92075 | 92075 | 111588 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 730X Lake Merced Blvd | 4 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 48 | 5987577.495069999 | 2091187.90071 | 37.7212874908284 | -122.485034126397 | (37.7212874908284, -122.485034126397) | |||
91685 | 91685 | 114268 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800x BROTHERHOOD WAY | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 30 | 5990271.0 | 2088582.0 | 37.7142888575797 | -122.475533361779 | (37.7142888575797, -122.475533361779) | ||||
90230 | 90230 | 98140 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 315 San Marcos Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | 5992920.8 | 2100212.1 | 37.746375486546704 | -122.467219803339 | (37.7463754865467, -122.467219803339) | ||||||
89354 | 89354 | 111589 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 730X Lake Merced Blvd | 5 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | Permit Number 774260 | 5987577.495069999 | 2091187.90071 | 37.7212874908284 | -122.485034126397 | (37.7212874908284, -122.485034126397) | |||
88589 | 88589 | 114269 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800x BROTHERHOOD WAY | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 38 | 5990271.0 | 2088582.0 | 37.7142888575797 | -122.475533361779 | (37.7142888575797, -122.475533361779) | ||||
78509 | 78509 | 102745 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 222 Moncada Way | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5992354.0 | 2093377.4 | 37.727576385896604 | -122.468682482409 | (37.7275763858966, -122.468682482409) | |||||
77269 | 77269 | 223713 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1201 San Jose Ave | 81 | Front Yard : Yard 7 | Tree 1 | Private 1 | 52 | 6004590.4575 | 2096203.6023099998 | 37.7360357993049 | -122.426582074619 | (37.7360357993049, -122.426582074619) | ||||
76851 | 76851 | 190981 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Tulare St | 24 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 6016079.678669999 | 2100249.91321 | 37.7477889734994 | -122.38714099058998 | (37.7477889734994, -122.38714099059) | ||||
75294 | 75294 | 93205 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 400 Masonic Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/24/2010 12:00:00 AM | Permit Number 53203 | 5999124.7 | 2111407.5 | 37.777471434329904 | -122.446572853901 | (37.7774714343299, -122.446572853901) | |||
71400 | 71400 | 223722 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 201 College Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | Width 2ft | 6005269.83523 | 2095874.10119 | 37.735169447301104 | -122.424209762894 | (37.7351694473011, -122.424209762894) | |||
71003 | 71003 | 223708 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 220 Coso Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 6007533.84485 | 2099558.41005 | 37.7454133189685 | -122.416643154074 | (37.7454133189685, -122.416643154074) | ||||
67821 | 67821 | 223782 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 4067 20th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | Width 3ft | 6003283.38954 | 2104156.06965 | 37.7577974386201 | -122.43166872824699 | (37.7577974386201, -122.431668728247) | |||
67041 | 67041 | 249828 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 339 Greenwich St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 26 | Width 0ft | 6011201.53996 | 2120373.03951 | 37.802771091668205 | -122.405426409314 | (37.8027710916682, -122.405426409314) | |||
65231 | 65231 | 247990 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 130 Mullen Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 21 | Width 10ft | 6009904.82703 | 2099823.3195700003 | 37.7462737660155 | -122.40846332542499 | (37.7462737660155, -122.408463325425) | |||
62231 | 62231 | 176114 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Zoo Rd | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | Width 10ft | 5982696.49512 | 2094384.4536 | 37.729778850703894 | -122.502142508582 | (37.7297788507039, -122.502142508582) | |||
60460 | 60460 | 217838 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Cranleigh Dr | 28 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 5991394.82586 | 2095823.8530599999 | 37.7342382748577 | -122.47217657729799 | (37.7342382748577, -122.472176577298) | ||||
60073 | 60073 | 223798 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 250 States St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 51 | Width 3ft | 6000691.89745 | 2106604.60917 | 37.764373293104896 | -122.44080679981501 | (37.7643732931049, -122.440806799815) | |||
58790 | 58790 | 205909 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 14 Martha Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 56 | 6000896.43949 | 2095509.3176099998 | 37.733919926568106 | -122.43930400388399 | (37.7339199265681, -122.439304003884) | ||||
58052 | 58052 | 223695 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1001 San Jose Ave | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 37 | 6005104.91543 | 2096758.07935 | 37.73758733938811 | -122.42484281995701 | (37.7375873393881, -122.424842819957) | ||||
56694 | 56694 | 223785 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 4053 20th St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 33 | Width 3ft | 6003318.98777 | 2104163.44905 | 37.7578197184314 | -122.431546141668 | (37.7578197184314, -122.431546141668) | |||
53725 | 53725 | 223707 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200 San Jose Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 37 | 6004449.31264 | 2096325.41802 | 37.7363622972844 | -122.42707874320699 | (37.7363622972844, -122.427078743207) | ||||
53546 | 53546 | 223712 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1201 San Jose Ave | 75 | Front Yard : Yard 7 | Tree 1 | Private 1 | 59 | 6004557.86024 | 2096180.22234 | 37.7359697602838 | -122.426693112116 | (37.7359697602838, -122.426693112116) | ||||
53350 | 53350 | 223795 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 22 Saturn St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 47 | Width 3ft | 6000543.87273 | 2106026.1348599996 | 37.7627765144437 | -122.44127726574101 | (37.7627765144437, -122.441277265741) | |||
49820 | 49820 | 223735 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1760 Diamond St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 34 | 6002021.50784 | 2098799.04405 | 37.7430167120556 | -122.43564958267 | (37.7430167120556, -122.43564958267) | ||||
49562 | 49562 | 223703 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1100 San Jose Ave | 77 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6004573.37155 | 2096423.41392 | 37.7366383864359 | -122.426656795699 | (37.7366383864359, -122.426656795699) | ||||
47893 | 47893 | 223716 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1101 San Jose Ave | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6004761.80581 | 2096370.25265 | 37.7365030690611 | -122.42600151366399 | (37.7365030690611, -122.426001513664) | ||||
46935 | 46935 | 250205 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 212 Union St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | Width 0ft | 6011817.68969 | 2119792.01106 | 37.8012101599872 | -122.4032533082 | (37.8012101599872, -122.4032533082) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");