trees
8,659 rows where qSpecies_id = 11 sorted by Supervisor Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
194389 | 265057 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 1190 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/2020 12:00:00 AM | 3 | 4x4 | Permit Number 781590 | |||||||||||
194396 | 265058 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 1190 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/2020 12:00:00 AM | 3 | 4x4 | Permit Number 781590 | |||||||||||
194403 | 265059 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 1190 Mason St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/2020 12:00:00 AM | 3 | 4x4 | Permit Number 781590 | |||||||||||
714 | 129877 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1800 Jefferson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 5ft | 6000546.03686 | 2121364.03146 | 37.8048905527229 | -122.442370961862 | (37.8048905527229, -122.442370961862) | 13 | 9 | 1 | 57 | 17 | |||
1602 | 45381 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/06/2001 12:00:00 AM | Permit Number 44200 | 5989322.60767277 | 2117225.76237725 | 37.7928819736725 | -122.480907237859 | (37.7928819736725, -122.480907237859) | 11 | 1 | 61 | 30 | |||||
1690 | 52430 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2536 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2005 12:00:00 AM | 12 | Permit Number 48545 | 6002701.73302 | 2117006.28973 | 37.7930479607542 | -122.434599161948 | (37.7930479607542, -122.434599161948) | 13 | 9 | 1 | 29490 | 27 | |
1865 | 250727 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2720 Lake St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 4ft | 5986989.77084 | 2114474.42914 | 37.7851917306499 | -122.488776528028 | (37.7851917306499, -122.488776528028) | 11 | 6 | 1 | 55 | 33 | |||
2256 | 34592 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3150 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | 7 | Permit Number 38288 | 5999079.37666 | 2116641.84681 | 37.7918409959053 | -122.447106431134 | (37.7918409959053, -122.447106431134) | 11 | 6 | 1 | 29490 | 30 | |
3616 | 7957 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1800 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/22/2016 03:18:00 PM | 3 | 3X3 | 6005720.43568 | 2116275.48789 | 37.7912122663809 | -122.424102272302 | (37.7912122663809, -122.424102272302) | 13 | 9 | 1 | 28858 | 27 | ||
4632 | 143126 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2055 LOMBARD ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6002559.0217 | 2119480.0502 | 37.7998321621177 | -122.435269976592 | (37.7998321621177, -122.435269976592) | 13 | 9 | 1 | 57 | 17 | |||
4915 | 26860 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1483 Sutter St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/2008 12:00:00 AM | 3 | 3X3 | 6005670.64359 | 2114807.23754 | 37.7871780057048 | -122.424170086605 | (37.7871780057048, -122.424170086605) | 13 | 9 | 1 | 28858 | 41 | ||
6836 | 12723 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1538 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/08/2012 12:00:00 AM | 3 | 3x3 | 5990625.74037 | 2114773.38232 | 37.7862240892432 | -122.476219173709 | (37.7862240892432, -122.476219173709) | 11 | 6 | 1 | 54 | 33 | ||
7398 | 13267 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 2460 Lombard St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/20/2020 12:00:00 AM | 3 | 3X3 | Permit Number 781193 | 6000572.6787 | 2119285.0637 | 37.7991837803388 | -122.442129440006 | (37.7991837803388, -122.442129440006) | 13 | 9 | 1 | 57 | 17 | |
8764 | 13266 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 2460 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/20/2020 12:00:00 AM | 3 | 3X3 | Permit Number 781193 | 6000592.3683 | 2119282.3787 | 37.7991775301158 | -122.442061114605 | (37.7991775301158, -122.442061114605) | 13 | 9 | 1 | 57 | 17 | |
9181 | 26766 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1661 Pine St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3X3 | 6006110.12347 | 2115558.4451 | 37.7892654396548 | -122.422702983606 | (37.7892654396548, -122.422702983606) | 13 | 9 | 1 | 28858 | 41 | |||
9219 | 74232 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 400 Locust St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 5997684.08326 | 2115006.73382 | 37.7872715918672 | -122.451816113239 | (37.7872715918672, -122.451816113239) | 11 | 6 | 1 | 54 | 31 | |||
9704 | 13240 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2346 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/2019 12:00:00 AM | 3 | 3x3 | Permit Number 774035 | 6001131.9237 | 2119364.2962 | 37.7994331868979 | -122.440199950322 | (37.7994331868979, -122.440199950322) | 13 | 9 | 1 | 57 | 17 | |
10068 | 49666 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3630 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 04/18/2011 12:00:00 AM | 6 | Permit Number 46510 | 6000245.17413 | 2120665.11682 | 37.8029543681198 | -122.443361894237 | (37.8029543681198, -122.443361894237) | 13 | 9 | 1 | 57 | 17 | ||
10590 | 13232 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2301 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/12/1995 12:00:00 AM | 10 | 3X3 | 6001301 | 2119283 | 37.7992195934801 | -122.439609056557 | (37.7992195934801, -122.439609056557) | 13 | 9 | 1 | 57 | 17 | ||
10649 | 76037 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2999X Polk St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/16/1996 12:00:00 AM | 6 | 4x6 | 6005804.42794414 | 2120704.37010887 | 37.8033775968655 | -122.42412676624 | (37.8033775968655, -122.42412676624) | 5 | 9 | 1 | 28858 | 32 | |
10777 | 35244 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2999X Polk St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1998 12:00:00 AM | Permit Number 38736 | 6005802.2 | 2120854.7 | 37.8037902383764 | -122.424145173625 | (37.8037902383764, -122.424145173625) | 5 | 9 | 1 | 28858 | 32 | |||
11600 | 260651 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 3751 Sacramento St | 2 | Front Yard : Cutout | Tree | Private 2 | Width 3ft | 5996933 | 2115011 | 37.7872402598449 | -122.454414995547 | (37.7872402598449, -122.454414995547) | 11 | 6 | 1 | 54 | 31 | ||||
12635 | 74018 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 400 Locust St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 5997681.3026 | 2115023.11514 | 37.7873164113684 | -122.451826915892 | (37.7873164113684, -122.451826915892) | 11 | 6 | 1 | 54 | 31 | |||
12918 | 42635 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1651 Union St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/07/2020 11:32:00 AM | 3 | 4x5 | Permit Number 42688 | 6005113.34773 | 2118824.42387 | 37.7981767035488 | -122.426384344263 | (37.7981767035488, -122.426384344263) | 13 | 9 | 1 | 57 | 17 |
13407 | 42632 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1651 Union St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/07/2020 12:07:00 PM | 3 | 4x4 | Permit Number 42688 | 6005134.31421 | 2118828.07494 | 37.7981879136105 | -122.426312054082 | (37.7981879136105, -122.426312054082) | 13 | 9 | 1 | 57 | 17 |
13480 | 26768 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1661 Pine St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6006153.01253 | 2115563.98266 | 37.7892830640976 | -122.42255498602 | (37.7892830640976, -122.42255498602) | 13 | 9 | 1 | 28858 | 41 | |||
14068 | 13261 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2443 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/14/1997 12:00:00 AM | 6 | 3X3 | 6000701.59201 | 2119217.25602 | 37.7990049442386 | -122.441678488129 | (37.7990049442386, -122.441678488129) | 13 | 9 | 1 | 57 | 17 | ||
15243 | 98997 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2190X North Point St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6000277.5 | 2120626.8 | 37.8028510037355 | -122.443247276641 | (37.8028510037355, -122.443247276641) | 13 | 9 | 1 | 57 | 17 | ||||
15563 | 42636 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1651 Union St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/07/2020 11:48:00 AM | 3 | 4x5 | Permit Number 42688 | 6005181.30457 | 2118838.80185 | 37.7982200229931 | -122.426150217479 | (37.7982200229931, -122.426150217479) | 13 | 9 | 1 | 57 | 17 |
15568 | 73765 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 400 Locust St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 5997676.95142 | 2115046.52536 | 37.7873804404128 | -122.451843659469 | (37.7873804404128, -122.451843659469) | 11 | 6 | 1 | 54 | 31 | |||
15593 | 130235 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2941 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6005988.60064 | 2120959.86285 | 37.8040895112914 | -122.42350760369 | (37.8040895112914, -122.42350760369) | 5 | 9 | 1 | 28858 | 32 | |||
16260 | 260650 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 3751 Sacramento St | 1 | Front Yard : Cutout | Tree | Private 2 | Width 3ft | 5996933 | 2115011 | 37.7872402598449 | -122.454414995547 | (37.7872402598449, -122.454414995547) | 11 | 6 | 1 | 54 | 31 | ||||
16378 | 261659 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 2401 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000878 | 2119196 | 37.7989566302666 | -122.441066533327 | (37.7989566302666, -122.441066533327) | 13 | 9 | 1 | 57 | 17 | ||||
16390 | 12806 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2100X Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/24/2014 12:00:00 AM | 3 | 5 | 5988917.68392 | 2114715.00312 | 37.7859645990864 | -122.4821242546 | (37.7859645990864, -122.4821242546) | 11 | 6 | 1 | 55 | 33 | ||
16686 | 99005 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2099X Beach St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | Permit Number 46510 | 6000381.4 | 2120794.3 | 37.8033168379221 | -122.442899765771 | (37.8033168379221, -122.442899765771) | 13 | 9 | 1 | 57 | 17 | ||||
17069 | 45774 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 610 El Camino Del Mar | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2001 12:00:00 AM | Permit Number 44417 | 5986681.45723276 | 2115112.83682499 | 37.7869266168429 | -122.489890152931 | (37.7869266168429, -122.489890152931) | 11 | 6 | 1 | 55 | 33 | |||
17749 | 13265 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 2460 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/20/2020 12:00:00 AM | 3 | 3X3 | Permit Number 781193 | 6000636.2224 | 2119294.0135 | 37.7992119752158 | -122.441910200363 | (37.7992119752158, -122.441910200363) | 13 | 9 | 1 | 57 | 17 | |
17940 | 42637 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1651 Union St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/07/2020 11:43:00 AM | 3 | 4x4 | Permit Number 42688 | 6005203.48268 | 2118840.06651 | 37.7982247489172 | -122.42607356464 | (37.7982247489172, -122.42607356464) | 13 | 9 | 1 | 57 | 17 |
19746 | 256618 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1255 Columbus Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 6007516.58505 | 2121541.63395 | 37.8057730322633 | -122.418261164826 | (37.8057730322633, -122.418261164826) | 5 | 1 | 1 | 308 | 32 | ||||
20092 | 129863 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2150 North Point St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6000467.55578 | 2120655.86618 | 37.8029416472097 | -122.442591676161 | (37.8029416472097, -122.442591676161) | 13 | 9 | 1 | 57 | 17 | |||
20374 | 1327 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2001X Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/25/2012 12:00:00 AM | 3 | 3x3 | 6007161.0410492 | 2119546.6911637 | 37.8002754054915 | -122.41934996955 | (37.8002754054915, -122.41934996955) | 5 | 1 | 1 | 28858 | 32 | ||
20930 | 129933 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2245 Vallejo St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6002889.58723 | 2117823.05104 | 37.7953012391235 | -122.434007586974 | (37.7953012391235, -122.434007586974) | 13 | 9 | 1 | 29490 | 27 | |||
21099 | 76027 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2999X Polk St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/16/1996 12:00:00 AM | 6 | 4x4 | 6005804.42794414 | 2120704.37010887 | 37.8033775968655 | -122.42412676624 | (37.8033775968655, -122.42412676624) | 5 | 9 | 1 | 28858 | 32 | |
21222 | 18533 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3048X Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5999384.2843879 | 2114676.1257555 | 37.7864610583451 | -122.445910013189 | (37.7864610583451, -122.445910013189) | 15 | 6 | 1 | 29490 | 31 | |||
21366 | 110901 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2300x Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/20/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775830 | 6005492.72202 | 2117931.87278 | 37.7957474224706 | -122.425008057783 | (37.7957474224706, -122.425008057783) | 13 | 9 | 1 | 28858 | 27 | |
21389 | 130250 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2333 Leavenworth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007531.72548 | 2120344.09497 | 37.8024857457914 | -122.418123815875 | (37.8024857457914, -122.418123815875) | 5 | 1 | 1 | 28858 | 32 | |||
21779 | 34899 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2530 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/2016 12:00:00 AM | 3 | Permit Number 38504 | 6002713.84084 | 2116933.67027 | 37.7928492537523 | -122.434552073422 | (37.7928492537523, -122.434552073422) | 13 | 9 | 1 | 29490 | 27 | ||
22809 | 12793 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2022 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/21/1995 12:00:00 AM | 30 | 3X3 | 5989145.28019 | 2114725.01824 | 37.786005332771 | -122.481337576557 | (37.786005332771, -122.481337576557) | 11 | 6 | 1 | 55 | 33 | ||
22919 | 87960 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1792- 1796 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50995 | 6004410 | 2118774 | 37.7979984691166 | -122.428814538952 | (37.7979984691166, -122.428814538952) | 13 | 9 | 1 | 57 | 17 | ||
23387 | 129871 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2051 Beach St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6000279.3397 | 2120931.08359 | 37.8036865898136 | -122.443262778155 | (37.8036865898136, -122.443262778155) | 13 | 9 | 1 | 57 | 17 | |||
23750 | 52217 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2655 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/2008 12:00:00 AM | 7 | 3x3 | Permit Number 48401 | 6005661.93398 | 2119519.49914 | 37.8001161980736 | -122.424535539885 | (37.8001161980736, -122.424535539885) | 13 | 9 | 1 | 57 | 17 | |
23962 | 129940 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2049 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6003749.71311 | 2117940.72233 | 37.7956731096831 | -122.431039816153 | (37.7956731096831, -122.431039816153) | 13 | 9 | 1 | 29490 | 27 | |||
24016 | 13282 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2532 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/26/1993 12:00:00 AM | 0 | 3x3 | 6000258 | 2119239 | 37.7990393633551 | -122.443215022549 | (37.7990393633551, -122.443215022549) | 13 | 9 | 1 | 57 | 17 | ||
24557 | 87727 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2238X Van Ness Ave | 5 | Median : Cutout | Tree | DPW 1 | 01/25/2008 12:00:00 AM | 3 | 3x3 | 6005927.4039 | 2118140.07713 | 37.7963436433 | -122.423518786778 | (37.7963436433, -122.423518786778) | 13 | 9 | 1 | 28858 | 32 | ||
25219 | 129908 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 65 Cervantes Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6001694.14605 | 2120844.10453 | 37.8035283424228 | -122.438360541313 | (37.8035283424228, -122.438360541313) | 13 | 9 | 1 | 57 | 17 | |||
25369 | 13148 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1839 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/14/1997 12:00:00 AM | 18 | 3X3 | 6003562.8454 | 2119623.2596 | 37.8002823318939 | -122.431806605227 | (37.8002823318939, -122.431806605227) | 13 | 9 | 1 | 57 | 17 | ||
25527 | 117367 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 3199X LAGUNA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003762 | 2119666 | 37.8004109732815 | -122.431120504486 | (37.8004109732815, -122.431120504486) | 13 | 9 | 1 | 57 | 17 | ||||
25637 | 76093 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2999X Polk St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/16/1996 12:00:00 AM | 6 | 3x3 | 6005804.42794414 | 2120704.37010887 | 37.8033775968655 | -122.42412676624 | (37.8033775968655, -122.42412676624) | 5 | 9 | 1 | 28858 | 32 | |
26409 | 129855 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 112 Moulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6002709.70924 | 2119395.93366 | 37.799609756141 | -122.434742523747 | (37.799609756141, -122.434742523747) | 13 | 9 | 1 | 57 | 17 | |||
26732 | 9905 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1801 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2016 12:00:00 AM | 3 | 3X3 | Permit Number 779094 | 6005234.1394 | 2115947.34634 | 37.790283803614 | -122.425761478317 | (37.790283803614, -122.425761478317) | 13 | 9 | 1 | 28858 | 27 | |
27047 | 130226 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1400x Van Ness Ave | 6 | Median : Cutout | Tree | DPW 1 | 4 | Width 4ft | 6006285.03142 | 2115530.78249 | 37.7891993516294 | -122.422095856054 | (37.7891993516294, -122.422095856054) | 13 | 9 | 1 | 28858 | 21 | |||
27058 | 129862 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3630 Divisadero St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 6ft | 6000214.38483 | 2120902.15861 | 37.8036034654848 | -122.443485478179 | (37.8036034654848, -122.443485478179) | 13 | 9 | 1 | 57 | 17 | |||
28659 | 18087 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2996 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | 5999641.9923 | 2114716.1155 | 37.7865855715731 | -122.44502128729 | (37.7865855715731, -122.44502128729) | 15 | 6 | 1 | 29490 | 31 | ||||
28821 | 87755 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 19 Cook St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/27/2008 12:00:00 AM | 3x3 | Permit Number 50410 | 5997460 | 2113566 | 37.7833028815315 | -122.452487379595 | (37.7833028815315, -122.452487379595) | 15 | 6 | 1 | 54 | 31 | ||
29024 | 129885 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3601 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5997717.96247 | 2115099.88043 | 37.7875292880781 | -122.451705620744 | (37.7875292880781, -122.451705620744) | 11 | 6 | 1 | 54 | 31 | |||
29077 | 24419 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1711X Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1995 12:00:00 AM | 18 | 3X3 | 6005291.39458 | 2115516.60231 | 37.7891043236602 | -122.425532710879 | (37.7891043236602, -122.425532710879) | 13 | 9 | 1 | 28858 | 27 | ||
29477 | 249560 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1483 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6005650.48271 | 2114804.03912 | 37.7871680852857 | -122.424239611394 | (37.7871680852857, -122.424239611394) | 13 | 9 | 1 | 28858 | 41 | |||
29670 | 23477 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2400X Van Ness Ave | 4 | Median : Cutout | Tree | DPW 1 | 32 | 9 | 6005826.46835 | 2118791.49543 | 37.7981265753418 | -122.423914390454 | (37.7981265753418, -122.423914390454) | 13 | 9 | 1 | 28858 | 32 | |||
29677 | 47472 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3000 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | Permit Number 45373 | 5999998.46325144 | 2115118.74868782 | 37.78771143635 | -122.443816926647 | (37.78771143635, -122.443816926647) | 13 | 6 | 1 | 29490 | 27 | ||
29751 | 24309 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2532 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 40 | 3x3 | 6000157.29561 | 2119225.57302 | 37.7989967536561 | -122.443562527405 | (37.7989967536561, -122.443562527405) | 13 | 9 | 1 | 57 | 17 | |||
29970 | 64387 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2441 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/1988 12:00:00 AM | 17 | Permit Number 25229 | 6004950.14651 | 2117992.35404 | 37.795882825278 | -122.426889778557 | (37.795882825278, -122.426889778557) | 13 | 9 | 1 | 28858 | 27 | ||
30052 | 13149 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1840 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/15/2014 12:00:00 AM | 3 | 7x5 | 6003547.2086 | 2119700.6621 | 37.8004939726553 | -122.431866244519 | (37.8004939726553, -122.431866244519) | 13 | 9 | 1 | 57 | 17 | ||
30889 | 254841 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 71 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/29/2018 12:00:00 AM | 3 | 3x3 | 5993910 | 2115089 | 37.7872805943627 | -122.464879512834 | (37.7872805943627, -122.464879512834) | 11 | 6 | 1 | 54 | 11 | |
31573 | 6093 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2010 Eddy St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/29/2012 12:00:00 AM | 3 | 3X3 | 6000747.9276 | 2112435.0864 | 37.7803855097501 | -122.441031325867 | (37.7803855097501, -122.441031325867) | 15 | 5 | 1 | 29490 | 41 | ||
31739 | 102357 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3551 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/16/2013 12:00:00 AM | 3 | 3x3 | Permit Number 769877 | 6000702.42644 | 2120580.06982 | 37.8027469161033 | -122.441773461287 | (37.8027469161033, -122.441773461287) | 13 | 9 | 1 | 57 | 17 |
32008 | 96370 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 168 Cervantes Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/2011 12:00:00 AM | 24 | 3x3 | Permit Number 767919 | 6001150.89126 | 2121288.6307 | 37.8047179782121 | -122.440272392077 | (37.8047179782121, -122.440272392077) | 13 | 9 | 1 | 57 | 17 | |
32022 | 14474 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 250 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 5999023.61918 | 2112089.68788 | 37.7793387721051 | -122.446971627792 | (37.7793387721051, -122.446971627792) | 15 | 5 | 1 | 54 | 16 | |||
32580 | 49659 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3630 Divisadero St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/2011 12:00:00 AM | 8 | 6000216.68095 | 2120880.45401 | 37.8035440014225 | -122.443475972348 | (37.8035440014225, -122.443475972348) | 13 | 9 | 1 | 57 | 17 | |||
33908 | 13271 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2498 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/03/1997 12:00:00 AM | 30 | 3x3 | 6000496.39313 | 2119288.99632 | 37.7991902305208 | -122.442393695926 | (37.7991902305208, -122.442393695926) | 13 | 9 | 1 | 57 | 17 | ||
34161 | 17749 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1661 Pine St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3X3 | 6005944.2845 | 2115534.71048 | 37.7891909123744 | -122.423275079495 | (37.7891909123744, -122.423275079495) | 13 | 9 | 1 | 28858 | 41 | |||
34374 | 250065 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1600 Franklin St | 3 | : | Tree | Private 2 | 2 | Width 3ft | 6005813.48437 | 2115655.74749 | 37.7895158671227 | -122.423736241932 | (37.7895158671227, -122.423736241932) | 13 | 9 | 1 | 28858 | 41 | |||
34610 | 129897 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 400 Cherry St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5996264.38909 | 2114700.39578 | 37.7863490565186 | -122.456705760474 | (37.7863490565186, -122.456705760474) | 11 | 6 | 1 | 54 | 31 | |||
35117 | 11110 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2027 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | 5 | 3x3 | 6007193.19069 | 2119311.88557 | 37.7996324991014 | -122.41922205355 | (37.7996324991014, -122.41922205355) | 5 | 1 | 1 | 28858 | 32 | ||
36283 | 13214 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2200 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/08/2003 12:00:00 AM | 20 | 3x3 | 6001803.99728 | 2119454.47327 | 37.799719029379 | -122.437880804599 | (37.799719029379, -122.437880804599) | 13 | 9 | 1 | 57 | 17 | ||
36751 | 121063 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 2901x Polk St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005984 | 2121043 | 37.8043175249008 | -122.423529438764 | (37.8043175249008, -122.423529438764) | 5 | 1 | 1 | 28858 | 32 | ||||
37315 | 129880 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 74 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6001684.60494 | 2120906.53368 | 37.8036992136187 | -122.438398034063 | (37.8036992136187, -122.438398034063) | 13 | 9 | 1 | 57 | 17 | |||
37328 | 129924 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3195 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5998986.03075 | 2116580.385 | 37.79166690426 | -122.447424980874 | (37.79166690426, -122.447424980874) | 13 | 6 | 1 | 29490 | 31 | |||
37508 | 130236 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2941 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6005991.87522 | 2120936.11489 | 37.8040244903099 | -122.423494582406 | (37.8040244903099, -122.423494582406) | 5 | 9 | 1 | 28858 | 32 | |||
37557 | 129852 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3190 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6000940.62214 | 2119185.8879 | 37.798932431747 | -122.440849114708 | (37.798932431747, -122.440849114708) | 13 | 9 | 1 | 57 | 17 | |||
38024 | 26770 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1661 Pine St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6006197.69813 | 2115570.77894 | 37.789304245831 | -122.422400862011 | (37.789304245831, -122.422400862011) | 13 | 9 | 1 | 28858 | 41 | |||
38261 | 29751 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1331 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2006 12:00:00 AM | 8 | 3x3 | 6007205.02077 | 2121826.2812 | 37.8065370584924 | -122.41935958779 | (37.8065370584924, -122.41935958779) | 5 | 1 | 1 | 28858 | 32 | ||
38420 | 250095 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1700 Gough St | 9 | : | Tree | Private 2 | 11 | Width 4ft | 6005324.16733 | 2115642.15375 | 37.789450908188 | -122.425428259725 | (37.789450908188, -122.425428259725) | 13 | 9 | 1 | 28858 | 41 | |||
38812 | 17760 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1661 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6005860.46958 | 2115524.11878 | 37.7891570996581 | -122.423564315834 | (37.7891570996581, -122.423564315834) | 13 | 9 | 1 | 28858 | 41 | |||
38957 | 130240 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2941 Polk St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6006000.03403 | 2120857.11191 | 37.8038080288815 | -122.423460728342 | (37.8038080288815, -122.423460728342) | 5 | 9 | 1 | 28858 | 32 | |||
39192 | 13256 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2419 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1993 12:00:00 AM | 6 | 3X3 | 6000771.23346 | 2119209.53421 | 37.7989877098355 | -122.441436951696 | (37.7989877098355, -122.441436951696) | 13 | 9 | 1 | 57 | 17 | ||
39975 | 121061 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 2901x Polk St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005984 | 2121043 | 37.8043175249008 | -122.423529438764 | (37.8043175249008, -122.423529438764) | 5 | 1 | 1 | 28858 | 32 | ||||
40032 | 23954 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1985X Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/13/1995 12:00:00 AM | 12 | 3X3 | 6002890.93346 | 2119517.51166 | 37.7999538645084 | -122.434124118866 | (37.7999538645084, -122.434124118866) | 13 | 9 | 1 | 57 | 17 | ||
40379 | 250067 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1600 Franklin St | 5 | : | Tree | Private 2 | 2 | Width 3ft | 6005802.81063 | 2115708.11007 | 37.7896590391771 | -122.423776896684 | (37.7896590391771, -122.423776896684) | 13 | 9 | 1 | 28858 | 41 | |||
40677 | 87723 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2238X Van Ness Ave | 1 | Median : Cutout | Tree | DPW 1 | 04/18/2008 12:00:00 AM | 5 | 3x3 | 6005943.63727 | 2118022.22733 | 37.7960209737506 | -122.423454233435 | (37.7960209737506, -122.423454233435) | 13 | 9 | 1 | 28858 | 32 | ||
41068 | 87725 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2238X Van Ness Ave | 3 | Median : Cutout | Tree | DPW 1 | 01/25/2008 12:00:00 AM | 5 | 3x3 | 6005934.54297 | 2118086.35684 | 37.7961965438983 | -122.423490262985 | (37.7961965438983, -122.423490262985) | 13 | 9 | 1 | 28858 | 32 |
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) );