Street_Tree_List

Data source: data.sfgov.org

884 rows where qSpecies = 100

View and edit SQL

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

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
608 233928 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 8 Octavia St Frontage East 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     29 Width 8ft   6005775.18179 2109348.30824 37.77219502161479 -122.423420179704 (37.7721950216148, -122.423420179704)
724 25734 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 500X The Embarcadero 4 Median : Cutout 11 Tree 1 Port 9   08/15/1996 12:00:00 AM 16 10   6013899.49111 2118360.1858599996 37.7973947538281 -122.395948920127 (37.7973947538281, -122.395948920127)
1312 25735 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 500X The Embarcadero 5 Median : Cutout 11 Tree 1 Port 9   08/15/1996 12:00:00 AM 16 10   6013816.07307 2118422.78251 37.7975619881486 -122.396241959692 (37.7975619881486, -122.396241959692)
1379 25668 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 450X The Embarcadero 1 Median : Cutout 11 Tree 1 Port 9   12/18/2000 12:00:00 AM 36 15   6014174.0749699995 2117868.41683 37.796059744425996 -122.394964320767 (37.796059744426, -122.394964320767)
2027 25628 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 650 The Embarcadero 1 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   12/18/2000 12:00:00 AM 12 4X4   6014034.02503 2117986.25531 37.796375512586 -122.39545718430401 (37.796375512586, -122.395457184304)
3463 25005 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 400X Dolores St 11 Median : Cutout 11 Tree 1 DPW 2     60 20   6004909.6221900005 2105744.1135299997 37.7622498768445 -122.426157591005 (37.7622498768445, -122.426157591005)
4067 25799 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 1300X The Embarcadero 1 Median : Cutout 11 Tree 1 Port 9   08/30/1996 12:00:00 AM 36 10   6012220.09673 2120843.1378 37.8041187644177 -122.401934728525 (37.8041187644177, -122.401934728525)
5331 25671 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 450X The Embarcadero 4 Median : Cutout 11 Tree 1 Port 9   12/18/2000 12:00:00 AM 36 15   6014100.8579 2117974.29057 37.7963463772386 -122.395225088169 (37.7963463772386, -122.395225088169)
5467 27939 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 500X The Embarcadero 8 Median : Cutout 11 Tree 1 Port 9     36 4X4   6013788.66429 2118525.16075 37.7978415693921 -122.396343981507 (37.7978415693921, -122.396343981507)
5785 25798 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 1100X The Embarcadero 1 Median : Cutout 11 Tree 1 Port 9   08/30/1996 12:00:00 AM 36 10   6012871.9305 2119823.23547 37.801354716114 -122.39960734420201 (37.801354716114, -122.399607344202)
5927 25672 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 450X The Embarcadero 5 Median : Cutout 11 Tree 1 Port 9   12/18/2000 12:00:00 AM 36 15   6014076.201780001 2118013.23421 37.796451936061295 -122.39531313361799 (37.7964519360613, -122.395313133618)
6093 26031 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 450X The Embarcadero 3 Median : Cutout 11 Tree 1 Port 9   12/01/2000 12:00:00 AM 36 10   6014122.12078 2117941.0950599997 37.7962564126589 -122.39514918719999 (37.7962564126589, -122.3951491872)
6610 25631 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 650 The Embarcadero 4 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   12/18/2000 12:00:00 AM 12 4X4   6014105.621619999 2117876.68788 37.7960786481665 -122.395201764263 (37.7960786481665, -122.395201764263)
6748 26030 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 450X The Embarcadero 2 Median : Cutout 11 Tree 1 Port 9   12/01/2000 12:00:00 AM 36 10   6014150.34723 2117905.1373099997 37.796159250800294 -122.395048997307 (37.7961592508003, -122.395048997307)
7009 27938 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 500X The Embarcadero 7 Median : Cutout 11 Tree 1 Port 9     36 4X4   6013758.52527 2118508.2804400004 37.7977935429048 -122.396447087875 (37.7977935429048, -122.396447087875)
7108 25783 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 500X The Embarcadero 2 Median : Cutout 11 Tree 1 Port 9   08/30/1996 12:00:00 AM 36 10   6013938.98446 2118296.9177 37.7972232315271 -122.39580782638599 (37.7972232315271, -122.395807826386)
7340 25782 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 500X The Embarcadero 1 Median : Cutout 11 Tree 1 Port 9   08/15/1996 12:00:00 AM 36 10   6013997.3565 2118221.08563 37.7970182616509 -122.395600527244 (37.7970182616509, -122.395600527244)
8064 25629 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 650 The Embarcadero 2 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   12/18/2000 12:00:00 AM 12 4X4   6014059.75449 2117949.14567 37.79627504929729 -122.39536555327801 (37.7962750492973, -122.395365553278)
8404 25630 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 650 The Embarcadero 3 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   12/18/2000 12:00:00 AM 12 4X4   6014084.49775 2117912.38554 37.7961754907607 -122.395277359473 (37.7961754907607, -122.395277359473)
8788 27937 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 500X The Embarcadero 6 Median : Cutout 11 Tree 1 Port 9     36 4X4   6013847.17816 2118440.8928400003 37.797613445554205 -122.396135596873 (37.7976134455542, -122.396135596873)
8987 25784 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 500X The Embarcadero 3 Median : Cutout 11 Tree 1 Port 9   08/30/1996 12:00:00 AM 36 10   6013869.26975 2118339.24702 37.797335579338004 -122.396052026484 (37.797335579338, -122.396052026484)
9337 113319 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 100 VALENCIA ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3x3   6005986.0 2109035.0 37.7713466487942 -122.42266867187 (37.7713466487942, -122.42266867187)
9471 18535 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 270 PROSPECT AVE 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     45 3X3   6006489.0 2098160.0 37.74151478014 -122.420156839009 (37.74151478014, -122.420156839009)
9735 173670 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 251x Lathrop Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6012236.0 2086860.0 37.7108094381203 -122.399492405366 (37.7108094381203, -122.399492405366)
11148 20065 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 100 STAIRWAY54 12 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 15ST            
13621 18556 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1700X Quesada Ave 11 Median : Cutout 11 Tree 1 DPW 2     30 19   6014603.96741 2095108.67042 37.7335903547148 -122.391884517749 (37.7335903547148, -122.391884517749)
13733 29537 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 2600X Ingalls St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     35 3X3   6015071.7012 2091079.6967 37.7225535544976 -122.38998606447299 (37.7225535544976, -122.389986064473)
14049 18560 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1700X Quesada Ave 15 Median : Cutout 11 Tree 1 DPW 2     12 19   6014546.06488 2095149.2171099999 37.7336984729967 -122.392087539714 (37.7336984729967, -122.392087539714)
14133 29536 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 2600X Ingalls St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     35 3X3   6015127.6919 2091149.846 37.7227492757118 -122.38979741293699 (37.7227492757118, -122.389797412937)
14829 95065 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 4801 03rd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 3x3   6014916.5089 2095299.5463 37.7341318071091 -122.390817297505 (37.7341318071091, -122.390817297505)
15304 19794 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 100 STAIRWAY19 16 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 50ST            
16559 18559 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1700X Quesada Ave 14 Median : Cutout 11 Tree 1 DPW 2     30 19   6014565.4208 2095135.4289 37.733661688034104 -122.392019656183 (37.7336616880341, -122.392019656183)
16768 18555 Landmark tree 9 Phoenix canariensis :: Canary Island Date Palm 100 1700X Quesada Ave 10 Median : Cutout 11 Tree 1 DPW 2     12 19   6014626.04256 2095092.9200799998 37.733548332979105 -122.39180709603201 (37.7335483329791, -122.391807096032)
16811 18551 Landmark tree 9 Phoenix canariensis :: Canary Island Date Palm 100 1700X Quesada Ave 6 Median : Cutout 11 Tree 1 DPW 2     30 19   6014649.71614 2095074.3239900002 37.733498586072294 -122.391723949223 (37.7334985860723, -122.391723949223)
16918 25119 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1500X Dolores St 6 Median : Cutout 11 Tree 1 DPW 2     30 20   6005258.69008 2099408.1764 37.7448725899054 -122.42449959638999 (37.7448725899054, -122.42449959639)
16926 24992 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 340 Dolores St 3 Median : Cutout 11 Tree 1 DPW 2     90 20   6004882.50848 2106257.6214799997 37.763658315014204 -122.426287928865 (37.7636583150142, -122.426287928865)
16962 25071 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1100X Dolores St 2 Median : Cutout 11 Tree 1 DPW 2     80 20   6005127.376540001 2101840.69033 37.751544296835206 -122.42512670443001 (37.7515442968352, -122.42512670443)
17004 25108 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1400 Dolores St 1 Median : Cutout 11 Tree 1 DPW 2     30 20   6005223.671490001 2100130.84124 37.7468548845426 -122.424672082757 (37.7468548845426, -122.424672082757)
17005 25139 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1700X Dolores St 5 Median : Cutout 11 Tree 1 DPW 2     90 20   6005326.84877 2098252.91312 37.741704348480795 -122.42418177058599 (37.7417043484808, -122.424181770586)
17024 25136 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1700X Dolores St 2 Median : Cutout 11 Tree 1 DPW 2     90 20   6005320.97591 2098341.7574 37.741947963130706 -122.424208394127 (37.7419479631307, -122.424208394127)
17056 25058 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1000X Dolores St 1 Median : Cutout 11 Tree 1 DPW 2     90 20   6005092.48697 2102458.1018 37.753237594341996 -122.425291287561 (37.753237594342, -122.425291287561)
17078 25113 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1400 Dolores St 6 Median : Cutout 11 Tree 1 DPW 2     30 20   6005228.94357 2100007.06865 37.7465153311328 -122.424645049125 (37.7465153311328, -122.424645049125)
17125 25503 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1900X Market St 3 Median : Cutout 11 Tree 1 DPW 2   04/01/1993 12:00:00 AM 36 8   6005164.8443 2108651.7776 37.7702480498919 -122.42548181214701 (37.7702480498919, -122.425481812147)
17149 25538 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 2200X Market St 4 Median : Cutout 11 Tree 1 DPW 2   04/01/1993 12:00:00 AM 36 20   6003277.964 2106841.2745 37.7651700578839 -122.431879221699 (37.7651700578839, -122.431879221699)
17224 25054 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 900X Dolores St 9 Median : Cutout 11 Tree 1 DPW 2     35 20   6005073.8483 2102816.15893 37.7542196827988 -122.42538122246201 (37.7542196827988, -122.425381222462)
17235 708 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1504X Dolores St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/06/2015 02:27:00 PM 3 6x6   6005213.6425 2099570.03766 37.745314479891896 -122.42466687479799 (37.7453144798919, -122.424666874798)
17252 24963 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 100 Dolores St 4 Median : Cutout 11 Tree 1 DPW 2     90 20   6004800.736959999 2107633.50365 37.7674315357679 -122.42666873508999 (37.7674315357679, -122.42666873509)
17260 24994 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 300 Dolores St 5 Median : Cutout 11 Tree 1 DPW 2     90 20   6004873.5625 2106448.79257 37.7641827195917 -122.42633248217399 (37.7641827195917, -122.426332482174)
17276 25090 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1250X Dolores St 5 Median : Cutout 11 Tree 1 DPW 2     90 20   6005182.99372 2100845.43458 37.7488146961375 -122.424863573617 (37.7488146961375, -122.424863573617)
17311 25026 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 750X Dolores St 1 Median : Cutout 11 Tree 1 DPW 2     70 20   6005011.77925 2103932.39938 37.7572811108424 -122.42567531518499 (37.7572811108424, -122.425675315185)
17316 25084 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1200X Dolores St 4 Median : Cutout 11 Tree 1 DPW 2     90 20   6005164.22411 2101175.53736 37.7497200220711 -122.42495196167499 (37.7497200220711, -122.424951961675)
17339 25501 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1900X Market St 1 Median : Cutout 11 Tree 1 DPW 2   04/01/1993 12:00:00 AM 36 8   6005202.0445 2108688.1512 37.770350024818704 -122.425355725564 (37.7703500248187, -122.425355725564)
17397 25527 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 2300X Market St 2 Median : Cutout 11 Tree 1 DPW 2   04/01/1993 12:00:00 AM 36 10   6002730.2479 2106324.2376 37.7637193356407 -122.433736680672 (37.7637193356407, -122.433736680672)
17398 5707 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1600 Dolores St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     100 3X3   6005241.864159999 2098983.9941 37.74370693182271 -122.424527610259 (37.7437069318227, -122.424527610259)
17405 24337 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 2020X Market St 2 Median : Cutout 11 Tree 1 DPW 2   05/07/1993 12:00:00 AM 36 8   6004420.4688 2107930.9893 37.7682268534635 -122.428005232451 (37.7682268534635, -122.428005232451)
17411 25526 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 2300X Market St 1 Median : Cutout 11 Tree 1 DPW 2   04/01/1993 12:00:00 AM 36 10   6002746.7355 2106338.4868 37.7637593960329 -122.43368067367201 (37.7637593960329, -122.433680673672)
17425 25099 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1300X Dolores St 4 Median : Cutout 11 Tree 1 DPW 2     70 20   6005195.84744 2100584.78774 37.7480997459068 -122.42480058509899 (37.7480997459068, -122.424800585099)
17442 25157 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 2X Dolores St 5 Median : Cutout 11 Tree 1 DPW 2     90 20   6004782.44605 2108032.94108 37.7685272607631 -122.42676044975201 (37.7685272607631, -122.426760449752)
17487 25100 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1350X Dolores St 5 Median : Cutout 11 Tree 1 DPW 2     60 20   6005208.528519999 2100314.21379 37.7473575282405 -122.424737488671 (37.7473575282405, -122.424737488671)
17518 25033 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 700X Dolores St 1 Median : Cutout 11 Tree 1 DPW 2     70 20   6004995.411590001 2104224.22732 37.7580814768833 -122.425752691957 (37.7580814768833, -122.425752691957)
17523 5503 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 773 Dolores St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 5x5   6005056.9343 2103834.44184 37.757014693887704 -122.42551217994301 (37.7570146938877, -122.425512179943)
17575 24996 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 400X Dolores St 1 Median : Cutout 11 Tree 1 DPW 2     90 20   6004898.747380001 2105973.30508 37.7628785677218 -122.42621152066002 (37.7628785677218, -122.42621152066)
17579 27481 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 850X Dolores St 6 Median : Cutout 11 Tree 1 DPW 2   10/04/1999 12:00:00 AM 90 20   6005053.38343 2103172.36846 37.755196594762 -122.425477343801 (37.755196594762, -122.425477343801)
17598 9369 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 276 Gold Mine Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 2x2   6001136.50681 2098095.27018 37.7410340073111 -122.438659251142 (37.7410340073111, -122.438659251142)
17620 25096 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1300X Dolores St 1 Median : Cutout 11 Tree 1 DPW 2     90 20   6005188.030230001 2100718.94336 37.748467664846295 -122.42483715961001 (37.7484676648463, -122.42483715961)
17621 25516 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 2190X Market St 3 Median : Cutout 11 Tree 1 DPW 2   04/01/1993 12:00:00 AM 36 10   6003679.0354 2107225.3342 37.7662473210814 -122.430519419203 (37.7662473210814, -122.430519419203)
17629 25102 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1400X Dolores St 2 Median : Cutout 11 Tree 1 DPW 2     90 20   6005226.05485 2100086.94121 37.7467344797311 -122.424660718923 (37.7467344797311, -122.424660718923)
17694 25052 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 900X Dolores St 7 Median : Cutout 11 Tree 1 DPW 2     80 20   6005070.62845 2102872.02457 37.7543728949014 -122.42539633287 (37.7543728949014, -122.42539633287)
17722 25061 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1000X Dolores St 4 Median : Cutout 11 Tree 1 DPW 2     90 20   6005097.79962 2102345.06954 37.7529275341834 -122.425264872687 (37.7529275341834, -122.425264872687)
17756 25098 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1350X Dolores St 3 Median : Cutout 11 Tree 1 DPW 2     90 20   6005207.855169999 2100363.5353099997 37.7474929157794 -122.424743325238 (37.7474929157794, -122.424743325238)
17774 25504 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1950X Market St 4 Median : Cutout 11 Tree 1 DPW 2   04/01/1993 12:00:00 AM 36 8   6005007.7768 2108494.7101 37.769807904671005 -122.42601392538499 (37.769807904671, -122.426013925385)
17792 25085 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1200X Dolores St 5 Median : Cutout 11 Tree 1 DPW 2     70 20   6005165.443630001 2101134.8464599997 37.7496083631354 -122.424944849843 (37.7496083631354, -122.424944849843)
17821 25151 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 2X Dolores St 4 Median : Cutout 11 Tree 1 DPW 2     90 20   6004775.21348 2108066.2440299997 37.768618293721104 -122.42678783858999 (37.7686182937211, -122.42678783859)
17847 24989 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 370X Dolores St 3 Median : Cutout 11 Tree 1 DPW 2     60 20   6004890.15326 2106095.93205 37.7632147864474 -122.426249975677 (37.7632147864474, -122.426249975677)
17932 24987 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 340X Dolores St 1 Median : Cutout 11 Tree 1 DPW 2     40 20   6004879.52665 2106321.34538 37.7638331171148 -122.42630277934799 (37.7638331171148, -122.426302779348)
18053 24998 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 450X Dolores St 3 Median : Cutout 11 Tree 1 DPW 2     90 20   6004918.80727 2105618.72906 37.7619061199926 -122.426116896691 (37.7619061199926, -122.426116896691)
18060 25021 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 750X Dolores St 6 Median : Cutout 11 Tree 1 DPW 2     70 20   6005015.543430001 2103801.2681 37.7569212678239 -122.425652964336 (37.7569212678239, -122.425652964336)
18061 25129 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1650X Dolores St 4 Median : Cutout 11 Tree 1 DPW 2     40 20   6005306.59795 2098578.64869 37.7425976010056 -122.424274952941 (37.7425976010056, -122.424274952941)
18120 25009 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 550X Dolores St 3 Median : Cutout 11 Tree 1 DPW 2     50 20   6004942.008669999 2105066.11314 37.7603900788595 -122.425997312043 (37.7603900788595, -122.425997312043)
18142 13388 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 218 Marietta Dr 1 Median : Cutout 11 Tree 1 DPW 2     6 5   5997667.5215300005 2098758.8322 37.7426580336411 -122.45070150968999 (37.7426580336411, -122.45070150969)
18179 25015 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 550X Dolores St 9 Median : Cutout 11 Tree 1 DPW 2     90 20   6004955.918219999 2104917.6837 37.7599833128008 -122.42593863935 (37.7599833128008, -122.42593863935)
18199 25532 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 2300X Market St 7 Median : Cutout 11 Tree 1 DPW 2   04/01/1993 12:00:00 AM 36 10   6002592.5231 2106186.5128 37.7633333608706 -122.43420318116999 (37.7633333608706, -122.43420318117)
18227 25534 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 2300X Market St 9 Median : Cutout 11 Tree 1 DPW 2   04/01/1993 12:00:00 AM 36 10   6002560.5766 2106158.8258 37.763255525853296 -122.43431169398701 (37.7632555258533, -122.434311693987)
18230 25073 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1100X Dolores St 4 Median : Cutout 11 Tree 1 DPW 2     90 20   6005132.2187 2101761.89405 37.7513282140435 -122.42510435359199 (37.7513282140435, -122.425104353592)
18233 25024 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 700X Dolores St 9 Median : Cutout 11 Tree 1 DPW 2     70 20   6005003.848780001 2104046.64903 37.757594365417496 -122.42571087345699 (37.7575943654175, -122.425710873457)
18236 25007 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 500X Dolores St 1 Median : Cutout 11 Tree 1 DPW 2     90 20   6004931.59557 2105384.6255099997 37.7612640499245 -122.426056000898 (37.7612640499245, -122.426056000898)
18284 25123 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1550 Dolores St 4 Median : Cutout 11 Tree 1 DPW 2     90 20   6005274.82817 2099143.28527 37.744146170621704 -122.424424956245 (37.7441461706217, -122.424424956245)
18337 25498 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1745X Market St 3 Median : Cutout 11 Tree 1 DPW 2   04/01/1993 12:00:00 AM 24 20   6005901.64349 2109360.28288 37.7722350378549 -122.422983588528 (37.7722350378549, -122.422983588528)
18340 25152 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 50X Dolores St 5 Median : Cutout 11 Tree 1 DPW 2     90 20   6004796.34623 2107853.39536 37.768035057311 -122.42669958273999 (37.768035057311, -122.42669958274)
18432 25070 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1100X Dolores St 1 Median : Cutout 11 Tree 1 DPW 2     80 20   6005125.726319999 2101888.99536 37.751676838028395 -122.425135847862 (37.7516768380284, -122.425135847862)
18461 24339 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 2020X Market St 3 Median : Cutout 11 Tree 1 DPW 2   05/07/1993 12:00:00 AM 36 8   6004378.3201 2107887.5635 37.7681052320451 -122.42814792550399 (37.7681052320451, -122.428147925504)
18527 25047 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 900X Dolores St 1 Median : Cutout 11 Tree 1 DPW 2     90 20   6005062.19129 2103039.48532 37.754832226347396 -122.425437427413 (37.7548322263474, -122.425437427413)
18585 25121 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1500 Dolores St 2 Median : Cutout 11 Tree 1 DPW 2     24 20   6005252.19486 2099522.95164 37.745187369700105 -122.424530218294 (37.7451873697001, -122.424530218294)
18700 25031 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 700X Dolores St 6 Median : Cutout 11 Tree 1 DPW 2     25 20   6005006.55303 2104135.2293700003 37.7578377390251 -122.425707825673 (37.7578377390251, -122.425707825673)
18703 24975 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 200 Dolores St 2 Median : Cutout 11 Tree 1 DPW 2     90 20   6004832.79825 2107115.15692 37.76601009251021 -122.426520926121 (37.7660100925102, -122.426520926121)
18754 25528 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 2300X Market St 3 Median : Cutout 11 Tree 1 DPW 2   04/01/1993 12:00:00 AM 36 10   6002714.6296 2106302.2301 37.7636580221412 -122.433789126424 (37.7636580221412, -122.433789126424)
18853 24967 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 150 Dolores St 8 Median : Cutout 11 Tree 1 DPW 2     90 20   6004824.658890001 2107297.38564 37.7665099887808 -122.42656205570499 (37.7665099887808, -122.426562055705)
18866 25038 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 800X Dolores St 2 Median : Cutout 11 Tree 1 DPW 2     90 20   6005033.4036 2103578.1948599997 37.756309770193 -122.425575321353 (37.756309770193, -122.425575321353)
18925 25041 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 800X Dolores St 5 Median : Cutout 11 Tree 1 DPW 2     90 20   6005036.0793699995 2103453.27666 37.7559669252599 -122.42555717752899 (37.7559669252599, -122.425557177529)
18928 25116 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1500X Dolores St 3 Median : Cutout 11 Tree 1 DPW 2     90 20   6005256.05434 2099495.31423 37.7451117016422 -122.42451490734301 (37.7451117016422, -122.424514907343)

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 265.1ms · Data source: data.sfgov.org