trees
8,758 rows where qSpecies_id = 16 sorted by DBH
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24 | 264941 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100X Portola Dr | 12 | Median : Cutout | Tree | Private 2 | 3x3 | 5999749 | 2101261 | 37.7496473113918 | -122.443684097942 | (37.7496473113918, -122.443684097942) | 2 | 5 | 5 | 28862 | 38 | ||||
408 | 109629 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 200X GELLERT DR | 30 | Median : Cutout | Tree | DPW 1 | 30x200 | 5985380 | 2094516.3 | 37.730298158605 | -122.492875173009 | (37.730298158605, -122.492875173009) | 1 | 8 | 4 | 64 | 35 | ||||
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 | ||
829 | 262514 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2230 Jerrold Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012281 | 2099339 | 37.74507671213 | -122.400212745638 | (37.74507671213, -122.400212745638) | 10 | 3 | 8 | 58 | 1 | ||||
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 | ||
1093 | 262511 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2230 Jerrold Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012281 | 2099339 | 37.74507671213 | -122.400212745638 | (37.74507671213, -122.400212745638) | 10 | 3 | 8 | 58 | 1 | ||||
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 | ||||
1542 | 261489 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1100X Portola Dr | 3 | Median : Cutout | Tree | DPW 1 | Private | 3x3 | 5995262 | 2098056 | 37.7405902419398 | -122.458968175006 | (37.7405902419398, -122.458968175006) | 1 | 7 | 4 | 59 | 40 | |||
1574 | 122761 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 86X Park Hill Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001171 | 2107689 | 37.7673780360046 | -122.439227450619 | (37.7673780360046, -122.439227450619) | 15 | 5 | 5 | 29492 | 3 | ||||
1677 | 259282 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3891 Sacramento St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 7ft | 5996301.11796 | 2114890.85877 | 37.7868741256738 | -122.456592467462 | (37.7868741256738, -122.456592467462) | 11 | 6 | 1 | 54 | 31 | ||||
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 | ||||||||||||||
2361 | 256460 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2901 Sunset Blvd | 9 | Median : Yard | Tree | Private 2 | 3x3 | 5984945 | 2095183 | 37.7321032922905 | -122.494428131787 | (37.7321032922905, -122.494428131787) | 1 | 8 | 4 | 64 | 35 | ||||
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 | ||
2945 | 98684 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 40 Bay View St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6014207 | 2094775 | 37.7326521179743 | -122.393233618799 | (37.7326521179743, -122.393233618799) | 10 | 3 | 8 | 58 | 1 | |||||
3496 | 98500 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1670 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5990941.3 | 2104038.3 | 37.7567667631156 | -122.474343775715 | (37.7567667631156, -122.474343775715) | 1 | 8 | 4 | 56 | 12 | ||||
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 | ||
3825 | 263630 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1020 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000550 | 2112598 | 37.7808215534457 | -122.441727743189 | (37.7808215534457, -122.441727743189) | 15 | 5 | 1 | 29490 | 16 | ||||
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 | ||||||||||||||
4197 | 262260 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2 Everglade Dr | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986312 | 2095495 | 37.7330398702545 | -122.489725113139 | (37.7330398702545, -122.489725113139) | 1 | 8 | 4 | 64 | 35 | ||||
4298 | 262513 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2230 Jerrold Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012281 | 2099339 | 37.74507671213 | -122.400212745638 | (37.74507671213, -122.400212745638) | 10 | 3 | 8 | 58 | 1 | ||||
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 | ||
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 | ||||
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 | ||
5054 | 102983 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 555 Turk St | 10 | 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 | ||||
5115 | 260959 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 400 Cherry St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 9ft | 5996243 | 2114742 | 37.7864620624436 | -122.456782770891 | (37.7864620624436, -122.456782770891) | 11 | 6 | 1 | 54 | 31 | ||||
5512 | 259281 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3891 Sacramento St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 7ft | 5996301.11796 | 2114890.85877 | 37.7868741256738 | -122.456592467462 | (37.7868741256738, -122.456592467462) | 11 | 6 | 1 | 54 | 31 | ||||
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 | ||
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 | |||
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 | |||
6775 | 256471 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2901 Sunset Blvd | 15 | Median : Yard | Tree | Private 2 | 3x3 | 5984945 | 2095183 | 37.7321032922905 | -122.494428131787 | (37.7321032922905, -122.494428131787) | 1 | 8 | 4 | 64 | 35 | ||||
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 | |||
6885 | 259563 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 200 Public Park | 2 | Unaccepted Street : Cutout | Tree | Private 2 | 5x10 | 5994204 | 2098512 | 37.741781429361 | -122.462659374294 | (37.741781429361, -122.462659374294) | 1 | 8 | 4 | 59 | 40 | ||||
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 | ||||||||||||||
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 | ||||
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 | ||
8676 | 34246 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 38056 | |||||||||||||||
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 | |||||
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 | ||
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 | |||
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 | ||||
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 | ||||||||||||||
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 | |||||
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 | ||||
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 | |||
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 | ||||
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 | ||||||||||||||
10041 | 261145 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3425 Quintara St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5982854.31136486 | 2100808.2311864 | 37.7474260606989 | -122.502072085099 | (37.7474260606989, -122.502072085099) | 1 | 8 | 3 | 29491 | 35 | ||||
10168 | 102888 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2940 16th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007175 | 2106758 | 37.7651615533416 | -122.418394378814 | (37.7651615533416, -122.418394378814) | 8 | 4 | 7 | 28853 | 19 | ||||
10392 | 111979 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 39 SEACLIFF AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5987939 | 2115796 | 37.788875735681 | -122.485589552136 | (37.788875735681, -122.485589552136) | 11 | 6 | 1 | 55 | 33 | |||||
10423 | 259280 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3891 Sacramento St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 7ft | 5996301.11796 | 2114890.85877 | 37.7868741256738 | -122.456592467462 | (37.7868741256738, -122.456592467462) | 11 | 6 | 1 | 54 | 31 | ||||
10516 | 102842 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1101X Portola Dr | 8 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
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 | ||
10735 | 121071 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 600x Sansome St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012133 | 2117811 | 37.7957883852557 | -122.402022845886 | (37.7957883852557, -122.402022845886) | 3 | 1 | 10 | 28860 | 4 | ||||
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 | ||
10900 | 256098 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1776 Vallejo St | 1 | Front Yard : Cutout | Tree | Private 2 | 6005064.21519 | 2118169.93221 | 37.7963768588038 | -122.426507729874 | (37.7963768588038, -122.426507729874) | 13 | 9 | 1 | 28858 | 17 | |||||
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 | ||||||||||||||
11227 | 106481 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 301X LAWTON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5993233 | 2104592 | 37.7584195821345 | -122.466458543785 | (37.7584195821345, -122.466458543785) | 1 | 8 | 4 | 56 | 12 | |||||
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 | |||
11384 | 258014 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4222 Moraga Ave | 1 | Sidewalk: Curb side : | Tree | DPW 1 | |||||||||||||||
11602 | 122483 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1295 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5983305 | 2106338 | 37.7626357248351 | -122.500922549214 | (37.7626357248351, -122.500922549214) | 1 | 8 | 3 | 56 | 35 | ||||
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 | ||||||||||||||
11803 | 261486 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1000 Portola Dr | 13 | Median : Yard | Tree | DPW 1 | 10x10 | 5995664 | 2098286 | 37.741244865522 | -122.457594860017 | (37.741244865522, -122.457594860017) | 1 | 8 | 4 | 59 | 40 | ||||
12279 | 121334 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2401x Sutter St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001103 | 2113984 | 37.7846586481563 | -122.439914057191 | (37.7846586481563, -122.439914057191) | 15 | 6 | 11 | 29490 | 13 | ||||
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 | |||
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 | ||||||||||||||
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 | |||
13802 | 173606 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1199x 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015354 | 2104874 | 37.7604455241109 | -122.389973337883 | (37.7604455241109, -122.389973337883) | 10 | 3 | 8 | 28856 | 29 | ||||
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 | ||
15037 | 262257 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2 Everglade Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986312 | 2095495 | 37.7330398702545 | -122.489725113139 | (37.7330398702545, -122.489725113139) | 1 | 8 | 4 | 64 | 35 | ||||
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 | |||
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 | ||||||||||||||
16147 | 260471 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 Masonic Ave | 6 | Side Yard : Yard | Tree | Private 2 | 5998961 | 2113697 | 37.7837484562249 | -122.447303968308 | (37.7837484562249, -122.447303968308) | 15 | 6 | 1 | 54 | 31 | |||||
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 | ||||||||||||||
16399 | 262491 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3940 Judah St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5982210 | 2105632 | 37.760632897171 | -122.504657384045 | (37.760632897171, -122.504657384045) | 1 | 8 | 3 | 56 | 35 | ||||
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 | ||||||||||||||
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 | ||||||||||||||
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 | ||
17550 | 122763 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 86X Park Hill Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001171 | 2107689 | 37.7673780360046 | -122.439227450619 | (37.7673780360046, -122.439227450619) | 15 | 5 | 5 | 29492 | 3 | ||||
17827 | 262490 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3940 Judah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5982210 | 2105632 | 37.760632897171 | -122.504657384045 | (37.760632897171, -122.504657384045) | 1 | 8 | 3 | 56 | 35 | ||||
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 | ||||
18044 | 262512 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2230 Jerrold Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012281 | 2099339 | 37.74507671213 | -122.400212745638 | (37.74507671213, -122.400212745638) | 10 | 3 | 8 | 58 | 1 | ||||
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 |
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) );