trees
2,421 rows where qSpecies_id = 8 sorted by Longitude
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
102920 | 38634 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1595 Shafter Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/16/2011 12:00:00 AM | 16 | 4x10 | Permit Number 767658 | 6014976.9663 | 2094092.323 | 37.7308203704303 | -122.390523948894 | (37.7308203704303, -122.390523948894) | 10 | 3 | 8 | 58 | 1 |
13864 | 38641 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1595 Shafter Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 16 | 4x10 | Permit Number 40566 | 6014964.8748 | 2094103.3153 | 37.7308498822776 | -122.39056651931 | (37.7308498822776, -122.39056651931) | 10 | 3 | 8 | 58 | 1 |
6046 | 81390 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1588 Indiana St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6015103.68734 | 2101191.55999 | 37.750320442739 | -122.390581737352 | (37.750320442739, -122.390581737352) | 10 | 3 | 8 | 28856 | 1 | |||
126278 | 38632 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1595 Shafter Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/16/2011 12:00:00 AM | 17 | 6x60 | Permit Number 767658 | 6014957.1802 | 2094111.5595 | 37.7308720923122 | -122.390593696874 | (37.7308720923122, -122.390593696874) | 10 | 3 | 8 | 58 | 1 |
122226 | 38633 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1595 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/16/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767658 | 6014946.188 | 2094119.254 | 37.7308926100283 | -122.390632236495 | (37.7308926100283, -122.390632236495) | 10 | 3 | 8 | 58 | 1 |
89603 | 26011 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1618X Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 01/02/1998 12:00:00 AM | 6 | 3X3 | 6014975.06835 | 2095558.90554 | 37.7348472038217 | -122.390632955135 | (37.7348472038217, -122.390632955135) | 10 | 3 | 8 | 58 | 1 | ||
29812 | 99390 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1590 Yosemite Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980856 | -122.390639783135 | (37.726418980856, -122.390639783135) | 10 | 3 | 8 | 58 | 1 | ||
30232 | 99397 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1590 Yosemite Ave | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980856 | -122.390639783135 | (37.726418980856, -122.390639783135) | 10 | 3 | 8 | 58 | 1 | ||
32256 | 99396 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1590 Yosemite Ave | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980856 | -122.390639783135 | (37.726418980856, -122.390639783135) | 10 | 3 | 8 | 58 | 1 | ||
38088 | 99382 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1590 Yosemite Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980856 | -122.390639783135 | (37.726418980856, -122.390639783135) | 10 | 3 | 8 | 58 | 1 | ||
48395 | 99378 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1590 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 1 | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980856 | -122.390639783135 | (37.726418980856, -122.390639783135) | 10 | 3 | 8 | 58 | 1 | |
56655 | 99384 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1590 Yosemite Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980856 | -122.390639783135 | (37.726418980856, -122.390639783135) | 10 | 3 | 8 | 58 | 1 | ||
74544 | 99389 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1590 Yosemite Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980856 | -122.390639783135 | (37.726418980856, -122.390639783135) | 10 | 3 | 8 | 58 | 1 | ||
95979 | 99388 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1590 Yosemite Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980856 | -122.390639783135 | (37.726418980856, -122.390639783135) | 10 | 3 | 8 | 58 | 1 | ||
147844 | 99392 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1590 Yosemite Ave | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980856 | -122.390639783135 | (37.726418980856, -122.390639783135) | 10 | 3 | 8 | 58 | 1 | ||
165704 | 99383 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1590 Yosemite Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980856 | -122.390639783135 | (37.726418980856, -122.390639783135) | 10 | 3 | 8 | 58 | 1 | ||
181547 | 99391 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1590 Yosemite Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980856 | -122.390639783135 | (37.726418980856, -122.390639783135) | 10 | 3 | 8 | 58 | 1 | ||
110041 | 200106 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1536 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6014892.206 | 2092484.8121 | 37.726401765616 | -122.390704688118 | (37.726401765616, -122.390704688118) | 10 | 3 | 8 | 58 | 1 | |||
57053 | 200107 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1538 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6014865.1345 | 2092505.1157 | 37.726456013252 | -122.390799692144 | (37.726456013252, -122.390799692144) | 10 | 3 | 8 | 58 | 1 | |||
158966 | 200108 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1538 Yosemite Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6014848.2148 | 2092517.9747 | 37.7264903827113 | -122.390859081597 | (37.7264903827113, -122.390859081597) | 10 | 3 | 8 | 58 | 1 | |||
112916 | 200109 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1550 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6014832.6487 | 2092528.8033 | 37.7265192521755 | -122.390913649883 | (37.7265192521755, -122.390913649883) | 10 | 3 | 8 | 58 | 1 | |||
88009 | 189269 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1600 Oakdale Ave | 1 | : | Tree | Private 2 | 10 | Width 4ft | 6014890.23079 | 2095625.56683 | 37.7350255350863 | -122.390930927939 | (37.7350255350863, -122.390930927939) | 10 | 3 | 8 | 58 | 1 | |||
172874 | 200110 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1550 Yosemite Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6014819.7897 | 2092537.6015 | 37.7265426967552 | -122.390958717949 | (37.7265426967552, -122.390958717949) | 10 | 3 | 8 | 58 | 1 | |||
2148 | 154032 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1662 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6014879.40227 | 2097032.81009 | 37.7388889362706 | -122.391066694069 | (37.7388889362706, -122.391066694069) | 10 | 3 | 8 | 58 | 1 | |||
132797 | 200114 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1566 Yosemite Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6014762.2628 | 2092586.3302 | 37.7266733037648 | -122.39116099243 | (37.7266733037648, -122.39116099243) | 10 | 3 | 8 | 58 | 1 | |||
11678 | 262547 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1329 Egbert Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/2020 12:00:00 AM | Width 0ft | 6014600.2068 | 2090881.6643 | 37.7219836364279 | -122.391602089471 | (37.7219836364279, -122.391602089471) | 10 | 3 | 8 | 58 | 1 | |||
83473 | 26006 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1669 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2000 12:00:00 AM | 3 | 3X3 | 6014649.37023 | 2095737.8438 | 37.7353204569787 | -122.391771523335 | (37.7353204569787, -122.391771523335) | 10 | 3 | 8 | 58 | 1 | ||
113322 | 26016 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1690 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/2000 12:00:00 AM | 3 | 3X3 | 6014602.53952 | 2095841.20994 | 37.735601679469 | -122.391940661537 | (37.735601679469, -122.391940661537) | 10 | 3 | 8 | 58 | 1 | ||
149315 | 26433 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1679 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/19/2000 12:00:00 AM | 3 | 3X3 | 6014598.59548 | 2095777.3145 | 37.7354260166954 | -122.391949831041 | (37.7354260166954, -122.391949831041) | 10 | 3 | 8 | 58 | 1 | ||
11677 | 26000 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1715 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/25/2012 12:00:00 AM | 3 | 3x3 | 6014353.43695 | 2095957.87317 | 37.7359081801195 | -122.39281007034 | (37.7359081801195, -122.39281007034) | 10 | 3 | 8 | 58 | 1 | ||
56744 | 189271 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1715 Oakdale Ave | 1 | : | Tree | Private 2 | 3 | Width 3ft | 6014352.7466 | 2095957.7571 | 37.7359078230711 | -122.392812449055 | (37.7359078230711, -122.392812449055) | 10 | 3 | 8 | 58 | 1 | |||
45086 | 25999 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1717 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/22/1997 12:00:00 AM | 3 | 3x3 | 6014332.85691 | 2095971.76656 | 37.7359451854222 | -122.392882195975 | (37.7359451854222, -122.392882195975) | 10 | 3 | 8 | 58 | 1 | ||
96628 | 189268 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1721 Oakdale Ave | 2 | : | Tree | Private 2 | 7 | Width 3ft | 6014331.30759 | 2095974.08961 | 37.7359514779837 | -122.39288771511 | (37.7359514779837, -122.39288771511) | 10 | 3 | 8 | 58 | 1 | |||
78139 | 106892 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 629 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2014 12:00:00 AM | 1 | Permit Number 773229 | 6014439.75654 | 2104200.5982 | 37.7585457626959 | -122.393088190163 | (37.7585457626959, -122.393088190163) | 10 | 3 | 8 | 28856 | 29 | ||
118388 | 191088 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1 01st St | 19 | : Yard | Tree | Private 2 | 18 | 6014455.34951 | 2105889.69248 | 37.7631845152826 | -122.393152451232 | (37.7631845152826, -122.393152451232) | 14 | 3 | 8 | 28856 | 29 | ||||
186400 | 191083 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1050 18th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | 6014452.20409 | 2105784.61715 | 37.7628958266015 | -122.39315597749 | (37.7628958266015, -122.39315597749) | 14 | 3 | 8 | 28856 | 29 | ||||
125381 | 53156 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1785@ 3RD ST Quesada Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/2006 12:00:00 AM | 6 | Permit Number 49078 | 6014235.0305 | 2095339.35268 | 37.7342032723443 | -122.393176185249 | (37.7342032723443, -122.393176185249) | 10 | 3 | 8 | 58 | 1 | |
48749 | 103917 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1300X Fitzgerald Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6014139.7 | 2090933.3 | 37.7220998454463 | -122.393197569728 | (37.7220998454463, -122.393197569728) | 10 | 3 | 8 | 58 | 1 | |||
76198 | 103919 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1300X Fitzgerald Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6014139.7 | 2090933.3 | 37.7220998454463 | -122.393197569728 | (37.7220998454463, -122.393197569728) | 10 | 3 | 8 | 58 | 1 | |||
159416 | 103923 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1300X Fitzgerald Ave | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6014139.7 | 2090933.3 | 37.7220998454463 | -122.393197569728 | (37.7220998454463, -122.393197569728) | 10 | 3 | 8 | 58 | 1 | |||
179325 | 103921 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1300X Fitzgerald Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6014139.7 | 2090933.3 | 37.7220998454463 | -122.393197569728 | (37.7220998454463, -122.393197569728) | 10 | 3 | 8 | 58 | 1 | |||
187500 | 103915 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1300X Fitzgerald Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6014139.7 | 2090933.3 | 37.7220998454463 | -122.393197569728 | (37.7220998454463, -122.393197569728) | 10 | 3 | 8 | 58 | 1 | |||
23656 | 191084 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1050 18th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | 6014440.03961 | 2105781.9689 | 37.7628878793072 | -122.393197865211 | (37.7628878793072, -122.393197865211) | 14 | 3 | 8 | 28856 | 29 | ||||
153010 | 53155 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1785@ 3RD ST Quesada Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/02/2006 12:00:00 AM | 7 | Permit Number 49078 | 6014228.24564 | 2095345.46405 | 37.7342196759901 | -122.393200070342 | (37.7342196759901, -122.393200070342) | 10 | 3 | 8 | 58 | 1 | ||
46308 | 191085 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1050 18th St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6014420.63086 | 2105780.43179 | 37.762882580487 | -122.393264886285 | (37.762882580487, -122.393264886285) | 14 | 3 | 8 | 28856 | 29 | ||||
170486 | 95807 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 10993 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767551 | 6014326.8 | 2102083.7 | 37.752726939242 | -122.393330710599 | (37.752726939242, -122.393330710599) | 10 | 3 | 8 | 28856 | 29 | |
33794 | 191086 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1050 18th St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 10ft | 6014399.78897 | 2105779.8886 | 37.762879931094 | -122.393336933676 | (37.762879931094, -122.393336933676) | 14 | 3 | 8 | 28856 | 29 | |||
124140 | 191087 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1050 18th St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6014377.05875 | 2105781.79588 | 37.762883905197 | -122.393415683687 | (37.762883905197, -122.393415683687) | 14 | 3 | 8 | 28856 | 29 | ||||
190937 | 189272 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1789 Oakdale Ave | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6014048.88892 | 2096189.76773 | 37.7365279946626 | -122.393879249144 | (37.7365279946626, -122.393879249144) | 10 | 3 | 8 | 58 | 1 | |||
34932 | 25993 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1789 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/25/2012 12:00:00 AM | 3 | 3x3 | 6014037.23638 | 2096196.21513 | 37.7365450503068 | -122.393919988427 | (37.7365450503068, -122.393919988427) | 10 | 3 | 8 | 58 | 1 | ||
119510 | 102645 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1800 Oakdale Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/16/2015 12:33:00 PM | 3 | 3x3 | 6013980.4 | 2096382.2 | 37.7370525675082 | -122.394129514082 | (37.7370525675082, -122.394129514082) | 10 | 3 | 8 | 58 | 1 | ||
55558 | 191092 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 299 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6014058.4688 | 2105768.40922 | 37.7628294422497 | -122.394516646351 | (37.7628294422497, -122.394516646351) | 14 | 3 | 8 | 28856 | 29 | |||
34407 | 25915 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1800 Oakdale Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/16/2015 12:17:00 PM | 3 | 3X3 | 6013847.66398 | 2096411.7192 | 37.737126242566 | -122.394590512161 | (37.737126242566, -122.394590512161) | 10 | 3 | 8 | 58 | 1 | ||
130010 | 27245 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1840X Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6013813.10368 | 2096437.28943 | 37.7371945316856 | -122.394711793835 | (37.7371945316856, -122.394711793835) | 10 | 3 | 8 | 58 | 1 | ||
92049 | 27246 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1840X Oakdale Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6013798.74354 | 2096448.75806 | 37.7372252237561 | -122.394762246699 | (37.7372252237561, -122.394762246699) | 10 | 3 | 8 | 58 | 1 | ||
139174 | 189244 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 690 Texas St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780809 | 6013923.09543 | 2103892.83973 | 37.7576720101792 | -122.394853496397 | (37.7576720101792, -122.394853496397) | 10 | 3 | 8 | 28856 | 29 | |
140396 | 66887 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1324 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/1991 12:00:00 AM | 9 | Permit Number 30200 | 6013938.0874 | 2104806.5934 | 37.7601818129701 | -122.394865641745 | (37.7601818129701, -122.394865641745) | 10 | 3 | 8 | 28856 | 29 | ||
138524 | 189243 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 690 Texas St | 4 | : | Tree | Private 2 | 4 | Width 3ft | 6013912.25282 | 2103910.20868 | 37.757719098672 | -122.3948922113 | (37.757719098672, -122.3948922113) | 10 | 3 | 8 | 28856 | 29 | |||
152232 | 189242 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 690 Texas St | 3 | : | Tree | Private 2 | 5 | Width 3ft | 6013899.94699 | 2103926.17826 | 37.7577622634227 | -122.394935888703 | (37.7577622634227, -122.394935888703) | 10 | 3 | 8 | 28856 | 29 | |||
97130 | 189241 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 690 Texas St | 2 | : | Tree | Private 2 | 5 | Width 3ft | 6013889.32799 | 2103940.39875 | 37.7578007193328 | -122.394973609851 | (37.7578007193328, -122.394973609851) | 10 | 3 | 8 | 28856 | 29 | |||
31011 | 189240 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 690 Texas St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6013877.57271 | 2103955.2138 | 37.7578407445781 | -122.39501530244 | (37.7578407445781, -122.39501530244) | 10 | 3 | 8 | 28856 | 29 | |||
47596 | 189239 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 670 Texas St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6013865.85822 | 2103972.02889 | 37.7578862637531 | -122.39505699409 | (37.7578862637531, -122.39505699409) | 10 | 3 | 8 | 28856 | 29 | |||
164702 | 37992 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 650 Texas St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/1998 12:00:00 AM | 5 | Permit Number 40210 | 6013843.22598 | 2104002.49869 | 37.7579686686468 | -122.39513740069 | (37.7579686686468, -122.39513740069) | 10 | 3 | 8 | 28856 | 29 | ||
18922 | 74929 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 39 Stillman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6014021.82023 | 2112985.48182 | 37.7826438712502 | -122.395148955186 | (37.7826438712502, -122.395148955186) | 6 | 2 | 9 | 28856 | 6 | |||
177312 | 37991 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 650 Texas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/1998 12:00:00 AM | 4 | Permit Number 40210 | 6013832.0389 | 2104017.01631 | 37.7580079087535 | -122.395177107536 | (37.7580079087535, -122.395177107536) | 10 | 3 | 8 | 28856 | 29 | ||
102516 | 37990 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 650 Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2002 12:00:00 AM | 1 | Permit Number 44744 | 6013820.84604 | 2104031.24845 | 37.758046364659 | -122.395216814417 | (37.758046364659, -122.395216814417) | 10 | 3 | 8 | 28856 | 29 | |
9764 | 150815 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 640 Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6013813.37874 | 2104087.70708 | 37.7582009725247 | -122.395246594574 | (37.7582009725247, -122.395246594574) | 10 | 3 | 8 | 28856 | 29 | |||
38276 | 52807 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 25@ TEXAS Sierra St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2006 12:00:00 AM | Permit Number 48835 | 6013772.92448179 | 2104112.24559711 | 37.7582661000564 | -122.39538822301 | (37.7582661000564, -122.39538822301) | 10 | 3 | 8 | 28856 | 29 | |||
64054 | 52809 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 25@ TEXAS Sierra St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2006 12:00:00 AM | Permit Number 48835 | 6013772.92448179 | 2104112.24559711 | 37.7582661000564 | -122.39538822301 | (37.7582661000564, -122.39538822301) | 10 | 3 | 8 | 28856 | 29 | |||
68640 | 52808 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 25@ TEXAS Sierra St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2006 12:00:00 AM | Permit Number 48835 | 6013772.92448179 | 2104112.24559711 | 37.7582661000564 | -122.39538822301 | (37.7582661000564, -122.39538822301) | 10 | 3 | 8 | 28856 | 29 | |||
146226 | 52806 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 25@ TEXAS Sierra St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2006 12:00:00 AM | Permit Number 48835 | 6013772.92448179 | 2104112.24559711 | 37.7582661000564 | -122.39538822301 | (37.7582661000564, -122.39538822301) | 10 | 3 | 8 | 28856 | 29 | |||
19092 | 150813 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 25 Sierra St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6013747.19893 | 2104113.81693 | 37.758268983752 | -122.395477303948 | (37.758268983752, -122.395477303948) | 10 | 3 | 8 | 28856 | 29 | |||
164537 | 52805 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 25@ TEXAS Sierra St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2006 12:00:00 AM | 3 | Permit Number 48835 | 6013721.70041 | 2104112.27723 | 37.758263337788 | -122.395565381751 | (37.758263337788, -122.395565381751) | 10 | 3 | 8 | 28856 | 29 | ||
190222 | 52804 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 25@ TEXAS Sierra St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2006 12:00:00 AM | 4 | Permit Number 48835 | 6013685.88605 | 2104111.17484 | 37.758258318682 | -122.395689167119 | (37.758258318682, -122.395689167119) | 10 | 3 | 8 | 28856 | 29 | ||
24529 | 27530 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1898X Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5 | 3X3 | 6013528.91672 | 2096649.27619 | 37.7377607988237 | -122.395709213912 | (37.7377607988237, -122.395709213912) | 10 | 3 | 8 | 58 | 1 | |||
42964 | 52803 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 25@ TEXAS Sierra St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2006 12:00:00 AM | 4 | Permit Number 48835 | 6013662.91964 | 2104110.04081 | 37.7582539273014 | -122.395768516112 | (37.7582539273014, -122.395768516112) | 10 | 3 | 8 | 28856 | 29 | ||
85606 | 25919 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1894X Oakdale Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/10/2007 12:00:00 AM | 3 | 3X3 | 6013501.35934 | 2096660.10843 | 37.7377890089073 | -122.395805252575 | (37.7377890089073, -122.395805252575) | 10 | 3 | 8 | 58 | 1 | ||
115858 | 52802 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 25@ TEXAS Sierra St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2006 12:00:00 AM | 3 | Permit Number 48835 | 6013642.25558 | 2104109.31738 | 37.7582507913691 | -122.395839931279 | (37.7582507913691, -122.395839931279) | 10 | 3 | 8 | 28856 | 29 | ||
60769 | 52801 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 25@ TEXAS Sierra St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2006 12:00:00 AM | 1 | Permit Number 48835 | 6013622.04592 | 2104108.35581 | 37.7582470267928 | -122.395909758227 | (37.7582470267928, -122.395909758227) | 10 | 3 | 8 | 28856 | 29 | ||
180320 | 191668 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 535 Brannan St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6013300.95519 | 2111099.53181 | 37.7774253698298 | -122.397510546978 | (37.7774253698298, -122.397510546978) | 6 | 2 | 9 | 28856 | 34 | |||
62574 | 191667 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 535 Brannan St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6013269.51559 | 2111071.49251 | 37.7773466296777 | -122.397617340561 | (37.7773466296777, -122.397617340561) | 6 | 2 | 9 | 28856 | 34 | |||
33288 | 191666 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 535 Brannan St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6013244.57038 | 2111045.61556 | 37.7772741883968 | -122.397701819284 | (37.7772741883968, -122.397701819284) | 6 | 2 | 9 | 28856 | 34 | |||
36375 | 191665 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 535 Brannan St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6013224.69067 | 2111029.20074 | 37.7772280099979 | -122.397769438408 | (37.7772280099979, -122.397769438408) | 6 | 2 | 9 | 28856 | 34 | |||
146918 | 191664 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 535 Brannan St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6013199.96962 | 2111004.76664 | 37.7771595428277 | -122.397853242637 | (37.7771595428277, -122.397853242637) | 6 | 2 | 9 | 28856 | 34 | |||
69618 | 191057 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 351 Saint Francis Pl | 2 | : | Tree | Private 2 | 4 | Width 1ft | 6013212.85575 | 2113183.51616 | 37.78314260738 | -122.397961541709 | (37.78314260738, -122.397961541709) | 6 | 2 | 9 | 28856 | 6 | |||
59674 | 191663 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 535 Brannan St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6013137.81115 | 2110946.71833 | 37.7769966935644 | -122.398064196625 | (37.7769966935644, -122.398064196625) | 6 | 2 | 9 | 28856 | 34 | |||
17486 | 191662 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 535 Brannan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6013078.45063 | 2110885.87068 | 37.776826313422 | -122.398265274217 | (37.776826313422, -122.398265274217) | 6 | 2 | 9 | 28856 | 34 | |||
148796 | 191661 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 535 Brannan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6013060.06963 | 2110865.5961 | 37.7767696201591 | -122.398327437183 | (37.7767696201591, -122.398327437183) | 6 | 2 | 9 | 28856 | 34 | |||
173736 | 191660 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 535 Brannan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6013043.398 | 2110850.10481 | 37.7767261559098 | -122.3983840225 | (37.7767261559098, -122.3983840225) | 6 | 2 | 9 | 28856 | 34 | |||
44433 | 94516 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1106X Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 08/27/2010 12:00:00 AM | 2 | Permit Number 53703 | 6012787.7377 | 2102360.94736 | 37.7534025731789 | -122.398672553793 | (37.7534025731789, -122.398672553793) | 10 | 3 | 8 | 28856 | 29 | ||
129567 | 1769 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2000X Bay Shore Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/11/2011 12:00:00 AM | 3 | 3x3 | 6012375.8565272 | 2088505.2474917 | 37.7153347551878 | -122.399124435859 | (37.7153347551878, -122.399124435859) | 10 | 7 | 8 | 309 | 39 | ||
36881 | 46985 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2011 26th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2002 12:00:00 AM | 5 | Permit Number 44999 | 6012611.41785 | 2101473.70376 | 37.7509565692018 | -122.399220032275 | (37.7509565692018, -122.399220032275) | 10 | 3 | 8 | 28856 | 1 | ||
110605 | 46987 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2011 26th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/24/2010 12:00:00 AM | 5 | Permit Number 53455 | 6012596.87958 | 2101472.71362 | 37.7509530402521 | -122.39927023785 | (37.7509530402521, -122.39927023785) | 10 | 3 | 8 | 28856 | 1 | ||
22344 | 189270 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 59 Robblee Ave | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6012477.87962 | 2095853.3507 | 37.735516831132 | -122.39928732315 | (37.735516831132, -122.39928732315) | 10 | 3 | 8 | 58 | 1 | |||
152105 | 46999 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2011 26th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/24/2010 12:00:00 AM | 5 | Permit Number 53455 | 6012582.01898 | 2101471.73036 | 37.7509495122074 | -122.399321558558 | (37.7509495122074, -122.399321558558) | 10 | 3 | 8 | 28856 | 1 | ||
166764 | 96201 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2000X Bay Shore Blvd | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/11/2011 12:00:00 AM | 3 | 3x3 | 6012318.2 | 2088514.6 | 37.71535722204 | -122.399324379639 | (37.71535722204, -122.399324379639) | 10 | 7 | 8 | 309 | 39 | ||
114813 | 191095 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1951 23rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6012592.46534 | 2102823.04083 | 37.7546604998905 | -122.399380288765 | (37.7546604998905, -122.399380288765) | 10 | 3 | 8 | 28856 | 29 | |||
167748 | 46986 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2011 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/24/2010 12:00:00 AM | 4 | Permit Number 53455 | 6012562.93976 | 2101469.54753 | 37.7509424552537 | -122.399387383547 | (37.7509424552537, -122.399387383547) | 10 | 3 | 8 | 28856 | 1 | ||
1268 | 261097 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1999 Carroll Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2019 12:00:00 AM | 3 | 4x6 | 6012390 | 2093339 | 37.7286080475288 | -122.399414697344 | (37.7286080475288, -122.399414697344) | 10 | 3 | 8 | 58 | 1 | ||
16994 | 261098 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1999 Carroll Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2019 12:00:00 AM | 3 | 4x6 | 6012390 | 2093339 | 37.7286080475288 | -122.399414697344 | (37.7286080475288, -122.399414697344) | 10 | 3 | 8 | 58 | 1 |
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) );