trees
6,344 rows where qSpecies_id = 19 sorted by SiteOrder
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12976 | 260626 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1546 Van Dyke Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6014701.33267 | 2093312.36998 | 37.7286634818435 | -122.391422361758 | (37.7286634818435, -122.391422361758) | 10 | 3 | 8 | 58 | 1 | |||
14870 | 87142 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 54 Homestead St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2008 12:00:00 AM | 3x3 | Permit Number 50130 | 6000955 | 2101398 | 37.7500921913505 | -122.439523535984 | (37.7500921913505, -122.439523535984) | 2 | 4 | 5 | 28862 | 22 | |||
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 | |||||||||||
17566 | 89252 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 433 34th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2020 12:00:00 AM | 3 | 4x4 | Permit Number 51885 | 5985288.27991 | 2112944.49227 | 37.780891524599 | -122.49455024837 | (37.780891524599, -122.49455024837) | 11 | 6 | 2 | 55 | 26 | ||
25928 | 96470 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2001 Market St | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 05/20/2011 12:00:00 AM | Permit Number 767173 | 6004662.9 | 2108069.9 | 37.7686219813575 | -122.427176582427 | (37.7686219813575, -122.427176582427) | 8 | 4 | 5 | 28862 | 3 | |||
46974 | 86712 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 3806 22nd St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/24/2007 12:00:00 AM | Permit Number 49698 | 6003066 | 2103019 | 37.7546629917484 | -122.432339342326 | (37.7546629917484, -122.432339342326) | 2 | 4 | 5 | 28862 | 22 | ||||
51013 | 88533 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 55 Cervantes Blvd | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2008 12:00:00 AM | 3x3 | Permit Number 51490 | 6001717.8 | 2120796.9 | 37.8034000766729 | -122.438275302167 | (37.8034000766729, -122.438275302167) | 13 | 9 | 1 | 57 | 17 | |||
64034 | 96464 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2001 Market St | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 05/20/2011 12:00:00 AM | Permit Number 767173 | 6004662.9 | 2108069.9 | 37.7686219813575 | -122.427176582427 | (37.7686219813575, -122.427176582427) | 8 | 4 | 5 | 28862 | 3 | |||
67424 | 94559 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1652 12th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/15/2010 12:00:00 AM | 3x3 | Permit Number 53733 | 5992517.8 | 2104198.3 | 37.7572972894341 | -122.468903351171 | (37.7572972894341, -122.468903351171) | 1 | 8 | 4 | 56 | 12 | ||
67905 | 96467 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2001 Market St | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 05/20/2011 12:00:00 AM | Permit Number 767173 | 6004662.9 | 2108069.9 | 37.7686219813575 | -122.427176582427 | (37.7686219813575, -122.427176582427) | 8 | 4 | 5 | 28862 | 3 | |||
71352 | 115910 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 867 HAYES ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003721 | 2110697 | 37.7757820445063 | -122.430622023399 | (37.7757820445063, -122.430622023399) | 7 | 9 | 11 | 29492 | 10 | ||||||
74433 | 88391 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 278 22nd Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51369 | 5989038.05439 | 2113475.60189 | 37.7825685533271 | -122.481617002005 | (37.7825685533271, -122.481617002005) | 11 | 6 | 2 | 55 | 26 | ||
98248 | 94927 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 325 Sanchez St | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 12/07/2010 12:00:00 AM | 3x3 | Permit Number 53976 | 6003898 | 2106263.7 | 37.7636193068731 | -122.429693469686 | (37.7636193068731, -122.429693469686) | 8 | 4 | 5 | 28862 | 3 | |||
99316 | 108440 | Private 9 | Magnolia grandiflora :: Southern Magnolia 19 | 105 Lake St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 5995179.45913 | 2114890.0759 | 37.7868075137311 | -122.460473064302 | (37.7868075137311, -122.460473064302) | 11 | 6 | 1 | 54 | 11 | ||||
104334 | 96466 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2001 Market St | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 05/20/2011 12:00:00 AM | Permit Number 767173 | 6004662.9 | 2108069.9 | 37.7686219813575 | -122.427176582427 | (37.7686219813575, -122.427176582427) | 8 | 4 | 5 | 28862 | 3 | |||
129173 | 254479 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1542 Broderick St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/20/2018 12:00:00 AM | 3 | 3x3 | Permit Number 769825 | 6000683.63216 | 2113941.30813 | 37.784517546108 | -122.441361861535 | (37.784517546108, -122.441361861535) | 15 | 6 | 11 | 29490 | 13 | |
131611 | 255979 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 965 Powhattan Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2018 12:00:00 AM | 3 | 3x3 | Permit Number 776273 | 6009246 | 2098072 | 37.7414281092456 | -122.410617825786 | (37.7414281092456, -122.410617825786) | 10 | 7 | 7 | 28859 | 2 | ||
147031 | 108439 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 105 Lake St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 5995179.45913 | 2114890.0759 | 37.7868075137311 | -122.460473064302 | (37.7868075137311, -122.460473064302) | 11 | 6 | 1 | 54 | 11 | ||||
148408 | 106044 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 415 DEWEY BLVD | Sidewalk: Curb side : Yard | Tree | Private 2 | 5995172.1 | 2100351 | 37.7468865723154 | -122.459445180048 | (37.7468865723154, -122.459445180048) | 1 | 8 | 4 | 59 | 40 | ||||||
150385 | 96469 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2001 Market St | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 05/20/2011 12:00:00 AM | Permit Number 767173 | 6004662.9 | 2108069.9 | 37.7686219813575 | -122.427176582427 | (37.7686219813575, -122.427176582427) | 8 | 4 | 5 | 28862 | 3 | |||
153733 | 96465 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2001 Market St | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 05/20/2011 12:00:00 AM | Permit Number 767173 | 6004662.9 | 2108069.9 | 37.7686219813575 | -122.427176582427 | (37.7686219813575, -122.427176582427) | 8 | 4 | 5 | 28862 | 3 | |||
162815 | 108667 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 743 45th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773175 | 5981956.75596 | 2110691.04473 | 37.7745086716833 | -122.505908306981 | (37.7745086716833, -122.505908306981) | 11 | 6 | 2 | 55 | 26 | |
187934 | 108441 | Private 9 | Magnolia grandiflora :: Southern Magnolia 19 | 105 Lake St | Front Yard : Cutout | Tree | Private 2 | FUF | 3x3 | Permit Number 773769 | 5995179.45913 | 2114890.0759 | 37.7868075137311 | -122.460473064302 | (37.7868075137311, -122.460473064302) | 11 | 6 | 1 | 54 | 11 | |||
188064 | 87822 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2274 44th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50715 | 5982710.3 | 2099649.4 | 37.744235769489 | -122.502484303694 | (37.744235769489, -122.502484303694) | 1 | 8 | 3 | 29491 | 35 | |||
190657 | 96468 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2001 Market St | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 05/20/2011 12:00:00 AM | Permit Number 767173 | 6004662.9 | 2108069.9 | 37.7686219813575 | -122.427176582427 | (37.7686219813575, -122.427176582427) | 8 | 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 | |
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 | |
355 | 229322 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2771 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 6009868 | 2101202 | 37.7500572563342 | -122.408687913648 | (37.7500572563342, -122.408687913648) | 2 | 4 | 7 | 28859 | 19 | |||
493 | 193117 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1789 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6014368.11598 | 2096649.52963 | 37.737808141841 | -122.39280769162 | (37.737808141841, -122.39280769162) | 10 | 3 | 8 | 58 | 1 | |||
500 | 230695 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 174 Hancock St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6003158.12549 | 2105079.13528 | 37.7603248546353 | -122.432167861868 | (37.7603248546353, -122.432167861868) | 2 | 4 | 5 | 28862 | 3 | |||
527 | 32100 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 156 Hartford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1995 12:00:00 AM | 10 | Permit Number 35473 | 6002658.19542 | 2104999.95129 | 37.7600790771166 | -122.433891224619 | (37.7600790771166, -122.433891224619) | 2 | 4 | 5 | 28862 | 3 | |
745 | 43286 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1200 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/2000 12:00:00 AM | 13 | Permit Number 43056 | 6013973.47383 | 2105741.62866 | 37.7627511832352 | -122.394808740727 | (37.7627511832352, -122.394808740727) | 14 | 3 | 8 | 28856 | 29 | |
879 | 229569 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 129 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5997890.05734 | 2106786.37745 | 37.7647124175658 | -122.450510642978 | (37.7647124175658, -122.450510642978) | 15 | 5 | 11 | 29492 | 9 | |||
1025 | 55220 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 151 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/27/1984 12:00:00 AM | 3 | Permit Number 21451 | 5989581.42537 | 2114369.00761 | 37.7850531755237 | -122.479802589294 | (37.7850531755237, -122.479802589294) | 11 | 6 | 2 | 55 | 26 | |
1118 | 36625 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1998 12:00:00 AM | Permit Number 39461 | ||||||||||||||
1184 | 138898 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 640 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6004115.5085 | 2110637.0852 | 37.7756398749162 | -122.429253045645 | (37.7756398749162, -122.429253045645) | 7 | 9 | 11 | 28852 | 10 | |||
1219 | 122783 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 424 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6006739 | 2101281 | 37.7500984250046 | -122.419513794578 | (37.7500984250046, -122.419513794578) | 2 | 4 | 7 | 28859 | 19 | |||
1278 | 170724 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 540 San Juan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 3ft | 6000352.85514 | 2092916.82872 | 37.7267706040626 | -122.440997412 | (37.7267706040626, -122.440997412) | 9 | 7 | 6 | 28861 | 25 | ||
1296 | 114159 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 2250 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770124 | 6002793.85496 | 2117859.65506 | 37.7953963109343 | -122.434341453993 | (37.7953963109343, -122.434341453993) | 13 | 9 | 1 | 57 | 17 | |
1344 | 230660 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3881 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6003952.37271 | 2101858.52195 | 37.751526811317 | -122.429191284844 | (37.751526811317, -122.429191284844) | 2 | 4 | 5 | 28862 | 22 | |||
1369 | 229980 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 542 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/1982 12:00:00 AM | 15 | Width 3ft | Permit Number 19660 | 6003257.39485 | 2095864.57819 | 37.735029463323 | -122.431166815702 | (37.735029463323, -122.431166815702) | 2 | 7 | 5 | 63 | 7 | |
1463 | 229983 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 568 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/1982 12:00:00 AM | 15 | Width 2ft | Permit Number 19661 | 6003129.34202 | 2095763.1248 | 37.7347436380916 | -122.431602298905 | (37.7347436380916, -122.431602298905) | 2 | 7 | 5 | 63 | 7 | |
1509 | 78622 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 535 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6008370.1442 | 2114331.41346 | 37.7860235585803 | -122.414796682248 | (37.7860235585803, -122.414796682248) | 13 | 10 | 9 | 28858 | 36 | |||
1624 | 70261 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3828 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5996527.35216 | 2114976.82048 | 37.7871231398678 | -122.455815970326 | (37.7871231398678, -122.455815970326) | 11 | 6 | 1 | 54 | 31 | |||
1682 | 3092 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2980 California St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000114.43818 | 2115142.33295 | 37.7877828069853 | -122.443417371621 | (37.7877828069853, -122.443417371621) | 13 | 6 | 1 | 29490 | 27 | |||
1993 | 230761 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 240 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6001081.17206 | 2104997.55986 | 37.7599828919108 | -122.43934520993 | (37.7599828919108, -122.43934520993) | 2 | 4 | 5 | 28862 | 3 | |||
2006 | 50719 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2279 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/2004 12:00:00 AM | 5 | Permit Number 47272 | 5988534.5082 | 2099828.4885 | 37.7450680122132 | -122.482358807669 | (37.7450680122132, -122.482358807669) | 1 | 8 | 3 | 29491 | 35 | |
2078 | 168123 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2329 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5999728.56043 | 2116992.74288 | 37.792841533961 | -122.444885497769 | (37.792841533961, -122.444885497769) | 13 | 6 | 1 | 29490 | 27 | |||
2253 | 71688 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1930 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 5998564.1414 | 2110396.2631 | 37.774662803409 | -122.448439160727 | (37.774662803409, -122.448439160727) | 15 | 5 | 11 | 29492 | 16 | |||
2329 | 248481 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 771 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5999055.2186 | 2107891.4924 | 37.7678134046704 | -122.446560186722 | (37.7678134046704, -122.446560186722) | 15 | 5 | 11 | 29492 | 9 | |||
2390 | 143239 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 986 POLK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6006984.4971 | 2114185.2189 | 37.7855441907656 | -122.41958028036 | (37.7855441907656, -122.41958028036) | 13 | 9 | 9 | 28858 | 36 | |||
2439 | 152111 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 61 Woodward St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4x5 | 6006504.58335 | 2108147.23788 | 37.7689383093717 | -122.420811828315 | (37.7689383093717, -122.420811828315) | 8 | 4 | 7 | 28853 | 19 | |||
2486 | 230212 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 176 States St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/2015 12:00:00 AM | 3 | Width 3ft | 6001156.11314 | 2106298.81983 | 37.7635600973444 | -122.439179292201 | (37.7635600973444, -122.439179292201) | 15 | 5 | 5 | 28862 | 3 | ||
2488 | 142324 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1773 GROVE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5999334.4877 | 2110458.6226 | 37.7748780407761 | -122.44577887398 | (37.7748780407761, -122.44577887398) | 15 | 5 | 11 | 29492 | 16 | |||
2498 | 230703 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 230 Dorland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003998.71516 | 2105716.62151 | 37.7621228628946 | -122.42930611389 | (37.7621228628946, -122.42930611389) | 8 | 4 | 5 | 28862 | 3 | |||
2594 | 177351 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 501X San Juan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2020 12:07:00 PM | 3 | Width 3ft | Permit Number 48612 | 6000375.5599 | 2092850.31101 | 37.7265892548896 | -122.440914152761 | (37.7265892548896, -122.440914152761) | 9 | 7 | 6 | 28861 | 25 | |
2609 | 10168 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1025 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 2X2 | 6005769.33975 | 2102766.2906 | 37.7541220254375 | -122.422972492697 | (37.7541220254375, -122.422972492697) | 2 | 4 | 5 | 28859 | 19 | |||
2786 | 208603 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 330 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 5ft | 5996564.3769 | 2106988.87425 | 37.7651924567906 | -122.455110430599 | (37.7651924567906, -122.455110430599) | 15 | 5 | 11 | 29492 | 12 | |||
2828 | 81279 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2294 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52532 | 5986721.5097 | 2099657.5798 | 37.7444931137009 | -122.488615192328 | (37.7444931137009, -122.488615192328) | 1 | 8 | 3 | 29491 | 35 | |
2840 | 208818 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 204 Acadia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6001433.86045 | 2094986.8847 | 37.7325160147058 | -122.437408581945 | (37.7325160147058, -122.437408581945) | 9 | 7 | 5 | 63 | 40 | |||
2848 | 230823 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 4328 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6001534.87211 | 2105281.58352 | 37.7607885603698 | -122.43779642627 | (37.7607885603698, -122.43779642627) | 15 | 4 | 5 | 28862 | 3 | |||
2933 | 192982 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1135 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6011684.46525 | 2103085.46172 | 37.755330400403 | -122.402538867895 | (37.755330400403, -122.402538867895) | 10 | 3 | 8 | 28856 | 29 | |||
2943 | 177371 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 49 Ney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003790.41241 | 2094032.67984 | 37.7300296743254 | -122.429193404555 | (37.7300296743254, -122.429193404555) | 9 | 7 | 6 | 28861 | 5 | |||
3029 | 181658 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1285 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5987371.0004 | 2106539.9848 | 37.7634282140159 | -122.486874731079 | (37.7634282140159, -122.486874731079) | 1 | 8 | 3 | 56 | 35 | |||
3137 | 66513 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1411 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/28/1991 12:00:00 AM | 4 | Permit Number 29678 | 6006713.5616 | 2115771.7123 | 37.7898850457115 | -122.420630301385 | (37.7898850457115, -122.420630301385) | 13 | 9 | 10 | 28858 | 21 | |
3248 | 85701 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 926 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/23/2020 12:00:00 AM | 3 | 3x3 | 6010962.65697 | 2112458.52521 | 37.781026374014 | -122.405695276931 | (37.781026374014, -122.405695276931) | 14 | 2 | 9 | 28853 | 34 | ||
3378 | 230766 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 194 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6000059.54509 | 2104891.85845 | 37.7596344702783 | -122.442870922879 | (37.7596344702783, -122.442870922879) | 2 | 4 | 5 | 28862 | 3 | |||
3405 | 108544 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 150 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773707 | 6003029.81861 | 2094379.55796 | 37.730939036385 | -122.431847627669 | (37.730939036385, -122.431847627669) | 9 | 7 | 5 | 28861 | 25 |
3514 | 236494 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 330 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2019 12:00:00 AM | 3 | 3x3 | 6008239.85381 | 2097040.27643 | 37.7385387618647 | -122.414023771603 | (37.7385387618647, -122.414023771603) | 2 | 7 | 7 | 28859 | 2 | ||
3524 | 142455 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1612 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6000105.7777 | 2110265.4989 | 37.7743917798743 | -122.443096955102 | (37.7743917798743, -122.443096955102) | 15 | 5 | 11 | 29492 | 16 | |||
3769 | 39565 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 340 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | 7 | Permit Number 40986 | 6011421.0186 | 2106801.06955 | 37.765517919653 | -122.403711377001 | (37.765517919653, -122.403711377001) | 8 | 3 | 8 | 28853 | 20 | |
3816 | 229732 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2749 Harrison St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 8ft | 6008964.54646 | 2102425.01611 | 37.7533647423057 | -122.411898531501 | (37.7533647423057, -122.411898531501) | 2 | 4 | 7 | 28859 | 19 | |||
3950 | 230064 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 501 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007631.21664 | 2095734.29453 | 37.7349186191825 | -122.416035690789 | (37.7349186191825, -122.416035690789) | 2 | 7 | 7 | 28859 | 2 | |||
3961 | 79969 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1209 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6009151.65519 | 2110631.00796 | 37.7759070057295 | -122.411831280182 | (37.7759070057295, -122.411831280182) | 8 | 2 | 9 | 28853 | 34 | |||
3965 | 141553 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 59 KITTREDGE TER | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5997973.788 | 2111391.0975 | 37.7773605902541 | -122.450553037974 | (37.7773605902541, -122.450553037974) | 15 | 6 | 2 | 54 | 16 | |||
3978 | 109312 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 60 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774768 | 6008187.9 | 2099833.5 | 37.7462054183774 | -122.414400990572 | (37.7462054183774, -122.414400990572) | 2 | 7 | 7 | 28859 | 2 |
4018 | 230535 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3470 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6007100.85634 | 2104416.17044 | 37.7587272602842 | -122.418484755192 | (37.7587272602842, -122.418484755192) | 2 | 4 | 7 | 28859 | 19 | |||
4030 | 65762 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3002 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1990 12:00:00 AM | 13 | Permit Number 28725 | 6003868.45772 | 2119096.10509 | 37.7988522212082 | -122.43071142781 | (37.7988522212082, -122.43071142781) | 13 | 9 | 1 | 57 | 17 | |
4068 | 38625 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1396 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 3 | Permit Number 40563 | 6016053.9414 | 2093366.9092 | 37.7288882156246 | -122.386750071292 | (37.7288882156246, -122.386750071292) | 10 | 3 | 8 | 58 | 1 | |
4127 | 74230 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 1011 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/02/1996 12:00:00 AM | 10 | 6011143.4423 | 2118449.9882 | 37.7974876128867 | -122.405491940883 | (37.7974876128867, -122.405491940883) | 3 | 1 | 10 | 308 | 23 | ||
4219 | 71431 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 212 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6010229.3071 | 2121323.3934 | 37.8053261203342 | -122.408857935135 | (37.8053261203342, -122.408857935135) | 3 | 1 | 10 | 308 | 23 | |||
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 | |
4264 | 130484 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 148 Pixley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6002643.1953 | 2119039.17059 | 37.7986264014436 | -122.434947157292 | (37.7986264014436, -122.434947157292) | 13 | 9 | 1 | 57 | 17 | |||
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 | |||||||||||||
4387 | 264910 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 1615 Wallace Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 11/04/2020 12:00:00 AM | 3 | 4x4 | Permit Number 775989 | 6014687.7877 | 2092924.6213 | 37.7275980500808 | -122.391442091837 | (37.7275980500808, -122.391442091837) | 10 | 3 | 8 | 58 | 1 | |
4390 | 61550 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 933 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1984 12:00:00 AM | 8 | Permit Number 21508 | 6012798.10137 | 2103191.73514 | 37.7556843132942 | -122.398695011666 | (37.7556843132942, -122.398695011666) | 10 | 3 | 8 | 28856 | 29 | |
4505 | 59850 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1274 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/1981 12:00:00 AM | 4 | Permit Number 19305 | 6016629.87582 | 2093981.66592 | 37.7306080858771 | -122.384801815251 | (37.7306080858771, -122.384801815251) | 10 | 3 | 8 | 58 | 1 | |
4515 | 130841 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2140 Pacific Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6003916.87009 | 2117324.15419 | 37.7939896417495 | -122.430417409747 | (37.7939896417495, -122.430417409747) | 13 | 9 | 1 | 29490 | 27 | |||
4550 | 60389 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1458 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 5 | Permit Number 19969 | 6015669.4777 | 2094699.9194 | 37.7325271015793 | -122.388172191813 | (37.7325271015793, -122.388172191813) | 10 | 3 | 8 | 58 | 1 | |
4575 | 29055 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 400X 11th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/27/2005 12:00:00 AM | 3 | 3x3 | 6008920.1536798 | 2108682.7358637 | 37.7705445174102 | -122.412494357701 | (37.7705445174102, -122.412494357701) | 8 | 2 | 9 | 28853 | 19 | ||
4626 | 5513 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 821 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/26/2002 12:00:00 AM | 18 | 5X5 | 6005073.13796 | 2103547.17923 | 37.7562268536034 | -122.425435698922 | (37.7562268536034, -122.425435698922) | 2 | 4 | 5 | 28859 | 19 | ||
4673 | 60356 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1261 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1982 12:00:00 AM | 4 | Permit Number 19934 | 6016682.1383 | 2093866.4324 | 37.7302945678233 | -122.384613110545 | (37.7302945678233, -122.384613110545) | 10 | 3 | 8 | 58 | 1 | ||
4708 | 65963 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2658 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/1990 12:00:00 AM | 9 | Permit Number 28985 | 5989288.4886 | 2097252.0638 | 37.7380376514495 | -122.479563236125 | (37.7380376514495, -122.479563236125) | 1 | 8 | 3 | 29491 | 35 | |
4718 | 181925 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2351 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5986069.5587 | 2099239.0051 | 37.7433057547251 | -122.490838681113 | (37.7433057547251, -122.490838681113) | 1 | 8 | 3 | 29491 | 35 | |||
4882 | 193004 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 901 Rankin St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 6013457.05978 | 2097724.05261 | 37.7407079131502 | -122.396032957252 | (37.7407079131502, -122.396032957252) | 10 | 3 | 8 | 58 | 1 | |||
4959 | 47411 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2722 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2002 12:00:00 AM | Permit Number 45322 | |||||||||||||
5002 | 138596 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1997 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6001444.315 | 2115232.308 | 37.788105604547 | -122.438822708512 | (37.788105604547, -122.438822708512) | 13 | 6 | 1 | 29490 | 27 | |||
5270 | 80931 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1111 Munich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6001747.57084 | 2087049.21095 | 37.710738776642 | -122.435756299834 | (37.710738776642, -122.435756299834) | 9 | 7 | 6 | 28861 | 5 | |||
5418 | 70426 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1590 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 3x3 | 6006596.62742 | 2117360.41575 | 37.7942406389433 | -122.42114773947 | (37.7942406389433, -122.42114773947) | 13 | 9 | 10 | 28858 | 32 | ||
5437 | 44085 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 363 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/08/2002 12:00:00 AM | 7 | Permit Number 45154 | 5986819.42477 | 2113508.89753 | 37.7825307151502 | -122.489294848866 | (37.7825307151502, -122.489294848866) | 11 | 6 | 2 | 55 | 26 |
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) );