Street_Tree_List

Data source: data.sfgov.org

1,824 rows where qSpecies = 47 sorted by rowid descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, PermitNotes

Link rowid ▲ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
188957 188957 186755 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1200 Sunset Blvd 21 Sidewalk: Property side : Yard 9 Tree 1 Private 1     20 Width 0ft   5984869.1172 2106699.1363 37.763719016073104 -122.495539548031 (37.7637190160731, -122.495539548031)
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)
188560 188560 185508 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2400 Sunset Blvd 62 unknown : Yard 19 Tree 1 Private 1     5 Width 0ft   5985138.3382 2098803.9124 37.742056662806796 -122.494026493821 (37.7420566628068, -122.494026493821)
188106 188106 205877 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1337 Portola Dr 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     17 Width 3ft   5993571.02759 2097763.88788 37.7396908266808 -122.464793651423 (37.7396908266808, -122.464793651423)
187759 187759 187201 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2301 Sunset Blvd 63 Sidewalk: Property side : Yard 9 Tree 1 Private 1     50 Width 0ft   5984911.8709 2099008.3578 37.742604760863294 -122.494824604589 (37.7426047608633, -122.494824604589)
187642 187642 206837 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 100x Idora Ave 25 Median : Yard 3 Tree 1 DPW 2     63 Width 9ft   5995840.17489 2099294.03492 37.7440227989188 -122.45705861128401 (37.7440227989188, -122.457058611284)
187617 187617 249716 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2975 Broadway 5 Back Yard : Yard 13 Tree 1 Private 1     7     5999444.23089 2116975.8695799997 37.7927789735145 -122.44586807365 (37.7927789735145, -122.44586807365)
187491 187491 185577 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2201 Sunset Blvd 61 Sidewalk: Property side : Yard 9 Tree 1 Private 1     43 Width 0ft   5984876.2578 2099639.0685 37.7443344368575 -122.4949942382 (37.7443344368575, -122.4949942382)
187359 187359 186164 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1700 Sunset Blvd 49 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984969.5188 2103423.199 37.754730082816295 -122.49495073100701 (37.7547300828163, -122.494950731007)
187143 187143 206901 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 901 Monterey Blvd 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   5996051.82187 2094624.9249900002 37.7312147154845 -122.45598930567199 (37.7312147154845, -122.455989305672)
186983 186983 206877 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 900 Junipero Serra Blvd 112 : 4 Tree 1 Private 1     24 Width 0ft   5991127.9538900005 2090310.3975099998 37.7190842541173 -122.472697367507 (37.7190842541173, -122.472697367507)
186923 186923 186140 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1700 Sunset Blvd 25 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984976.0967 2103251.4805 37.7542589762797 -122.494915322593 (37.7542589762797, -122.494915322593)
186893 186893 187048 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2501 Sunset Blvd 67 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984981.0582 2097651.451 37.738883110049706 -122.494485373526 (37.7388831100497, -122.494485373526)
186814 186814 187163 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2301 Sunset Blvd 25 Sidewalk: Property side : Yard 9 Tree 1 Private 1     45 Width 0ft   5984895.2042 2099383.9139 37.743634960627496 -122.494909916988 (37.7436349606275, -122.494909916988)
186777 186777 185153 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2500 Sunset Blvd 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5985133.3579 2097569.1313 37.7386659945279 -122.49395273452299 (37.7386659945279, -122.493952734523)
186743 186743 223811 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 80 Digby St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     49 Width 7ft   6002713.41805 2097728.02904 37.7401152293236 -122.433180638776 (37.7401152293236, -122.433180638776)
186596 186596 2255 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 700X Brotherhood Way 1 Median : Cutout 11 Tree 1 DPW 2     17     5990660.02895 2088282.4204099998 37.713488829713796 -122.474166893001 (37.7134888297138, -122.474166893001)
186593 186593 185679 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2101 Sunset Blvd 11 Sidewalk: Property side : Yard 9 Tree 1 Private 1     44 Width 0ft   5984848.3389 2100716.8784 37.747292175118496 -122.49517023896601 (37.7472921751185, -122.495170238966)
186554 186554 250195 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 201 Union St 1 Side Yard : Yard 17 Tree 1 Private 1     18 Width 0ft   6011875.28376 2119779.56963 37.8011792152183 -122.40305313080401 (37.8011792152183, -122.403053130804)
186424 186424 184800 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1301 Sunset Blvd 61 Sidewalk: Property side : Yard 9 Tree 1 Private 1     64 Width 0ft   5984686.2732 2105775.8403 37.76117319587821 -122.496103817218 (37.7611731958782, -122.496103817218)
186330 186330 186414 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1601 Sunset Blvd 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5984773.6035 2104227.8714 37.7569280195247 -122.49568759978001 (37.7569280195247, -122.49568759978)
186329 186329 223728 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 5210 Diamond Heights Blvd 9 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     39 Width 3ft   6001017.17414 2099295.49651 37.7443227561014 -122.43915786136002 (37.7443227561014, -122.43915786136)
186276 186276 186413 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1601 Sunset Blvd 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     64 Width 0ft   5984739.2681 2104238.7582 37.75695590087879 -122.495807145737 (37.7569559008788, -122.495807145737)
186272 186272 223809 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 6 Miguel St 2 Side Yard : Yard 17 Tree 1 Private 1     34     6003330.909440001 2097346.2966299998 37.7391020890899 -122.431018368229 (37.7391020890899, -122.431018368229)
186232 186232 205900 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 106 Miraloma Dr 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 3ft   5994506.11445 2097146.60332 37.7380497842769 -122.461515803309 (37.7380497842769, -122.461515803309)
186173 186173 186341 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1801 Sunset Blvd 8 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 0ft   5984771.9036 2102828.9064 37.7530867492181 -122.49559029679199 (37.7530867492181, -122.495590296792)
186166 186166 181496 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1400 Sunset Blvd 56 Sidewalk: Property side : Yard 9 Tree 1 Private 1     34 Width 0ft   5984867.2226 2105416.0239 37.7601958376586 -122.495451461713 (37.7601958376586, -122.495451461713)
185755 185755 205895 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 110 Cresta Vista Dr 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     14 Width 3ft   5995734.854669999 2096206.24435 37.7355384364582 -122.457199459482 (37.7355384364582, -122.457199459482)
185674 185674 185392 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2300 Sunset Blvd 3 unknown : Yard 19 Tree 1 Private 1     38 Width 0ft   5985108.1339 2098944.4572 37.7424407935289 -122.494141285581 (37.7424407935289, -122.494141285581)
185648 185648 185953 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2001 Sunset Blvd 12 Sidewalk: Property side : Yard 9 Tree 1 Private 1     69 Width 0ft   5984818.0255 2101428.1429 37.7492433382305 -122.49532750509199 (37.7492433382305, -122.495327505092)
185468 185468 206865 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 700 Junipero Serra Blvd 129 : 4 Tree 1 Private 1     25 Width 0ft   5991211.79314 2091726.01373 37.722976039705 -122.472510720395 (37.722976039705, -122.472510720395)
185443 185443 142131 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 2200x GEARY BLVD 14 Median : Cutout 11 Tree 1 DPW 2     20 Width 0ft   6000333.6993 2113366.7616 37.7829200486713 -122.442531241518 (37.7829200486713, -122.442531241518)
185428 185428 205905 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 125 Hamerton Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     51 Width 4ft   6001385.86644 2095459.79202 37.7338117803923 -122.437608363645 (37.7338117803923, -122.437608363645)
185332 185332 185887 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2000 Sunset Blvd 30 Sidewalk: Property side : Yard 9 Tree 1 Private 1     56 Width 0ft   5985024.6397 2101148.4339 37.748487428935 -122.494592422422 (37.748487428935, -122.494592422422)
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)
185047 185047 185699 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2101 Sunset Blvd 31 Sidewalk: Property side : Yard 9 Tree 1 Private 1     49 Width 0ft   5984860.4343 2100518.1203 37.7467471477001 -122.495113760419 (37.7467471477001, -122.495113760419)
185035 185035 183344 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1210 48th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 0ft   5981199.4113 2106812.2909 37.763814137238896 -122.50824009998999 (37.7638141372389, -122.50824009999)
185031 185031 190987 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 100 Topeka Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 5ft   6012468.98817 2095242.94143 37.7338402790006 -122.39927522817 (37.7338402790006, -122.39927522817)
184882 184882 223774 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 615 Sanchez St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     53 Width 3ft   6003694.6697 2104650.23962 37.759177615567296 -122.43028160673201 (37.7591776155673, -122.430281606732)
184868 184868 205876 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 9 Locksley Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     43 Width 3ft   5994093.62789 2104819.10263 37.7590927708292 -122.463498614174 (37.7590927708292, -122.463498614174)
184827 184827 176107 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 700x Mansell St 46 Median : Cutout 11 Tree 1 DPW 2     61 Width 0ft   6008982.60232 2089910.3513099998 37.7190031946297 -122.41095224595699 (37.7190031946297, -122.410952245957)
184682 184682 223747 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 526 Duncan St 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     31 Width 3ft   6003046.91412 2099810.87444 37.7458531522163 -122.432176253431 (37.7458531522163, -122.432176253431)
184674 184674 126416 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2836 Larkin St 12 Side Yard : Yard 17 Tree 1 Private 1     46     6006501.512069999 2121012.26216 37.804262323204895 -122.421736358356 (37.8042623232049, -122.421736358356)
184580 184580 206812 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 66x Santa Monica Way 9 Median : Yard 3 Tree 1 DPW 2     15     5993679.09704 2097560.53952 37.739138713068 -122.464405236026 (37.739138713068, -122.464405236026)
184555 184555 186200 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1701 Sunset Blvd 11 Sidewalk: Property side : Yard 9 Tree 1 Private 1     70 Width 0ft   5984778.3318 2103452.7061 37.754799907325605 -122.49561407416701 (37.7547999073256, -122.495614074167)
184501 184501 181442 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1400 Sunset Blvd 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984907.8806 2105046.76 37.7591843225176 -122.495283614644 (37.7591843225176, -122.495283614644)
184471 184471 187407 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2100 Sunset Blvd 60 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5985024.7009 2100846.8762 37.747659437344204 -122.49456998306101 (37.7476594373442, -122.494569983061)
184103 184103 223730 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 425 Burnett Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 Width 4ft   5999661.00739 2103457.53905 37.7556734530948 -122.444146194814 (37.7556734530948, -122.444146194814)
184095 184095 176151 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 10 Lake Merced Blvd 12 : 4 Tree 1 Private 1     28 Width 0ft   5987601.77319 2090779.60025 37.7201678157831 -122.484920265686 (37.7201678157831, -122.484920265686)
184027 184027 185994 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2001 Sunset Blvd 53 Sidewalk: Property side : Yard 9 Tree 1 Private 1     14 Width 0ft   5984830.686000001 2100989.8439 37.7480406303286 -122.49525140725001 (37.7480406303286, -122.49525140725)
183983 183983 186607 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1501 Sunset Blvd 78 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984762.1933 2104423.9388 37.757465697935096 -122.495741522143 (37.7574656979351, -122.495741522143)
183973 183973 176110 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 520 Carter St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     47     6005248.37143 2086351.63031 37.709021603021604 -122.423607162245 (37.7090216030216, -122.423607162245)
183931 183931 185393 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2300 Sunset Blvd 6 unknown : Yard 19 Tree 1 Private 1     30 Width 0ft   5985089.6389999995 2098965.9512 37.742498727988895 -122.49420681837499 (37.7424987279889, -122.494206818375)
183860 183860 186109 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1901 Sunset Blvd 55 Sidewalk: Property side : Yard 9 Tree 1 Private 1     57 Width 0ft   5984840.4659 2101628.7594 37.7497954900583 -122.495264699643 (37.7497954900583, -122.495264699643)
183726 183726 205911 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 198 Mangels Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     51     6000172.88009 2095259.68329 37.733193286925996 -122.441787651691 (37.733193286926, -122.441787651691)
183704 183704 186061 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1901 Sunset Blvd 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     29 Width 0ft   5984814.7269 2102156.8472 37.751243967202896 -122.495392646831 (37.7512439672029, -122.495392646831)
183650 183650 185948 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2001 Sunset Blvd 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 0ft   5984838.4114 2101503.1034 37.74945035282 -122.495262538639 (37.74945035282, -122.495262538639)
183624 183624 205888 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 300 Hazelwood Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     16 Width 3ft   5996225.80911 2095294.3314200002 37.733062728758505 -122.455436166843 (37.7330627287585, -122.455436166843)
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)
183462 183462 206813 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 198x San Anselmo Ave 5 Median : Yard 3 Tree 1 DPW 2     12     5993675.924 2096312.14772 37.7357107573442 -122.464325594759 (37.7357107573442, -122.464325594759)
183441 183441 185627 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2100 Sunset Blvd 8 Sidewalk: Property side : Yard 9 Tree 1 Private 1     87 Width 0ft   5985046.4186 2100324.9202 37.7462275593372 -122.494456414967 (37.7462275593372, -122.494456414967)
183409 183409 186360 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1801 Sunset Blvd 27 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984814.757999999 2102602.0458 37.7524663619043 -122.495425370042 (37.7524663619043, -122.495425370042)
183376 183376 176159 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 0 Serrano Dr 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2     5989661.71527 2090692.2421799998 37.720047719404 -122.477793431626 (37.720047719404, -122.477793431626)
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)
182720 182720 247577 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 300x Alemany Blvd 1 Median : Yard 3 Tree 1 DPW 2     44     6008700.9232 2095336.3735 37.7338860994661 -122.41230921050501 (37.7338860994661, -122.412309210505)
182493 182493 185683 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2101 Sunset Blvd 15 Sidewalk: Property side : Yard 9 Tree 1 Private 1     54 Width 0ft   5984892.471 2100629.5948 37.7470551018081 -122.49501120069999 (37.7470551018081, -122.4950112007)
182419 182419 187231 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2401 Sunset Blvd 14 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 0ft   5984940.0793 2098640.1078 37.7415952970055 -122.49469992638001 (37.7415952970055, -122.49469992638)
182357 182357 206895 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1 Pizarro Way 9 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   5995113.71049 2093937.45787 37.729273208687204 -122.459182739799 (37.7292732086872, -122.459182739799)
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)
182177 182177 223766 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 317 Elsie St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   6006968.556340001 2098198.91003 37.7416486273844 -122.418501452004 (37.7416486273844, -122.418501452004)
182159 182159 181511 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1400 Sunset Blvd 71 Sidewalk: Property side : Yard 9 Tree 1 Private 1     29 Width 0ft   5984874.1846 2105548.3017 37.7605594432249 -122.495437139743 (37.7605594432249, -122.495437139743)
182045 182045 205897 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 5 Sequoia Way 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   5998217.20085 2097803.5301 37.740066453703605 -122.448732094232 (37.7400664537036, -122.448732094232)
182008 182008 223760 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 5735 Diamond Heights Blvd 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 8ft   6000715.37701 2097028.89046 37.7380820132743 -122.44003891457899 (37.7380820132743, -122.440038914579)
181873 181873 250227 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 312 Filbert St 7 Side Yard : Yard 17 Tree 1 Private 1     17 Width 0ft   6011220.88869 2120048.61475 37.8018813824768 -122.40533659221902 (37.8018813824768, -122.405336592219)
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)
181646 181646 187045 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2501 Sunset Blvd 64 Sidewalk: Property side : Yard 9 Tree 1 Private 1     61 Width 0ft   5984969.2884 2097687.4331 37.7389812183872 -122.494528719258 (37.7389812183872, -122.494528719258)
181515 181515 185432 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2300 Sunset Blvd 48 unknown : Yard 19 Tree 1 Private 1     28 Width 0ft   5985081.6412 2099386.335 37.7436525202566 -122.49426545113899 (37.7436525202566, -122.494265451139)
181416 181416 176125 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 3500 Great Hwy 12 : 4 Tree 1 Private 1     2 Width 0ft   5982332.21205 2092769.0757400002 37.7253220489632 -122.50328229583499 (37.7253220489632, -122.503282295835)
181209 181209 223741 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 600 Alvarado St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     57 Width 10ft   6002372.47353 2102685.98683 37.753709268083895 -122.434713928899 (37.7537092680839, -122.434713928899)
181042 181042 186841 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 1200x Sunset Blvd 1 Median : Cutout 11 Tree 1 DPW 2     32 Width 0ft   5984746.1314 2106971.8455 37.764460596444295 -122.495985031222 (37.7644605964443, -122.495985031222)
180949 180949 205903 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 110 Kensington Way 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 3ft   5994961.52752 2098342.73028 37.7413602552605 -122.460027852509 (37.7413602552605, -122.460027852509)
180925 180925 186084 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1901 Sunset Blvd 30 Sidewalk: Property side : Yard 9 Tree 1 Private 1     16 Width 0ft   5984861.6365 2101880.8765 37.7504889739788 -122.49521008166 (37.7504889739788, -122.49521008166)
180895 180895 176096 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 184 Mount Vernon Ave 5 Side Yard : Yard 17 Tree 1 Private 1     15     5998966.43073 2089373.6298 37.7169627336137 -122.445535550248 (37.7169627336137, -122.445535550248)
180857 180857 205886 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 15 Mesa Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     24 Width 3ft   5993719.33373 2100700.69366 37.7477631044975 -122.46449405846501 (37.7477631044975, -122.464494058465)
180824 180824 223748 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 460 Beacon St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     31     6002280.901380001 2098490.25327 37.742183574702395 -122.43473059513799 (37.7421835747024, -122.434730595138)
180772 180772 186089 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1901 Sunset Blvd 35 Sidewalk: Property side : Yard 9 Tree 1 Private 1     72 Width 0ft   5984838.8917 2101823.6441 37.750330497842995 -122.49528451351001 (37.750330497843, -122.49528451351)
180749 180749 206822 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 335x Pacheco St 11 Median : Yard 3 Tree 1 DPW 2     5 Width 8ft   5994175.83574 2101201.51334 37.7491645333344 -122.462951839858 (37.7491645333344, -122.462951839858)
180706 180706 184052 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1600 Sunset Blvd 53 Sidewalk: Property side : Yard 9 Tree 1 Private 1     25 Width 0ft   5984937.3498 2103855.5949 37.7559154391845 -122.49509386136101 (37.7559154391845, -122.495093861361)
180433 180433 126428 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1701 North Point St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 3ft   6002587.87385 2120898.67704 37.803728977572604 -122.43527166598 (37.8037289775726, -122.43527166598)
180242 180242 217767 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 470 West Portal Ave 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     20     5991530.54586 2096117.5642099997 37.7350525849042 -122.471728751803 (37.7350525849042, -122.471728751803)
180182 180182 186931 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2800 Sunset Blvd 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     28 Width 0ft   5985210.3719 2095929.9944 37.7341698678439 -122.49356571698799 (37.7341698678439, -122.493565716988)
180144 180144 176124 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 3500 Great Hwy 11 : 4 Tree 1 Private 1     4 Width 0ft   5982349.65867 2092765.21103 37.7253124630738 -122.50322169953002 (37.7253124630738, -122.50322169953)
180115 180115 187140 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2301 Sunset Blvd 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984921.9385 2099490.838 37.7439301101756 -122.494825359501 (37.7439301101756, -122.494825359501)
180025 180025 250698 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 877 El Camino Del Mar 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 4ft   5985618.29441 2114950.69693 37.78641929175679 -122.49355644897601 (37.7864192917568, -122.493556448976)
179874 179874 186060 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1901 Sunset Blvd 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     90 Width 0ft   5984837.0831 2102159.5408 37.7512526720721 -122.49531553640101 (37.7512526720721, -122.495315536401)
179841 179841 249924 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 358 Greenwich St 8 Back Yard : Yard 13 Tree 1 Private 1     12 Width 0ft   6011171.36702 2120411.09017 37.802873882370896 -122.405533505089 (37.8028738823709, -122.405533505089)
179607 179607 185430 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2300 Sunset Blvd 46 unknown : Yard 19 Tree 1 Private 1     3 Width 0ft   5985106.6343 2099374.8382 37.7436224157034 -122.49417818512899 (37.7436224157034, -122.494178185129)
179538 179538 176165 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 654 Peru Ave 3 Side Yard : Yard 17 Tree 1 Private 1     27     6005141.81262 2092533.90812 37.7259907884276 -122.42441488026199 (37.7259907884276, -122.424414880262)
179404 179404 223742 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 921 Alvarado St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     42 Width 8ft   6000348.4325 2102535.54442 37.753181072867 -122.441702702621 (37.753181072867, -122.441702702621)
179269 179269 206894 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 380 Santa Clara Ave 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 3ft   5993143.80759 2095435.7511200001 37.7332737043188 -122.46610164609699 (37.7332737043188, -122.466101646097)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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");
Powered by Datasette · Query took 1010.833ms · Data source: data.sfgov.org