trees
8,758 rows where qSpecies_id = 16 sorted by DBH 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6635 | 8146 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1000 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 4X4 | 6002926.0085 | 2111351.5233 | 37.7775341328911 | -122.433418880148 | (37.7775341328911, -122.433418880148) | 15 | 5 | 11 | 29492 | 41 | |||
53956 | 12603 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 645 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 3X3 | 5993471.58312 | 2114823.45454 | 37.7865261918162 | -122.466377023021 | (37.7865261918162, -122.466377023021) | 11 | 6 | 2 | 54 | 11 | |||
54620 | 8176 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1200 Fulton St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6001924.4605 | 2111208.7057 | 37.7770851190514 | -122.436873336808 | (37.7770851190514, -122.436873336808) | 15 | 5 | 11 | 29492 | 41 | |||
58611 | 8173 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1200 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6001985.2987 | 2111217.5273 | 37.7771127985152 | -122.436663510376 | (37.7771127985152, -122.436663510376) | 15 | 5 | 11 | 29492 | 41 | |||
65481 | 8174 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1200 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6001968.8724 | 2111216.0063 | 37.7771076887262 | -122.436720225115 | (37.7771076887262, -122.436720225115) | 15 | 5 | 11 | 29492 | 41 | |||
87103 | 14421 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2X Masonic Ave | 9 | Median : Cutout | Tree | DPW 1 | 90 | 3X3 | 5998843.9665 | 2113055.4136 | 37.7819801389805 | -122.447662657424 | (37.7819801389805, -122.447662657424) | 15 | 5 | 2 | 54 | 16 | |||
92306 | 8150 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1000 Fulton St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 4X4 | 6002846.3106 | 2111341.485 | 37.7775020483312 | -122.433693863913 | (37.7775020483312, -122.433693863913) | 15 | 5 | 11 | 29492 | 41 | |||
95615 | 8167 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1124 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6002248.7279 | 2111258.593 | 37.7772405215532 | -122.435755166091 | (37.7772405215532, -122.435755166091) | 15 | 5 | 11 | 29492 | 41 | |||
138767 | 8175 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1200 Fulton St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6001945.7539 | 2111212.6602 | 37.7770971873076 | -122.436799959546 | (37.7770971873076, -122.436799959546) | 15 | 5 | 11 | 29492 | 41 | |||
159244 | 12589 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 501 Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 3X3 | 5993835.87193 | 2114839.30681 | 37.7865907308189 | -122.465117835634 | (37.7865907308189, -122.465117835634) | 11 | 6 | 2 | 54 | 11 | |||
1485 | 70364 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4039 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 5982287.6338 | 2104871.478 | 37.7585492864556 | -122.504332547004 | (37.7585492864556, -122.504332547004) | 1 | 8 | 3 | 56 | 35 | |||
1966 | 61296 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2360 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1986 12:00:00 AM | 9 | Permit Number 23055 | 6006748.00387 | 2119357.01746 | 37.7997313381808 | -122.420765770421 | (37.7997313381808, -122.420765770421) | 5 | 9 | 1 | 28858 | 32 | |
3103 | 60359 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1313 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/27/1982 12:00:00 AM | 9 | Permit Number 19937 | 6016370.5081 | 2094099.468 | 37.7309171984938 | -122.385706704196 | (37.7309171984938, -122.385706704196) | 10 | 3 | 8 | 58 | 1 | |
3290 | 122954 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 201 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5993081.91997 | 2114080.47457 | 37.7844636809028 | -122.467671095614 | (37.7844636809028, -122.467671095614) | 11 | 6 | 2 | 54 | 11 | |||
4091 | 210316 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 450 Parnassus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5995716.2843 | 2106399.35256 | 37.7635250903217 | -122.458001093579 | (37.7635250903217, -122.458001093579) | 15 | 5 | 11 | 56 | 12 | |||
4927 | 60400 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1515 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 9 | Permit Number 19981 | 6015674.9738 | 2094268.7486 | 37.731343497592 | -122.388123111176 | (37.731343497592, -122.388123111176) | 10 | 3 | 8 | 58 | 1 | |
5233 | 65185 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 247 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/1989 12:00:00 AM | 9 | Permit Number 27169 | 6003009.64323 | 2091977.07087 | 37.7243412033768 | -122.43174590807 | (37.7243412033768, -122.43174590807) | 9 | 7 | 6 | 28861 | 5 | |
5381 | 131608 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2318 Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6008064.43802 | 2120372.10874 | 37.8025926337993 | -122.416282346076 | (37.8025926337993, -122.416282346076) | 5 | 1 | 10 | 308 | 32 | |||
5620 | 250454 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 200 Seacliff Ave | 1 | : | Tree | Private 2 | 9 | Width 4ft | 5987161.73503 | 2115752.97281 | 37.7887122778945 | -122.488275583153 | (37.7887122778945, -122.488275583153) | 11 | 6 | 1 | 55 | 33 | |||
5751 | 209873 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 449 Parnassus Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5995567.09272 | 2106280.19552 | 37.7631893428269 | -122.458508470412 | (37.7631893428269, -122.458508470412) | 15 | 5 | 4 | 63 | 12 | |||
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 | |||
6725 | 209934 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2497 Funston Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5992330.36628 | 2098511.09323 | 37.7416708550141 | -122.469137657486 | (37.7416708550141, -122.469137657486) | 1 | 8 | 4 | 29491 | 40 | |||
9881 | 213143 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 233 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5995623.80037 | 2091512.74066 | 37.7226448283785 | -122.457243989419 | (37.7226448283785, -122.457243989419) | 9 | 8 | 4 | 28861 | 24 | |||
11135 | 231408 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 301X Powhattan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6008046.11593 | 2098164.93005 | 37.7416159298358 | -122.414773197351 | (37.7416159298358, -122.414773197351) | 2 | 7 | 7 | 28859 | 2 | |||
11198 | 141214 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3333 CALIFORNIA ST | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5998764.522 | 2114890.4212 | 37.7870140492715 | -122.448069662403 | (37.7870140492715, -122.448069662403) | 15 | 6 | 1 | 54 | 31 | |||
11411 | 209829 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 408 Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5994458.79503 | 2106705.86696 | 37.764294369523 | -122.46237254966 | (37.764294369523, -122.46237254966) | 11 | 5 | 11 | 56 | 12 | |||
11650 | 213242 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 116 Majestic Ave | 2 | : | Tree | Private 2 | 9 | Width 3ft | 5997026.98347 | 2089301.08259 | 37.7166526221889 | -122.452234013791 | (37.7166526221889, -122.452234013791) | 9 | 8 | 6 | 28861 | 24 | |||
12589 | 142807 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 560 Polk St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6007175.9825 | 2112820.8168 | 37.7818086588347 | -122.418820996316 | (37.7818086588347, -122.418820996316) | 7 | 9 | 9 | 28852 | 36 | |||
13207 | 210348 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 349 Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5991814.98108 | 2097712.03468 | 37.7394470501364 | -122.470861477093 | (37.7394470501364, -122.470861477093) | 1 | 8 | 4 | 59 | 40 | |||
13455 | 131485 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 75 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6008130.48281 | 2112560.90329 | 37.7811486961987 | -122.415500453895 | (37.7811486961987, -122.415500453895) | 7 | 10 | 9 | 28852 | 36 | |||
14126 | 27524 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3201 California St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | 3X3 | 5999021.2149 | 2114925.4479 | 37.7871248935498 | -122.447184087894 | (37.7871248935498, -122.447184087894) | 15 | 6 | 1 | 54 | 31 | |||
14271 | 74932 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1494 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 4.5x6 | 5982503.1091 | 2104954.5575 | 37.7587900699554 | -122.503593501173 | (37.7587900699554, -122.503593501173) | 1 | 8 | 3 | 56 | 35 | ||
15122 | 78380 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1027 Russia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6x4 | 6003865.37713 | 2089493.15016 | 37.7175693740048 | -122.428610778768 | (37.7175693740048, -122.428610778768) | 9 | 7 | 6 | 28861 | 5 | ||
15135 | 182891 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2701 45th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5982435.5854 | 2096557.1815 | 37.7357292403034 | -122.503205291534 | (37.7357292403034, -122.503205291534) | 1 | 8 | 3 | 29491 | 35 | |||
15319 | 124408 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3934 Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5995920.28595 | 2115219.75913 | 37.787755325276 | -122.457933860098 | (37.787755325276, -122.457933860098) | 11 | 6 | 1 | 54 | 31 | |||
15371 | 209896 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 850 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5991895.12342 | 2105938.54186 | 37.7620395398243 | -122.471183574658 | (37.7620395398243, -122.471183574658) | 1 | 8 | 11 | 56 | 12 | |||
15855 | 73381 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1475 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 5982456.3495 | 2105084.8019 | 37.7591449348846 | -122.503764860601 | (37.7591449348846, -122.503764860601) | 1 | 8 | 3 | 56 | 35 | |||
16101 | 131675 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 611 Montgomery St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6011754.46444 | 2117581.93802 | 37.7951383017382 | -122.403316534134 | (37.7951383017382, -122.403316534134) | 3 | 1 | 10 | 28860 | 4 | |||
16970 | 60371 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1443 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 9 | 3x3 | Permit Number 19949 | 6015704.6529 | 2094599.8899 | 37.7322543895383 | -122.388043603722 | (37.7322543895383, -122.388043603722) | 10 | 3 | 8 | 58 | 1 |
17038 | 59845 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1242 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 9 | 3x3 | Permit Number 19956 | 6016795.10947 | 2093858.56743 | 37.7302792190936 | -122.38422200256 | (37.7302792190936, -122.38422200256) | 10 | 3 | 8 | 58 | 1 |
17250 | 142143 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3301 GEARY BLVD | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5996871.8135 | 2112889.0793 | 37.7814105195996 | -122.454473344154 | (37.7814105195996, -122.454473344154) | 11 | 6 | 2 | 54 | 16 | |||
18325 | 231317 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3982 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6004019.96915 | 2100738.14503 | 37.7484543441139 | -122.428877661575 | (37.7484543441139, -122.428877661575) | 2 | 4 | 5 | 28862 | 22 | |||
18594 | 232209 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 6 Park Hill Ave | 12 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 6001153.56951 | 2107660.61538 | 37.7672991069859 | -122.439285705372 | (37.7672991069859, -122.439285705372) | 15 | 5 | 5 | 29492 | 3 | |||
19356 | 232579 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 500x 27th St | 25 | Median : Cutout | Tree | DPW 1 | 9 | Width 4ft | 6002958.22552 | 2100071.04753 | 37.7465624978722 | -122.432501505848 | (37.7465624978722, -122.432501505848) | 2 | 7 | 5 | 63 | 22 | |||
19671 | 232252 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 280 Beacon St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6002922.77177 | 2097914.27869 | 37.7406385016668 | -122.432470079036 | (37.7406385016668, -122.432470079036) | 2 | 7 | 5 | 63 | 7 | |||
20108 | 95282 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2549 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 5986028.4364 | 2102948.921 | 37.7534897766964 | -122.491253852674 | (37.7534897766964, -122.491253852674) | 1 | 8 | 3 | 56 | 35 | |||
20804 | 250778 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 262 32nd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 5985912.05089 | 2114139.62959 | 37.7842095154089 | -122.492480388582 | (37.7842095154089, -122.492480388582) | 11 | 6 | 1 | 55 | 33 | |||
21947 | 193920 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 151 Berry St | 23 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6015113.53371 | 2111034.03481 | 37.7773462879393 | -122.391235610162 | (37.7773462879393, -122.391235610162) | 6 | 2 | 9 | 28856 | 20 | |||
22482 | 193893 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 10 De Boom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6014872.0348 | 2112972.27336 | 37.7826548483902 | -122.392206628835 | (37.7826548483902, -122.392206628835) | 6 | 2 | 9 | 28856 | 6 | |||
22786 | 209841 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 749 Parnassus Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5994719.88794 | 2106012.35408 | 37.7624051942773 | -122.461419229638 | (37.7624051942773, -122.461419229638) | 15 | 5 | 11 | 56 | 12 | |||
23822 | 210055 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 430 Edna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5998778.10372 | 2094264.62441 | 37.7303815169854 | -122.446538187299 | (37.7303815169854, -122.446538187299) | 9 | 7 | 4 | 28861 | 40 | |||
24092 | 193808 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 285 Texas St | 2 | : | Tree | Private 2 | 9 | Width 3ft | 6013779.37544 | 2105782.77884 | 37.7628533785923 | -122.395482946298 | (37.7628533785923, -122.395482946298) | 14 | 3 | 8 | 28856 | 29 | |||
24437 | 232673 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 240 Coso Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007720.20174 | 2099466.78066 | 37.7451722044469 | -122.415992272452 | (37.7451722044469, -122.415992272452) | 2 | 7 | 7 | 28859 | 2 | |||
24702 | 231218 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2350 22nd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6011097.99403 | 2103712.0487 | 37.7570181104029 | -122.404611179272 | (37.7570181104029, -122.404611179272) | 10 | 4 | 8 | 28859 | 19 | |||
24837 | 182800 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1844 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5988215.9683 | 2103104.473 | 37.7540444574828 | -122.483700393918 | (37.7540444574828, -122.483700393918) | 1 | 8 | 3 | 56 | 35 | |||
26947 | 184519 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1951 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5981334.3609 | 2101610.8343 | 37.7495403714561 | -122.507387417699 | (37.7495403714561, -122.507387417699) | 1 | 8 | 3 | 29491 | 35 | |||
27155 | 8784 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3540 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3X3 | 5996032.85664 | 2112932.5799 | 37.7814818094971 | -122.457378857535 | (37.7814818094971, -122.457378857535) | 11 | 6 | 1 | 54 | 31 | |||
27187 | 116311 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1515 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 6001644.4919 | 2113785.0974 | 37.7841433216068 | -122.438026427359 | (37.7841433216068, -122.438026427359) | 15 | 6 | 11 | 29490 | 13 | ||||
27951 | 232571 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4388 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6000720.02529 | 2101726.07569 | 37.7509796323187 | -122.440359615531 | (37.7509796323187, -122.440359615531) | 2 | 4 | 5 | 28862 | 22 | |||
28376 | 139375 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2451 SUTTER ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6000996.0798 | 2114152.7262 | 37.7851158399965 | -122.440296068741 | (37.7851158399965, -122.440296068741) | 15 | 6 | 11 | 29490 | 13 | |||
28826 | 183225 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2195 Rivera St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 0ft | 5981668.485 | 2100141.7164 | 37.7455262605285 | -122.506123109259 | (37.7455262605285, -122.506123109259) | 1 | 8 | 3 | 29491 | 35 | |||
29248 | 56014 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2514 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/12/1974 12:00:00 AM | 9 | Permit Number 12097 | 5997060.1608 | 2110812.0765 | 37.7757184145069 | -122.453671734403 | (37.7757184145069, -122.453671734403) | 15 | 6 | 2 | 54 | 16 | ||
29920 | 184520 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1951 48th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5981335.7145 | 2101600.3432 | 37.7495116455819 | -122.507381958717 | (37.7495116455819, -122.507381958717) | 1 | 8 | 3 | 29491 | 35 | |||
30827 | 131559 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1067 Green St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007926.31383 | 2118874.38942 | 37.7984725040564 | -122.41665416448 | (37.7984725040564, -122.41665416448) | 5 | 1 | 10 | 28858 | 21 | |||
31244 | 231258 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 19 Cumberland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6005474.65034 | 2104574.92503 | 37.7590714802805 | -122.424120217369 | (37.7590714802805, -122.424120217369) | 2 | 4 | 5 | 28859 | 19 | |||
32170 | 5307 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1635 Divisadero St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3X3 | 6001124.6062 | 2113907.9724 | 37.7844511257674 | -122.439833854271 | (37.7844511257674, -122.439833854271) | 15 | 6 | 11 | 29490 | 13 | |||
32939 | 122232 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 664 14th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 5991656.88331 | 2110756.8131 | 37.7752554351498 | -122.472358810173 | (37.7752554351498, -122.472358810173) | 11 | 6 | 2 | 54 | 26 | |||
33216 | 250048 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 50 Daniel Burnham Ct | 7 | : | Tree | Private 2 | 9 | Width 3ft | 6005996.49093 | 2114715.62099 | 37.7869448420797 | -122.423036209646 | (37.7869448420797, -122.423036209646) | 13 | 9 | 1 | 28858 | 41 | |||
33888 | 119224 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 731 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5981025.77438 | 2110715.4681 | 37.7745208888731 | -122.509130508226 | (37.7745208888731, -122.509130508226) | 11 | 6 | 2 | 55 | 26 | |||
34499 | 66464 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 55 Wood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/1991 12:00:00 AM | 9 | Permit Number 29614 | 5998385.1512 | 2113437.238 | 37.7830022962548 | -122.449277458337 | (37.7830022962548, -122.449277458337) | 15 | 6 | 1 | 54 | 31 | |
35637 | 232258 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 297 Addison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002432.63098 | 2097705.94364 | 37.7400386556651 | -122.4341499065 | (37.7400386556651, -122.4341499065) | 2 | 7 | 5 | 63 | 7 | |||
36323 | 184257 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3917 Kirkham St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 0ft | 5982725.806 | 2104886.1449 | 37.7586153188015 | -122.502818261057 | (37.7586153188015, -122.502818261057) | 1 | 8 | 3 | 56 | 35 | |||
37619 | 232639 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 355 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5995990.17982 | 2106431.82414 | 37.7636299818619 | -122.457056130933 | (37.7636299818619, -122.457056130933) | 15 | 5 | 4 | 29492 | 12 | |||
38064 | 250040 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 10 Daniel Burnham Ct | 2 | : | Tree | Private 2 | 9 | Width 3ft | 6006198.948 | 2114743.14871 | 37.7870318487916 | -122.422337709814 | (37.7870318487916, -122.422337709814) | 13 | 9 | 1 | 28858 | 41 | |||
38526 | 131585 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1232 Filbert St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6007102.45973 | 2119505.49835 | 37.800159000888 | -122.419549760231 | (37.800159000888, -122.419549760231) | 5 | 1 | 1 | 28858 | 32 | |||
38621 | 193859 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 90 Stevenson St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 9 | Width 4ft | 6012502.23298 | 2115355.06002 | 37.7890655567855 | -122.400572617131 | (37.7890655567855, -122.400572617131) | 12 | 2 | 9 | 28855 | 6 | |||
38854 | 40217 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 755 La Playa | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1999 12:00:00 AM | 9 | Permit Number 41396 | 5980721.24963 | 2110609.89549 | 37.7742130596134 | -122.51017605379 | (37.7742130596134, -122.51017605379) | 11 | 6 | 2 | 55 | 26 | |
40339 | 250779 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 262 32nd Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 5985912.1837 | 2114145.86634 | 37.7842266474879 | -122.492480388561 | (37.7842266474879, -122.492480388561) | 11 | 6 | 1 | 55 | 33 | |||
40905 | 213216 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 211 Farallones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5994887.0913 | 2088379.52093 | 37.7139994126132 | -122.459563796032 | (37.7139994126132, -122.459563796032) | 9 | 8 | 6 | 28861 | 24 | |||
41370 | 108354 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 140 COLLEGE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 9x5 | 6004696.1 | 2095922.4 | 37.735269652849 | -122.426196812164 | (37.735269652849, -122.426196812164) | 2 | 7 | 5 | 28861 | 2 | |||
41451 | 184435 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3818 Quintara St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5981578.363 | 2100820.7886 | 37.7473854973256 | -122.506485082857 | (37.7473854973256, -122.506485082857) | 1 | 8 | 3 | 29491 | 35 | |||
41466 | 232250 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 280 Beacon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6002944.36476 | 2097884.92462 | 37.7405591266105 | -122.432393322787 | (37.7405591266105, -122.432393322787) | 2 | 7 | 5 | 63 | 7 | |||
41851 | 231250 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 915 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009958.53706 | 2103864.01655 | 37.7573716312054 | -122.408562590785 | (37.7573716312054, -122.408562590785) | 2 | 4 | 7 | 28859 | 19 | |||
42206 | 183292 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4006 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5983284.089 | 2106318.1786 | 37.762580073092 | -122.500993405664 | (37.762580073092, -122.500993405664) | 1 | 8 | 3 | 56 | 35 | |||
42501 | 56835 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1650 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/02/1974 12:00:00 AM | 9 | 3x3 | Permit Number 14066 | 5988818.5665 | 2103123.6691 | 37.7541322232503 | -122.481617894691 | (37.7541322232503, -122.481617894691) | 1 | 8 | 3 | 56 | 35 | |
43468 | 53972 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4535 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/1972 12:00:00 AM | 9 | Permit Number 9687 | 5981468.43648 | 2110942.49917 | 37.7751703368006 | -122.507616130998 | (37.7751703368006, -122.507616130998) | 11 | 6 | 2 | 55 | 26 | ||
45250 | 209935 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2497 Funston Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5992331.90989 | 2098489.07773 | 37.7416104952368 | -122.469130718332 | (37.7416104952368, -122.469130718332) | 1 | 8 | 4 | 29491 | 40 | |||
45347 | 193795 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2200 20th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6011469.75754 | 2104666.96332 | 37.759660864481 | -122.403392650047 | (37.759660864481, -122.403392650047) | 10 | 3 | 8 | 28856 | 29 | |||
45377 | 110942 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2472 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 5984287.5536 | 2098355.7059 | 37.7407761911521 | -122.496935118791 | (37.7407761911521, -122.496935118791) | 1 | 8 | 3 | 29491 | 35 | |||
45844 | 213209 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 263 Minerva St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5994446.26249 | 2089007.27998 | 37.7156977319386 | -122.461132931352 | (37.7156977319386, -122.461132931352) | 9 | 8 | 6 | 28861 | 24 | |||
46042 | 185268 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2601 Sunset Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 0ft | 5985025.0471 | 2097388.4377 | 37.7381635204764 | -122.494313900939 | (37.7381635204764, -122.494313900939) | 1 | 8 | 3 | 29491 | 35 | |||
46788 | 113189 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 25 Point Lobos Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3X3 | 5982748.86125 | 2112489.82297 | 37.7794941834215 | -122.503301521808 | (37.7794941834215, -122.503301521808) | 11 | 6 | 2 | 55 | 26 | |||
46812 | 131625 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2 John Maher St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6012570.48986 | 2119721.62868 | 37.8010589209946 | -122.400643327244 | (37.8010589209946, -122.400643327244) | 3 | 1 | 10 | 28860 | 6 | |||
48663 | 124120 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4420 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5993242.80554 | 2112831.55186 | 37.7810437673008 | -122.467023660903 | (37.7810437673008, -122.467023660903) | 11 | 6 | 2 | 54 | 11 | |||
48842 | 31109 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 415 Edna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/21/1995 12:00:00 AM | 9 | Permit Number 34838 | 5998750.71169 | 2094265.01214 | 37.7303810169512 | -122.446632912889 | (37.7303810169512, -122.446632912889) | 9 | 7 | 4 | 28861 | 40 | ||
49480 | 251064 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5200 Geary Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5990798.0462 | 2112741.6906 | 37.7806556188752 | -122.475474649381 | (37.7806556188752, -122.475474649381) | 11 | 6 | 2 | 54 | 26 | |||
51785 | 113713 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2500X Clement St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 5987721.03096 | 2113311.65427 | 37.7820417295273 | -122.486161237676 | (37.7820417295273, -122.486161237676) | 11 | 6 | 2 | 55 | 26 | |||
52223 | 131630 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 6 John Maher St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6012421.77135 | 2119692.7375 | 37.8009712973424 | -122.401155929114 | (37.8009712973424, -122.401155929114) | 3 | 1 | 10 | 28860 | 6 | |||
52536 | 131311 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3701 Jackson St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 9 | Width 3ft | 5996479.01622 | 2115904.55519 | 37.7896676762649 | -122.456050298602 | (37.7896676762649, -122.456050298602) | 11 | 6 | 1 | 54 | 31 | |||
52871 | 209955 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1100 Ulloa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5992680.60052 | 2098475.10494 | 37.7415922713624 | -122.467924058348 | (37.7415922713624, -122.467924058348) | 1 | 8 | 4 | 59 | 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) );