trees
6,344 rows where qSpecies_id = 19 sorted by Police Districts 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 76 | 34164 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2500 Broadway | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/1997 12:00:00 AM | 5 | Permit Number 38230 | 6001594.91074 | 2117340.13182 | 37.7939017096586 | -122.438452751501 | (37.7939017096586, -122.438452751501) | 13 | 9 | 1 | 57 | 27 | ||
| 867 | 130823 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2451 Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004083.73489 | 2117213.2991 | 37.7936947127019 | -122.429832130065 | (37.7936947127019, -122.429832130065) | 13 | 9 | 1 | 29490 | 27 | |||
| 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 | |||
| 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 | |
| 1341 | 76159 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 380 Webster St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/12/1994 12:00:00 AM | 4 | 3x3 | 6004161.50647736 | 2110040.16949733 | 37.7740034947051 | -122.429051358355 | (37.7740034947051, -122.429051358355) | 7 | 9 | 11 | 28852 | 10 | |
| 1464 | 130824 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2451 Laguna St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004088.29924 | 2117192.3041 | 37.7936373242572 | -122.429814838808 | (37.7936373242572, -122.429814838808) | 13 | 9 | 1 | 29490 | 27 | |||
| 2353 | 229453 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 500 Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6004612.82375 | 2110259.96619 | 37.7746325395952 | -122.427505836641 | (37.7746325395952, -122.427505836641) | 7 | 9 | 11 | 28852 | 10 | |||
| 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 | |||
| 2701 | 246408 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 153 Sanchez St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6003537.9846 | 2107412.8853 | 37.7667542995576 | -122.431020673856 | (37.7667542995576, -122.431020673856) | 7 | 9 | 5 | 28862 | 3 | |||
| 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 | |
| 3139 | 130835 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2707 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6003954.12542 | 2118159.05361 | 37.7962841720447 | -122.430348098084 | (37.7962841720447, -122.430348098084) | 13 | 9 | 1 | 57 | 17 | |||
| 3209 | 130852 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2400 Octavia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6004581.36981 | 2117470.78611 | 37.7944298743033 | -122.42812862796 | (37.7944298743033, -122.42812862796) | 13 | 9 | 1 | 28858 | 27 | |||
| 3661 | 130497 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3536 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6000731.95465 | 2120687.25683 | 37.8030429054598 | -122.441678975811 | (37.8030429054598, -122.441678975811) | 13 | 9 | 1 | 57 | 17 | |||
| 3833 | 130643 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2596 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002472.36463 | 2115758.47109 | 37.7896087481804 | -122.435303491175 | (37.7896087481804, -122.435303491175) | 13 | 9 | 1 | 29490 | 27 | |||
| 4013 | 264857 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 800x Polk St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007181 | 2113695 | 37.7842092359088 | -122.41886565636 | (37.7842092359088, -122.41886565636) | 7 | 9 | 9 | 28858 | 36 | ||||
| 4024 | 114160 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 2250 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770124 | 6002777.5161 | 2117854.22202 | 37.7953804657925 | -122.434397600465 | (37.7953804657925, -122.434397600465) | 13 | 9 | 1 | 57 | 17 | |
| 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 | |
| 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 | |||
| 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 | |||
| 5325 | 230238 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 30 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6003399.42304 | 2108502.79044 | 37.7697390612459 | -122.431577753704 | (37.7697390612459, -122.431577753704) | 15 | 9 | 5 | 29492 | 10 | |||
| 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 | ||
| 5958 | 102480 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 1456 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2013 12:00:00 AM | 3 | 3x3 | Permit Number 768914 | 6004877.03101 | 2120232.91154 | 37.8020306879258 | -122.427302455863 | (37.8020306879258, -122.427302455863) | 13 | 9 | 1 | 57 | 17 | |
| 6152 | 68969 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3343 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1994 12:00:00 AM | 9 | Permit Number 32959 | 5999787.27845 | 2120075.09917 | 37.8013082157737 | -122.44490400674 | (37.8013082157737, -122.44490400674) | 13 | 9 | 1 | 57 | 17 | |
| 6248 | 21612 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1550 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6005218.1717 | 2114795.8159 | 37.7871210866889 | -122.4257347292 | (37.7871210866889, -122.4257347292) | 13 | 9 | 11 | 28858 | 27 | |||
| 6342 | 264855 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 800x Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007181 | 2113695 | 37.7842092359088 | -122.41886565636 | (37.7842092359088, -122.41886565636) | 7 | 9 | 9 | 28858 | 36 | ||||
| 6574 | 65759 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3016 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/20/1990 12:00:00 AM | 13 | Permit Number 28722 | 6003857.62455 | 2119183.89761 | 37.7990926630433 | -122.430755182511 | (37.7990926630433, -122.430755182511) | 13 | 9 | 1 | 57 | 17 | |
| 7141 | 264858 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 800x Polk St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007181 | 2113695 | 37.7842092359088 | -122.41886565636 | (37.7842092359088, -122.41886565636) | 7 | 9 | 9 | 28858 | 36 | ||||
| 7498 | 138017 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1798 Bush St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6005043.9346 | 2115067.7403 | 37.7878578757703 | -122.426356919881 | (37.7878578757703, -122.426356919881) | 13 | 9 | 11 | 28858 | 27 | |||
| 7596 | 137880 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2148 PINE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6003654.0545 | 2115274.6949 | 37.7883474575543 | -122.431180423335 | (37.7883474575543, -122.431180423335) | 13 | 9 | 1 | 29490 | 27 | |||
| 7649 | 39891 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1550 Sutter St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/1999 12:00:00 AM | Permit Number 41175 | 6005174.09555111 | 2114787.61295618 | 37.7870960726836 | -122.425886638993 | (37.7870960726836, -122.425886638993) | 13 | 9 | 11 | 28858 | 27 | |||
| 7708 | 76081 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 380 Webster St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/12/1994 12:00:00 AM | 4 | 3x3 | 6004161.50647736 | 2110040.16949733 | 37.7740034947051 | -122.429051358355 | (37.7740034947051, -122.429051358355) | 7 | 9 | 11 | 28852 | 10 | |
| 8647 | 146616 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 1320 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 4x4 | Permit Number 783073 | 6005474.41066 | 2120313.40732 | 37.8022854748664 | -122.425240967805 | (37.8022854748664, -122.425240967805) | 13 | 9 | 1 | 57 | 17 | ||
| 8654 | 142867 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1020 Polk St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6006956.6744 | 2114391.9796 | 37.786110337763 | -122.41969121449 | (37.786110337763, -122.41969121449) | 13 | 9 | 9 | 28858 | 36 | |||
| 8704 | 79435 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 606 Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6004044.7014 | 2110862.9754 | 37.7762561050616 | -122.429514097991 | (37.7762561050616, -122.429514097991) | 7 | 9 | 11 | 28852 | 10 | |||
| 9233 | 17847 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2082 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003983.5737 | 2115317.762 | 37.7884843766402 | -122.430043414021 | (37.7884843766402, -122.430043414021) | 13 | 9 | 11 | 29490 | 27 | |||
| 9640 | 17196 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2235X Octavia St | 5 | Median : Cutout | Tree | DPW 1 | 24 | 20 | 6004629.78741 | 2116932.39582 | 37.792954330542 | -122.427922714666 | (37.792954330542, -122.427922714666) | 13 | 9 | 1 | 28858 | 27 | |||
| 9882 | 110280 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2845 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 4x4 | 5999937.93955 | 2117050.91929 | 37.7930132181276 | -122.444165220867 | (37.7930132181276, -122.444165220867) | 13 | 9 | 1 | 29490 | 27 | |||
| 9988 | 87741 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2536 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/27/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50404 | 6001459.44727 | 2117322.47349 | 37.7938455182068 | -122.438920201115 | (37.7938455182068, -122.438920201115) | 13 | 9 | 1 | 57 | 27 | |
| 10500 | 99636 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2201@Vallejo Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6006351.46016 | 2118390.69708 | 37.7970557085202 | -122.422069273873 | (37.7970557085202, -122.422069273873) | 13 | 9 | 10 | 28858 | 32 | |||
| 10995 | 108012 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 419X Ivy St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 773433 | 6005343.63147 | 2111122.79579 | 37.7770429674219 | -122.425039228843 | (37.7770429674219, -122.425039228843) | 7 | 9 | 11 | 28852 | 10 | ||
| 11241 | 30330 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2820 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/1990 12:00:00 AM | 9 | Permit Number 28881 | 5999458.41568 | 2118085.66723 | 37.795826993587 | -122.445898848463 | (37.795826993587, -122.445898848463) | 13 | 9 | 1 | 57 | 17 | ||
| 11746 | 57593 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 600 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/04/1976 12:00:00 AM | 3 | Permit Number 16461 | 6003141.6397 | 2110360.8759 | 37.7748262921144 | -122.432602160624 | (37.7748262921144, -122.432602160624) | 15 | 9 | 11 | 29492 | 10 | |
| 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 | ||
| 11852 | 113406 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2120 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6006433.26818 | 2118140.51551 | 37.7963733865886 | -122.421768418302 | (37.7963733865886, -122.421768418302) | 13 | 9 | 10 | 28858 | 32 | |||
| 12039 | 130797 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2420 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6002334.43206 | 2117092.48928 | 37.7932637845338 | -122.435876212726 | (37.7932637845338, -122.435876212726) | 13 | 9 | 1 | 29490 | 27 | |||
| 12132 | 88765 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2661 Broadway | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/21/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51686 | 6000918.40593 | 2117193.70791 | 37.7934611641623 | -122.440783009137 | (37.7934611641623, -122.440783009137) | 13 | 9 | 1 | 29490 | 27 | |
| 12270 | 142858 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1224 POLK ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6006850.3084 | 2115136.6964 | 37.7881491547051 | -122.420112084006 | (37.7881491547051, -122.420112084006) | 13 | 9 | 10 | 28858 | 21 | |||
| 12554 | 130859 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1890 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6004541.87026 | 2118099.91409 | 37.7961550644564 | -122.428310161511 | (37.7961550644564, -122.428310161511) | 13 | 9 | 1 | 57 | 17 | |||
| 12734 | 70119 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1590 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 3x3 | 6006574.99187 | 2117356.21064 | 37.7942278730643 | -122.421222302288 | (37.7942278730643, -122.421222302288) | 13 | 9 | 10 | 28858 | 32 | ||
| 13039 | 130815 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2225 Pacific Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6003300.13476 | 2117178.12968 | 37.7935537412686 | -122.432540939311 | (37.7935537412686, -122.432540939311) | 13 | 9 | 1 | 29490 | 27 | |||
| 13166 | 46255 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2161 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Permit Number 44539 | 6000416.49604 | 2120605.00843 | 37.802799094759 | -122.442764714729 | (37.802799094759, -122.442764714729) | 13 | 9 | 1 | 57 | 17 | |||
| 13367 | 132936 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2600 Webster St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 4ft | 6003117.4123 | 2117569.74013 | 37.794618639305 | -122.433201167605 | (37.794618639305, -122.433201167605) | 13 | 9 | 1 | 29490 | 27 | |||
| 13384 | 39889 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1550 Sutter St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/1999 12:00:00 AM | Permit Number 41175 | 6005174.09555111 | 2114787.61295618 | 37.7870960726836 | -122.425886638993 | (37.7870960726836, -122.425886638993) | 13 | 9 | 11 | 28858 | 27 | |||
| 13440 | 264856 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 800x Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007181 | 2113695 | 37.7842092359088 | -122.41886565636 | (37.7842092359088, -122.41886565636) | 7 | 9 | 9 | 28858 | 36 | ||||
| 13879 | 79434 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 606 Webster St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6004043.3643 | 2110877.3492 | 37.7762954962714 | -122.42951974871 | (37.7762954962714, -122.42951974871) | 7 | 9 | 11 | 28852 | 10 | |||
| 13914 | 130707 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2878 Broadway | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 4ft | 5999875.30316 | 2117112.77625 | 37.7931794874933 | -122.444386392923 | (37.7931794874933, -122.444386392923) | 13 | 9 | 1 | 57 | 27 | |||
| 14523 | 130701 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2897 Broadway | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 5999786.03622 | 2117022.81208 | 37.7929273760386 | -122.444688791774 | (37.7929273760386, -122.444688791774) | 13 | 9 | 1 | 29490 | 27 | |||
| 14575 | 30998 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2101 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | 10 | Permit Number 34777 | 6003940.50328 | 2117270.99344 | 37.7938450145991 | -122.430331841946 | (37.7938450145991, -122.430331841946) | 13 | 9 | 1 | 29490 | 27 | |
| 16013 | 108100 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 2390X Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6001806.63782 | 2118043.59498 | 37.7958452773357 | -122.437770563269 | (37.7958452773357, -122.437770563269) | 13 | 9 | 1 | 57 | 17 | |||||
| 16410 | 130500 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2143 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6000509.0654 | 2120617.57283 | 37.8028388699826 | -122.44244528095 | (37.8028388699826, -122.44244528095) | 13 | 9 | 1 | 57 | 17 | |||
| 16881 | 66780 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1341 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/20/1991 12:00:00 AM | 10 | Permit Number 30046 | 6006517.61971 | 2119019.77197 | 37.7987923596445 | -122.421539021018 | (37.7987923596445, -122.421539021018) | 13 | 9 | 10 | 28858 | 32 | |
| 17087 | 95226 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2424@Vallejo Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2011 12:00:00 AM | 13 | 3x21 | Permit Number 767114 | 6005007 | 2117874 | 37.7955610696182 | -122.426684622292 | (37.7955610696182, -122.426684622292) | 13 | 9 | 1 | 28858 | 27 | |
| 17280 | 130875 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1127 Polk St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6006854.83787 | 2114740.0583 | 37.7870603393069 | -122.420068253547 | (37.7870603393069, -122.420068253547) | 13 | 9 | 10 | 28858 | 21 | |||
| 17359 | 27339 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 640 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4X4 | 6004290.4577 | 2110500.9764 | 37.7752760561488 | -122.428638148774 | (37.7752760561488, -122.428638148774) | 7 | 9 | 11 | 28852 | 10 | |||
| 17406 | 130876 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1160 Polk St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 4ft | 6006890.67261 | 2114861.92769 | 37.7873969816278 | -122.419952924504 | (37.7873969816278, -122.419952924504) | 13 | 9 | 10 | 28858 | 21 | |||
| 17634 | 230232 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 220 Laussat St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003632.48933 | 2109183.89655 | 37.7716224196593 | -122.430820198111 | (37.7716224196593, -122.430820198111) | 15 | 9 | 11 | 29492 | 10 | |||
| 17966 | 106220 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2840 Broadway | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 6000008.65567 | 2117119.29999 | 37.7932050075534 | -122.4439254553 | (37.7932050075534, -122.4439254553) | 13 | 9 | 1 | 57 | 27 | ||||
| 18010 | 53063 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2414 Pacific Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/08/2006 12:00:00 AM | 6 | Permit Number 49036 | 6002461.41479 | 2117112.6303 | 37.7933262991092 | -122.435438286059 | (37.7933262991092, -122.435438286059) | 13 | 9 | 1 | 29490 | 27 | ||
| 18154 | 26960 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1755 Bush St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4x4 | 6005137.68077 | 2115060.19605 | 37.7878424598464 | -122.426032037994 | (37.7878424598464, -122.426032037994) | 13 | 9 | 11 | 28858 | 27 | |||
| 18226 | 98437 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 1840 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/13/2012 12:00:00 AM | 4 | 4x12 | Permit Number 768068 | 6005870.33263 | 2116931.58044 | 37.7930221942694 | -122.423630300016 | (37.7930221942694, -122.423630300016) | 13 | 9 | 1 | 28858 | 27 | |
| 18364 | 66788 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1346 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/20/1991 12:00:00 AM | 9 | Permit Number 30061 | 6006476.7124 | 2119411.4454 | 37.7998654891501 | -122.421708408323 | (37.7998654891501, -122.421708408323) | 13 | 9 | 1 | 28858 | 32 | |
| 18367 | 103786 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1221 Polk St | 1 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006804.9894 | 2115120.2532 | 37.7881014522033 | -122.420267712778 | (37.7881014522033, -122.420267712778) | 13 | 9 | 10 | 28858 | 21 | ||
| 18534 | 88746 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 986 Polk St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51679 | 6006977.45504 | 2114231.90086 | 37.7856719713322 | -122.419607957142 | (37.7856719713322, -122.419607957142) | 13 | 9 | 9 | 28858 | 36 | |
| 19181 | 40558 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2418 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/27/1999 12:00:00 AM | 7 | Permit Number 41804 | 6003105.8528 | 2116546.98238 | 37.7918097534735 | -122.433168052783 | (37.7918097534735, -122.433168052783) | 13 | 9 | 1 | 29490 | 27 | |
| 19735 | 138895 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 600 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6004478.4652 | 2110688.3143 | 37.7758010783635 | -122.428001140268 | (37.7758010783635, -122.428001140268) | 7 | 9 | 11 | 28852 | 10 | |||
| 19820 | 130770 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2780 Vallejo St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 19 | Width 4ft | 6000266.86927 | 2117513.67047 | 37.7943025707535 | -122.44306035785 | (37.7943025707535, -122.44306035785) | 13 | 9 | 1 | 57 | 27 | |||
| 20082 | 130869 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1234 Polk St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 4ft | 6006839.32081 | 2115241.49926 | 37.7884362984408 | -122.420157540061 | (37.7884362984408, -122.420157540061) | 13 | 9 | 10 | 28858 | 21 | |||
| 20126 | 49155 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2736 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/24/2008 12:00:00 AM | 6 | 3x3 | Permit Number 51748 | 5999856.15982 | 2118488.80857 | 37.796956615824 | -122.444551573191 | (37.796956615824, -122.444551573191) | 13 | 9 | 1 | 57 | 17 | |
| 20211 | 53592 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1426 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/16/1969 12:00:00 AM | 2 | Permit Number 6521 | 6006754.9579 | 2115825.0045 | 37.790033705848 | -122.420490858055 | (37.790033705848, -122.420490858055) | 13 | 9 | 10 | 28858 | 21 | ||
| 20307 | 253871 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 1601 Larkin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2017 12:00:00 AM | 3 | 3x3 | Permit Number 56289 | 6007037 | 2116831 | 37.7928118105792 | -122.419586418272 | (37.7928118105792, -122.419586418272) | 13 | 9 | 10 | 28858 | 32 | |
| 20420 | 130838 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2525 Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6004058.85202 | 2117409.50442 | 37.7942320333212 | -122.429932229093 | (37.7942320333212, -122.429932229093) | 13 | 9 | 1 | 29490 | 27 | |||
| 20600 | 143513 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2000 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6003380.0372 | 2118637.4432 | 37.7975651712073 | -122.432368745511 | (37.7975651712073, -122.432368745511) | 13 | 9 | 1 | 57 | 17 | |||
| 20762 | 130598 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2262 Bay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5999963.36772 | 2120238.6192 | 37.8017672459261 | -122.444306419822 | (37.8017672459261, -122.444306419822) | 13 | 9 | 1 | 57 | 17 | |||
| 20768 | 130813 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2280 Pacific Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6003228.44682 | 2117222.33116 | 37.7936710416461 | -122.432792144238 | (37.7936710416461, -122.432792144238) | 13 | 9 | 1 | 29490 | 27 | |||
| 20784 | 108700 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3024 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772805 | 6001479.41501 | 2118822.32035 | 37.7979648412708 | -122.438958648025 | (37.7979648412708, -122.438958648025) | 13 | 9 | 1 | 57 | 17 |
| 21024 | 130466 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2350 Green St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6001795.77555 | 2118067.14242 | 37.7959093148112 | -122.437809836048 | (37.7959093148112, -122.437809836048) | 13 | 9 | 1 | 57 | 17 | |||
| 21128 | 98717 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1500@Polk Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Permit Number 49344 | 6006371.84738 | 2118011.66864 | 37.7960161416733 | -122.421971790069 | (37.7960161416733, -122.421971790069) | 13 | 9 | 10 | 28858 | 32 | |||
| 21165 | 61387 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1907 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/1984 12:00:00 AM | 8 | Permit Number 21304 | 6003890.4452 | 2115106.1173 | 37.7878979790124 | -122.430350517837 | (37.7878979790124, -122.430350517837) | 13 | 9 | 11 | 29490 | 27 | ||
| 21190 | 93913 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1233 Polk St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 04/26/2010 12:00:00 AM | 3 | Permit Number 53384 | 6006791.18319 | 2115201.26263 | 37.7883231061636 | -122.42032123196 | (37.7883231061636, -122.42032123196) | 13 | 9 | 10 | 28858 | 21 | ||
| 21362 | 130789 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2332 Broadway | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6002469.61326 | 2117461.53698 | 37.7942847722743 | -122.435434889332 | (37.7942847722743, -122.435434889332) | 13 | 9 | 1 | 29490 | 27 | |||
| 21413 | 130451 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2800 Divisadero St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6000640.0525 | 2117925.65091 | 37.7954550312843 | -122.441798686384 | (37.7954550312843, -122.441798686384) | 13 | 9 | 1 | 57 | 17 | |||
| 21608 | 130595 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3555 Broderick St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5999688.85407 | 2120789.3256 | 37.8032636719547 | -122.445295978938 | (37.8032636719547, -122.445295978938) | 13 | 9 | 1 | 57 | 17 | |||
| 21792 | 59832 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2080 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1990 12:00:00 AM | Permit Number 19285 | 5999268.33868417 | 2121186.40779193 | 37.8043299394007 | -122.446779769241 | (37.8043299394007, -122.446779769241) | 13 | 9 | 1 | 57 | 17 | ||
| 21829 | 44276 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2550 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/22/2001 12:00:00 AM | 4 | Permit Number 43702 | 6001414.45003 | 2117313.34114 | 37.7938178829298 | -122.439075240633 | (37.7938178829298, -122.439075240633) | 13 | 9 | 1 | 57 | 27 | ||
| 21842 | 229455 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 380 Webster St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6004159.49688 | 2110026.75581 | 37.7739665502488 | -122.429057353316 | (37.7739665502488, -122.429057353316) | 7 | 9 | 11 | 28852 | 10 | |||
| 21944 | 58811 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2049 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/2014 12:00:00 AM | 3 | Permit Number 773701 | 6003239.80181 | 2118222.27779 | 37.7964172815815 | -122.432824322909 | (37.7964172815815, -122.432824322909) | 13 | 9 | 1 | 57 | 17 | ||
| 22351 | 130583 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3115 Divisadero St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6000429.11547 | 2118988.9593 | 37.7983625736353 | -122.442604944756 | (37.7983625736353, -122.442604944756) | 13 | 9 | 1 | 57 | 17 | |||
| 23068 | 33129 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2900 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | 12 | Permit Number 37361 | 6001538.06756 | 2118399.08454 | 37.7968060836887 | -122.438725350392 | (37.7968060836887, -122.438725350392) | 13 | 9 | 1 | 57 | 17 | |
| 23207 | 21622 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1600X Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/13/1989 12:00:00 AM | 3 | 3X3 | 6004941.8052503 | 2114940.8187044 | 37.7875036072686 | -122.426701226862 | (37.7875036072686, -122.426701226862) | 13 | 9 | 11 | 28858 | 27 | ||
| 23633 | 142838 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1446 POLK ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6006737.5121 | 2115940.1069 | 37.7903487653649 | -122.420559393145 | (37.7903487653649, -122.420559393145) | 13 | 9 | 10 | 28858 | 21 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );