trees
8,758 rows where qSpecies_id = 16 sorted by rowid descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
192521 | 218275 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1470 Portola Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 5ft | 5992692.18514 | 2097160.68592 | 37.737983877442 | -122.467788427113 | (37.737983877442, -122.467788427113) | 1 | 8 | 4 | 59 | 40 | |||
192517 | 250536 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 77 25th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 5ft | 5987989.55058 | 2115532.53909 | 37.7881552926911 | -122.485395315455 | (37.7881552926911, -122.485395315455) | 11 | 6 | 1 | 55 | 33 | |||
192503 | 183604 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2086 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 5990091.9281 | 2101143.995 | 37.7487705213837 | -122.477069693787 | (37.7487705213837, -122.477069693787) | 1 | 8 | 3 | 29491 | 35 | |||
192461 | 246429 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 476 Duncan St | 1 | : | Tree | Private 2 | 15 | Width 4ft | 6003446.58995 | 2099832.72905 | 37.7459358124929 | -122.430795790488 | (37.7459358124929, -122.430795790488) | 2 | 7 | 5 | 63 | 22 | |||
192407 | 184560 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3717 Moraga St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5982760.5563 | 2103528.5185 | 37.7548897016982 | -122.502597594087 | (37.7548897016982, -122.502597594087) | 1 | 8 | 3 | 56 | 35 | |||
192406 | 177606 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 30 Ruth St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6001463.15581 | 2091693.71446 | 37.7234753864602 | -122.437071609562 | (37.7234753864602, -122.437071609562) | 9 | 7 | 6 | 28861 | 25 | |||
192372 | 56372 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1431 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/29/1973 12:00:00 AM | 14 | Permit Number 12518 | 5991130.71773 | 2110611.3931 | 37.7748256849269 | -122.474168305535 | (37.7748256849269, -122.474168305535) | 11 | 6 | 2 | 54 | 26 | ||
192365 | 232477 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4377 Cesar Chavez St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 5ft | 6001508.16094 | 2100266.16656 | 37.747015912651 | -122.437529634306 | (37.747015912651, -122.437529634306) | 2 | 4 | 5 | 63 | 22 | |||
192306 | 131591 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1918 Leavenworth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6007764.24326 | 2119027.43451 | 37.7988836111499 | -122.41722583111 | (37.7988836111499, -122.41722583111) | 5 | 1 | 10 | 308 | 32 | |||
192297 | 210266 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1201 Irving St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5991983.85012 | 2106561.35819 | 37.7637547601024 | -122.470922077917 | (37.7637547601024, -122.470922077917) | 1 | 8 | 11 | 56 | 12 | |||
192296 | 19555 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 399X Saint Joseph's Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6000237.59521 | 2113336.21742 | 37.7828307037077 | -122.442861526711 | (37.7828307037077, -122.442861526711) | 15 | 5 | 1 | 29490 | 16 | |||
192285 | 19250 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1901X Ellis St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6001670.2566 | 2112782.84102 | 37.7813928458395 | -122.437865480342 | (37.7813928458395, -122.437865480342) | 15 | 5 | 11 | 29490 | 41 | |||
192267 | 53213 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 77 Toledo Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/08/1990 12:00:00 AM | 9 | Permit Number 28860 | 6001508.75338 | 2119947.52013 | 37.801056012589 | -122.438937808027 | (37.801056012589, -122.438937808027) | 13 | 9 | 1 | 57 | 17 | |
192262 | 123975 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 59 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5993615.75025 | 2115111.34494 | 37.7873249775569 | -122.4658991705 | (37.7873249775569, -122.4658991705) | 11 | 6 | 1 | 54 | 11 | |||
192240 | 21471 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2703X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 10 | 5985126.1868718 | 2096824.207438 | 37.7366202133833 | -122.493922645108 | (37.7366202133833, -122.493922645108) | 1 | 8 | 3 | 29491 | 35 | |||
192236 | 231389 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 291 Putnam St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6009112.04531 | 2096385.28281 | 37.7367892396354 | -122.410961891173 | (37.7367892396354, -122.410961891173) | 10 | 7 | 7 | 28859 | 2 | |||
192224 | 250035 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 Daniel Burnham Ct | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6006298.52089 | 2114736.52863 | 37.7870192879551 | -122.421992738875 | (37.7870192879551, -122.421992738875) | 13 | 9 | 1 | 28858 | 41 | |||
192222 | 183405 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 95 Escolta Way | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 0ft | Permit Number 18001 | 5986895.1605 | 2097136.7526 | 37.7375817229107 | -122.487829579453 | (37.7375817229107, -122.487829579453) | 1 | 8 | 3 | 29491 | 35 | ||
192202 | 232245 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3001 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6002884.54028 | 2096128.86275 | 37.7357339922251 | -122.432474776193 | (37.7357339922251, -122.432474776193) | 2 | 7 | 5 | 63 | 7 | |||
192196 | 103016 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1950X Turk St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 4x4 | 6000619.3 | 2112146.9 | 37.7795868963645 | -122.441455622144 | (37.7795868963645, -122.441455622144) | 15 | 5 | 1 | 29490 | 16 | |||
192146 | 5027 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5320 Diamond Heights Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/08/1992 12:00:00 AM | 7 | 2X2 | 6001740.3856 | 2098700.64131 | 37.7427305495746 | -122.436614583123 | (37.7427305495746, -122.436614583123) | 2 | 7 | 5 | 63 | 7 | ||
192141 | 231373 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 893 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 4x4 | 5998690.57736 | 2106995.19349 | 37.7653315594218 | -122.447756899972 | (37.7653315594218, -122.447756899972) | 15 | 5 | 11 | 29492 | 9 | |||
192136 | 43553 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3863 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2008 12:00:00 AM | 3x3 | Permit Number 50465 | 6004776.47397667 | 2100730.42745748 | 37.7484759432665 | -122.426261131709 | (37.7484759432665, -122.426261131709) | 2 | 4 | 5 | 63 | 22 | ||
192126 | 122011 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1414 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5991200.95511 | 2110671.71942 | 37.7749953931106 | -122.473929744445 | (37.7749953931106, -122.473929744445) | 11 | 6 | 2 | 54 | 26 | |||
192120 | 184342 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1300 Sunset Blvd | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | Width 0ft | 5984819.0615 | 2106093.3866 | 37.7620528660847 | -122.49566798926 | (37.7620528660847, -122.49566798926) | 1 | 8 | 3 | 56 | 35 | |||
192117 | 193821 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 501 Phelps St | 2 | : | Tree | Private 2 | 15 | Width 3ft | 6015477.1577 | 2098231.99769 | 37.7422148117602 | -122.389083622404 | (37.7422148117602, -122.389083622404) | 10 | 3 | 8 | 58 | 1 | |||
192088 | 69505 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 400 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/14/1995 12:00:00 AM | Permit Number 33631 | 6008896.44583149 | 2096442.39545416 | 37.7369339663906 | -122.411711350033 | (37.7369339663906, -122.411711350033) | 10 | 7 | 7 | 28859 | 2 | ||
192069 | 68406 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 165 Manor Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 32241 | 5993785.35141141 | 2093816.39694136 | 37.7288643478836 | -122.463766175381 | (37.7288643478836, -122.463766175381) | 9 | 8 | 4 | 59 | 40 | ||
192000 | 177771 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 395 Hamilton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6009446.94851 | 2092555.33738 | 37.7262918005011 | -122.409533751594 | (37.7262918005011, -122.409533751594) | 10 | 3 | 7 | 309 | 28 | |||
191946 | 107167 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 27 WEST PORTAL AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5993261.4 | 2098012.7 | 37.7403561458765 | -122.465882276537 | (37.7403561458765, -122.465882276537) | 1 | 8 | 4 | 59 | 40 | |||||
191945 | 9189 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 6127 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5987963.655 | 2112535.8932 | 37.7799258464349 | -122.485264939527 | (37.7799258464349, -122.485264939527) | 11 | 6 | 2 | 55 | 26 | |||
191917 | 185443 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2401 Sunset Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 0ft | 5984984.7709 | 2098783.4934 | 37.7419916109579 | -122.494555968092 | (37.7419916109579, -122.494555968092) | 1 | 8 | 3 | 29491 | 35 | |||
191913 | 177709 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 41 Rhine St | 3 | : | Tree | Private 2 | 5 | Width 3ft | 5994451.68551 | 2086639.19983 | 37.7091958547847 | -122.460942654584 | (37.7091958547847, -122.460942654584) | 9 | 8 | 6 | 28861 | 25 | |||
191868 | 186988 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2501 Sunset Blvd | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 0ft | 5984944.4036 | 2098106.7752 | 37.7401311625536 | -122.494645664988 | (37.7401311625536, -122.494645664988) | 1 | 8 | 3 | 29491 | 35 | |||
191843 | 131547 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1329 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008378.88528 | 2117240.90103 | 37.7940127921137 | -122.414972444817 | (37.7940127921137, -122.414972444817) | 5 | 1 | 10 | 28858 | 21 | |||
191783 | 93021 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1403 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 4x4 | Tree 1 on Judah | 5992673.9 | 2105865.8 | 37.7618848250494 | -122.468484819075 | (37.7618848250494, -122.468484819075) | 1 | 8 | 4 | 56 | 12 | ||
191768 | 38872 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2041 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | 7 | Permit Number 40697 | 5988488.7731 | 2105083.1896 | 37.7594933558722 | -122.482901989065 | (37.7594933558722, -122.482901989065) | 1 | 8 | 3 | 56 | 35 | |
191766 | 183998 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1600 Sunset Blvd | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 0ft | 5984888.9105 | 2103901.6725 | 37.7560391195839 | -122.495264775736 | (37.7560391195839, -122.495264775736) | 1 | 8 | 3 | 56 | 35 | |||
191737 | 246938 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 301 Frederick St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5998548.43852 | 2107573.0737 | 37.7669101475202 | -122.448290139495 | (37.7669101475202, -122.448290139495) | 15 | 5 | 11 | 29492 | 9 | |||
191659 | 177762 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 327 Silver Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6003326.6739 | 2093552.98042 | 37.7286862643511 | -122.430762386101 | (37.7286862643511, -122.430762386101) | 9 | 7 | 6 | 28861 | 5 | |||
191650 | 8865 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4141 Geary Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X4 | 5994193.80479 | 2112760.26257 | 37.7809028716738 | -122.463728530875 | (37.7809028716738, -122.463728530875) | 11 | 6 | 2 | 54 | 11 | |||
191619 | 90226 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2600 Balboa St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5987438.69878 | 2111212.71275 | 37.7762621713286 | -122.486983771967 | (37.7762621713286, -122.486983771967) | 11 | 6 | 2 | 55 | 26 | ||
191616 | 142819 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 401 LARKIN ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6007654.4234 | 2112531.861 | 37.781042183178 | -122.417145328405 | (37.781042183178, -122.417145328405) | 7 | 9 | 9 | 28852 | 36 | |||
191603 | 209869 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 375 Parnassus Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5995873.06207 | 2106388.61612 | 37.7635046172729 | -122.457458075752 | (37.7635046172729, -122.457458075752) | 15 | 5 | 4 | 29492 | 12 | |||
191538 | 24383 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1400 Holloway Ave | 2 | Median : Cutout | Tree | DPW 1 | 06/27/1995 12:00:00 AM | 6 | 5X5 | 5990686.40185 | 2091107.57212 | 37.721247528335 | -122.474281766115 | (37.721247528335, -122.474281766115) | 9 | 8 | 4 | 64 | 40 | ||
191523 | 16276 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 690 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 5997552.36845 | 2094747.2906 | 37.7316367142582 | -122.450810493128 | (37.7316367142582, -122.450810493128) | 9 | 7 | 4 | 59 | 40 | |||
191491 | 232629 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 151 Starview Way | 4 | : | Tree | Private 2 | 14 | Width 3ft | 5997494.11803 | 2102162.88078 | 37.7519947870451 | -122.451546566645 | (37.7519947870451, -122.451546566645) | 1 | 5 | 4 | 63 | 38 | |||
191480 | 54069 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1645 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/1972 12:00:00 AM | 8 | Permit Number 9792 | 5981258.5718 | 2103857.679 | 37.7557051061066 | -122.507816210489 | (37.7557051061066, -122.507816210489) | 1 | 8 | 3 | 56 | 35 | ||
191437 | 65173 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 354 Edinburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/1989 12:00:00 AM | Permit Number 27154 | 6003399.5533224 | 2091672.05986303 | 37.7235258054263 | -122.43037629263 | (37.7235258054263, -122.43037629263) | 9 | 7 | 6 | 28861 | 5 | ||
191429 | 184428 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3829 Quintara St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5981466.6838 | 2100758.8574 | 37.7472088755344 | -122.506866662033 | (37.7472088755344, -122.506866662033) | 1 | 8 | 3 | 29491 | 35 | |||
191407 | 90985 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2901X Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/13/2008 12:00:00 AM | 3 | 3x3 | 5986529.10834 | 2111124.74148 | 37.7759675511026 | -122.490123780066 | (37.7759675511026, -122.490123780066) | 11 | 6 | 2 | 55 | 26 | ||
191349 | 187001 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2501 Sunset Blvd | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984953.9876 | 2098070.625 | 37.7400324647869 | -122.494609863527 | (37.7400324647869, -122.494609863527) | 1 | 8 | 3 | 29491 | 35 | |||
191333 | 33890 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2600 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/03/1997 12:00:00 AM | 2 | Permit Number 37865 | 6001690.6518 | 2116678.64965 | 37.7920908968329 | -122.438074073056 | (37.7920908968329, -122.438074073056) | 13 | 6 | 1 | 29490 | 27 | ||
191322 | 9243 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 6500 Geary Blvd | 2 | Median : Cutout | Tree | DPW 1 | 18 | 8M | 5986886.6516554 | 2112572.1737573 | 37.7799626628655 | -122.488993391881 | (37.7799626628655, -122.488993391881) | 11 | 6 | 2 | 55 | 26 | |||
191277 | 68288 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1994 Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/26/1993 12:00:00 AM | Permit Number 32097 | 5981192.89165036 | 2101506.41861494 | 37.7492453412397 | -122.507868866206 | (37.7492453412397, -122.507868866206) | 1 | 8 | 3 | 29491 | 35 | ||
191268 | 232738 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 470 Alvarado St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | Width 3ft | 6003332.48043 | 2102747.6052 | 37.7539329123867 | -122.431398409134 | (37.7539329123867, -122.431398409134) | 2 | 4 | 5 | 28862 | 22 | |||
191220 | 95472 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5986558.09049 | 2112203.93573 | 37.7789324044573 | -122.490102922958 | (37.7789324044573, -122.490102922958) | 11 | 6 | 2 | 55 | 26 | ||
191209 | 139703 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 319 Saint Joseph's Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6000441.6999 | 2113146.7863 | 37.7823222086005 | -122.442141809842 | (37.7823222086005, -122.442141809842) | 15 | 5 | 1 | 29490 | 16 | |||
191198 | 122233 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 664 14th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 22 | Width 3ft | 5991642.18522 | 2110940.40215 | 37.7757586700444 | -122.472423040614 | (37.7757586700444, -122.472423040614) | 11 | 6 | 2 | 54 | 26 | |||
191149 | 38135 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 423 Burrows St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1998 12:00:00 AM | 13 | Permit Number 40297 | 6009950.81596 | 2093093.13583 | 37.7277967026344 | -122.4078298052 | (37.7277967026344, -122.4078298052) | 10 | 3 | 7 | 309 | 28 | |
191136 | 187136 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2301 Sunset Blvd | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 0ft | 5984969.053 | 2099291.7064 | 37.7433861065054 | -122.494647773186 | (37.7433861065054, -122.494647773186) | 1 | 8 | 3 | 29491 | 35 | |||
191125 | 104612 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2 Rousseau St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 6003456.6 | 2095390.6 | 37.7337393134306 | -122.43044428521 | (37.7337393134306, -122.43044428521) | 2 | 7 | 5 | 28861 | 25 | ||||
191051 | 60935 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1547 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/1983 12:00:00 AM | Permit Number 20738 | 5990530.38833297 | 2104858.97757318 | 37.7589963110185 | -122.475824774532 | (37.7589963110185, -122.475824774532) | 1 | 8 | 4 | 56 | 12 | ||
191048 | 105827 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 930 ELIZABETH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 6000439.7 | 2102016.1 | 37.7517600039536 | -122.441349813189 | (37.7517600039536, -122.441349813189) | 2 | 4 | 5 | 28862 | 22 | ||||
191029 | 95148 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 250 23rd Ave | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 14 | 5988724.77962 | 2113566.52719 | 37.7827999873072 | -122.482707449869 | (37.7827999873072, -122.482707449869) | 11 | 6 | 2 | 55 | 26 | |||
191004 | 184426 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3811 Quintara St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5981632.5105 | 2100764.6105 | 37.7472344359238 | -122.506293682659 | (37.7472344359238, -122.506293682659) | 1 | 8 | 3 | 29491 | 35 | |||
190986 | 131336 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3605 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6003111.95247 | 2120710.82669 | 37.8032429371717 | -122.433444632988 | (37.8032429371717, -122.433444632988) | 13 | 9 | 1 | 57 | 17 | |||
190972 | 112124 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1298X 26TH AVE | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 5988007 | 2106798 | 37.764173712799 | -122.484693968894 | (37.764173712799, -122.484693968894) | 1 | 8 | 3 | 56 | 35 | ||||
190884 | 118506 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 8149 Geary Blvd | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 5981691.49804 | 2112321.67959 | 37.7789702984457 | -122.506946851069 | (37.7789702984457, -122.506946851069) | 11 | 6 | 2 | 55 | 26 | ||||
190871 | 90227 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2700X Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5987182.5795 | 2111204.4956 | 37.7762246728784 | -122.487869143441 | (37.7762246728784, -122.487869143441) | 11 | 6 | 2 | 55 | 26 | ||
190863 | 182834 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2813 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5985267.0612 | 2102920.5778 | 37.7533674367799 | -122.493884724798 | (37.7533674367799, -122.493884724798) | 1 | 8 | 3 | 56 | 35 | |||
190848 | 122018 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1425 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5991161.9613 | 2110610.42879 | 37.774824847068 | -122.474060158238 | (37.774824847068, -122.474060158238) | 11 | 6 | 2 | 54 | 26 | |||
190810 | 232758 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 650 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6004255.31793 | 2105073.45653 | 37.7603714089324 | -122.428372780398 | (37.7603714089324, -122.428372780398) | 2 | 4 | 5 | 28862 | 3 | |||
190795 | 97750 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2685 30th Ave | 8 | 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 | ||||
190770 | 124625 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 801 Euclid Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5995820.23201 | 2113778.98779 | 37.7837936049739 | -122.458175709009 | (37.7837936049739, -122.458175709009) | 11 | 6 | 1 | 54 | 31 | |||
190722 | 41477 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 950 Gilman Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | 5 | Permit Number 45188 | 6015801.2991 | 2089365.072 | 37.7178859659534 | -122.387344435884 | (37.7178859659534, -122.387344435884) | 10 | 3 | 8 | 58 | 1 | |
190714 | 185511 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2201 Sunset Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 0ft | 5984941.2618 | 2100008.6625 | 37.7453530468244 | -122.49479671566 | (37.7453530468244, -122.49479671566) | 1 | 8 | 3 | 29491 | 35 | |||
190705 | 66724 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 985 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/14/1991 12:00:00 AM | 16 | 3x3 | Permit Number 29967 | 6008288.03327 | 2119274.40334 | 37.7995911797528 | -122.415430833761 | (37.7995911797528, -122.415430833761) | 5 | 1 | 10 | 308 | 32 | |
190667 | 61484 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3330 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/06/1984 12:00:00 AM | Permit Number 21429 | 6004650.67994237 | 2106631.89148221 | 37.7646728642392 | -122.427116411757 | (37.7646728642392, -122.427116411757) | 8 | 4 | 5 | 28862 | 3 | ||
190660 | 52706 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 950 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/02/2006 12:00:00 AM | Permit Number 48845 | 6009564.39642774 | 2116599.60561075 | 37.7923184964294 | -122.410825126139 | (37.7923184964294, -122.410825126139) | 5 | 1 | 10 | 28857 | 21 | ||
190631 | 250430 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 78 Seacliff Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 4ft | 5987736.51992 | 2115825.2591 | 37.788944273303 | -122.486292245294 | (37.788944273303, -122.486292245294) | 11 | 6 | 1 | 55 | 33 | |||
190607 | 96742 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1090 Quintara St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 4x4 | 5990110.9428 | 2101113.3387 | 37.7486874503378 | -122.477001701975 | (37.7486874503378, -122.477001701975) | 1 | 8 | 3 | 29491 | 35 | |||
190583 | 8851 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4055X Geary Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5994484.79353 | 2112772.49441 | 37.780953220392 | -122.462722753062 | (37.780953220392, -122.462722753062) | 11 | 6 | 2 | 54 | 11 | |||
190582 | 112276 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3410 17TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6006056 | 2106092 | 37.7632698189292 | -122.422217414098 | (37.7632698189292, -122.422217414098) | 8 | 4 | 5 | 28859 | 19 | ||||
190574 | 61401 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3430 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1984 12:00:00 AM | Permit Number 21324 | 6003953.35749199 | 2106593.20175953 | 37.7645271739601 | -122.429525505861 | (37.7645271739601, -122.429525505861) | 8 | 4 | 5 | 28862 | 3 | ||
190564 | 10674 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1099X Hayes St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6002728.1788 | 2110582.7781 | 37.7754121244262 | -122.434048272069 | (37.7754121244262, -122.434048272069) | 15 | 5 | 11 | 29492 | 10 | |||
190556 | 35427 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1501 25th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/16/1998 12:00:00 AM | 7 | Permit Number 38876 | 6014082.4666 | 2101967.51335 | 37.7523943378461 | -122.394167532215 | (37.7523943378461, -122.394167532215) | 10 | 3 | 8 | 28856 | 1 | |
190531 | 9186 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 6114 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/1993 12:00:00 AM | 3 | 4X4 | 5988017.65 | 2112638.8526 | 37.7802116892223 | -122.485085705328 | (37.7802116892223, -122.485085705328) | 11 | 6 | 2 | 55 | 26 | ||
190521 | 218259 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1400x Portola Dr | 17 | Median : Yard | Tree | DPW 1 | 11 | 5992809.1507 | 2097219.82873 | 37.7381530219397 | -122.46738832232 | (37.7381530219397, -122.46738832232) | 1 | 8 | 4 | 59 | 40 | ||||
190518 | 42652 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2535 40th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | 3 | Permit Number 42692 | 5983937.5442 | 2098055.9454 | 37.7399326142193 | -122.498123168331 | (37.7399326142193, -122.498123168331) | 1 | 8 | 3 | 29491 | 35 | |
190506 | 210244 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1350 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 5ft | 5990534.81426 | 2106203.93845 | 37.7626894708617 | -122.475907690904 | (37.7626894708617, -122.475907690904) | 1 | 8 | 3 | 56 | 12 | |||
190490 | 140834 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100 PARKER AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 5996876.2129 | 2113774.3907 | 37.7838416028044 | -122.454522098809 | (37.7838416028044, -122.454522098809) | 11 | 6 | 1 | 54 | 31 | |||
190413 | 200254 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 862 Jamestown Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6014796.6152 | 2089127.4216 | 37.7171777312965 | -122.390800614465 | (37.7171777312965, -122.390800614465) | 10 | 3 | 8 | 58 | 1 | |||
190397 | 53879 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1087 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/10/1972 12:00:00 AM | 11 | Permit Number 9590 | 6011253.4806 | 2089742.64876 | 37.7186697961475 | -122.403090869943 | (37.7186697961475, -122.403090869943) | 10 | 7 | 8 | 309 | 28 | ||
190377 | 32727 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 431 Capitol Ave | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/29/1996 12:00:00 AM | 3 | 3x3 | 5995024.97569 | 2088634.0427 | 37.7147061970204 | -122.459105637321 | (37.7147061970204, -122.459105637321) | 9 | 8 | 6 | 28861 | 24 | |
190309 | 8752 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3330 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5996845.9242 | 2112992.1287 | 37.7816919812146 | -122.454570354799 | (37.7816919812146, -122.454570354799) | 11 | 6 | 1 | 54 | 31 | |||
190286 | 43960 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2700 Sloat Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/24/2000 12:00:00 AM | Permit Number 43533 | 5982473.74529439 | 2096486.33377202 | 37.7355369547755 | -122.503068116639 | (37.7355369547755, -122.503068116639) | 1 | 8 | 3 | 29491 | 35 | |||
190271 | 213169 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 751 Junipero Serra Blvd | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 3ft | 5991358.96487 | 2092127.43547 | 37.7240867617905 | -122.472031227078 | (37.7240867617905, -122.472031227078) | 9 | 8 | 4 | 59 | 40 | |||
190244 | 101177 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 408 IRVING ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994501 | 2106722 | 37.7643410968681 | -122.462227745791 | (37.7643410968681, -122.462227745791) | 11 | 5 | 11 | 56 | 12 | ||||
190223 | 218301 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 8 Ardenwood Way | 1 | : | Tree | Private 2 | 7 | Width 2ft | 5991277.55412 | 2096357.62934 | 37.735697102027 | -122.472620923325 | (37.735697102027, -122.472620923325) | 1 | 8 | 4 | 29491 | 40 |
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) );