trees
8,758 rows where qSpecies_id = 16
This data as json, CSV (advanced)
rowid ▼ | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7360 | 91134 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 400X Trumbull St | 2 | Median : Cutout | Tree | DPW 1 | 3 | 3x3 | 6005738.144013 | 2094265.96683 | 37.730780298312 | -122.422476416564 | (37.730780298312, -122.422476416564) | 9 | 7 | 6 | 28861 | 5 | |||
7384 | 131525 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1083 Clay St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6009580.99158 | 2117083.07964 | 37.7936469290112 | -122.41080186673 | (37.7936469290112, -122.41080186673) | 3 | 1 | 10 | 28857 | 21 | |||
7465 | 17540 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 512 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6002977.3728 | 2090782.38877 | 37.721059043035 | -122.431772202434 | (37.721059043035, -122.431772202434) | 9 | 7 | 6 | 28861 | 5 | |||
7474 | 35177 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
7518 | 20555 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1305X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 10 | 5984811.9199471 | 2106303.0061321 | 37.7626280043626 | -122.495708151398 | (37.7626280043626, -122.495708151398) | 1 | 8 | 3 | 56 | 35 | |||
7562 | 61590 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 909 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1984 12:00:00 AM | 11 | Permit Number 21557 | 6012793.74418 | 2103295.37957 | 37.7559686555484 | -122.398717353534 | (37.7559686555484, -122.398717353534) | 10 | 3 | 8 | 28856 | 29 | |
7600 | 12920 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2981X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3x3 | 5996820.13855 | 2087345.5314 | 37.7112712800431 | -122.452807904632 | (37.7112712800431, -122.452807904632) | 9 | 7 | 6 | 28861 | 25 | |||
7606 | 193912 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 151 Berry St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6014944.72987 | 2110876.13402 | 37.7769033583289 | -122.391808518763 | (37.7769033583289, -122.391808518763) | 6 | 2 | 9 | 28856 | 20 | |||
7611 | 70362 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3934 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5982621.9145 | 2104937.2986 | 37.7587496661055 | -122.503181346298 | (37.7587496661055, -122.503181346298) | 1 | 8 | 3 | 56 | 35 | |||
7630 | 24158 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 110X Whitney Young Cir | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6016346.0952597 | 2096044.1423309 | 37.736255534298 | -122.385926606914 | (37.736255534298, -122.385926606914) | 10 | 3 | 8 | 58 | 1 | |||
7688 | 58773 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1185 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/1979 12:00:00 AM | 17 | Permit Number 18016 | 6011971.93292 | 2102954.59115 | 37.7549871030883 | -122.401535514949 | (37.7549871030883, -122.401535514949) | 10 | 3 | 8 | 28856 | 29 | ||
7734 | 61566 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1111 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1984 12:00:00 AM | 13 | Permit Number 21526 | 6012850.93763 | 2102313.95355 | 37.7532770593148 | -122.398450696442 | (37.7532770593148, -122.398450696442) | 10 | 3 | 8 | 28856 | 29 | |
7741 | 261484 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1000 Portola Dr | 12 | Median : Yard | Tree | DPW 1 | 10x10 | 5995664 | 2098286 | 37.741244865522 | -122.457594860017 | (37.741244865522, -122.457594860017) | 1 | 8 | 4 | 59 | 40 | ||||
7802 | 184178 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1604 Lower Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5980981.8741 | 2104106.8749 | 37.756373020872 | -122.508791602838 | (37.756373020872, -122.508791602838) | 1 | 8 | 3 | 56 | 35 | |||
7875 | 71825 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1555 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | 5988675.2864 | 2104754.3629 | 37.758601337299 | -122.482232850163 | (37.758601337299, -122.482232850163) | 1 | 8 | 3 | 56 | 35 | |||
7914 | 193840 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 101 Barneveld Ave | 8 | : | Tree | Private 2 | 6 | Width 3ft | 6011575.20658 | 2099640.54229 | 37.7458653020467 | -122.402674470349 | (37.7458653020467, -122.402674470349) | 10 | 3 | 8 | 58 | 1 | |||
7949 | 61573 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 939 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1984 12:00:00 AM | 13 | Permit Number 21534 | 6012798.72555 | 2103171.42619 | 37.7556285841179 | -122.398691427883 | (37.7556285841179, -122.398691427883) | 10 | 3 | 8 | 28856 | 29 | |
7957 | 231433 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 401 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6001197.9223 | 2097527.04801 | 37.739477296143 | -122.438406199002 | (37.739477296143, -122.438406199002) | 2 | 7 | 5 | 63 | 7 | |||
7982 | 65224 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 424 Russia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/1989 12:00:00 AM | 15 | Permit Number 28011 | 6002436.63551 | 2090340.67814 | 37.7198155369321 | -122.433609818641 | (37.7198155369321, -122.433609818641) | 9 | 7 | 6 | 28861 | 5 | |
7984 | 213195 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 66 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5995352.58216 | 2090355.50173 | 37.7194517449684 | -122.45809781389 | (37.7194517449684, -122.45809781389) | 9 | 8 | 6 | 28861 | 24 | |||
7993 | 185387 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2300 Sunset Blvd | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 22 | Width 0ft | 5985052.013 | 2099287.3331 | 37.7433789539578 | -122.494360600593 | (37.7433789539578, -122.494360600593) | 1 | 8 | 3 | 29491 | 35 | |||
8006 | 9157 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 6000 Geary Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5988304.2257 | 2112648.9137 | 37.7802560029507 | -122.484095058697 | (37.7802560029507, -122.484095058697) | 11 | 6 | 2 | 55 | 26 | |||
8044 | 90232 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2738 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5986996.67991 | 2111198.28734 | 37.7761967812113 | -122.488511755965 | (37.7761967812113, -122.488511755965) | 11 | 6 | 2 | 55 | 26 | ||
8054 | 251208 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4115 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 5982071 | 2104840 | 37.7584501132023 | -122.505079418654 | (37.7584501132023, -122.505079418654) | 1 | 8 | 3 | 56 | 35 | |||
8085 | 60360 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1327 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 13 | Permit Number 19938 | 6016306.2035 | 2094147.2843 | 37.7310449340747 | -122.385932349662 | (37.7310449340747, -122.385932349662) | 10 | 3 | 8 | 58 | 1 | |
8148 | 7734 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 300 Franklin St | 5 | Sidewalk: Curb side : Cutout | Tree | War Memorial 17 | 12 | 3x3 | 6006417.36011 | 2111247.60822 | 37.777446266458 | -122.421333726477 | (37.777446266458, -122.421333726477) | 7 | 9 | 11 | 28852 | 10 | |||
8173 | 193892 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 10 De Boom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6014902.21965 | 2113000.89074 | 37.7827351011774 | -122.392104203263 | (37.7827351011774, -122.392104203263) | 6 | 2 | 9 | 28856 | 6 | |||
8194 | 24582 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 731 Cortland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 2X3 | 6007975.47278 | 2097199.92125 | 37.7389622589098 | -122.414949173076 | (37.7389622589098, -122.414949173076) | 2 | 7 | 7 | 28859 | 2 | |||
8283 | 19872 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100 STAIRWAY33 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 25ST | |||||||||||||
8323 | 10894 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1300X Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6017213.3373221 | 2095437.5732367 | 37.7346379721127 | -122.382885962987 | (37.7346379721127, -122.382885962987) | 10 | 3 | 8 | 58 | 1 | |||
8332 | 131472 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 280 Redwood St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6006289.44845 | 2112330.99569 | 37.7804137729253 | -122.421853191093 | (37.7804137729253, -122.421853191093) | 7 | 9 | 11 | 28852 | 41 | |||
8345 | 258530 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2122 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/28/2019 12:00:00 AM | 3 | 3x3 | Permit Number 784316 | 5981434 | 2100610 | 37.7467982300359 | -122.506968637856 | (37.7467982300359, -122.506968637856) | 1 | 8 | 3 | 29491 | 35 |
8365 | 183280 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1246 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5982138.4385 | 2106606.3363 | 37.763303936332 | -122.504977083187 | (37.763303936332, -122.504977083187) | 1 | 8 | 3 | 56 | 35 | |||
8399 | 95483 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 601X 30th Ave | 17 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 3x3 | 5986569.82886 | 2111856.71768 | 37.7779797279503 | -122.490036770148 | (37.7779797279503, -122.490036770148) | 11 | 6 | 2 | 55 | 26 | ||
8406 | 41624 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2285 Jerrold Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/2002 12:00:00 AM | 5 | Permit Number 46000 | 6011690.97977 | 2099682.45584 | 37.745986850809 | -122.402277086926 | (37.745986850809, -122.402277086926) | 10 | 3 | 8 | 58 | 1 | |
8430 | 112946 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2567 16TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991374 | 2097953 | 37.7400831663883 | -122.472403743487 | (37.7400831663883, -122.472403743487) | 1 | 8 | 4 | 29491 | 40 | ||||
8472 | 65709 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 142 Pope St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1990 12:00:00 AM | Permit Number 28638 | 6000250.18995538 | 2088032.18663542 | 37.7133526386349 | -122.44100204672 | (37.7133526386349, -122.44100204672) | 9 | 7 | 6 | 28861 | 5 | ||
8478 | 63679 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3900 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1987 12:00:00 AM | 11 | Permit Number 24332 | 5982744.7336 | 2104942.115 | 37.7587701092211 | -122.502756944956 | (37.7587701092211, -122.502756944956) | 1 | 8 | 3 | 56 | 35 | |
8499 | 8180 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1205X Fulton St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002000.37874 | 2111170.93633 | 37.7769857283744 | -122.436608008152 | (37.7769857283744, -122.436608008152) | 15 | 5 | 11 | 29492 | 10 | |||
8514 | 250400 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 15 Seacliff Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 4ft | 5988097.76743 | 2115798.38338 | 37.7888915289683 | -122.485040420476 | (37.7888915289683, -122.485040420476) | 11 | 6 | 1 | 55 | 33 | |||
8555 | 77658 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 299X Cambridge St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 3x3 | 6006705.39704 | 2093310.53877 | 37.7282114196192 | -122.419064719886 | (37.7282114196192, -122.419064719886) | 9 | 3 | 7 | 309 | 5 | ||
8588 | 61586 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 895 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1984 12:00:00 AM | 13 | Permit Number 21550 | 6012788.74443 | 2103337.06012 | 37.7560828226837 | -122.3987375694 | (37.7560828226837, -122.3987375694) | 10 | 3 | 8 | 28856 | 29 | |
8609 | 31455 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 625 Douglass St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/01/1995 12:00:00 AM | 14 | Permit Number 35026 | 6001232.34718 | 2102698.03632 | 37.7536775597828 | -122.438657597283 | (37.7536775597828, -122.438657597283) | 2 | 4 | 5 | 28862 | 22 | |
8676 | 34246 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 38056 | |||||||||||||||
8690 | 183553 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1202 Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 5989150.9777 | 2097677.2182 | 37.7391970264356 | -122.480069779917 | (37.7391970264356, -122.480069779917) | 1 | 8 | 3 | 29491 | 35 | |||
8718 | 74934 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 747 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6007018.6844 | 2113571.6653 | 37.7838614481007 | -122.419418459219 | (37.7838614481007, -122.419418459219) | 7 | 9 | 9 | 28858 | 36 | |||
8762 | 97574 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 501x Presidio Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999116.8 | 2114959.9 | 37.7872249510267 | -122.4468558657 | (37.7872249510267, -122.4468558657) | 15 | 6 | 1 | 54 | 31 | |||||
8796 | 146945 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 653 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/16/2020 12:00:00 AM | 3 | Width 3ft | 5982243.60068 | 2111319.85778 | 37.7762520882053 | -122.504962680002 | (37.7762520882053, -122.504962680002) | 11 | 6 | 2 | 55 | 26 | ||
8797 | 213239 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 25 Majestic Ave | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5997415.57746 | 2089795.63137 | 37.7180327919586 | -122.450926484985 | (37.7180327919586, -122.450926484985) | 9 | 8 | 6 | 28861 | 24 | |||
8806 | 41617 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2285 Jerrold Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/18/2020 12:00:00 AM | 4 | Permit Number 44542 | 6011837.54866 | 2099572.35682 | 37.7456927230357 | -122.401762530825 | (37.7456927230357, -122.401762530825) | 10 | 3 | 8 | 58 | 1 | |
8815 | 60244 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1211 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1982 12:00:00 AM | 14 | Permit Number 19796 | 5987977.3326 | 2107012.5647 | 37.764761120752 | -122.484812320079 | (37.764761120752, -122.484812320079) | 1 | 8 | 3 | 56 | 35 | |
8839 | 60946 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1422 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/1983 12:00:00 AM | Permit Number 20749 | 5990554.23882352 | 2105697.78860744 | 37.7613008451159 | -122.475803544713 | (37.7613008451159, -122.475803544713) | 1 | 8 | 4 | 56 | 12 | ||
8940 | 119554 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 601 30th Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5986557.94783 | 2112181.99105 | 37.7788721422837 | -122.490101801894 | (37.7788721422837, -122.490101801894) | 11 | 6 | 2 | 55 | 26 | |||
9011 | 6052 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1900 Eddy St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2003 12:00:00 AM | 3 | 3X3 | 6001270.4508 | 2112511.2313 | 37.7806243318768 | -122.439229137442 | (37.7806243318768, -122.439229137442) | 15 | 5 | 11 | 29490 | 41 | ||
9040 | 3086 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2925 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 45 | 3X3 | 6000198.2675 | 2115085.6403 | 37.7876319239021 | -122.443123265692 | (37.7876319239021, -122.443123265692) | 13 | 6 | 1 | 29490 | 27 | |||
9060 | 183028 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2550 41st Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5983678.1778 | 2097913.7541 | 37.739526984806 | -122.499009432355 | (37.739526984806, -122.499009432355) | 1 | 8 | 3 | 29491 | 35 | |||
9076 | 9908 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1809 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 6x6 | 6005225.98494 | 2115998.17525 | 37.7904229062421 | -122.425793311632 | (37.7904229062421, -122.425793311632) | 13 | 9 | 1 | 28858 | 27 | |||
9136 | 11920 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 620X Keith St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6017350.6902257 | 2096387.6229349 | 37.7372542074531 | -122.382477163454 | (37.7372542074531, -122.382477163454) | 10 | 3 | 8 | 58 | 1 | |||
9175 | 232785 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 311 Diamond St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6001794.37579 | 2104040.43503 | 37.7573954200892 | -122.436810069649 | (37.7573954200892, -122.436810069649) | 2 | 4 | 5 | 28862 | 3 | |||
9192 | 9302 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 320X Mansell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/10/1992 12:00:00 AM | 6 | 3X100 | 6010916.2744 | 2090546.6069 | 37.7208584636334 | -122.404313017158 | (37.7208584636334, -122.404313017158) | 10 | 3 | 7 | 309 | 28 | ||
9199 | 59852 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1123 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/1981 12:00:00 AM | 18 | 4x4 | Permit Number 19308 | 6017402.1303 | 2093334.4078 | 37.7288735235199 | -122.382086980049 | (37.7288735235199, -122.382086980049) | 10 | 3 | 8 | 58 | 1 |
9207 | 78507 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 465 Brussels St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6010703.64551 | 2092552.92571 | 37.7263555156731 | -122.4051892212 | (37.7263555156731, -122.4051892212) | 10 | 3 | 7 | 309 | 28 | |||
9261 | 61896 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 19 Holyoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/15/1985 12:00:00 AM | 11 | Permit Number 21939 | 6009273.47888 | 2094140.55724 | 37.7306347561928 | -122.410245303295 | (37.7306347561928, -122.410245303295) | 9 | 3 | 7 | 309 | 28 | ||
9275 | 232510 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 810 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6001254.99625 | 2101553.2012 | 37.7505354058999 | -122.438497252644 | (37.7505354058999, -122.438497252644) | 2 | 4 | 5 | 28862 | 22 | |||
9321 | 70250 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1475 44th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 5982457.955 | 2105055.9033 | 37.759065681929 | -122.503757167883 | (37.759065681929, -122.503757167883) | 1 | 8 | 3 | 56 | 35 | |||
9329 | 78804 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 463 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5987773.67277 | 2112847.71573 | 37.780770953663 | -122.485945059015 | (37.780770953663, -122.485945059015) | 11 | 6 | 2 | 55 | 26 | |||
9332 | 103261 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4174 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 7x15 | 6002762 | 2100662 | 37.7481739852998 | -122.433222250243 | (37.7481739852998, -122.433222250243) | 2 | 4 | 5 | 28862 | 22 | |||
9336 | 131379 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2990 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 5999358.44425 | 2117025.78745 | 37.7929111360792 | -122.446168490398 | (37.7929111360792, -122.446168490398) | 13 | 9 | 1 | 57 | 27 | |||
9346 | 66616 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2450 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/1991 12:00:00 AM | 3 | Permit Number 29819 | 5985544.9203 | 2098918.2658 | 37.742394428205 | -122.492629101957 | (37.742394428205, -122.492629101957) | 1 | 8 | 3 | 29491 | 35 | ||
9347 | 114899 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1545 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/2015 12:00:00 AM | Permit Number 774413 | 5981525.9 | 2104542.4 | 37.7576009016243 | -122.506942509341 | (37.7576009016243, -122.506942509341) | 1 | 8 | 3 | 56 | 35 | |||
9364 | 27216 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 440 Silver Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6004188.32264 | 2093464.07452 | 37.7284909288141 | -122.427777281084 | (37.7284909288141, -122.427777281084) | 9 | 7 | 6 | 28861 | 5 | |||
9371 | 199999 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1450 Griffith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6017702.3066 | 2092388.4628 | 37.7262927161578 | -122.380983501033 | (37.7262927161578, -122.380983501033) | 10 | 3 | 8 | 58 | 1 | |||
9393 | 210003 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 44 Lakewood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5993676.73838 | 2093064.62621 | 37.7267939100051 | -122.46408710354 | (37.7267939100051, -122.46408710354) | 9 | 8 | 4 | 59 | 40 | |||
9431 | 232592 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 820 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 6001105.09491 | 2102035.20124 | 37.7518503343262 | -122.439050162161 | (37.7518503343262, -122.439050162161) | 2 | 4 | 5 | 28862 | 22 | |||
9461 | 98346 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1943 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997281 | 2108783 | 37.7701597533774 | -122.452761318704 | (37.7701597533774, -122.452761318704) | 15 | 5 | 11 | 29492 | 9 | ||||
9491 | 72305 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3662 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5997266.67895 | 2115407.36737 | 37.7883477098214 | -122.453289170381 | (37.7883477098214, -122.453289170381) | 11 | 6 | 1 | 54 | 31 | |||
9534 | 113541 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 446 HOFFMAN AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6000626 | 2101420 | 37.7501338681145 | -122.440662811526 | (37.7501338681145, -122.440662811526) | 2 | 4 | 5 | 28862 | 22 | |||
9535 | 124144 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4100x Geary Blvd | 6 | Median : Yard | Tree | DPW 1 | 14 | 5994110.98895 | 2112812.22704 | 37.7810407796467 | -122.464018802579 | (37.7810407796467, -122.464018802579) | 11 | 6 | 2 | 54 | 11 | ||||
9540 | 83049 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100X Cargo Way | 5 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 11 | 6018864.16071 | 2097578.25634 | 37.7406069390666 | -122.377326932804 | (37.7406069390666, -122.377326932804) | 10 | 3 | 8 | 58 | 1 | ||||
9613 | 68469 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2766 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1993 12:00:00 AM | Permit Number 32334 | 6009569.05217042 | 2103972.19360753 | 37.757646840311 | -122.409917225443 | (37.757646840311, -122.409917225443) | 2 | 4 | 7 | 28859 | 19 | ||
9631 | 35176 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
9656 | 38138 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 423 Burrows St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1998 12:00:00 AM | 11 | Permit Number 40297 | 6010013.18685 | 2093111.14841 | 37.7278496529363 | -122.407615456286 | (37.7278496529363, -122.407615456286) | 10 | 3 | 7 | 309 | 28 | |
9679 | 111947 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 95 SEACLIFF AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 5987570 | 2115773 | 37.7887910778243 | -122.486864535179 | (37.7887910778243, -122.486864535179) | 11 | 6 | 1 | 55 | 33 | ||||
9728 | 74639 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 749 Polk St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6007029.8225 | 2113512.73169 | 37.7837002581006 | -122.419375743216 | (37.7837002581006, -122.419375743216) | 7 | 9 | 9 | 28858 | 36 | |||
9739 | 77653 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 299X Cambridge St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 6006717.25868 | 2093269.99639 | 37.7281007670162 | -122.41902083924 | (37.7281007670162, -122.41902083924) | 9 | 3 | 7 | 309 | 5 | ||
9763 | 111086 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 582X Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5996560.16999 | 2095740.09269 | 37.7343058616961 | -122.454312386561 | (37.7343058616961, -122.454312386561) | 9 | 7 | 4 | 59 | 40 | |||||
9777 | 184408 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3930 Quintara St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5981297.8113 | 2100810.2975 | 37.7473401694267 | -122.507454415813 | (37.7473401694267, -122.507454415813) | 1 | 8 | 3 | 29491 | 35 | |||
9844 | 78523 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3550 Santiago St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5981811.5356 | 2099469.1319 | 37.7436879505195 | -122.505578623462 | (37.7436879505195, -122.505578623462) | 1 | 8 | 3 | 29491 | 35 | |||
9856 | 35210 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
9864 | 102975 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 555 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007348.4 | 2112963.4 | 37.7822098643106 | -122.41823462296 | (37.7822098643106, -122.41823462296) | 7 | 9 | 9 | 28852 | 36 | ||||
9878 | 186643 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1401 Sunset Blvd | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 0ft | 5984764.0775 | 2105097.6653 | 37.7593156736844 | -122.495784702365 | (37.7593156736844, -122.495784702365) | 1 | 8 | 3 | 56 | 35 | |||
9881 | 213143 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 233 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5995623.80037 | 2091512.74066 | 37.7226448283785 | -122.457243989419 | (37.7226448283785, -122.457243989419) | 9 | 8 | 4 | 28861 | 24 | |||
9884 | 73155 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1539 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5984024.4181 | 2104677.685 | 37.7581191804023 | -122.498311745037 | (37.7581191804023, -122.498311745037) | 1 | 8 | 3 | 56 | 35 | |||
9916 | 91389 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 165 Kenwood Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 52087 | 5994308.9 | 2093484 | 37.7279818222938 | -122.461932151311 | (37.7279818222938, -122.461932151311) | 9 | 8 | 4 | 59 | 40 | |||
9926 | 80088 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2325 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6001799.98611 | 2118713.99662 | 37.7976856467424 | -122.437841619893 | (37.7976856467424, -122.437841619893) | 13 | 9 | 1 | 57 | 17 | |||
9969 | 209840 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 749 Parnassus Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5994752.13294 | 2106017.73198 | 37.7624218164232 | -122.461308096788 | (37.7624218164232, -122.461308096788) | 15 | 5 | 11 | 56 | 12 | |||
9995 | 60885 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 837 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/12/1983 12:00:00 AM | 11 | Permit Number 20669 | 6008911.6951 | 2119705.40633 | 37.8008096406195 | -122.413303226667 | (37.8008096406195, -122.413303226667) | 3 | 1 | 10 | 308 | 32 | |
9999 | 187636 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 142 28th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x6 | 5987141 | 2115018 | 37.7866930444454 | -122.488293288956 | (37.7866930444454, -122.488293288956) | 11 | 6 | 1 | 55 | 33 | ||||
10004 | 20406 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 262X Sunset Blvd | 51 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
10010 | 41581 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 291 18th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/2000 12:00:00 AM | Permit Number 42092 | 5990233.66540637 | 2113445.43887164 | 37.7825551838187 | -122.477478543034 | (37.7825551838187, -122.477478543034) | 11 | 6 | 2 | 55 | 26 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );