trees
6,344 rows where qSpecies_id = 19
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7602 | 5107 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2680 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2007 12:00:00 AM | 6 | 3X3 | 6002305.28224 | 2096351.99681 | 37.736313802225 | -122.434493443022 | (37.736313802225, -122.434493443022) | 2 | 7 | 5 | 63 | 7 | ||
| 7649 | 39891 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1550 Sutter St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/1999 12:00:00 AM | Permit Number 41175 | 6005174.09555111 | 2114787.61295618 | 37.7870960726836 | -122.425886638993 | (37.7870960726836, -122.425886638993) | 13 | 9 | 11 | 28858 | 27 | |||
| 7659 | 261346 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 600X Columbus Ave | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2020 12:42:00 PM | 3 | 5X5 | 6009675.3838 | 2119664.5956 | 37.8007404309352 | -122.410657649881 | (37.8007404309352, -122.410657649881) | 3 | 1 | 10 | 308 | 23 | ||
| 7708 | 76081 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 380 Webster St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/12/1994 12:00:00 AM | 4 | 3x3 | 6004161.50647736 | 2110040.16949733 | 37.7740034947051 | -122.429051358355 | (37.7740034947051, -122.429051358355) | 7 | 9 | 11 | 28852 | 10 | |
| 7709 | 177350 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 500x San Juan Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6000388.06795 | 2092890.63875 | 37.7267006979702 | -122.440873804687 | (37.7267006979702, -122.440873804687) | 9 | 7 | 6 | 28861 | 25 | |||
| 7714 | 101793 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 795 Folsom St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6012464.9097 | 2112928.8888 | 37.7824017756076 | -122.400531256447 | (37.7824017756076, -122.400531256447) | 6 | 2 | 9 | 28856 | 34 | |||
| 7727 | 259597 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 345 04th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 3ft | 6012481.99467 | 2112636.57875 | 37.7816001127017 | -122.400451610675 | (37.7816001127017, -122.400451610675) | 6 | 2 | 9 | 28856 | 34 | ||||
| 7764 | 251735 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 338 Chicago Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 02:05:00 PM | 3 | 3x3 | 6002437 | 2086534 | 37.7093632573177 | -122.433336687258 | (37.7093632573177, -122.433336687258) | 9 | 7 | 6 | 28861 | 5 | ||
| 7772 | 74841 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 200 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 17 | 6011912.74207 | 2119472.92585 | 37.800339337445 | -122.402901928701 | (37.800339337445, -122.402901928701) | 3 | 1 | 10 | 308 | 23 | |||
| 7798 | 52068 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 712 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2005 12:00:00 AM | Permit Number 48263 | 6002387.64911421 | 2104013.98805982 | 37.7573565030376 | -122.434756406645 | (37.7573565030376, -122.434756406645) | 2 | 4 | 5 | 28862 | 3 | |||
| 7812 | 177349 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 500x San Juan Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6000408.55271 | 2092877.8532 | 37.726666758438 | -122.440802072953 | (37.726666758438, -122.440802072953) | 9 | 7 | 6 | 28861 | 25 | |||
| 7815 | 78721 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 115 Rey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6008722.75942 | 2087395.11673 | 37.7120823080297 | -122.411672802567 | (37.7120823080297, -122.411672802567) | 9 | 7 | 8 | 309 | 39 | |||
| 7871 | 104619 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 800 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | MTA | 7 | 4x4 | Permit Number 770959 | 6012190.226 | 2112753.6665 | 37.7819053332353 | -122.401469228728 | (37.7819053332353, -122.401469228728) | 6 | 2 | 9 | 28853 | 34 | |
| 7937 | 47337 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 415 Garfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779205 | 5992952.66327787 | 2090462.04360939 | 37.7196060953775 | -122.466401119038 | (37.7196060953775, -122.466401119038) | 9 | 8 | 6 | 64 | 24 | |
| 7952 | 262419 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 101 Brighton Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784737 | 5996197.23422 | 2090625.75995 | 37.7202423066045 | -122.455197699909 | (37.7202423066045, -122.455197699909) | 9 | 8 | 6 | 28861 | 24 | |
| 7986 | 180642 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 56 Seville St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 6ft | 6001992.8038 | 2087466.28016 | 37.7118978840556 | -122.4349385283 | (37.7118978840556, -122.4349385283) | 9 | 7 | 6 | 28861 | 5 | |||
| 8008 | 260640 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 3936 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/07/2019 12:00:00 AM | 3 | 4x4 | Permit Number 776281 | 6004258 | 2100777 | 37.7485745007292 | -122.428057323873 | (37.7485745007292, -122.428057323873) | 2 | 4 | 5 | 28862 | 22 | |
| 8021 | 130909 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1268 Washington St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6008550.55684 | 2117302.71746 | 37.7941921699808 | -122.414382817833 | (37.7941921699808, -122.414382817833) | 5 | 1 | 10 | 28857 | 21 | |||
| 8047 | 229934 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 602 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6002630.53663 | 2098906.06974 | 37.7433451534675 | -122.433551376193 | (37.7433451534675, -122.433551376193) | 2 | 7 | 5 | 63 | 22 | |||
| 8073 | 64439 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 40 Rausch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1988 12:00:00 AM | 15 | Permit Number 25301 | 6009724.66306 | 2110846.10571 | 37.7765297431014 | -122.409864276736 | (37.7765297431014, -122.409864276736) | 8 | 2 | 9 | 28853 | 34 | |
| 8081 | 39780 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 50 San Jose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | Permit Number 41452 | 6006177.81610853 | 2102875.29261487 | 37.7544443606741 | -122.421567620452 | (37.7544443606741, -122.421567620452) | 2 | 4 | 5 | 28859 | 19 | ||
| 8087 | 188688 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1300 Evans Ave | 37 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/18/2017 02:16:00 PM | 3 | Width 4ft | 6017441.41972 | 2097257.16832 | 37.739646816544 | -122.382223941884 | (37.739646816544, -122.382223941884) | 10 | 3 | 8 | 58 | 1 | ||
| 8091 | 84430 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 3500 23rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50590 | 6006171.77574756 | 2102614.8499471 | 37.7537289046252 | -122.421570013482 | (37.7537289046252, -122.421570013482) | 2 | 4 | 5 | 28859 | 19 | ||
| 8096 | 59801 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1035 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/27/1981 12:00:00 AM | 3 | Permit Number 19252 | 6008957.26664 | 2115956.46154 | 37.7905185185761 | -122.412880324992 | (37.7905185185761, -122.412880324992) | 5 | 1 | 10 | 28858 | 21 | |
| 8140 | 26662 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1275 Fairfax Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/01/2001 12:00:00 AM | 8 | 3x3 | 6017216.3972 | 2096959.142 | 37.7388160650952 | -122.382981244792 | (37.7388160650952, -122.382981244792) | 10 | 3 | 8 | 58 | 1 | ||
| 8164 | 192896 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 345 04th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6012481.99467 | 2112636.57875 | 37.7816001127017 | -122.400451610675 | (37.7816001127017, -122.400451610675) | 6 | 2 | 9 | 28856 | 34 | |||
| 8191 | 74104 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 189 Oxford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6006471.06973 | 2093054.28635 | 37.7274946077702 | -122.419856624186 | (37.7274946077702, -122.419856624186) | 9 | 7 | 7 | 309 | 5 | |||
| 8285 | 36624 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1998 12:00:00 AM | Permit Number 39461 | ||||||||||||||
| 8292 | 261770 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 600X Columbus Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/26/2020 11:05:00 AM | 3 | 4x4 | ||||||||||||
| 8353 | 246952 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2101 15th St | 4 | : | Tree | Private 2 | 2 | Width 3ft | 6003390.88605 | 2107111.412 | 37.7659181907902 | -122.43150793845 | (37.7659181907902, -122.43150793845) | 15 | 5 | 5 | 28862 | 3 | |||
| 8382 | 2324 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2298X Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/17/1996 12:00:00 AM | 6 | 3X3 | 6009641.4422065 | 2103972.2905262 | 37.7576511632266 | -122.409666876922 | (37.7576511632266, -122.409666876922) | 2 | 4 | 7 | 28859 | 19 | ||
| 8392 | 230069 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 800X Eugenia Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007643.30066 | 2097725.00947 | 37.74038536408 | -122.416134851864 | (37.74038536408, -122.416134851864) | 2 | 7 | 7 | 28859 | 2 | |||
| 8419 | 85699 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 918 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/23/2020 12:00:00 AM | 3 | 3x3 | 6010993.40445 | 2112488.15858 | 37.7811094596721 | -122.405590993329 | (37.7811094596721, -122.405590993329) | 14 | 2 | 9 | 28853 | 34 | ||
| 8426 | 177304 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 10 Ruth St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 2ft | 6001647.41554 | 2091598.69121 | 37.723224945954 | -122.436427860461 | (37.723224945954, -122.436427860461) | 9 | 7 | 6 | 28861 | 25 | |||
| 8471 | 230647 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 300 Vicksburg St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6004129.21796 | 2101814.78019 | 37.7514167163076 | -122.428576614423 | (37.7514167163076, -122.428576614423) | 2 | 4 | 5 | 28862 | 22 | |||
| 8528 | 5525 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 875 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/09/2015 07:32:00 AM | 3 | 8x8 | 6005129 | 2103286 | 37.7555128725534 | -122.425223924554 | (37.7555128725534, -122.425223924554) | 2 | 4 | 5 | 28859 | 19 | ||
| 8615 | 81216 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1490 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 5989947.3486 | 2105228.4272 | 37.7599768999261 | -122.477868186468 | (37.7599768999261, -122.477868186468) | 1 | 8 | 3 | 56 | 35 | |||
| 8620 | 230618 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 293 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003249.58488 | 2101526.98547 | 37.7505766802717 | -122.431597943511 | (37.7505766802717, -122.431597943511) | 2 | 4 | 5 | 28862 | 22 | |||
| 8647 | 146616 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 1320 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 4x4 | Permit Number 783073 | 6005474.41066 | 2120313.40732 | 37.8022854748664 | -122.425240967805 | (37.8022854748664, -122.425240967805) | 13 | 9 | 1 | 57 | 17 | ||
| 8654 | 142867 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1020 Polk St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6006956.6744 | 2114391.9796 | 37.786110337763 | -122.41969121449 | (37.786110337763, -122.41969121449) | 13 | 9 | 9 | 28858 | 36 | |||
| 8704 | 79435 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 606 Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6004044.7014 | 2110862.9754 | 37.7762561050616 | -122.429514097991 | (37.7762561050616, -122.429514097991) | 7 | 9 | 11 | 28852 | 10 | |||
| 8769 | 32194 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 40 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/18/1995 12:00:00 AM | 2 | Permit Number 35521 | 6000876.834 | 2109176.6725 | 37.7714460698883 | -122.440351630177 | (37.7714460698883, -122.440351630177) | 15 | 5 | 11 | 29492 | 9 | |
| 8772 | 42026 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 49 Rausch St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | 6 | Permit Number 42349 | 6009754.59547 | 2110863.51813 | 37.776579230974 | -122.409761960854 | (37.776579230974, -122.409761960854) | 8 | 2 | 9 | 28853 | 34 | |
| 8813 | 229976 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 506 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/20/1983 12:00:00 AM | 13 | Width 2ft | Permit Number 20257 | 6003460.20133 | 2096023.86311 | 37.7354783140686 | -122.430477003328 | (37.7354783140686, -122.430477003328) | 2 | 7 | 5 | 63 | 7 | |
| 8825 | 36621 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1998 12:00:00 AM | Permit Number 39461 | ||||||||||||||
| 8865 | 248498 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 156 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5998302.5369 | 2107853.4873 | 37.7676660307619 | -122.449160873661 | (37.7676660307619, -122.449160873661) | 15 | 5 | 11 | 29492 | 9 | |||
| 8884 | 4658 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 600X Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2020 12:50:00 PM | 3 | 5X5 | 6009795.4348 | 2119557.2423 | 37.8004523952872 | -122.410234638074 | (37.8004523952872, -122.410234638074) | 3 | 1 | 10 | 308 | 23 | ||
| 8929 | 29875 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1900X Evans Ave | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/11/2006 12:00:00 AM | 3 | 4x4 | 6014068.9121897 | 2099730.7814701 | 37.746251993267 | -122.394057835868 | (37.746251993267, -122.394057835868) | 10 | 3 | 8 | 58 | 1 | ||
| 8963 | 36618 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1998 12:00:00 AM | Permit Number 39461 | ||||||||||||||
| 8967 | 18314 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 180 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2020 12:00:00 AM | 3 | 4x4 | Permit Number 782360 | 6010236.79256 | 2107510.48621 | 37.7673995909374 | -122.407857396411 | (37.7673995909374, -122.407857396411) | 8 | 4 | 8 | 28853 | 19 | |
| 8977 | 61589 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 912 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1984 12:00:00 AM | 11 | Permit Number 21556 | 6012739.7847 | 2103229.26142 | 37.7557841029764 | -122.398899324171 | (37.7557841029764, -122.398899324171) | 10 | 3 | 8 | 28856 | 29 | |
| 8989 | 70675 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 49 Rausch St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6009740.45587 | 2110875.89947 | 37.7766124348397 | -122.409811748212 | (37.7766124348397, -122.409811748212) | 8 | 2 | 9 | 28853 | 34 | |||
| 8990 | 229341 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2384 Bryant St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 6ft | 6009657.14519 | 2103466.25311 | 37.7562625782597 | -122.409576854282 | (37.7562625782597, -122.409576854282) | 2 | 4 | 7 | 28859 | 19 | |||
| 9118 | 120468 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 90 West Clay St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 6ft | 5988384.0014 | 2115083.94801 | 37.7869465618324 | -122.483997692017 | (37.7869465618324, -122.483997692017) | 11 | 6 | 1 | 55 | 33 | |||
| 9123 | 46414 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 525X 18th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2002 12:00:00 AM | 5 | 3x3 | Permit Number 44641 | 6015977.84148898 | 2105815.09709753 | 37.763064153155 | -122.387881407344 | (37.763064153155, -122.387881407344) | 14 | 3 | 8 | 28856 | 29 | |
| 9133 | 229721 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3345 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | Permit Number 768018 | 6007953.43646 | 2104421.40603 | 37.7587895958797 | -122.415536504129 | (37.7587895958797, -122.415536504129) | 2 | 4 | 7 | 28859 | 19 | ||
| 9142 | 28298 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 637 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/2003 12:00:00 AM | 3 | 3X3 | 6010087.47543 | 2115987.95406 | 37.7906683645059 | -122.408972077304 | (37.7906683645059, -122.408972077304) | 5 | 1 | 10 | 28857 | 21 | ||
| 9233 | 17847 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2082 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003983.5737 | 2115317.762 | 37.7884843766402 | -122.430043414021 | (37.7884843766402, -122.430043414021) | 13 | 9 | 11 | 29490 | 27 | |||
| 9273 | 28375 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3014 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/09/2003 12:00:00 AM | 3 | 3x3 | Permit Number 54020 | 6000248.59092 | 2115494.6796 | 37.7887579085949 | -122.442978542939 | (37.7887579085949, -122.442978542939) | 13 | 6 | 1 | 29490 | 27 | |
| 9325 | 3933 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 100X Castro St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/24/2014 07:53:00 AM | 3 | 4x4 | 6002195.04278 | 2107524.92983 | 37.7669857589152 | -122.435673694403 | (37.7669857589152, -122.435673694403) | 15 | 5 | 5 | 28862 | 3 | ||
| 9373 | 71806 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2567 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 5988291.4423 | 2097857.1501 | 37.7396410933419 | -122.483054814949 | (37.7396410933419, -122.483054814949) | 1 | 8 | 3 | 29491 | 35 | |||
| 9409 | 76076 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 60 Rausch St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6009855.80512 | 2110709.84536 | 37.7761629527799 | -122.409400998174 | (37.7761629527799, -122.409400998174) | 8 | 2 | 9 | 28853 | 34 | |||
| 9417 | 203065 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1300 Evans Ave | 36 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/18/2017 01:10:00 PM | 3 | Width 3ft | 6017458.84969 | 2097245.24162 | 37.7396150308979 | -122.382162846439 | (37.7396150308979, -122.382162846439) | 10 | 3 | 8 | 58 | 1 | ||
| 9421 | 50706 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 668 18th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2004 12:00:00 AM | 3 | Permit Number 47265 | 5990376.16513 | 2110779.50852 | 37.7752435440041 | -122.476790717818 | (37.7752435440041, -122.476790717818) | 11 | 6 | 2 | 55 | 26 | |
| 9422 | 80211 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 340 11th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6008650.63461 | 2108952.54787 | 37.7712702289655 | -122.413445714359 | (37.7712702289655, -122.413445714359) | 8 | 2 | 9 | 28853 | 19 | |||
| 9477 | 193012 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 901 Rankin St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 3ft | 6013566.4311 | 2097855.47673 | 37.7410748608127 | -122.395663996006 | (37.7410748608127, -122.395663996006) | 10 | 3 | 8 | 58 | 1 | |||
| 9484 | 71331 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 315 05th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6011757.84173 | 2112077.6198 | 37.7800249312328 | -122.402917523848 | (37.7800249312328, -122.402917523848) | 6 | 2 | 9 | 28856 | 34 | |||
| 9497 | 193189 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 401 Harrison St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 6014845.7191 | 2114331.63578 | 37.7863858864432 | -122.392392780401 | (37.7863858864432, -122.392392780401) | 6 | 2 | 9 | 28855 | 6 | |||
| 9503 | 109132 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 124 Ellsworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 6008117 | 2098031 | 37.7412521699945 | -122.414518628477 | (37.7412521699945, -122.414518628477) | 2 | 7 | 7 | 28859 | 2 | ||||
| 9593 | 70541 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1830 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6000327.1082 | 2111334.4422 | 37.777339444143 | -122.442408091617 | (37.777339444143, -122.442408091617) | 15 | 5 | 11 | 29490 | 16 | |||
| 9614 | 130665 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3152 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 5999642.12267 | 2116065.45546 | 37.7902905134552 | -122.445117879904 | (37.7902905134552, -122.445117879904) | 13 | 6 | 1 | 29490 | 27 | |||
| 9630 | 248945 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1500x Galvez Ave | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 03/18/2017 12:00:00 AM | 3 | 3x3 | 6016393 | 2097292 | 37.7396844950272 | -122.385851388433 | (37.7396844950272, -122.385851388433) | 10 | 3 | 8 | 58 | 1 | |
| 9640 | 17196 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2235X Octavia St | 5 | Median : Cutout | Tree | DPW 1 | 24 | 20 | 6004629.78741 | 2116932.39582 | 37.792954330542 | -122.427922714666 | (37.792954330542, -122.427922714666) | 13 | 9 | 1 | 28858 | 27 | |||
| 9654 | 230071 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 800X Eugenia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007616.48764 | 2097727.27317 | 37.7403900720444 | -122.416227721243 | (37.7403900720444, -122.416227721243) | 2 | 7 | 7 | 28859 | 2 | |||
| 9660 | 94240 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2517 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2019 12:00:00 AM | 3 | 3x3 | Permit Number 53613 | 6001913.77798 | 2116990.99637 | 37.7929612067506 | -122.437324430597 | (37.7929612067506, -122.437324430597) | 13 | 6 | 1 | 29490 | 27 | |
| 9680 | 230722 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 4244 19th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6001792.12891 | 2104707.83961 | 37.759227823833 | -122.436865617157 | (37.759227823833, -122.436865617157) | 2 | 4 | 5 | 28862 | 3 | |||
| 9683 | 13057 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 570 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/2014 12:00:00 AM | 3 | 2x2 | 6009630.8999 | 2120542.6321 | 37.8031488074681 | -122.410873631329 | (37.8031488074681, -122.410873631329) | 3 | 1 | 10 | 308 | 23 | ||
| 9744 | 19850 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 100 STAIRWAY27 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 10ST | |||||||||||||
| 9796 | 72145 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 350 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6001088.11474 | 2092709.73665 | 37.72624382708 | -122.438440814794 | (37.72624382708, -122.438440814794) | 9 | 7 | 6 | 28861 | 25 | |||
| 9853 | 46194 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2001 12:00:00 AM | Permit Number 44518 | ||||||||||||||
| 9869 | 5383 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 325X Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/06/2009 12:00:00 AM | 3 | 4X4 | 6004919.4864142 | 2106495.5645768 | 37.7643137401636 | -122.426176974515 | (37.7643137401636, -122.426176974515) | 8 | 4 | 5 | 28859 | 19 | ||
| 9882 | 110280 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2845 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 4x4 | 5999937.93955 | 2117050.91929 | 37.7930132181276 | -122.444165220867 | (37.7930132181276, -122.444165220867) | 13 | 9 | 1 | 29490 | 27 | |||
| 9918 | 74256 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1126X Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6009656.55619 | 2111209.09392 | 37.7775226063216 | -122.410125511783 | (37.7775226063216, -122.410125511783) | 8 | 2 | 9 | 28853 | 34 | |||
| 9972 | 71995 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 400 38th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5984088.02561 | 2113084.30818 | 37.7812050975324 | -122.498712783587 | (37.7812050975324, -122.498712783587) | 11 | 6 | 2 | 55 | 26 | |||
| 9977 | 12786 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1926X Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 5989360.57879 | 2114746.40468 | 37.7860765689348 | -122.480594276512 | (37.7860765689348, -122.480594276512) | 11 | 6 | 1 | 55 | 33 | |||
| 9988 | 87741 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2536 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/27/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50404 | 6001459.44727 | 2117322.47349 | 37.7938455182068 | -122.438920201115 | (37.7938455182068, -122.438920201115) | 13 | 9 | 1 | 57 | 27 | |
| 10003 | 264730 | Private 9 | Magnolia grandiflora :: Southern Magnolia 19 | 748 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/23/2020 12:00:00 AM | 3 | 6002983.4557 | 2109619.25261 | 37.7727810060219 | -122.433096352422 | (37.7727810060219, -122.433096352422) | 15 | 5 | 11 | 29492 | 9 | |||
| 10007 | 264696 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1285 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/16/2020 12:00:00 AM | 3 | Width 0ft | Permit Number 782245 | 5999562.003 | 2108407.0589 | 37.7692579547157 | -122.444844350278 | (37.7692579547157, -122.444844350278) | 15 | 5 | 11 | 29492 | 9 | |
| 10046 | 48825 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 550 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/2002 12:00:00 AM | 6 | Permit Number 46050 | 5988463.29715 | 2112242.22119 | 37.7791485995736 | -122.483514940107 | (37.7791485995736, -122.483514940107) | 11 | 6 | 2 | 55 | 26 | ||
| 10060 | 262273 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 2470 Diamond St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6x6 | 6002133 | 2097220 | 37.738687356955 | -122.435151157914 | (37.738687356955, -122.435151157914) | 2 | 7 | 5 | 63 | 7 | ||||
| 10064 | 229649 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 46 Mirabel Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6007603.84542 | 2099930.90044 | 37.7464400309007 | -122.416427482269 | (37.7464400309007, -122.416427482269) | 2 | 7 | 7 | 28859 | 2 | |||
| 10130 | 193311 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1433 Galvez Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6016240.13881 | 2097427.00946 | 37.7400467432612 | -122.386389332697 | (37.7400467432612, -122.386389332697) | 10 | 3 | 8 | 58 | 1 | |||
| 10136 | 41571 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 331 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/15/2000 12:00:00 AM | 6 | 4x4 | Permit Number 42086 | 5989933.46596 | 2113143.03075 | 37.7817074314288 | -122.478494971039 | (37.7817074314288, -122.478494971039) | 11 | 6 | 2 | 55 | 26 |
| 10149 | 47738 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 765ST Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/23/2002 12:00:00 AM | Permit Number 45522 | 6001007.50472324 | 2111284.16772448 | 37.7772401606319 | -122.440050778725 | (37.7772401606319, -122.440050778725) | 15 | 5 | 11 | 29492 | 41 | |||
| 10175 | 103130 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 418 28th Ave | 1 | : | Tree | Private 2 | 1 | 5987189.39247 | 2113118.19249 | 37.7814795396885 | -122.487986220863 | (37.7814795396885, -122.487986220863) | 11 | 6 | 2 | 55 | 26 | ||||
| 10210 | 46620 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1566 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2002 12:00:00 AM | 4 | 3x3 | Permit Number 44746 | 6015560.90449 | 2096875.62072 | 37.7384951204397 | -122.388699385265 | (37.7384951204397, -122.388699385265) | 10 | 3 | 8 | 58 | 1 |
| 10226 | 237496 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3927 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2017 12:00:00 AM | 8 | Width 3ft | 6003620.49393 | 2101843.48933 | 37.7514667420033 | -122.430337889878 | (37.7514667420033, -122.430337889878) | 2 | 4 | 5 | 28862 | 22 | ||
| 10244 | 82748 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1434-1436 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6008231.53118 | 2109847.29583 | 37.7737034553791 | -122.414958754439 | (37.7737034553791, -122.414958754439) | 8 | 2 | 9 | 28853 | 34 | |||
| 10254 | 201218 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 687 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6013091.2306 | 2113527.2998 | 37.7840797833092 | -122.398406448239 | (37.7840797833092, -122.398406448239) | 6 | 2 | 9 | 28856 | 6 | |||
| 10262 | 71774 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1209 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6007619.84868 | 2115422.03298 | 37.7889759474427 | -122.417469829771 | (37.7889759474427, -122.417469829771) | 13 | 1 | 10 | 28858 | 21 |
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) );