8,758 rows where qSpecies_id = 16 sorted by qCareAssistant

View and edit SQL

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)
24 264941 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 100X Portola Dr 12 Median : Cutout Tree Private 2       3x3   5999749 2101261 37.7496473113918 -122.443684097942 (37.7496473113918, -122.443684097942) 2 5 5 28862 38
173 27068 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 801 Silver Ave 10 Sidewalk: Curb side : Cutout Tree DPW 1     3 4   6006971.0744 2093616.11167 37.7290654140285 -122.418167915919 (37.7290654140285, -122.418167915919) 9 3 7 309 28
181 14420 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 2X Masonic Ave 8 Median : Cutout Tree DPW 1     35     5998841.5976 2113071.3194 37.7820236767836 -122.447671998063 (37.7820236767836, -122.447671998063) 15 5 2 54 16
408 109629 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 200X GELLERT DR 30 Median : Cutout Tree DPW 1       30x200   5985380 2094516.3 37.730298158605 -122.492875173009 (37.730298158605, -122.492875173009) 1 8 4 64 35
487 5304 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1635 Divisadero St 6 Sidewalk: Curb side : Cutout Tree Private 2     8 3X3   6001115.9968 2113959.0141 37.7845907831124 -122.439867300639 (37.7845907831124, -122.439867300639) 15 6 11 29490 13
529 131532 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 899 Powell St 7 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6009999.72804 2116574.87915 37.7922750033291 -122.409317116588 (37.7922750033291, -122.409317116588) 5 1 10 28857 21
545 90279 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 4338 Balboa St 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/24/2008 12:00:00 AM 3 3x3   5982078.08793 2111023.84587 37.7754295872152 -122.505513277346 (37.7754295872152, -122.505513277346) 11 6 2 55 26
556 116312 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1515 Scott St 2 Sidewalk: Curb side : Cutout Tree Private 2     12     6001647.9793 2113762.7776 37.784082235457 -122.438012762917 (37.784082235457, -122.438012762917) 15 6 11 29490 13
624 20956 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 2000X Sunset Blvd 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 10   5984893.4728491 2101578.9445242 37.749661815397 -122.495077729215 (37.749661815397, -122.495077729215) 1 8 3 29491 35
682 16784 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1961 O'Farrell St 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 4X4   5999039.4234543 2112720.6314145 37.781072082708 -122.446962370058 (37.781072082708, -122.446962370058) 15 5 1 54 16
829 262514 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 2230 Jerrold Ave 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6012281 2099339 37.74507671213 -122.400212745638 (37.74507671213, -122.400212745638) 10 3 8 58 1
836 115913 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 701X 28th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   5987215.25385 2111126.11495 37.776011367597 -122.487750355607 (37.776011367597, -122.487750355607) 11 6 2 55 26
850 181731 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 2755 Lincoln Way 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5987133.0103 2107077.382 37.7648898800849 -122.487737334915 (37.7648898800849, -122.487737334915) 1 8 3 56 35
854 121835 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 450 19th Ave 7 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 5ft   5990009.97122 2112348.02461 37.7795290070423 -122.47817215782 (37.7795290070423, -122.47817215782) 11 6 2 55 26
1060 9003 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 5211 Geary Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   5990830.5755 2112639.2637 37.7803762685111 -122.475354635721 (37.7803762685111, -122.475354635721) 11 6 2 54 26
1093 262511 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 2230 Jerrold Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6012281 2099339 37.74507671213 -122.400212745638 (37.74507671213, -122.400212745638) 10 3 8 58 1
1109 102184 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1840X Webster St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/19/2015 12:00:00 AM 12 3x3   6003534.8 2115143.2 37.7879796472282 -122.431583632877 (37.7879796472282, -122.431583632877) 13 9 11 29490 27
1147 131409 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 2817 Buchanan St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 4ft   6003467.33625 2118170.97636 37.796289323341 -122.432033340382 (37.796289323341, -122.432033340382) 13 9 1 57 17
1182 922 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1253 Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     20 3X3   6002943.78693 2094101.1406 37.7301696879821 -122.432125178253 (37.7301696879821, -122.432125178253) 9 7 6 28861 25
1188 186259 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1800 Sunset Blvd 3 Sidewalk: Curb side : Yard Tree Private 2     14 Width 0ft   5984936.3948 2102583.754 37.7524232591449 -122.495003387226 (37.7524232591449, -122.495003387226) 1 8 3 56 35
1201 2190 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1055 Broderick St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6000864.0909 2112351.4116 37.7801623757286 -122.440623460362 (37.7801623757286, -122.440623460362) 15 5 1 29490 41
1217 8697 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 3015 Geary Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3X3   5997765.247 2113011.588 37.7817980956526 -122.451391351666 (37.7817980956526, -122.451391351666) 15 6 2 54 16
1237 35474 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 455 Golden Gate Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/17/1998 12:00:00 AM     Permit Number 38887 6007396.82109854 2112616.81920427 37.7812609627381 -122.418042529741 (37.7812609627381, -122.418042529741) 7 9 9 28852 36
1299 117654 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 5001 Anza St 4 Sidewalk: Curb side : Cutout Tree Private 2   01/30/2020 12:00:00 AM 3 Width 3ft   5983150.11815 2111683.94621 37.7773050604289 -122.501853783426 (37.7773050604289, -122.501853783426) 11 6 2 55 26
1303 35175 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16   7 Sidewalk: Curb side : Cutout Tree Private 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
1307 184338 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1300 Sunset Blvd 1 Sidewalk: Curb side : Yard Tree Private 2     16 Width 0ft   5984829.2872 2105764.6569 37.7611508651334 -122.495608375429 (37.7611508651334, -122.495608375429) 1 8 3 56 35
1340 87020 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 10 Osceola Dr 2 Sidewalk: Property side : Cutout Tree Private 2   12/05/2007 12:00:00 AM     Permit Number 49949                    
1368 184450 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 2127 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   5982917.6673 2100633.8105 37.7469508716588 -122.501840104956 (37.7469508716588, -122.501840104956) 1 8 3 29491 35
1396 90269 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 4010 Balboa St 4 Sidewalk: Curb side : Cutout Tree DPW 1   04/22/2008 12:00:00 AM 3 3x3   5983101.97325 2111055.77054 37.7755774445967 -122.501973836946 (37.7755774445967, -122.501973836946) 11 6 2 55 26
1457 209974 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 634 Miramar Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5995417.8126 2093581.25052 37.7283126275124 -122.458105669454 (37.7283126275124, -122.458105669454) 9 7 4 28861 40
1458 97747 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 2685 30th Ave 5 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 18001 5986960.2 2097027.9 37.7372866359421 -122.487596715706 (37.7372866359421, -122.487596715706) 1 8 3 29491 35
1484 118198 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 830 35th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   5985123.98161 2110205.8621 37.7733624146684 -122.49491664155 (37.7733624146684, -122.49491664155) 11 6 2 55 26
1492 20444 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 495X Sunset Blvd 9 Sidewalk: Curb side : Cutout Tree DPW 1     12 15                      
1574 122761 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 86X Park Hill Ave 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001171 2107689 37.7673780360046 -122.439227450619 (37.7673780360046, -122.439227450619) 15 5 5 29492 3
1667 101664 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 2X Daniel Burnham Ct 4 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6006348.55699 2114768.54675 37.7871100236423 -122.421821900065 (37.7871100236423, -122.421821900065) 13 9 1 28858 41
1677 259282 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 3891 Sacramento St 5 Sidewalk: Property side : Yard Tree Private 2       Width 7ft   5996301.11796 2114890.85877 37.7868741256738 -122.456592467462 (37.7868741256738, -122.456592467462) 11 6 1 54 31
1740 5129 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 2775 Diamond St 1 Sidewalk: Curb side : Cutout Tree DPW 1   07/18/1983 12:00:00 AM 10 3X3   6002512.34992 2095942.64763 37.7352015755927 -122.433748276472 (37.7352015755927, -122.433748276472) 2 7 5 63 7
1767 143451 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 501 KEARNY ST 12 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   6011460.6008 2116606.6227 37.7924439028882 -122.404264674229 (37.7924439028882, -122.404264674229) 4 1 10 28854 6
1894 185385 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 2300 Sunset Blvd 2 Sidewalk: Curb side : Yard Tree Private 2     13 Width 0ft   5985055.3332 2099090.1134 37.7428376362899 -122.494334586063 (37.7428376362899, -122.494334586063) 1 8 3 29491 35
1919 98261 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 676 47th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/16/2020 12:00:00 AM 3   Permit Number 776653 5981365.73942 2111125.46261 37.775666650072 -122.507984958591 (37.775666650072, -122.507984958591) 11 6 2 55 26
1974 114892 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 2226 45TH AVE 1 Sidewalk: Curb side : Cutout Tree Private 2   07/12/2016 12:00:00 AM 3 3x3 Permit Number 777232 5982390 2099932 37.7449928846436 -122.503612737002 (37.7449928846436, -122.503612737002) 1 8 3 29491 35
1994 10838 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1139X Hudson Ave 45 Sidewalk: Curb side : Cutout Tree DPW 1     0 3X4   6017982.97201 2094620.05501 37.7324357213845 -122.380168255061 (37.7324357213845, -122.380168255061) 10 3 8 58 1
2051 250522 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 95 26th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     14 Width 6ft   5987685.78964 2115424.25577 37.7878402763649 -122.486438309599 (37.7878402763649, -122.486438309599) 11 6 1 55 33
2095 210451 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 755 Ocean Ave 3 Sidewalk: Property side : Yard Tree Private 2     19 Width 4ft Permit Number 779678 5998008.54618 2091535.2933 37.722843428355 -122.449002108475 (37.722843428355, -122.449002108475) 9 7 4 28861 24
2124 209922 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 870 Taraval St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5990546.69569 2099087.99208 37.7431516445476 -122.475347038257 (37.7431516445476, -122.475347038257) 1 8 4 29491 40
2147 1184 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 3014 Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     20 3x3   5996622.2967 2087313.8651 37.7111729927061 -122.453489407116 (37.7111729927061, -122.453489407116) 9 7 6 28861 25
2162 250415 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 50 Seacliff Ave 1 Sidewalk: Curb side : Yard Tree Private 2   01/14/2020 12:00:00 AM 3 Width 4ft   5987895.18737 2115830.32518 37.7889674299609 -122.485743656163 (37.7889674299609, -122.485743656163) 11 6 1 55 33
2190 117790 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 3915 Balboa St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5983427.0312 2111011.12513 37.775473951484 -122.500846098251 (37.775473951484, -122.500846098251) 11 6 2 55 26
2198 232238 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1742 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 4ft   6003957.58921 2098088.34983 37.7411750875649 -122.428904483875 (37.7411750875649, -122.428904483875) 2 7 5 63 7
2300 1941 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 217 Berkeley Way 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6000825.89094 2097729.82062 37.7400128936831 -122.439707051235 (37.7400128936831, -122.439707051235) 2 7 5 63 7
2323 35205 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16   16 Sidewalk: Curb side : Cutout Tree Private 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
2361 256460 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 2901 Sunset Blvd 9 Median : Yard Tree Private 2       3x3   5984945 2095183 37.7321032922905 -122.494428131787 (37.7321032922905, -122.494428131787) 1 8 4 64 35
2400 232794 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 701 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 3x9   6003144.80454 2104133.37104 37.7577272573137 -122.432146391441 (37.7577272573137, -122.432146391441) 2 4 5 28862 3
2443 58993 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 590 03rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/04/1980 12:00:00 AM 14   Permit Number 18284 5995033.83753 2111544.26695 37.7776124415586 -122.460734316672 (37.7776124415586, -122.460734316672) 11 6 2 54 11
2491 193810 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 285 Texas St 3 : Tree Private 2     10 Width 3ft   6013775.34661 2105819.12575 37.7629529551453 -122.395499427275 (37.7629529551453, -122.395499427275) 14 3 8 28856 29
2511 20282 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 20X Sunset Blvd 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
2518 250436 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 98 Seacliff Ave 1 Sidewalk: Curb side : Yard Tree Private 2     11 Width 4ft   5987616.8568 2115817.96032 37.7889172576592 -122.486705722111 (37.7889172576592, -122.486705722111) 11 6 1 55 33
2538 20304 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 50X Sunset Blvd 6 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
2550 1015 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1854X Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1     30 4X4   6001128.27711 2091386.71553 37.7226133962853 -122.438207240029 (37.7226133962853, -122.438207240029) 9 7 6 28861 25
2556 4083 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 3215 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6008095.47339 2100529.11474 37.7481102284008 -122.414769812274 (37.7481102284008, -122.414769812274) 2 4 7 28859 2
2562 232750 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 373 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6002968.45088 2106099.8261 37.7631166695342 -122.432896777683 (37.7631166695342, -122.432896777683) 15 4 5 28862 3
2563 18769 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 290 Roosevelt Way 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3X3 Permit Number 787822 6000600.23585 2106985.9234 37.765415066877 -122.441151190675 (37.765415066877, -122.441151190675) 15 5 5 29492 3
2639 210264 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1201 Irving St 5 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   5991895.36421 2106557.41103 37.7637388043301 -122.471227833003 (37.7637388043301, -122.471227833003) 1 8 11 56 12
2652 18747 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 222 Roosevelt Way 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6000958.79784 2107315.99315 37.7663417741813 -122.439934678663 (37.7663417741813, -122.439934678663) 15 5 5 29492 3
2663 181722 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 2645 Lincoln Way 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   5987446.5903 2107090.374 37.764943837931 -122.486653709544 (37.764943837931, -122.486653709544) 1 8 3 56 35
2692 18211 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1575 Post St 6 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6004651.3172937 2114317.5621297 37.7857758731644 -122.427661834419 (37.7857758731644, -122.427661834419) 13 9 11 28858 13
2732 118955 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 750 48th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 4ft   5981074.93145 2110594.12979 37.7741906275321 -122.508951455998 (37.7741906275321, -122.508951455998) 11 6 2 55 26
2738 140731 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 2023 O'Farrell St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/02/2004 12:00:00 AM 12 Width 0ft   6001651.0062 2113204.4884 37.7825494877114 -122.437962288192 (37.7825494877114, -122.437962288192) 15 5 11 29490 41
2863 143418 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 575 Kearny St 1 Sidewalk: Curb side : Pot Tree Private 2     4 Width 0ft   6011374.2644 2116814.4836 37.7930098144506 -122.404578041099 (37.7930098144506, -122.404578041099) 3 1 10 28857 4
2926 183551 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1200 Vicente St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 0ft   5989202.4612 2097677.5503 37.7392009295048 -122.479891799473 (37.7392009295048, -122.479891799473) 1 8 3 29491 35
2945 98684 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 40 Bay View St 1 Sidewalk: Curb side : Cutout Tree Private 2           6014207 2094775 37.7326521179743 -122.393233618799 (37.7326521179743, -122.393233618799) 10 3 8 58 1
2953 118676 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 4825 Balboa St 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5980559.76523 2110909.18852 37.7750253031785 -122.510756894567 (37.7750253031785, -122.510756894567) 11 6 2 55 26
2971 250510 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 75 27th Ave 3 Sidewalk: Curb side : Yard Tree Private 2     12 Width 5ft   5987308.66603 2115522.71145 37.7880886178397 -122.487750306256 (37.7880886178397, -122.487750306256) 11 6 1 55 33
3003 131309 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 101 Maple St 2 Sidewalk: Curb side : Pot Tree Private 2     8 Width 3ft   5996544.36803 2115871.17754 37.7895797810398 -122.455821775454 (37.7895797810398, -122.455821775454) 11 6 1 54 31
3007 27222 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 371 Silver Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     13 3x3   6003827.51824 2093508.67438 37.7285929731823 -122.429027779127 (37.7285929731823, -122.429027779127) 9 7 6 28861 5
3036 258017 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 2342 43rd Ave 1 Sidewalk: Curb side : Tree DPW 1     3     5983011.19804 2099184.33916 37.7429765166721 -122.501409485055 (37.7429765166721, -122.501409485055) 1 8 3 29491 35
3066 11935 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 660X Keith St 5 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6017236.56511 2096428.9556383 37.7373613939034 -122.382874625964 (37.7373613939034, -122.382874625964) 10 3 8 58 1
3074 144281 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 690 45th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   01/16/2020 12:00:00 AM 3 Width 3ft   5981991.18166 2111072.85964 37.7755590499331 -122.505817535952 (37.7755590499331, -122.505817535952) 11 6 2 55 26
3121 28070 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 3445 Geary Blvd 4 Sidewalk: Curb side : Cutout Tree DPW 1     3 3X3   5996465.30474 2112747.36669 37.780998091992 -122.455869411327 (37.780998091992, -122.455869411327) 11 6 2 54 16
3153 16204 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 504 Monterey Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 4x4   5998737.42681 2094729.30283 37.7316550910092 -122.446712233977 (37.7316550910092, -122.446712233977) 9 7 4 59 40
3245 177750 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1830 Alemany Blvd 4 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 5ft Permit Number 784881 6001125.87502 2091373.61723 37.7225772947014 -122.438214605635 (37.7225772947014, -122.438214605635) 9 7 6 28861 25
3249 9238 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 6400 Geary Blvd 6 Median : Cutout Tree DPW 1     12 8M   5987194.6568724 2112586.3612843 37.7800195894976 -122.487928920824 (37.7800195894976, -122.487928920824) 11 6 2 55 26
3264 1125 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 2466 Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     25 3X3   5998958.39293 2088881.75103 37.7156116878713 -122.445527983003 (37.7156116878713, -122.445527983003) 9 7 6 28861 25
3280 131640 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1 John Maher St 11 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 2ft   6012516.39598 2119702.01834 37.8010020586619 -122.400829137966 (37.8010020586619, -122.400829137966) 3 1 10 28860 6
3282 232681 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 998 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6009404.5391 2103406.76128 37.7560850691817 -122.410446255909 (37.7560850691817, -122.410446255909) 2 4 7 28859 19
3290 122954 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 201 09th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5993081.91997 2114080.47457 37.7844636809028 -122.467671095614 (37.7844636809028, -122.467671095614) 11 6 2 54 11
3318 185278 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 2601 Sunset Blvd 3 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5984958.2606 2097437.8471 37.7382952768032 -122.49454845339 (37.7382952768032, -122.49454845339) 1 8 3 29491 35
3330 213252 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 239 Byxbee St 1 Sidewalk: Property side : Yard Tree Private 2     12 Width 6ft   5991927.67162 2090111.22138 37.7185836258199 -122.4699185829 (37.7185836258199, -122.4699185829) 9 8 6 64 24
3339 19580 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 100 STAIRWAY4 3 Sidewalk: Curb side : Cutout Tree DPW 1     3 8                      
3371 9374 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 300 Gold Mine Dr 1 Sidewalk: Curb side : Cutout Tree Private 2   11/03/1994 12:00:00 AM 30 2X2   6001106.82258 2097916.97358 37.7405427580332 -122.438749114996 (37.7405427580332, -122.438749114996) 2 7 5 63 7
3401 21158 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 2300X Sunset Blvd 5 Sidewalk: Curb side : Cutout Tree DPW 1     12 10   5984964.3463827 2099540.4551822 37.7440688278009 -122.494682382207 (37.7440688278009, -122.494682382207) 1 8 3 29491 35
3424 116715 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 2817 Bush St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   5999908.2786 2114349.9787 37.7855954495545 -122.444073686604 (37.7855954495545, -122.444073686604) 15 6 1 29490 31
3473 58897 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 250 Arleta Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/29/1980 12:00:00 AM 13   Permit Number 18169 6009836.93544 2088163.79838 37.7142553893523 -122.407876041144 (37.7142553893523, -122.407876041144) 9 7 8 309 39
3496 98500 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 1670 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5990941.3 2104038.3 37.7567667631156 -122.474343775715 (37.7567667631156, -122.474343775715) 1 8 4 56 12
3536 58987 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 530 03rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/04/1980 12:00:00 AM 13   Permit Number 18276 5995021.45981 2111908.34632 37.7786113944275 -122.460803527373 (37.7786113944275, -122.460803527373) 11 6 2 54 11
3548 296 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 3451X 19th Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1     18 2X3   5990184.74118 2092923.50312 37.7262045448252 -122.476148412917 (37.7262045448252, -122.476148412917) 1 8 4 64 14
3634 20382 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 262X Sunset Blvd 28 Sidewalk: Curb side : Cutout Tree DPW 1     18 60                      
3658 140493 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1340 TURK ST 1 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 0ft   6003595.4388 2112480.2415 37.7806712690813 -122.431183683552 (37.7806712690813, -122.431183683552) 15 9 11 29490 41
3694 231406 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 301x Powhattan Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 2ft   6008008.21538 2098169.17057 37.7416254437701 -122.414904545115 (37.7416254437701, -122.414904545115) 2 7 7 28859 2
3752 209923 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 700 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5991036.77148 2099253.35889 37.7436340939434 -122.473664564077 (37.7436340939434, -122.473664564077) 1 8 4 29491 40

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);