trees
6,344 rows where qSpecies_id = 19 sorted by PlantDate 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
2140 | 46192 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2001 12:00:00 AM | Permit Number 44518 | ||||||||||||||
3497 | 46195 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2001 12:00:00 AM | Permit Number 44518 | ||||||||||||||
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 | ||||||||||||||
10529 | 46191 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2001 12:00:00 AM | Permit Number 44518 | ||||||||||||||
13013 | 46193 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2001 12:00:00 AM | Permit Number 44518 | ||||||||||||||
17701 | 46199 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2001 12:00:00 AM | Permit Number 44518 | ||||||||||||||
19157 | 46202 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2001 12:00:00 AM | Permit Number 44518 | ||||||||||||||
16484 | 65292 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 600 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/1990 12:00:00 AM | 14 | Permit Number 29486 | 6010574.9893 | 2116273.6869 | 37.7914802149935 | -122.407305449035 | (37.7914802149935, -122.407305449035) | 5 | 1 | 10 | 28857 | 6 | |
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 | |
62760 | 53664 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1541 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/1969 12:00:00 AM | 3 | Permit Number 6602 | 6006648.9932 | 2116230.7671 | 37.7911418571362 | -122.420886307748 | (37.7911418571362, -122.420886307748) | 13 | 9 | 10 | 28858 | 21 | ||
158158 | 53665 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1540 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/1969 12:00:00 AM | Permit Number 6603 | 6006700.2941 | 2116215.7306 | 37.7911034621337 | -122.420707740038 | (37.7911034621337, -122.420707740038) | 13 | 9 | 10 | 28858 | 21 | |||
160263 | 53661 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1542 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/1969 12:00:00 AM | 3 | Permit Number 6599 | 6006694.5449 | 2116253.3218 | 37.7912063542047 | -122.420730301917 | (37.7912063542047, -122.420730301917) | 13 | 9 | 10 | 28858 | 21 | ||
167342 | 53657 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1237 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/1969 12:00:00 AM | 2 | Permit Number 6595 | 6006789.7493 | 2115224.5271 | 37.7883869038613 | -122.420327844878 | (37.7883869038613, -122.420327844878) | 13 | 9 | 10 | 28858 | 21 | ||
89371 | 105995 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 331 19th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774584 | 5989936.41295 | 2113124.32829 | 37.7816562507803 | -122.478483407908 | (37.7816562507803, -122.478483407908) | 11 | 6 | 2 | 55 | 26 |
58125 | 52534 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2957 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2005 12:00:00 AM | 6 | Permit Number 48633 | 6003844.28772 | 2118934.9851 | 37.7984084579424 | -122.430783559724 | (37.7984084579424, -122.430783559724) | 13 | 9 | 1 | 57 | 17 | |
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 | ||
31305 | 39632 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 931 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41027 | 5997187.89015647 | 2107294.29840033 | 37.7660668249931 | -122.452975907923 | (37.7660668249931, -122.452975907923) | 15 | 5 | 11 | 29492 | 12 | ||
189299 | 39624 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1515 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41022 | 5997835.74069097 | 2105526.1019034 | 37.7612489103603 | -122.450607641875 | (37.7612489103603, -122.450607641875) | 15 | 5 | 11 | 29492 | 12 | ||
71989 | 68907 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 44 Collingwood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | Permit Number 32881 | 6001977.44615523 | 2105601.23239458 | 37.7616913943868 | -122.436288638926 | (37.7616913943868, -122.436288638926) | 15 | 4 | 5 | 28862 | 3 | ||
85054 | 68929 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 427 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | 9 | Permit Number 32913 | 5993402.00131 | 2112549.77269 | 37.7802792655033 | -122.466452442005 | (37.7802792655033, -122.466452442005) | 11 | 6 | 2 | 54 | 11 | |
113285 | 68889 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 27 Exeter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | 15 | 3x3 | Permit Number 32861 | 6012615.05484 | 2091124.42948 | 37.7225398298371 | -122.398481333647 | (37.7225398298371, -122.398481333647) | 10 | 3 | 8 | 58 | 1 |
129233 | 68928 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 425 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | 8 | Permit Number 32912 | 5993402.11193 | 2112592.48766 | 37.7803965556277 | -122.466455164786 | (37.7803965556277, -122.466455164786) | 11 | 6 | 2 | 54 | 11 | |
162794 | 68906 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 40 Collingwood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | Permit Number 32880 | 6001976.17664687 | 2105623.74450123 | 37.7617531350227 | -122.436294640809 | (37.7617531350227, -122.436294640809) | 15 | 4 | 5 | 28862 | 3 | ||
6083 | 60590 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 601 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1982 12:00:00 AM | 14 | 4x4 | Permit Number 20209 | 6000481 | 2111039 | 37.7765370051793 | -122.441854521628 | (37.7765370051793, -122.441854521628) | 15 | 5 | 11 | 29492 | 16 |
7452 | 60592 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 613 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1982 12:00:00 AM | 10 | Permit Number 20211 | 6000545.2975 | 2111100.6046 | 37.7767098193279 | -122.44163652073 | (37.7767098193279, -122.44163652073) | 15 | 5 | 11 | 29492 | 16 | |
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 | |
34012 | 177353 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 501X San Juan Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2005 12:00:00 AM | 7 | Width 3ft | Permit Number 48612 | 6000427.73907 | 2092811.40851 | 37.7264854092518 | -122.440730982474 | (37.7264854092518, -122.440730982474) | 9 | 7 | 6 | 28861 | 25 | |
68613 | 177352 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 501X San Juan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2005 12:00:00 AM | 8 | Width 3ft | Permit Number 48612 | 6000403.69972 | 2092831.46295 | 37.7265391050915 | -122.44081552324 | (37.7265391050915, -122.44081552324) | 9 | 7 | 6 | 28861 | 25 | |
93760 | 52489 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 365 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | Permit Number 48599 | 6007079.23363962 | 2096043.74544888 | 37.7357372530563 | -122.417966023861 | (37.7357372530563, -122.417966023861) | 2 | 7 | 7 | 28859 | 2 | ||
165376 | 52505 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 100 Delano Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | Permit Number 48612 | 6000459.21212403 | 2092796.53249414 | 37.7264463554341 | -122.440621115176 | (37.7264463554341, -122.440621115176) | 9 | 7 | 6 | 28861 | 25 | ||
170396 | 52504 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 100 Delano Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | Permit Number 48612 | 6000459.21212403 | 2092796.53249414 | 37.7264463554341 | -122.440621115176 | (37.7264463554341, -122.440621115176) | 9 | 7 | 6 | 28861 | 25 | ||
170820 | 52503 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 100 Delano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | Permit Number 48612 | 6000459.21212403 | 2092796.53249414 | 37.7264463554341 | -122.440621115176 | (37.7264463554341, -122.440621115176) | 9 | 7 | 6 | 28861 | 25 | ||
97401 | 46165 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 162 Grattan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2001 12:00:00 AM | Permit Number 44495 | 5997883.15879517 | 2106520.56521568 | 37.763982169642 | -122.450515338678 | (37.763982169642, -122.450515338678) | 15 | 5 | 11 | 29492 | 9 | ||
126454 | 46189 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 914 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2001 12:00:00 AM | Permit Number 44516 | 5997232.11231521 | 2107353.68145309 | 37.7662324098565 | -122.452827239648 | (37.7662324098565, -122.452827239648) | 15 | 5 | 11 | 29492 | 9 | ||
139240 | 46177 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 32 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2001 12:00:00 AM | Permit Number 44504 | 5998507.8029891 | 2106920.31776587 | 37.7651155214785 | -122.44838367853 | (37.7651155214785, -122.44838367853) | 15 | 5 | 11 | 29492 | 9 | ||
19929 | 44203 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 590 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2000 12:00:00 AM | 3 | Permit Number 43652 | 5991947.54509 | 2111428.22525 | 37.7771157685884 | -122.471402286754 | (37.7771157685884, -122.471402286754) | 11 | 6 | 2 | 54 | 11 | ||
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 | |
51044 | 39566 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 340 Kansas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/1998 12:00:00 AM | Permit Number 40986 | 6011428.39903317 | 2106785.87476625 | 37.7654766104888 | -122.403684780383 | (37.7654766104888, -122.403684780383) | 8 | 3 | 8 | 28853 | 20 | |||
53287 | 39573 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 847 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | 5 | Permit Number 40990 | 6011612.64777 | 2104397.51855 | 37.758929008798 | -122.402879510391 | (37.758929008798, -122.402879510391) | 10 | 3 | 8 | 28856 | 29 | |
97707 | 39541 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2009 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | 5 | Permit Number 40971 | 6011673.11484 | 2105564.66554 | 37.7621371108677 | -122.402752467659 | (37.7621371108677, -122.402752467659) | 10 | 3 | 8 | 28856 | 29 | |
130029 | 39572 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 847 Kansas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | 8 | Permit Number 40990 | 6011610.17185 | 2104414.41568 | 37.7589752663167 | -122.402889261739 | (37.7589752663167, -122.402889261739) | 10 | 3 | 8 | 28856 | 29 | |
175555 | 39567 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 340 Kansas St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/1998 12:00:00 AM | Permit Number 40986 | 6011428.39903317 | 2106785.87476625 | 37.7654766104888 | -122.403684780383 | (37.7654766104888, -122.403684780383) | 8 | 3 | 8 | 28853 | 20 | |||
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 | |
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 | ||
31185 | 52466 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 518@ ANZA 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2005 12:00:00 AM | 3 | Permit Number 48577 | 5993158.0656 | 2111921.07553 | 37.7785389545233 | -122.467250595131 | (37.7785389545233, -122.467250595131) | 11 | 6 | 2 | 54 | 11 | |
44161 | 29048 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 250 11th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/27/2005 12:00:00 AM | 3 | 3x3 | 6008255.0476588 | 2109381.1626173 | 37.7724248849226 | -122.414844410433 | (37.7724248849226, -122.414844410433) | 8 | 2 | 9 | 28853 | 19 | ||
69500 | 29057 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 400X 11th St | 3 | 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 | ||
85456 | 52462 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 709@ CABRILLO 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2005 12:00:00 AM | 3 | Permit Number 48573 | 5994401.17261 | 2110656.03449 | 37.7751371711935 | -122.462858446045 | (37.7751371711935, -122.462858446045) | 11 | 6 | 2 | 54 | 11 | |
109101 | 29060 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 428X 11th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2005 12:00:00 AM | 3 | 3x3 | 6009165.4926 | 2108414.8818 | 37.7698228177957 | -122.411626796839 | (37.7698228177957, -122.411626796839) | 8 | 2 | 9 | 28853 | 19 | ||
110223 | 29052 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 316 11th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2005 12:00:00 AM | 3 | 3x3 | 6008549.296365 | 2109070.7878522 | 37.7715891977893 | -122.413804613966 | (37.7715891977893, -122.413804613966) | 8 | 2 | 9 | 28853 | 19 | ||
110756 | 29042 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 101X 11th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/27/2005 12:00:00 AM | 3 | 3x3 | 6007638.7414429 | 2110099.0108592 | 37.7743612770066 | -122.417027150583 | (37.7743612770066, -122.417027150583) | 8 | 2 | 9 | 28853 | 34 | ||
114347 | 29044 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 158 11th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/27/2005 12:00:00 AM | 3 | 3x3 | 6007835.5335 | 2109807.45693 | 37.7735718072316 | -122.416325753636 | (37.7735718072316, -122.416325753636) | 8 | 2 | 9 | 28853 | 19 | ||
118828 | 29059 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 428X 11th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2005 12:00:00 AM | 3 | 3x3 | 6009124.86865 | 2108456.66549 | 37.7699352672303 | -122.41177026748 | (37.7699352672303, -122.41177026748) | 8 | 2 | 9 | 28853 | 19 | ||
127498 | 29036 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 299X 11th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/27/2005 12:00:00 AM | 3 | 3x3 | 6008502.2272158 | 2109192.483665 | 37.7719207024915 | -122.413976039829 | (37.7719207024915, -122.413976039829) | 8 | 2 | 9 | 28853 | 34 | ||
131625 | 29045 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 216 11th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/27/2005 12:00:00 AM | 3 | 3x3 | 6008109.60513 | 2109535.008621 | 37.7728391364198 | -122.41535840482 | (37.7728391364198, -122.41535840482) | 8 | 2 | 9 | 28853 | 19 | ||
141920 | 29058 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 428X 11th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/27/2005 12:00:00 AM | 3 | 3x3 | 6009090.46192 | 2108493.07157 | 37.7700332996243 | -122.411891853136 | (37.7700332996243, -122.411891853136) | 8 | 2 | 9 | 28853 | 19 | ||
143993 | 29054 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 390X 11th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2005 12:00:00 AM | 3 | 3x3 | 6008859.9995279 | 2108745.520328 | 37.770713532863 | -122.412706871412 | (37.770713532863, -122.412706871412) | 8 | 2 | 9 | 28853 | 19 | ||
155701 | 52465 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 731@ FULTON 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2005 12:00:00 AM | 5 | Permit Number 48576 | 5993473.86855 | 2110485.08002 | 37.7746143218649 | -122.466053745419 | (37.7746143218649, -122.466053745419) | 11 | 6 | 2 | 54 | 11 | |
171468 | 29038 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 201 11th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/27/2005 12:00:00 AM | 3 | 3x3 | 6008075.8155433 | 2109643.5327014 | 37.7731352187467 | -122.415482971916 | (37.7731352187467, -122.415482971916) | 8 | 2 | 9 | 28853 | 34 | ||
175389 | 29062 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 428X 11th St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/27/2005 12:00:00 AM | 3 | 3x3 | 6009190.0675 | 2108396.17825 | 37.769772840679 | -122.411540470915 | (37.769772840679, -122.411540470915) | 8 | 2 | 9 | 28853 | 19 | ||
178770 | 29039 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 201 11th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2005 12:00:00 AM | 3 | 3x3 | 6008075.8155433 | 2109643.5327014 | 37.7731352187467 | -122.415482971916 | (37.7731352187467, -122.415482971916) | 8 | 2 | 9 | 28853 | 34 | ||
179379 | 29043 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 140 11th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/27/2005 12:00:00 AM | 3 | 3x3 | 6007797.44699 | 2109846.96944 | 37.7736781574481 | -122.4164603003 | (37.7736781574481, -122.4164603003) | 8 | 2 | 9 | 28853 | 19 | ||
190050 | 29046 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 238 11th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/27/2005 12:00:00 AM | 3 | 3x3 | 6008237.00675 | 2109391.66947 | 37.7724527205492 | -122.414907559637 | (37.7724527205492, -122.414907559637) | 8 | 2 | 9 | 28853 | 19 | ||
190287 | 29041 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 101X 11th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/27/2005 12:00:00 AM | 3 | 3x3 | 6007638.7414429 | 2110099.0108592 | 37.7743612770066 | -122.417027150583 | (37.7743612770066, -122.417027150583) | 8 | 2 | 9 | 28853 | 34 | ||
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 |
111546 | 108557 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 107 San Juan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773716 | 6001404.88912 | 2092211.15094 | 37.7248928376179 | -122.437310059437 | (37.7248928376179, -122.437310059437) | 9 | 7 | 6 | 28861 | 25 |
129673 | 5703 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1595 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/24/2009 12:00:00 AM | 3 | 4X4 | 6005320.3308 | 2099089.18126 | 37.7440001827757 | -122.424263770782 | (37.7440001827757, -122.424263770782) | 2 | 7 | 5 | 28859 | 22 | ||
46457 | 46114 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1001 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2001 12:00:00 AM | Permit Number 44473 | 5998803.64501261 | 2106479.79215495 | 37.7639228586403 | -122.447328728164 | (37.7639228586403, -122.447328728164) | 15 | 5 | 11 | 29492 | 9 | |||
21330 | 33784 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 200x Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/1996 12:00:00 AM | Permit Number 37821 | 6014138 | 2116340 | 37.7918610639158 | -122.394982044679 | (37.7918610639158, -122.394982044679) | 12 | 2 | 9 | 28855 | 6 | |||
100255 | 96566 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1086 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/23/2014 12:36:00 PM | 3 | 3x3 | 6004399 | 2102565 | 37.7534919083855 | -122.427697122796 | (37.7534919083855, -122.427697122796) | 2 | 4 | 5 | 28862 | 22 | ||
181732 | 22325 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 5158 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/1997 12:00:00 AM | 12 | 3x3 | 6014537.89 | 2094298.7173 | 37.7313627194949 | -122.39205634622 | (37.7313627194949, -122.39205634622) | 10 | 3 | 8 | 58 | 1 | ||
168649 | 243745 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 130 Mateo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/2017 12:00:00 AM | 3 | 3x3 | Permit Number 774373 | 6003834.27428 | 2096405.12406 | 37.7365463534355 | -122.429210869408 | (37.7365463534355, -122.429210869408) | 2 | 7 | 5 | 63 | 7 | |
26746 | 82972 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2808 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775067 | 6000141.37646 | 2117136.25898 | 37.7932591422368 | -122.443467453072 | (37.7932591422368, -122.443467453072) | 13 | 9 | 1 | 57 | 27 | |
58347 | 114916 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2808 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/2015 12:00:00 AM | 5 | 3x3 | Permit Number 775067 | 6000128.60151 | 2117133.98921 | 37.793252181501 | -122.443511491989 | (37.793252181501, -122.443511491989) | 13 | 9 | 1 | 57 | 27 | |
121293 | 9996 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 115 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/22/2014 06:44:00 AM | 3 | 3X2 | 6005461.13944 | 2108328.79796 | 37.769377961859 | -122.424433951272 | (37.769377961859, -122.424433951272) | 8 | 4 | 5 | 28853 | 19 | ||
183340 | 52419 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 526@ NOE ST Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/2005 12:00:00 AM | Permit Number 48538 | 6002948.09879603 | 2102727.95302157 | 37.7538571599204 | -122.432726286472 | (37.7538571599204, -122.432726286472) | 2 | 4 | 5 | 28862 | 22 | |||
187112 | 52447 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 783 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2005 12:00:00 AM | 3 | Permit Number 48559 | 5992867.41722 | 2110151.422 | 37.7736631809479 | -122.468127286146 | (37.7736631809479, -122.468127286146) | 11 | 6 | 2 | 54 | 11 | |
179591 | 39335 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2687 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/21/1998 12:00:00 AM | Permit Number 40898 | 6010037.34730023 | 2103362.07640176 | 37.7559978294497 | -122.408254631326 | (37.7559978294497, -122.408254631326) | 2 | 4 | 7 | 28859 | 19 | ||
121265 | 58099 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 864X Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1977 12:00:00 AM | 22 | 4x4 | Permit Number 17073 | 6006749.38738 | 2113618.48291 | 37.7839748265105 | -122.42035345285 | (37.7839748265105, -122.42035345285) | 7 | 9 | 9 | 28858 | 36 | |
71921 | 256722 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 985 Powhattan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2018 12:00:00 AM | 3 | 3x3 | Permit Number 776274 | 6009288 | 2098069 | 37.7414222265504 | -122.410472391962 | (37.7414222265504, -122.410472391962) | 10 | 7 | 7 | 28859 | 2 | |
93272 | 256871 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 1025 Powhattan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2018 12:00:00 AM | 3 | 3x3 | Permit Number 776275 | 6009358.6182 | 2098062.94866 | 37.7414095695618 | -122.410227790564 | (37.7414095695618, -122.410227790564) | 10 | 7 | 7 | 28859 | 2 | |
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 | ||
155799 | 256869 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 985 Powhattan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2018 12:00:00 AM | 3 | 3x3 | Permit Number 776274 | 6009287.99434 | 2098069.06568 | 37.7414224065761 | -122.410472416169 | (37.7414224065761, -122.410472416169) | 10 | 7 | 7 | 28859 | 2 | |
148983 | 32777 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 552 Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/20/2010 12:00:00 AM | 1 | Permit Number 54024 | 6001138.0283 | 2110672.625 | 37.7755684482993 | -122.439555406407 | (37.7755684482993, -122.439555406407) | 15 | 5 | 11 | 29492 | 10 | |
19247 | 63477 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2064 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/20/1986 12:00:00 AM | 9 | Permit Number 24071 | 5999717.1794 | 2111601.8073 | 37.7780387769008 | -122.444537246991 | (37.7780387769008, -122.444537246991) | 15 | 5 | 11 | 29490 | 16 | |
85416 | 102087 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 212 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/19/2012 12:00:00 AM | 3x3 | Permit Number 769733 | 6006591.9 | 2098371.2 | 37.7421004853962 | -122.41981602805 | (37.7421004853962, -122.41981602805) | 2 | 7 | 7 | 28859 | 2 | |
58270 | 31470 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 538 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/2012 12:00:00 AM | 4 | 3x3 | Permit Number 52606 | 6002903.06232 | 2102137.64649 | 37.7522337638778 | -122.432839864978 | (37.7522337638778, -122.432839864978) | 2 | 4 | 5 | 28862 | 22 |
39051 | 5566 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1006 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2007 12:00:00 AM | 3 | 3X3 | 6005053.5245 | 2102397.57476 | 37.7530691998878 | -122.425421720741 | (37.7530691998878, -122.425421720741) | 2 | 4 | 5 | 28862 | 22 | ||
53470 | 5337 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 159 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/17/2007 12:00:00 AM | 3 | 6X8 | 6004857.08853 | 2107452.88089 | 37.7669387747413 | -122.426460960202 | (37.7669387747413, -122.426460960202) | 8 | 4 | 5 | 28862 | 19 | ||
99046 | 5661 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1354 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/17/2007 12:00:00 AM | 3 | 3X3 | 6005161.84095 | 2100410.45199 | 37.7476191392302 | -122.424905777 | (37.7476191392302, -122.424905777) | 2 | 7 | 5 | 63 | 22 | ||
141276 | 5698 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1563 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/17/2007 12:00:00 AM | 3 | 6005312.626 | 2099232.77644 | 37.7443940273637 | -122.424300623169 | (37.7443940273637, -122.424300623169) | 2 | 7 | 5 | 28859 | 22 | |||
142254 | 5660 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1352 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/17/2007 12:00:00 AM | 3 | 3X3 | 6005159.95383 | 2100443.10624 | 37.747708693703 | -122.424914625421 | (37.747708693703, -122.424914625421) | 2 | 7 | 5 | 63 | 22 | ||
177035 | 49008 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3152 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2002 12:00:00 AM | 15 | 4x4 | Permit Number 53069 | 5999660.30635 | 2116067.65778 | 37.7902975983001 | -122.445055124289 | (37.7902975983001, -122.445055124289) | 13 | 6 | 1 | 29490 | 27 |
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) );