trees
6,344 rows where qSpecies_id = 19 sorted by PermitNotes descending
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▲ | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
167547 | 93001 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 395 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | Tree 4 on Harrison St | 6013360.4 | 2113007 | 37.7826661507953 | -122.397438711561 | (37.7826661507953, -122.397438711561) | 6 | 2 | 9 | 28856 | 6 | ||
177669 | 93000 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 395 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | Tree 3 on Harrison St | 6013360.4 | 2113007 | 37.7826661507953 | -122.397438711561 | (37.7826661507953, -122.397438711561) | 6 | 2 | 9 | 28856 | 6 | ||
99593 | 92999 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 395 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | Tree 2 on Harrison St | 6013360.4 | 2113007 | 37.7826661507953 | -122.397438711561 | (37.7826661507953, -122.397438711561) | 6 | 2 | 9 | 28856 | 6 | ||
104232 | 92998 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 395 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | Tree 1 on Harrison St | 6013360.4 | 2113007 | 37.7826661507953 | -122.397438711561 | (37.7826661507953, -122.397438711561) | 6 | 2 | 9 | 28856 | 6 | ||
170842 | 103021 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 40X Coleridge St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 3x3 | See 61 Fair Ave for old permit records | 6006901 | 2099544.2 | 37.7453386886112 | -122.418830426928 | (37.7453386886112, -122.418830426928) | 2 | 7 | 7 | 28859 | 2 | |
157369 | 17376 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1600 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | Property owner contact Achmed 821-1594. | 6014810.60512 | 2095342.40421 | 37.7342436096391 | -122.391186437905 | (37.7342436096391, -122.391186437905) | 10 | 3 | 8 | 58 | 1 | ||
124166 | 54246 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1234 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/31/1972 12:00:00 AM | 12 | Permit Number 9988 | 5988645.1955 | 2106901.8925 | 37.764496120049 | -122.482494273902 | (37.764496120049, -122.482494273902) | 1 | 8 | 3 | 56 | 35 | ||
25106 | 54033 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 919 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/1972 12:00:00 AM | 6x9 | Permit Number 9754 | 6004397.63865744 | 2103548.43352753 | 37.7561921088561 | -122.427771896657 | (37.7561921088561, -122.427771896657) | 2 | 4 | 5 | 28862 | 22 | ||
109452 | 30448 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 162 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/1956 12:00:00 AM | Permit Number 97 | 6001177.91304525 | 2121268.79222575 | 37.8046650454957 | -122.440177457205 | (37.8046650454957, -122.440177457205) | 13 | 9 | 1 | 57 | 17 | |||
144696 | 53821 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2864 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/23/1972 12:00:00 AM | 11 | Permit Number 9518 | 6000487.59762 | 2116510.25701 | 37.7915600431993 | -122.442224549531 | (37.7915600431993, -122.442224549531) | 13 | 6 | 1 | 29490 | 27 | ||
179627 | 30436 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 551 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/1956 12:00:00 AM | Permit Number 89 | 6010321.91268588 | 2119551.55402882 | 37.8004662734974 | -122.408412403344 | (37.8004662734974, -122.408412403344) | 3 | 1 | 10 | 308 | 23 | |||
4332 | 30435 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 3229 Barker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/1956 12:00:00 AM | Permit Number 88 | |||||||||||||
192562 | 30432 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 330 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/1956 12:00:00 AM | Permit Number 85 | 6011333.48355533 | 2119742.21280945 | 37.801046372014 | -122.404925373787 | (37.801046372014, -122.404925373787) | 3 | 1 | 10 | 308 | 23 | |||
27724 | 30430 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 418 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/1956 12:00:00 AM | Permit Number 83 | 6010919.16231667 | 2119684.73214888 | 37.8008653758927 | -122.406355057963 | (37.8008653758927, -122.406355057963) | 3 | 1 | 10 | 308 | 23 | |||
122990 | 30427 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 570 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/1956 12:00:00 AM | Permit Number 81 | 6010212.29248636 | 2119589.67066913 | 37.8005647930868 | -122.40879442568 | (37.8005647930868, -122.40879442568) | 3 | 1 | 10 | 308 | 23 | |||
89146 | 30426 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 310 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/1956 12:00:00 AM | Permit Number 80 | 6011421.79010926 | 2119754.63199922 | 37.8010854078142 | -122.404620668305 | (37.8010854078142, -122.404620668305) | 3 | 1 | 10 | 308 | 23 | |||
70 | 264978 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1439 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2020 12:00:00 AM | 3 | 3x3 | Permit Number 787884 | 5989892.86343 | 2105570.52868 | 37.7609130564186 | -122.47808163393 | (37.7609130564186, -122.47808163393) | 1 | 8 | 3 | 56 | 35 | |
17787 | 264681 | Private 9 | Magnolia grandiflora :: Southern Magnolia 19 | 840 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2020 12:00:00 AM | 3 | Permit Number 785486 | 5982954.56765 | 2110060.16253 | 37.7728351334222 | -122.502410039067 | (37.7728351334222, -122.502410039067) | 11 | 6 | 2 | 55 | 26 | ||
194488 | 230144 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 4363 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | Permit Number 784873 | 6001567.34631 | 2100557.57487 | 37.747819415532 | -122.437345839845 | (37.747819415532, -122.437345839845) | 2 | 4 | 5 | 63 | 22 | ||
3414 | 262418 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 101 Brighton Ave | 2 | 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 | |
4243 | 162646 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 101 Brighton Ave | 1 | 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 | |
4810 | 262420 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 101 Brighton Ave | 4 | 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 | |
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 | |
19533 | 259217 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 200 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784737 | 5996177 | 2090586 | 37.7201319742324 | -122.455264770625 | (37.7201319742324, -122.455264770625) | 9 | 8 | 6 | 28861 | 24 | |
16245 | 234784 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 11 Surrey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/2019 12:00:00 AM | 3 | 3x5 | Permit Number 784584 | 6002739.51006 | 2095878.74653 | 37.7350390051434 | -122.432958338056 | (37.7350390051434, -122.432958338056) | 2 | 7 | 5 | 63 | 7 | |
11247 | 264702 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 625 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/17/2020 12:00:00 AM | 3x3 | Permit Number 783216 | 6005628.43923 | 2105332.18724 | 37.761159426347 | -122.42364218242 | (37.761159426347, -122.42364218242) | 2 | 4 | 5 | 28859 | 19 | ||
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 | ||
183118 | 55096 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 118 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2019 12:00:00 AM | 3 | 3x3 | Permit Number 782758 | 5989310.74743 | 2114538.0017 | 37.7855014569703 | -122.480751415036 | (37.7855014569703, -122.480751415036) | 11 | 6 | 2 | 55 | 26 |
187682 | 12736 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1625 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/26/2019 12:00:00 AM | 3 | 3X3 | Permit Number 782752 | 5990372.3863 | 2114714.93418 | 37.7860489118948 | -122.477091430633 | (37.7860489118948, -122.477091430633) | 11 | 6 | 2 | 55 | 26 | |
15890 | 256718 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 927 Brazil Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782649 | |||||||||||
16057 | 167157 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 368 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/11/2020 12:00:00 AM | 3 | 4x4 | Permit Number 782616 | 6001774.58914 | 2103700.91584 | 37.7564620577863 | -122.436854194887 | (37.7564620577863, -122.436854194887) | 2 | 4 | 5 | 28862 | 3 | |
33 | 261067 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 1832 Egbert Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/13/2020 12:00:00 AM | 3 | 4x6 | Permit Number 782484 | 6011934 | 2092960 | 37.727541965346 | -122.400964507068 | (37.727541965346, -122.400964507068) | 10 | 3 | 8 | 58 | 1 | |
11758 | 41190 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2518 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2020 12:00:00 AM | 3 | Permit Number 782407 | 6003669.72123 | 2117044.16503 | 37.7932068601533 | -122.431252574158 | (37.7932068601533, -122.431252574158) | 13 | 9 | 1 | 29490 | 27 | ||
134280 | 41188 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2518 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/1999 12:00:00 AM | 3 | Permit Number 782407 | 6003667.91152 | 2117059.35603 | 37.7932484681986 | -122.431259920709 | (37.7932484681986, -122.431259920709) | 13 | 9 | 1 | 29490 | 27 | ||
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 | |
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 | |
11138 | 264697 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1285 Waller St | 3 | 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 | |
16004 | 264700 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1285 Waller St | 6 | 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 | |
17632 | 264698 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1285 Waller St | 4 | 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 | |
18009 | 264699 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1285 Waller St | 5 | 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 | |
46720 | 136361 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1715 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/2018 12:00:00 AM | 3 | Width 2ft | Permit Number 782052 | 6008713.64761 | 2118857.43693 | 37.7984702062984 | -122.413928536971 | (37.7984702062984, -122.413928536971) | 5 | 1 | 10 | 308 | 21 | |
118574 | 125934 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1715 Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 782052 | 6008711.31794 | 2118818.36709 | 37.7983627993626 | -122.413933833098 | (37.7983627993626, -122.413933833098) | 5 | 1 | 10 | 308 | 21 | |
149330 | 136362 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1715 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 782052 | 6008714.5466 | 2118843.19382 | 37.7984311487376 | -122.413924418086 | (37.7984311487376, -122.413924418086) | 5 | 1 | 10 | 308 | 21 | |
192828 | 243440 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 610 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781301 | 6008145.24343 | 2096008.29074 | 37.7356998404811 | -122.414277893926 | (37.7356998404811, -122.414277893926) | 2 | 7 | 7 | 28859 | 2 |
156949 | 81388 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1578 Indiana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/18/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781218 | 6015102.11924 | 2101247.13022 | 37.7504729398956 | -122.390591042653 | (37.7504729398956, -122.390591042653) | 10 | 3 | 8 | 28856 | 1 |
88964 | 253991 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 534 Leland Ave | 3 | Front Yard : Yard | Tree | Private 2 | 3x3 | Permit Number 781039 | 6007916 | 2088302 | 37.7145271314419 | -122.414525337386 | (37.7145271314419, -122.414525337386) | 9 | 7 | 8 | 309 | 39 | |||
161196 | 253990 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 534 Leland Ave | 2 | Front Yard : Yard | Tree | Private 2 | 3x3 | Permit Number 781039 | 6007916 | 2088302 | 37.7145271314419 | -122.414525337386 | (37.7145271314419, -122.414525337386) | 9 | 7 | 8 | 309 | 39 | |||
84809 | 167131 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 4540 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/20/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780648 | 6000902.50099 | 2104660.33643 | 37.7590467894041 | -122.439938965707 | (37.7590467894041, -122.439938965707) | 2 | 4 | 5 | 28862 | 3 | |
139860 | 128055 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 449 North Point St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780354 | 6008758.87824 | 2121765.85838 | 37.8064585449799 | -122.413977880988 | (37.8064585449799, -122.413977880988) | 3 | 1 | 10 | 308 | 23 | |
79397 | 230623 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1189 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/14/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 780105 | 6003227.47781 | 2101395.97858 | 37.7502157130929 | -122.431665039223 | (37.7502157130929, -122.431665039223) | 2 | 4 | 5 | 28862 | 22 | |
121821 | 42970 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1150 Bacon St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 07/05/2000 12:00:00 AM | 12 | 3x3 | Permit Number 780074 | 6007984.36875 | 2092053.86438 | 37.7248328006832 | -122.414554361714 | (37.7248328006832, -122.414554361714) | 9 | 3 | 7 | 309 | 28 |
123807 | 47144 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3240 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780028 | 5998645.60192 | 2116582.62174 | 37.7916535861885 | -122.448603018129 | (37.7916535861885, -122.448603018129) | 11 | 6 | 1 | 54 | 30 | |
135541 | 103962 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3240 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/2017 12:00:00 AM | 3 | Permit Number 780028 | 5998623.05948 | 2116578.56663 | 37.7916411629484 | -122.448680722253 | (37.7916411629484, -122.448680722253) | 11 | 6 | 1 | 54 | 30 | ||
184054 | 253095 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1201 29th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779996 | 5987047.82966 | 2107087.01861 | 37.7649113707945 | -122.488032657316 | (37.7649113707945, -122.488032657316) | 1 | 8 | 3 | 56 | 35 | |
44224 | 124401 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3974 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779990 | 5995681.39121 | 2115513.426 | 37.7885479271183 | -122.45878165412 | (37.7885479271183, -122.45878165412) | 11 | 6 | 1 | 54 | 31 | |
84502 | 4457 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1408 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/26/2017 12:00:00 AM | 3 | 3X3 | Permit Number 779671 | 6004499.90701 | 2100635.94447 | 37.7482008782693 | -122.427210766376 | (37.7482008782693, -122.427210766376) | 2 | 4 | 5 | 63 | 22 | |
56035 | 130626 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3660 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | Permit Number 779583 | 5996802.12344 | 2115996.768 | 37.7899394082122 | -122.454939052208 | (37.7899394082122, -122.454939052208) | 11 | 6 | 1 | 54 | 31 | ||
145287 | 130716 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2898 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 779575 | 5999812.31371 | 2117089.58142 | 37.7931122065133 | -122.444602671772 | (37.7931122065133, -122.444602671772) | 13 | 9 | 1 | 57 | 27 | |
133795 | 63894 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1640 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/01/2017 12:00:00 AM | 3 | Permit Number 779548 | 6006894.81694 | 2116748.05753 | 37.7925760612872 | -122.420072490278 | (37.7925760612872, -122.420072490278) | 13 | 9 | 10 | 28858 | 32 | ||
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 | |
137101 | 251410 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 19 | 2777 Pine St | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | Permit Number 779015 | 6000658 | 2114782 | 37.7868244087741 | -122.441510888069 | (37.7868244087741, -122.441510888069) | 13 | 6 | 1 | 29490 | 27 | |||
39420 | 253554 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 1855 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778968 | 5986885.63083 | 2102641.2721 | 37.7526951056681 | -122.488266922919 | (37.7526951056681, -122.488266922919) | 1 | 8 | 3 | 56 | 35 | |
39573 | 97527 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 532 Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | Permit Number 778941 | 6013942.6198 | 2114432.1579 | 37.7866117064154 | -122.395524343042 | (37.7866117064154, -122.395524343042) | 6 | 2 | 9 | 28855 | 6 | ||
51137 | 97526 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 532 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | Permit Number 778941 | 6013958.0435 | 2114445.5251 | 37.7866492675441 | -122.395471917224 | (37.7866492675441, -122.395471917224) | 6 | 2 | 9 | 28855 | 6 | ||
88342 | 201175 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 600 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | Permit Number 778941 | 6013539.5466 | 2114043.4802 | 37.7855220594596 | -122.396891627661 | (37.7855220594596, -122.396891627661) | 6 | 2 | 9 | 28855 | 6 | ||
103100 | 97523 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 532 Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/28/2016 12:00:00 AM | 2 | 3x3 | Permit Number 778941 | 6013933.3655 | 2114419.8189 | 37.7865773116244 | -122.395555496101 | (37.7865773116244, -122.395555496101) | 6 | 2 | 9 | 28855 | 6 | |
110289 | 193166 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 282 02nd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | Permit Number 778941 | 6013536.23807 | 2114063.46383 | 37.7855767457266 | -122.396904475854 | (37.7855767457266, -122.396904475854) | 6 | 2 | 9 | 28855 | 6 | ||
129954 | 97525 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 532 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | Permit Number 778941 | 6013969.3542 | 2114455.8076 | 37.786678130014 | -122.395433505269 | (37.786678130014, -122.395433505269) | 6 | 2 | 9 | 28855 | 6 | ||
167705 | 97528 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 532 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | Permit Number 778941 | 6013984.7779 | 2114467.1183 | 37.7867100444277 | -122.395380935237 | (37.7867100444277, -122.395380935237) | 6 | 2 | 9 | 28855 | 6 | ||
121133 | 121467 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 50 Surrey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | Permit Number 778925 | 6002578 | 2096112 | 37.735670303373 | -122.4335333993 | (37.735670303373, -122.4335333993) | 2 | 7 | 5 | 63 | 7 | ||
27178 | 121211 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 72 Commonwealth Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/14/2016 12:00:00 AM | 3 | 4x4 | Permit Number 778868 | 5996545.60636 | 2114052.7721 | 37.784586997256 | -122.455685996702 | (37.784586997256, -122.455685996702) | 11 | 6 | 1 | 54 | 31 | |
148229 | 121210 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 72 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/14/2016 12:00:00 AM | 3 | 4x4 | Permit Number 778868 | 5996545.60636 | 2114052.7721 | 37.784586997256 | -122.455685996702 | (37.784586997256, -122.455685996702) | 11 | 6 | 1 | 54 | 31 | |
31974 | 112517 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2303 GREEN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/20/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778661 | 6001977 | 2118017 | 37.7957819399996 | -122.437179174175 | (37.7957819399996, -122.437179174175) | 13 | 9 | 1 | 57 | 27 | |
100907 | 229627 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 3662 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778622 | 6008456.11159 | 2097816.22885 | 37.7406815009641 | -122.413330912287 | (37.7406815009641, -122.413330912287) | 2 | 7 | 7 | 28859 | 2 | |
49828 | 117446 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1442 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/14/2016 12:00:00 AM | 3 | Permit Number 778580 | 6007836.0514 | 2116543.84727 | 37.7920683364342 | -122.416801303441 | (37.7920683364342, -122.416801303441) | 5 | 1 | 10 | 28858 | 21 | ||
63207 | 121472 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1290 20th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/06/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778435 | 5989898.73155 | 2106592.32318 | 37.7637189695993 | -122.47813604713 | (37.7637189695993, -122.47813604713) | 1 | 8 | 3 | 56 | 35 | |
15059 | 254699 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 650 Illinois St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2018 12:00:00 AM | 3 | Permit Number 778364 | 6015970.50894 | 2106056.61706 | 37.7637269088073 | -122.387923622314 | (37.7637269088073, -122.387923622314) | 14 | 3 | 8 | 28856 | 29 | ||
96441 | 254702 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 650 Illinois St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2018 12:00:00 AM | 3 | Permit Number 778364 | 6015970.50894 | 2106056.61706 | 37.7637269088073 | -122.387923622314 | (37.7637269088073, -122.387923622314) | 14 | 3 | 8 | 28856 | 29 | ||
145856 | 254700 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 650 Illinois St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2018 12:00:00 AM | 3 | Permit Number 778364 | 6015970.50894 | 2106056.61706 | 37.7637269088073 | -122.387923622314 | (37.7637269088073, -122.387923622314) | 14 | 3 | 8 | 28856 | 29 | ||
191366 | 254701 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 650 Illinois St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2018 12:00:00 AM | 3 | Permit Number 778364 | 6015970.50894 | 2106056.61706 | 37.7637269088073 | -122.387923622314 | (37.7637269088073, -122.387923622314) | 14 | 3 | 8 | 28856 | 29 | ||
40368 | 116995 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 145 Cherry St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778330 | 5996096.3847 | 2115639.09761 | 37.7889168317127 | -122.457354944402 | (37.7889168317127, -122.457354944402) | 11 | 6 | 1 | 54 | 31 | |
134012 | 117417 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 19 | 2835 Washington St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x10 | Permit Number 778177 | 6001153.1 | 2116153.5 | 37.7906183870332 | -122.439896334555 | (37.7906183870332, -122.439896334555) | 13 | 6 | 1 | 29490 | 27 | |||
179222 | 101795 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 795 Folsom St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | Permit Number 778116 | 6012494.1826 | 2112956.975 | 37.7824805262764 | -122.400431957866 | (37.7824805262764, -122.400431957866) | 6 | 2 | 9 | 28856 | 34 | ||
137713 | 36685 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 3425 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/10/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778028 | 6006750.72599795 | 2104934.92825062 | 37.7601319316605 | -122.41973247702 | (37.7601319316605, -122.41973247702) | 2 | 4 | 7 | 28859 | 19 | |
18462 | 98489 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1813 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/29/2016 12:00:00 AM | 3 | 4.5x5 | Permit Number 777656 | 5999969.69733 | 2115286.35323 | 37.7881699939074 | -122.443928497714 | (37.7881699939074, -122.443928497714) | 13 | 6 | 1 | 29490 | 27 | |
46368 | 116982 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2835 Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/23/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777189 | 6001198.54603 | 2115911.07508 | 37.7899553379293 | -122.439721706598 | (37.7899553379293, -122.439721706598) | 13 | 6 | 1 | 29490 | 27 | |
129048 | 59704 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3143 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/14/2016 12:00:00 AM | 2 | Permit Number 777181 | 5999649.90805 | 2116020.39429 | 37.7901672316774 | -122.445087702261 | (37.7901672316774, -122.445087702261) | 13 | 6 | 1 | 29490 | 27 | |
2065 | 849 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 109X POTRERO AVE | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 36 | 3x3 | Permit Number 777000 | 6010279 | 2107809 | 37.7682216042911 | -122.407732456911 | (37.7682216042911, -122.407732456911) | 8 | 4 | 8 | 28853 | 19 | |
24030 | 848 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 109X POTRERO AVE | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/11/2006 12:00:00 AM | 3x3 | Permit Number 777000 | 6010279 | 2107809 | 37.7682216042911 | -122.407732456911 | (37.7682216042911, -122.407732456911) | 8 | 4 | 8 | 28853 | 19 | ||
76330 | 846 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 109X POTRERO AVE | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 40 | 3x3 | Permit Number 777000 | 6010279 | 2107809 | 37.7682216042911 | -122.407732456911 | (37.7682216042911, -122.407732456911) | 8 | 4 | 8 | 28853 | 19 | |
103072 | 847 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 109X POTRERO AVE | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 24 | 3x3 | Permit Number 777000 | 6010279 | 2107809 | 37.7682216042911 | -122.407732456911 | (37.7682216042911, -122.407732456911) | 8 | 4 | 8 | 28853 | 19 | |
147458 | 845 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 109X POTRERO AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 40 | 3x3 | Permit Number 777000 | 6010279 | 2107809 | 37.7682216042911 | -122.407732456911 | (37.7682216042911, -122.407732456911) | 8 | 4 | 8 | 28853 | 19 | |
167256 | 18309 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 109 POTRERO AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 40 | 3x3 | Permit Number 777000 | 6010279 | 2107809 | 37.7682216042911 | -122.407732456911 | (37.7682216042911, -122.407732456911) | 8 | 4 | 8 | 28853 | 19 | |
177008 | 18308 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 111 Potrero Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 40 | 3x3 | Permit Number 777000 | 6010285.0040856 | 2107800.6845896 | 37.7681991081888 | -122.407711102885 | (37.7681991081888, -122.407711102885) | 8 | 4 | 8 | 28853 | 19 | |
179348 | 844 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 109X POTRERO AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 40 | 3x3 | Permit Number 777000 | 6010279 | 2107809 | 37.7682216042911 | -122.407732456911 | (37.7682216042911, -122.407732456911) | 8 | 4 | 8 | 28853 | 19 | |
92889 | 70255 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 235 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/29/2015 12:00:00 AM | 1 | 3x3 | Permit Number 776937 | 6004303.48389 | 2092032.17733 | 37.724565770383 | -122.427277205573 | (37.724565770383, -122.427277205573) | 9 | 7 | 6 | 28861 | 5 | |
132456 | 97136 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2929 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2015 12:00:00 AM | 24 | 3x3 | Permit Number 776885 | 6000665.32299 | 2116159.50281 | 37.7906070910044 | -122.441584441793 | (37.7906070910044, -122.441584441793) | 13 | 6 | 1 | 29490 | 27 | |
157082 | 97137 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2929 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2015 12:00:00 AM | 24 | 3x3 | Permit Number 776885 | 6000677.09541 | 2116163.2813 | 37.7906181364597 | -122.441543981264 | (37.7906181364597, -122.441543981264) | 13 | 6 | 1 | 29490 | 27 | |
64882 | 101080 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2619 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2015 12:00:00 AM | 2 | 3x3 | Permit Number 776708 | 5999607.59307 | 2117837.36801 | 37.7951537466998 | -122.445364806757 | (37.7951537466998, -122.445364806757) | 13 | 9 | 1 | 57 | 17 | |
121136 | 45835 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 680 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/29/2015 12:00:00 AM | Permit Number 776633 | 6012169.50994414 | 2114476.97613275 | 37.7866359833773 | -122.401662060279 | (37.7866359833773, -122.401662060279) | 12 | 2 | 9 | 28855 | 6 |
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) );