trees
8,758 rows where qSpecies_id = 16 sorted by qLegalStatus_id 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
144603 | 231331 | Landmark tree 11 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1221 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/1988 12:00:00 AM | 25 | Width 4ft | Permit Number 25220 | 5997416.53254 | 2105659.95446 | 37.7615924319549 | -122.452067155375 | (37.7615924319549, -122.452067155375) | 15 | 5 | 11 | 29492 | 12 | |
104613 | 89263 | Section 143 10 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775142 | 6007496.395175 | 2110885.881534 | 37.7765138277066 | -122.41757533494 | (37.7765138277066, -122.41757533494) | 7 | 2 | 9 | 28852 | 36 | |
117249 | 110651 | Section 143 10 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 127 CENTRAL AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 5999845 | 2108967 | 37.770811558248 | -122.44390571749 | (37.770811558248, -122.44390571749) | 15 | 5 | 11 | 29492 | 9 | |||
120017 | 105072 | Private 9 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 88X PROSPECT AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 5x6 | 6007074 | 2099135 | 37.7442248567037 | -122.418203213837 | (37.7442248567037, -122.418203213837) | 2 | 7 | 7 | 28859 | 2 | |||
193685 | 104552 | Private 9 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 151 STARVIEW WAY | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | 3x3 | 5997447 | 2102183 | 37.7520473310587 | -122.451710958005 | (37.7520473310587, -122.451710958005) | 1 | 5 | 4 | 63 | 38 | |||
4401 | 258690 | Property Tree 8 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100x Whitney Young Cir | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 6016360 | 2096059 | 37.7362970999571 | -122.385879567348 | (37.7362970999571, -122.385879567348) | 10 | 3 | 8 | 58 | 1 | ||||
5745 | 193934 | Property Tree 8 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 101 Whitney Young Cir | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3 | Width 3ft | 6016623.26344 | 2095403.70542 | 37.7345123576517 | -122.384923708478 | (37.7345123576517, -122.384923708478) | 10 | 3 | 8 | 58 | 1 | |||
17872 | 258685 | Property Tree 8 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100x Whitney Young Cir | 2 | Sidewalk: Curb side : Yard | Tree | SFUSD 4 | 3x3 | 6016360 | 2096059 | 37.7362970999571 | -122.385879567348 | (37.7362970999571, -122.385879567348) | 10 | 3 | 8 | 58 | 1 | ||||
54121 | 101901 | Property Tree 8 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1100 Ocean Ave | 2 | Front Yard : Yard | Tree | DPW 1 | Permit Number 769623 | 5996507.7 | 2092470.2 | 37.7253245106519 | -122.454257683967 | (37.7253245106519, -122.454257683967) | 9 | 7 | 4 | 28861 | 40 | ||||
66427 | 248974 | Property Tree 8 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 716 Goettingen St | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6010713 | 2091306 | 37.7229322393396 | -122.405069122237 | (37.7229322393396, -122.405069122237) | 10 | 3 | 7 | 309 | 28 | ||||
554 | 63105 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 86 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1987 12:00:00 AM | Permit Number 23825 | 6006733.57538349 | 2099199.19959074 | 37.7443819667232 | -122.41938488452 | (37.7443819667232, -122.41938488452) | 2 | 7 | 7 | 28859 | 2 | ||
656 | 37103 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1200 48th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | Permit Number 39701 | 5981201.77477995 | 2106888.46207069 | 37.7640234205488 | -122.508237579769 | (37.7640234205488, -122.508237579769) | 1 | 8 | 3 | 56 | 35 | ||
865 | 65062 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 481 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/31/1989 12:00:00 AM | Permit Number 27018 | 5982198.4613122 | 2112526.22921648 | 37.7795617740877 | -122.505208255718 | (37.7795617740877, -122.505208255718) | 11 | 6 | 2 | 55 | 26 | ||
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 | |||
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 | ||||||||||||||
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 | |||||||||||||
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 | ||||
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 | |||
2228 | 48000 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1901 16th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2002 12:00:00 AM | Permit Number 45728 | 5991233.33873947 | 2102463.46573508 | 37.752459596695 | -122.47321895744 | (37.752459596695, -122.47321895744) | 1 | 8 | 4 | 29491 | 12 | ||
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 | ||||||||||||||
2425 | 31630 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2482 Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/1995 12:00:00 AM | Permit Number 35147 | 5981478.22688702 | 2098193.22560061 | 37.7401650446812 | -122.506636494986 | (37.7401650446812, -122.506636494986) | 1 | 8 | 3 | 29491 | 35 | ||
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 | ||
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 | |||
3734 | 67984 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 35 Broad St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31708 | 5996379.31437828 | 2088033.23094013 | 37.713134273022 | -122.454381139129 | (37.713134273022, -122.454381139129) | 9 | 8 | 6 | 28861 | 24 | ||
3811 | 32184 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 191 Lakeshore Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1995 12:00:00 AM | Permit Number 35516 | 5984219.12182319 | 2094256.3665376 | 37.7295164954065 | -122.49686924842 | (37.7295164954065, -122.49686924842) | 1 | 8 | 4 | 64 | 35 | ||
3913 | 35208 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
4351 | 65141 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 430 Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1989 12:00:00 AM | Permit Number 27116 | 5981364.99930459 | 2112708.09753982 | 37.7800120543584 | -122.508105008848 | (37.7800120543584, -122.508105008848) | 11 | 6 | 2 | 55 | 26 | ||
4587 | 35197 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
4715 | 34359 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1827 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38115 | 6004598.72588548 | 2098167.19179023 | 37.7414278382274 | -122.426693274937 | (37.7414278382274, -122.426693274937) | 2 | 7 | 5 | 63 | 7 | ||
5362 | 109193 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4124 Moraga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773525 | ||||||||||
5889 | 37810 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1746 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2002 12:00:00 AM | Permit Number 44738 | 5981328.72954544 | 2103184.35370388 | 37.7538604793554 | -122.507523629232 | (37.7538604793554, -122.507523629232) | 1 | 8 | 3 | 56 | 35 | ||
5931 | 7196 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 949 Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6003418.39077 | 2111568.89089 | 37.7781588927529 | -122.431731089816 | (37.7781588927529, -122.431731089816) | 15 | 9 | 11 | 29492 | 41 | |||
6164 | 68307 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2167 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 32118 | 5981682.0022594 | 2100343.28066189 | 37.7460804954734 | -122.506091311951 | (37.7460804954734, -122.506091311951) | 1 | 8 | 3 | 29491 | 35 | ||
6302 | 38481 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1116 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/1998 12:00:00 AM | Permit Number 40480 | 6017830.40993478 | 2092735.6877236 | 37.727253198437 | -122.380564773574 | (37.727253198437, -122.380564773574) | 10 | 3 | 8 | 58 | 1 | |||
6363 | 12160 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1400X La Salle Ave | 41 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6016105.23501 | 2095780.81201 | 37.7355191499757 | -122.386741010111 | (37.7355191499757, -122.386741010111) | 10 | 3 | 8 | 58 | 1 | |||
6368 | 142137 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3059 GEARY BLVD | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5997680.98 | 2113001.7737 | 37.7817663225775 | -122.451682166477 | (37.7817663225775, -122.451682166477) | 15 | 6 | 2 | 54 | 16 | |||
6571 | 94972 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 230 Seacliff Ave | 4 | Sidewalk: Curb side : | Tree | Private 2 | 04/28/2010 12:00:00 AM | Permit Number 53388 | 5987086.7 | 2115743.7 | 37.7886824393648 | -122.488534508212 | (37.7886824393648, -122.488534508212) | 11 | 6 | 1 | 55 | 33 | |||
6869 | 51982 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 660 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/2005 12:00:00 AM | Permit Number 48204 | 6007266.85815782 | 2113345.5415055 | 37.7832545419232 | -122.4185438282 | (37.7832545419232, -122.4185438282) | 7 | 9 | 9 | 28858 | 36 | |||
7313 | 33583 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 151 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/1996 12:00:00 AM | Permit Number 37691 | 6007181.85623533 | 2098126.23586774 | 37.7414610860553 | -122.417758780801 | (37.7414610860553, -122.417758780801) | 2 | 7 | 7 | 28859 | 2 | |||
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 | ||||||||||||||
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 | |||
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 |
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 | ||
8676 | 34246 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 38056 | |||||||||||||||
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 | ||
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 | |||
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 | ||||||||||||||
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 | ||||||||||||||
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 | |||
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 | |||
10031 | 35174 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
10551 | 35179 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
10584 | 60431 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 454 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1982 12:00:00 AM | Permit Number 20015 | 6003628.53966279 | 2098964.72203761 | 37.7435627733769 | -122.430104722556 | (37.7435627733769, -122.430104722556) | 2 | 7 | 5 | 63 | 22 | ||
10731 | 16564 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2265X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 5999663.62849 | 2089384.1717 | 37.7170314576056 | -122.443126439495 | (37.7170314576056, -122.443126439495) | 9 | 7 | 6 | 28861 | 25 | |||
10863 | 56635 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1919 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/04/1982 12:00:00 AM | Permit Number 20078 | 6001606.33187064 | 2112849.40553557 | 37.7815719798524 | -122.438091398042 | (37.7815719798524, -122.438091398042) | 15 | 5 | 11 | 29490 | 41 | ||
10979 | 35203 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
11358 | 105913 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 115 Steuart St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 771767 | 6014820.9 | 2116826.5 | 37.7932348296087 | -122.392653238457 | (37.7932348296087, -122.392653238457) | 12 | 2 | 9 | 28855 | 6 | |||
11690 | 35212 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
12474 | 51019 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 251 Ramsell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2004 12:00:00 AM | Permit Number 47497 | 5992948.45681034 | 2088862.24435583 | 37.7152131901669 | -122.466299454682 | (37.7152131901669, -122.466299454682) | 9 | 8 | 6 | 64 | 24 | |||
12722 | 4851 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1499X ALEMANY BLVD | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X6 | 6002180 | 2093376 | 37.7281352832027 | -122.43471385212 | (37.7281352832027, -122.43471385212) | 9 | 7 | 6 | 28861 | 25 | |||
12844 | 35183 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
13209 | 209883 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1862 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/1987 12:00:00 AM | 11 | Width 3ft | Permit Number 24352 | 5993165.67031 | 2102796.35427 | 37.7534853189133 | -122.46656088218 | (37.7534853189133, -122.46656088218) | 1 | 8 | 4 | 56 | 12 | |
13515 | 35181 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
13752 | 38739 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 222 Schwerin St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/1998 12:00:00 AM | Permit Number 40629 | 6008735.41747655 | 2086742.92913816 | 37.7102922449528 | -122.411583002336 | (37.7102922449528, -122.411583002336) | 9 | 7 | 8 | 309 | 39 | |||
14148 | 89566 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5001X Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/2020 12:00:00 AM | 3 | 3x3 | Permit Number 782749 | 5983110.49799 | 2111681.5935 | 37.7772962731377 | -122.501990666002 | (37.7772962731377, -122.501990666002) | 11 | 6 | 2 | 55 | 26 |
14348 | 31622 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2400 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/22/1995 12:00:00 AM | Permit Number 35554 | 5992052.25118753 | 2099087.40328319 | 37.7432371814309 | -122.470141233061 | (37.7432371814309, -122.470141233061) | 1 | 8 | 4 | 29491 | 40 | ||
14889 | 35207 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
15025 | 37102 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1200 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | Permit Number 39701 | 5981201.77477995 | 2106888.46207069 | 37.7640234205488 | -122.508237579769 | (37.7640234205488, -122.508237579769) | 1 | 8 | 3 | 56 | 35 | ||
15225 | 210269 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1321 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/1983 12:00:00 AM | 10 | Width 3ft | Permit Number 20744 | 5990716.35188 | 2105159.9942 | 37.7598336026602 | -122.475203607164 | (37.7598336026602, -122.475203607164) | 1 | 8 | 4 | 56 | 12 | |
15416 | 94973 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 230 Seacliff Ave | 5 | Sidewalk: Curb side : | Tree | Private 2 | 04/28/2010 12:00:00 AM | Permit Number 53388 | 5987086.7 | 2115743.7 | 37.7886824393648 | -122.488534508212 | (37.7886824393648, -122.488534508212) | 11 | 6 | 1 | 55 | 33 | |||
15424 | 210235 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1524 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/1983 12:00:00 AM | 13 | Width 3ft | Permit Number 20742 | 5990577.68593 | 2104968.58211 | 37.7592999980115 | -122.475669202369 | (37.7592999980115, -122.475669202369) | 1 | 8 | 4 | 56 | 12 | |
15754 | 35209 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
16152 | 63923 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1762 Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/1987 12:00:00 AM | 10 | 4x6 | Permit Number 24645 | 5981062.59870673 | 2103072.00706036 | 37.7535363264903 | -122.50843561579 | (37.7535363264903, -122.50843561579) | 1 | 8 | 3 | 56 | 35 | |
16270 | 35178 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
16636 | 35198 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
16762 | 140732 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2019 O'Farrell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6001685.5252 | 2113210.58 | 37.7825681766306 | -122.437843304046 | (37.7825681766306, -122.437843304046) | 15 | 5 | 11 | 29490 | 41 | |||
17110 | 35180 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
17294 | 232622 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 291 Surrey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/1983 12:00:00 AM | 17 | Width 3ft | Permit Number 20859 | 6001685.29716 | 2096186.71215 | 37.7358247553907 | -122.436625158234 | (37.7358247553907, -122.436625158234) | 2 | 7 | 5 | 63 | 7 | |
17417 | 96352 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 533 Parnassus Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/10/2011 12:00:00 AM | 3x3 | Permit Number 767163 | 5995513.1 | 2106277.2 | 37.7631780147852 | -122.458694995111 | (37.7631780147852, -122.458694995111) | 15 | 5 | 4 | 63 | 12 | ||
17478 | 63127 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 51 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/09/1986 12:00:00 AM | Permit Number 23641 | 6007142.25261762 | 2099206.716095 | 37.7444256145798 | -122.417972293386 | (37.7444256145798, -122.417972293386) | 2 | 7 | 7 | 28859 | 2 | ||
17708 | 232623 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 9 Clarendon Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12/18/1997 12:00:00 AM | 8 | Width 2ft | Permit Number 38562 | 5998158.78525 | 2104648.31224 | 37.7588572051115 | -122.449427124456 | (37.7588572051115, -122.449427124456) | 15 | 5 | 4 | 28862 | 38 | |
18048 | 65381 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3001 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1989 12:00:00 AM | Permit Number 28220 | 6002894.34922795 | 2096164.85673792 | 37.7358333797031 | -122.432443432913 | (37.7358333797031, -122.432443432913) | 2 | 7 | 5 | 63 | 7 | ||
18187 | 35206 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
18230 | 35204 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
18284 | 258470 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2414 47th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/17/2019 12:00:00 AM | 3 | 3x3 | Permit Number 781119 | 5981787.508 | 2098641.53969 | 37.741414197633 | -122.505600368739 | (37.741414197633, -122.505600368739) | 1 | 8 | 3 | 29491 | 35 | |
18875 | 46976 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 94122 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2002 12:00:00 AM | Permit Number 44996 | |||||||||||||
19325 | 55119 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 101 Woodland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/14/1972 12:00:00 AM | 16 | Permit Number 11021 | 5997096.40798246 | 2105960.18380068 | 37.7623984432414 | -122.45319600432 | (37.7623984432414, -122.45319600432) | 15 | 5 | 11 | 29492 | 12 | ||
20041 | 97746 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2685 30th Ave | 4 | 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 | ||||
20068 | 59210 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 655 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1984 12:00:00 AM | Permit Number 21769 | 6004452.7032449 | 2107745.67004762 | 37.7677198351136 | -122.427880529994 | (37.7677198351136, -122.427880529994) | 8 | 4 | 5 | 28862 | 3 | ||
20158 | 64031 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2328 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/1987 12:00:00 AM | Permit Number 24788 | 6002100.67136952 | 2107083.49233192 | 37.7657683190956 | -122.435968519546 | (37.7657683190956, -122.435968519546) | 15 | 5 | 5 | 28862 | 3 | ||
20313 | 29719 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 80X Arguello Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3X5 | 5995527.39655 | 2115543.35672 | 37.7886212562912 | -122.459316616895 | (37.7886212562912, -122.459316616895) | 11 | 6 | 1 | 54 | 31 | |||
20443 | 94864 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 80 26th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5987748.3 | 2115456.9 | 37.7879335515465 | -122.486224435532 | (37.7879335515465, -122.486224435532) | 11 | 6 | 1 | 55 | 33 | |||||
20520 | 66318 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 158 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/30/1994 12:00:00 AM | Permit Number 29435 | 6001030.24418552 | 2094968.77102458 | 37.7324433243511 | -122.438802679239 | (37.7324433243511, -122.438802679239) | 9 | 7 | 5 | 63 | 40 | ||
20648 | 38458 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1115 Quesada Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/1998 12:00:00 AM | Permit Number 40472 | 6017828.60751249 | 2092672.1730279 | 37.7270786999418 | -122.380566591765 | (37.7270786999418, -122.380566591765) | 10 | 3 | 8 | 58 | 1 | ||
21006 | 31183 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 627 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34881 | 5992393.27316776 | 2089825.88959744 | 37.7178270773306 | -122.468288456554 | (37.7178270773306, -122.468288456554) | 9 | 8 | 6 | 64 | 24 | ||
21019 | 18787 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 345X Roosevelt Way | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6000292.8158924 | 2106925.3125911 | 37.7652311289718 | -122.442210131131 | (37.7652311289718, -122.442210131131) | 15 | 5 | 5 | 28862 | 3 | |||
21093 | 11635 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 499X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 18 | 3 | 5991474.53212 | 2093889.5616418 | 37.7289318087747 | -122.471760091134 | (37.7289318087747, -122.471760091134) | 9 | 8 | 4 | 59 | 40 | |||
21337 | 67795 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4518 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1992 12:00:00 AM | Permit Number 31438 | 6000923.92278491 | 2101155.09439533 | 37.7494234620324 | -122.439613590872 | (37.7494234620324, -122.439613590872) | 2 | 4 | 5 | 28862 | 22 | ||
21521 | 42412 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 255 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | 3x3 | Permit Number 42563 | 5999726.22128483 | 2094340.1247016 | 37.7306429333402 | -122.443265843466 | (37.7306429333402, -122.443265843466) | 9 | 7 | 4 | 63 | 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) );