trees
3,247 rows where qSpecies_id = 22 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 78306 | 51628 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 3100ON LYON ST Pacific Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2010 12:00:00 AM | Permit Number 53623 | 5999297.18368594 | 2116674.7385641 | 37.7919437500329 | -122.446355188809 | (37.7919437500329, -122.446355188809) | 11 | 6 | 1 | 29490 | 30 | |||
| 78848 | 123537 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 21 05th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 5994224.72449 | 2115479.15004 | 37.7883699808955 | -122.463818970533 | (37.7883699808955, -122.463818970533) | 11 | 6 | 1 | 54 | 11 | |||
| 79102 | 38056 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 2808 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/1998 12:00:00 AM | Permit Number 40251 | 6000058.11772036 | 2114423.79043866 | 37.7858066640823 | -122.443560592592 | (37.7858066640823, -122.443560592592) | 15 | 6 | 1 | 29490 | 31 | |||
| 79709 | 138735 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2414 Sutter St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6001020.4463 | 2114207.5995 | 37.7852678952601 | -122.440215704909 | (37.7852678952601, -122.440215704909) | 15 | 6 | 1 | 29490 | 27 | |||
| 80297 | 34615 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3251 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | 4 | Permit Number 38299 | 5999148.91841 | 2115949.9944 | 37.7899453248674 | -122.446816013048 | (37.7899453248674, -122.446816013048) | 13 | 6 | 1 | 29490 | 31 | |
| 80445 | 64707 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 326 Spruce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/20/1988 12:00:00 AM | 4 | Permit Number 25653 | 5997167.67909 | 2115229.0541 | 37.7878524342988 | -122.453618811457 | (37.7878524342988, -122.453618811457) | 11 | 6 | 1 | 54 | 31 | ||
| 80947 | 33317 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1443-1443X Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/2019 12:00:00 AM | 3 | Permit Number 782769 | 6004424.04227 | 2120465.37019 | 37.8026433303993 | -122.428886594537 | (37.8026433303993, -122.428886594537) | 13 | 9 | 1 | 57 | 17 | |
| 82819 | 36957 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 16 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/29/1998 12:00:00 AM | 2 | Permit Number 39587 | 5994270.38913 | 2115479.86635 | 37.7883745790366 | -122.46366103146 | (37.7883745790366, -122.46366103146) | 11 | 6 | 1 | 54 | 11 | |
| 83017 | 59991 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3760 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/13/1982 12:00:00 AM | 5 | Permit Number 19475 | 5996854.5601 | 2115352.07014 | 37.7881722484941 | -122.454711030012 | (37.7881722484941, -122.454711030012) | 11 | 6 | 1 | 54 | 31 | |
| 83059 | 141028 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5998911.4817 | 2112772.8314 | 37.7812081000292 | -122.447408740955 | (37.7812081000292, -122.447408740955) | 15 | 5 | 1 | 54 | 16 | |||
| 83596 | 128912 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2451 Steiner St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6002274.04301 | 2116265.77897 | 37.7909904207088 | -122.436025978634 | (37.7909904207088, -122.436025978634) | 13 | 9 | 1 | 29490 | 27 | |||
| 86253 | 128892 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1 Locust St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5997467.54437 | 2116264.26497 | 37.7907120328778 | -122.452656080026 | (37.7907120328778, -122.452656080026) | 11 | 6 | 1 | 54 | 31 | |||
| 86837 | 105352 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2055 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/16/2014 12:00:00 AM | 1 | 3x3 | Permit Number 768583 | 6003162.6 | 2118532.6 | 37.7972649672191 | -122.433113640832 | (37.7972649672191, -122.433113640832) | 13 | 9 | 1 | 57 | 17 | |
| 86915 | 48412 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2740 Divisadero St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2002 12:00:00 AM | 2 | Permit Number 45791 | 6000650.17466 | 2117761.24056 | 37.7950041804639 | -122.441751856862 | (37.7950041804639, -122.441751856862) | 13 | 9 | 1 | 57 | 27 | ||
| 87493 | 132224 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3720 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/10/2017 12:00:00 AM | 3 | Width 2ft | Permit Number 779917 | 5997037.00688 | 2115048.93067 | 37.7873503715741 | -122.454057896478 | (37.7873503715741, -122.454057896478) | 11 | 6 | 1 | 54 | 31 | |
| 87544 | 250770 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 247 32nd Ave | 1 | : | Tree | Private 2 | 3 | Width 3ft | 5985863.4711 | 2114256.40781 | 37.7845273142332 | -122.492657058592 | (37.7845273142332, -122.492657058592) | 11 | 6 | 1 | 55 | 33 | |||
| 87617 | 89351 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 301 Locust St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/14/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51933 | 5997595.15634 | 2115324.46751 | 37.7881389106226 | -122.452146713906 | (37.7881389106226, -122.452146713906) | 11 | 6 | 1 | 54 | 31 | |
| 88356 | 49438 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 358SACRAMENTO Walnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/28/2003 12:00:00 AM | 1 | Permit Number 46376 | 5998618.53988 | 2115293.38017 | 37.7881121225237 | -122.448603758256 | (37.7881121225237, -122.448603758256) | 13 | 6 | 1 | 54 | 31 | |
| 88681 | 63950 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1982 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/25/1987 12:00:00 AM | 2 | Permit Number 24681 | 6003447.61154 | 2118987.9571 | 37.7985314231417 | -122.432159964919 | (37.7985314231417, -122.432159964919) | 13 | 9 | 1 | 57 | 17 | ||
| 89341 | 249650 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2401 Lyon St | 2 | Front Yard : Yard | Tree | Private 2 | 3 | Width 10ft | 5999216.24829 | 2117285.03492 | 37.7936148393952 | -122.446679155136 | (37.7936148393952, -122.446679155136) | 11 | 1 | 57 | 30 | ||||
| 90047 | 128937 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2613 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6004426.80187 | 2118244.37407 | 37.7965452029457 | -122.428718624581 | (37.7965452029457, -122.428718624581) | 13 | 9 | 1 | 57 | 17 | |||
| 90117 | 36151 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 173 Collins St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/01/1998 12:00:00 AM | 2 | Permit Number 39236 | 5998089.3705 | 2113369.892 | 37.7828004589669 | -122.450295876994 | (37.7828004589669, -122.450295876994) | 15 | 6 | 1 | 54 | 31 | |
| 91412 | 50868 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2626 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/2004 12:00:00 AM | 4 | Permit Number 47381 | 6001017.8874 | 2117610.38946 | 37.7946109276092 | -122.440468695171 | (37.7946109276092, -122.440468695171) | 13 | 9 | 1 | 57 | 27 | ||
| 91935 | 140882 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 132 COMMONWEALTH AVE | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 0ft | 5996575.5252 | 2113451.7055 | 37.7829383450276 | -122.455539029498 | (37.7829383450276, -122.455539029498) | 11 | 6 | 1 | 54 | 31 | |||
| 92959 | 36150 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 173 Collins St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/01/1998 12:00:00 AM | 2 | Permit Number 39236 | 5998087.0016 | 2113388.1668 | 37.7828505012081 | -122.450305390102 | (37.7828505012081, -122.450305390102) | 15 | 6 | 1 | 54 | 31 | |
| 93047 | 124617 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 700 Euclid Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5996168.56737 | 2113847.27226 | 37.7840011051583 | -122.456975547234 | (37.7840011051583, -122.456975547234) | 11 | 6 | 1 | 54 | 31 | |||
| 93262 | 48589 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1813 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53725 | 6004114.81766 | 2119382.23545 | 37.799651815633 | -122.429879362441 | (37.799651815633, -122.429879362441) | 13 | 9 | 1 | 57 | 17 | |
| 93545 | 140880 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 137 COMMONWEALTH AVE | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 0ft | 5996520.3624 | 2113454.7513 | 37.7829435424358 | -122.455730089048 | (37.7829435424358, -122.455730089048) | 11 | 6 | 1 | 54 | 31 | |||
| 94861 | 54008 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2301 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1973 12:00:00 AM | 2 | Permit Number 769512 | 6001291.70567 | 2116333.98742 | 37.7911218476422 | -122.439429711138 | (37.7911218476422, -122.439429711138) | 13 | 6 | 1 | 29490 | 27 | ||
| 94973 | 121968 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 44 15th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 5991181.38701 | 2114863.262 | 37.7865030798053 | -122.474303361826 | (37.7865030798053, -122.474303361826) | 11 | 6 | 1 | 54 | 33 | ||||
| 94974 | 110194 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2123 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/26/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774924 | 6001844.69538 | 2115843.7088 | 37.7898071242475 | -122.437481264255 | (37.7898071242475, -122.437481264255) | 13 | 6 | 1 | 29490 | 27 | |
| 95483 | 128895 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3617 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 5997525.91778 | 2115395.31662 | 37.7883294769792 | -122.452391380763 | (37.7883294769792, -122.452391380763) | 11 | 6 | 1 | 54 | 31 | |||
| 96361 | 34602 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3200 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | 2 | Permit Number 38292 | 5999340.98118 | 2116024.12544 | 37.7901598392537 | -122.446156829774 | (37.7901598392537, -122.446156829774) | 13 | 6 | 1 | 29490 | 31 | |
| 96458 | 107778 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3155 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 770908 | 6000890.09266 | 2119225.96368 | 37.7990395913723 | -122.441026839613 | (37.7990395913723, -122.441026839613) | 13 | 9 | 1 | 57 | 17 | |
| 97723 | 250844 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 242 30th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 4ft | 5986530.96095 | 2114207.27352 | 37.7844314123243 | -122.490344186658 | (37.7844314123243, -122.490344186658) | 11 | 6 | 1 | 55 | 33 | |||
| 98377 | 124619 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 700 Euclid Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5996139.11449 | 2113846.54371 | 37.7839974133808 | -122.457077390109 | (37.7839974133808, -122.457077390109) | 11 | 6 | 1 | 54 | 31 | |||
| 98849 | 128907 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2699 Filbert St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6000123.7305 | 2118478.82178 | 37.7969444587701 | -122.443624999898 | (37.7969444587701, -122.443624999898) | 13 | 9 | 1 | 57 | 17 | |||
| 99039 | 120444 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 65 22nd Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 5988946.42808 | 2114912.85474 | 37.7865095153738 | -122.482039308131 | (37.7865095153738, -122.482039308131) | 11 | 6 | 1 | 55 | 33 | |||
| 99597 | 38391 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 305 Spruce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/17/1998 12:00:00 AM | 4 | Permit Number 40448 | 5997113.50777 | 2115291.59294 | 37.7880210436742 | -122.45381075109 | (37.7880210436742, -122.45381075109) | 11 | 6 | 1 | 54 | 31 | |
| 99832 | 128898 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 340 Spruce St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5997180.84435 | 2115121.59918 | 37.787558146434 | -122.453565500565 | (37.787558146434, -122.453565500565) | 11 | 6 | 1 | 54 | 31 | |||
| 101741 | 12698 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1400 Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4 | 3X3 | 5991072.89411 | 2114792.56605 | 37.7863026824924 | -122.474673554881 | (37.7863026824924, -122.474673554881) | 11 | 6 | 1 | 54 | 33 | |||
| 101940 | 88446 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1629 Green St | 1 | Front Yard : Yard | Tree | Private 2 | 3 | 3x3 | Permit Number 51411 | 6005229.98772 | 2118491.64787 | 37.7972695780743 | -122.425957034113 | (37.7972695780743, -122.425957034113) | 13 | 9 | 1 | 57 | 17 | ||
| 102443 | 140883 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 132 COMMONWEALTH AVE | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 0ft | 5996574.5099 | 2113471.334 | 37.7829921814191 | -122.45554396116 | (37.7829921814191, -122.45554396116) | 11 | 6 | 1 | 54 | 31 | |||
| 102499 | 51882 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3655 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2005 12:00:00 AM | 3 | Permit Number 48098 | 5997353.65964 | 2115375.0125 | 37.7882638570339 | -122.452985896487 | (37.7882638570339, -122.452985896487) | 11 | 6 | 1 | 54 | 31 | ||
| 103228 | 88440 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 2848 Scott St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2008 12:00:00 AM | 3x3 | Permit Number 51404 | 6001088 | 2118113 | 37.795994956377 | -122.440262158185 | (37.795994956377, -122.440262158185) | 13 | 9 | 1 | 57 | 17 | |||
| 104080 | 56050 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2303 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/21/2011 12:00:00 AM | 2 | Permit Number 767225 | 6001288.22397 | 2116357.81232 | 37.7911870664881 | -122.439443466256 | (37.7911870664881, -122.439443466256) | 13 | 6 | 1 | 29490 | 27 | ||
| 104378 | 26814 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1701 Divisadero St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6001067.2461 | 2114300.6778 | 37.7855261286913 | -122.440060468908 | (37.7855261286913, -122.440060468908) | 15 | 6 | 1 | 29490 | 27 | |||
| 104587 | 120443 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 77 22nd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 5988946.9866 | 2114882.90892 | 37.786427325124 | -122.482035181262 | (37.786427325124, -122.482035181262) | 11 | 6 | 1 | 55 | 33 | |||
| 105249 | 14418 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 10X Masonic Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/12/2000 12:00:00 AM | 12 | 3X3 | 5998974.44495 | 2113166.80204 | 37.7822934388942 | -122.447219282802 | (37.7822934388942, -122.447219282802) | 15 | 5 | 1 | 54 | 16 | ||
| 105351 | 51626 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 3100ON LYON ST Pacific Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2010 12:00:00 AM | Permit Number 53623 | 5999297.18368594 | 2116674.7385641 | 37.7919437500329 | -122.446355188809 | (37.7919437500329, -122.446355188809) | 11 | 6 | 1 | 29490 | 30 | |||
| 105386 | 123538 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 23 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 5ft | 5994225.48914 | 2115464.05716 | 37.7883285840326 | -122.463815229058 | (37.7883285840326, -122.463815229058) | 11 | 6 | 1 | 54 | 11 | |||
| 106750 | 128891 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1 Locust St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5997465.76158 | 2116272.47482 | 37.7907344727794 | -122.452662841125 | (37.7907344727794, -122.452662841125) | 11 | 6 | 1 | 54 | 31 | |||
| 109245 | 141267 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 65 PARKER AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5996811.5744 | 2114137.8557 | 37.7848358737513 | -122.454771991614 | (37.7848358737513, -122.454771991614) | 11 | 6 | 1 | 54 | 31 | |||
| 110140 | 88034 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2301X Lyon St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51052 | 5999283.09469 | 2116726.55526 | 37.7920852203074 | -122.446407665986 | (37.7920852203074, -122.446407665986) | 11 | 6 | 1 | 29490 | 30 | |
| 110336 | 59656 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2743 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/19/1981 12:00:00 AM | 9 | Permit Number 19077 | 5999546.51373 | 2118294.85744 | 37.7964064042791 | -122.445609064411 | (37.7964064042791, -122.445609064411) | 13 | 9 | 1 | 57 | 17 | ||
| 110457 | 128911 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3456 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5997735.67778 | 2116129.11105 | 37.7903562961647 | -122.451718603329 | (37.7903562961647, -122.451718603329) | 11 | 6 | 1 | 54 | 31 | |||
| 111385 | 120459 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 67 West Clay St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 5988568.8662 | 2114996.16494 | 37.7867162951637 | -122.4833516722 | (37.7867162951637, -122.4833516722) | 11 | 6 | 1 | 55 | 33 | |||
| 112348 | 124578 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3941 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5995873.19469 | 2115496.12164 | 37.7885114366016 | -122.458116794807 | (37.7885114366016, -122.458116794807) | 11 | 6 | 1 | 54 | 31 | |||
| 112776 | 30984 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2019 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2012 12:00:00 AM | 3 | Permit Number 768940 | 6004354.93926 | 2117328.04108 | 37.79402511912 | -122.4289019235 | (37.79402511912, -122.4289019235) | 13 | 9 | 1 | 28858 | 27 | ||
| 113138 | 108148 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3322 Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 6003294.68219 | 2119741.92969 | 37.8005929642463 | -122.432743036759 | (37.8005929642463, -122.432743036759) | 13 | 9 | 1 | 57 | 17 | ||||
| 113745 | 34613 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3242 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | 5 | Permit Number 38297 | 5999179.91212 | 2116003.96685 | 37.7900952895177 | -122.446712662971 | (37.7900952895177, -122.446712662971) | 13 | 6 | 1 | 29490 | 31 | |
| 114307 | 89349 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 301 Locust St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/14/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51933 | 5997587.89515 | 2115375.85191 | 37.7882795825748 | -122.452175545264 | (37.7882795825748, -122.452175545264) | 11 | 6 | 1 | 54 | 31 | |
| 114665 | 140888 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 140 COMMONWEALTH AVE | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 0ft | 5996575.8636 | 2113422.6012 | 37.7828584517603 | -122.455535754513 | (37.7828584517603, -122.455535754513) | 11 | 6 | 1 | 54 | 31 | |||
| 115703 | 51629 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3100ON LYON ST Pacific Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2010 12:00:00 AM | 3 | Permit Number 53623 | 5999225.71389 | 2116662.32922 | 37.7919055951227 | -122.446601580509 | (37.7919055951227, -122.446601580509) | 11 | 6 | 1 | 29490 | 30 | ||
| 117338 | 128933 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1911 Octavia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6004764.43017 | 2115845.45511 | 37.7899774819254 | -122.427379377553 | (37.7899774819254, -122.427379377553) | 13 | 9 | 1 | 28858 | 27 | |||
| 117451 | 128897 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 340 Spruce St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5997178.85158 | 2115136.29795 | 37.7875983911045 | -122.45357345685 | (37.7875983911045, -122.45357345685) | 11 | 6 | 1 | 54 | 31 | |||
| 119051 | 123591 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 26 05th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 5ft | 5994270.79581 | 2115427.05215 | 37.7882295890949 | -122.463655789773 | (37.7882295890949, -122.463655789773) | 11 | 6 | 1 | 54 | 11 | |||
| 119152 | 5313 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 1785 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/31/2016 12:00:00 AM | 3 | 3X3 | Permit Number 770253 | 6001045 | 2114480 | 37.786017234839 | -122.440150297316 | (37.786017234839, -122.440150297316) | 15 | 6 | 1 | 29490 | 27 | |
| 120996 | 105049 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2835 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/26/2014 12:00:00 AM | 3 | 3x3 | Permit Number 771766 | 6002046.08058 | 2117916.60345 | 37.7955102037842 | -122.436932952092 | (37.7955102037842, -122.436932952092) | 13 | 9 | 1 | 57 | 27 | |
| 121980 | 97204 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 173 Jordan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/31/2011 12:00:00 AM | 1 | Permit Number 768071 | 5996213.20813 | 2113152.77904 | 37.7820967750245 | -122.456770862489 | (37.7820967750245, -122.456770862489) | 11 | 6 | 1 | 54 | 31 | ||
| 122267 | 12712 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1462 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/11/1994 12:00:00 AM | 12 | 3X3 | 5990903.08198 | 2114785.23215 | 37.7862727045665 | -122.475260519465 | (37.7862727045665, -122.475260519465) | 11 | 6 | 1 | 54 | 33 | ||
| 123296 | 120472 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 88 West Clay St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 6ft | 5988447.19453 | 2115067.03638 | 37.786903806069 | -122.483777820382 | (37.786903806069, -122.483777820382) | 11 | 6 | 1 | 55 | 33 | |||
| 123406 | 84232 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 144 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52250 | 5988057.00135 | 2115013.9222 | 37.7867352483332 | -122.48512388384 | (37.7867352483332, -122.48512388384) | 11 | 6 | 1 | 55 | 33 | |
| 124381 | 108146 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3322 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 6003298.685 | 2119704.23273 | 37.800489685219 | -122.432726491033 | (37.800489685219, -122.432726491033) | 13 | 9 | 1 | 57 | 17 | ||||
| 124784 | 12713 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1462 Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/1990 12:00:00 AM | 8 | 3X3 | 5990888.84892 | 2114785.41496 | 37.7862723815337 | -122.475309775012 | (37.7862723815337, -122.475309775012) | 11 | 6 | 1 | 54 | 33 | ||
| 125658 | 63951 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1980 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/25/1987 12:00:00 AM | 6 | Permit Number 24682 | 6003463.5929 | 2118990.37708 | 37.7985389738578 | -122.432104837366 | (37.7985389738578, -122.432104837366) | 13 | 9 | 1 | 57 | 17 | ||
| 126547 | 141033 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2 Masonic Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5998897.268 | 2112867.5895 | 37.7814674689292 | -122.447464735793 | (37.7814674689292, -122.447464735793) | 15 | 5 | 1 | 54 | 16 | |||
| 128138 | 34607 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3201 Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/1997 12:00:00 AM | 2 | Permit Number 38293 | 5999326.50418 | 2115973.1439 | 37.7900190306076 | -122.446203250097 | (37.7900190306076, -122.446203250097) | 13 | 6 | 1 | 29490 | 31 | ||
| 129150 | 14477 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 270 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/1997 12:00:00 AM | 12 | 3X3 | 5999009.9624 | 2111977.0325 | 37.7790286692875 | -122.447010762923 | (37.7790286692875, -122.447010762923) | 15 | 5 | 1 | 54 | 16 | ||
| 129254 | 52585 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 179@ GEARY Jordan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/27/2006 12:00:00 AM | 4 | Permit Number 48679 | 5996212.5737 | 2113122.44093 | 37.782013438206 | -122.456770862482 | (37.782013438206, -122.456770862482) | 11 | 6 | 1 | 54 | 31 | ||
| 129279 | 128916 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2600 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6000720.63837 | 2117249.04929 | 37.7936018522923 | -122.441471271084 | (37.7936018522923, -122.441471271084) | 13 | 9 | 1 | 57 | 27 | |||
| 130041 | 123867 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 800 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/1997 12:00:00 AM | 3 | Width 4ft | 5992987.31992 | 2114863.7473 | 37.7866088704155 | -122.468055371527 | (37.7866088704155, -122.468055371527) | 11 | 6 | 1 | 54 | 11 | ||
| 133525 | 120059 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 126 27th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5987428.00047 | 2115126.85711 | 37.7870086753365 | -122.48730834766 | (37.7870086753365, -122.48730834766) | 11 | 6 | 1 | 55 | 33 | |||
| 134218 | 141031 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2 Masonic Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5998902.6827 | 2112826.302 | 37.7813544136007 | -122.447443030906 | (37.7813544136007, -122.447443030906) | 15 | 5 | 1 | 54 | 16 | |||
| 134417 | 51507 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3641 Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/13/2005 12:00:00 AM | 6 | Permit Number 47816 | 5997392.13134 | 2115378.5114 | 37.7882756687359 | -122.452853044141 | (37.7882756687359, -122.452853044141) | 11 | 6 | 1 | 54 | 31 | ||
| 134980 | 128928 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2101 Washington St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6004782.20902 | 2116734.88051 | 37.7924206251688 | -122.427381250838 | (37.7924206251688, -122.427381250838) | 13 | 9 | 1 | 28858 | 27 | |||
| 135289 | 128883 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2728 Union St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 5999906.60451 | 2118147.85643 | 37.7960233299564 | -122.444352508267 | (37.7960233299564, -122.444352508267) | 13 | 9 | 1 | 57 | 17 | |||
| 135625 | 128880 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2848 Scott St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001079.71107 | 2118186.43072 | 37.7961961059217 | -122.440296108089 | (37.7961961059217, -122.440296108089) | 13 | 9 | 1 | 57 | 17 | |||
| 136699 | 59993 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 337 Spruce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/13/1982 12:00:00 AM | Permit Number 19477 | 5997117.96876659 | 2115242.06175139 | 37.7878853000005 | -122.453791738714 | (37.7878853000005, -122.453791738714) | 11 | 6 | 1 | 54 | 31 | ||
| 139102 | 33893 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3608 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52572 | 5997568.78085 | 2115124.80264 | 37.7875891730452 | -122.452223555579 | (37.7875891730452, -122.452223555579) | 11 | 6 | 1 | 54 | 31 |
| 139586 | 128923 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2101 Washington St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6004469.58856 | 2116691.73972 | 37.7922844857989 | -122.428459850062 | (37.7922844857989, -122.428459850062) | 13 | 9 | 1 | 28858 | 27 | |||
| 139658 | 128926 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2101 Washington St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6004675.73489 | 2116715.51663 | 37.79236143447 | -122.427748274059 | (37.79236143447, -122.427748274059) | 13 | 9 | 1 | 28858 | 27 | |||
| 140143 | 128913 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2307 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6001285.20806 | 2116386.66634 | 37.7912661204978 | -122.439455970441 | (37.7912661204978, -122.439455970441) | 13 | 6 | 1 | 29490 | 27 | |||
| 141136 | 123536 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 21 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 5994224.71951 | 2115491.8038 | 37.7884047243772 | -122.463819906584 | (37.7884047243772, -122.463819906584) | 11 | 6 | 1 | 54 | 11 | |||
| 141203 | 140887 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 140 COMMONWEALTH AVE | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 0ft | 5996576.5404 | 2113403.6496 | 37.782806454531 | -122.455532042867 | (37.782806454531, -122.455532042867) | 11 | 6 | 1 | 54 | 31 | |||
| 141511 | 128905 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3760 Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5996816.7571 | 2115345.41207 | 37.7881517988211 | -122.454841339957 | (37.7881517988211, -122.454841339957) | 11 | 6 | 1 | 54 | 31 | |||
| 141777 | 128884 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1978 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003477.22131 | 2118991.9993 | 37.7985442007084 | -122.432057794742 | (37.7985442007084, -122.432057794742) | 13 | 9 | 1 | 57 | 17 | |||
| 143355 | 51508 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3641 Clay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/13/2005 12:00:00 AM | 5 | Permit Number 47816 | 5997405.62491 | 2115381.09768 | 37.7882835431974 | -122.452806545611 | (37.7882835431974, -122.452806545611) | 11 | 6 | 1 | 54 | 31 | ||
| 143646 | 128917 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2600 Divisadero St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6000719.36827 | 2117263.4475 | 37.7936413136459 | -122.441476699392 | (37.7936413136459, -122.441476699392) | 13 | 9 | 1 | 57 | 27 | |||
| 143956 | 34616 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3251 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | 5 | Permit Number 38299 | 5999167.90423 | 2115953.27793 | 37.7899554251564 | -122.446750560392 | (37.7899554251564, -122.446750560392) | 13 | 6 | 1 | 29490 | 31 |
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) );