trees
563 rows where qSpecies_id = 52 sorted by TreeID 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 183646 | 99975 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 2295 Folsom St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47188 | 6008194 | 2105070 | 37.7605840051662 | -122.414750422926 | (37.7605840051662, -122.414750422926) | 2 | 4 | 7 | 28859 | 19 | ||||
| 128798 | 99751 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 500x Clipper St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 3x3 | 1046 Diamond St | 6001860.7 | 2100931.8 | 37.7488636216299 | -122.436358217698 | (37.7488636216299, -122.436358217698) | 2 | 4 | 5 | 28862 | 22 | ||
| 31523 | 98952 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 302 Ivy St | 18 | Front Yard : Yard | Tree | Private 2 | 6005888.5 | 2111234.3 | 37.7773798943726 | -122.42316228433 | (37.7773798943726, -122.42316228433) | 7 | 9 | 11 | 28852 | 10 | |||||
| 140823 | 98951 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 401 Grove St | 11 | Front Yard : Yard | Tree | Private 2 | 6005778.2 | 2111279 | 37.7774964045324 | -122.423547027313 | (37.7774964045324, -122.423547027313) | 7 | 9 | 11 | 28852 | 10 | |||||
| 46714 | 9895 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1800X Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6005051.0377 | 2115464.4068 | 37.7889474242075 | -122.426360597873 | (37.7889474242075, -122.426360597873) | 13 | 9 | 1 | 28858 | 27 | |||
| 38900 | 97781 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 249 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | strip | 5992441.6 | 2097612.4 | 37.7392096976829 | -122.468687674985 | (37.7392096976829, -122.468687674985) | 1 | 8 | 4 | 59 | 40 | |||
| 154498 | 97394 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 907 Diamond St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/30/2011 12:00:00 AM | 23 | 4x4 | Permit Number 768003 | 6001936 | 2101462 | 37.7503237031932 | -122.436135767062 | (37.7503237031932, -122.436135767062) | 2 | 4 | 5 | 28862 | 22 | |
| 139874 | 97392 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 907 Diamond St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/30/2011 12:00:00 AM | 23 | 4x4 | Permit Number 768003 | 6001936 | 2101462 | 37.7503237031932 | -122.436135767062 | (37.7503237031932, -122.436135767062) | 2 | 4 | 5 | 28862 | 22 | |
| 123227 | 95381 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 20 Fillmore St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 6003883.1 | 2108496.4 | 37.7697489175502 | -122.429904273455 | (37.7697489175502, -122.429904273455) | 7 | 9 | 5 | 29492 | 10 | ||||
| 72544 | 95380 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 20 Fillmore St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 6003883.1 | 2108496.4 | 37.7697489175502 | -122.429904273455 | (37.7697489175502, -122.429904273455) | 7 | 9 | 5 | 29492 | 10 | ||||
| 63332 | 95379 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 20 Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 6003883.1 | 2108496.4 | 37.7697489175502 | -122.429904273455 | (37.7697489175502, -122.429904273455) | 7 | 9 | 5 | 29492 | 10 | ||||
| 120835 | 95378 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 20 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 6003883.1 | 2108496.4 | 37.7697489175502 | -122.429904273455 | (37.7697489175502, -122.429904273455) | 7 | 9 | 5 | 29492 | 10 | ||||
| 56075 | 94645 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 30 Middle Point Rd | 34 | : | Tree | Private 2 | 6018215 | 2095138 | 37.7338706954973 | -122.379402036794 | (37.7338706954973, -122.379402036794) | 10 | 3 | 8 | 58 | 1 | |||||
| 154879 | 94599 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1709 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5997540 | 2108126 | 37.7683706375079 | -122.451818041345 | (37.7683706375079, -122.451818041345) | 15 | 5 | 11 | 29492 | 9 | |||||
| 49613 | 94388 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1001 Potrero Ave | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | 10 | 4 | 8 | 28859 | 19 | ||||
| 36976 | 94387 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1001 Potrero Ave | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | 10 | 4 | 8 | 28859 | 19 | ||||
| 154210 | 94386 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1001 Potrero Ave | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | 10 | 4 | 8 | 28859 | 19 | ||||
| 92922 | 94385 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1001 Potrero Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | 10 | 4 | 8 | 28859 | 19 | ||||
| 66164 | 94384 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1001 Potrero Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | 10 | 4 | 8 | 28859 | 19 | ||||
| 38709 | 94383 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1001 Potrero Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | 10 | 4 | 8 | 28859 | 19 | ||||
| 189365 | 94382 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1001 Potrero Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | 10 | 4 | 8 | 28859 | 19 | ||||
| 104871 | 94381 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1001 Potrero Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | 10 | 4 | 8 | 28859 | 19 | ||||
| 48424 | 94380 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1001 Potrero Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | 10 | 4 | 8 | 28859 | 19 | ||||
| 75000 | 94379 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1001 Potrero Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | 10 | 4 | 8 | 28859 | 19 | ||||
| 24093 | 94378 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1001 Potrero Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | 10 | 4 | 8 | 28859 | 19 | ||||
| 151322 | 94377 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1001 Potrero Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | 10 | 4 | 8 | 28859 | 19 | ||||
| 128188 | 94201 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1227 Pierce St | 2 | Sidewalk: Property side : | Tree | Private 2 | 06/22/2010 12:00:00 AM | Permit Number 53604 | 6002086 | 2112766.6 | 37.7813718842821 | -122.436426049876 | (37.7813718842821, -122.436426049876) | 15 | 5 | 11 | 29490 | 41 | |||
| 76051 | 9290 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 22 George Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6017267.4584317 | 2094080.8187147 | 37.7309155826614 | -122.382604470803 | (37.7309155826614, -122.382604470803) | 10 | 3 | 8 | 58 | 1 | |||
| 3992 | 9289 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 13X George Ct | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6017208.5497632 | 2094048.0250587 | 37.7308222832509 | -122.382805848563 | (37.7308222832509, -122.382805848563) | 10 | 3 | 8 | 58 | 1 | |||
| 47917 | 9288 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 13X George Ct | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6017208.5497632 | 2094048.0250587 | 37.7308222832509 | -122.382805848563 | (37.7308222832509, -122.382805848563) | 10 | 3 | 8 | 58 | 1 | |||
| 13854 | 9287 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 13X George Ct | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6017208.5497632 | 2094048.0250587 | 37.7308222832509 | -122.382805848563 | (37.7308222832509, -122.382805848563) | 10 | 3 | 8 | 58 | 1 | |||
| 194069 | 9286 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 13X George Ct | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6017208.5497632 | 2094048.0250587 | 37.7308222832509 | -122.382805848563 | (37.7308222832509, -122.382805848563) | 10 | 3 | 8 | 58 | 1 | |||
| 106421 | 9285 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 13X George Ct | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6017208.5497632 | 2094048.0250587 | 37.7308222832509 | -122.382805848563 | (37.7308222832509, -122.382805848563) | 10 | 3 | 8 | 58 | 1 | |||
| 95853 | 9283 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 12 George Ct | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6017331.5677853 | 2094059.0389315 | 37.7308593210732 | -122.382381317235 | (37.7308593210732, -122.382381317235) | 10 | 3 | 8 | 58 | 1 | |||
| 26132 | 9282 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 12 George Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6017331.5677853 | 2094059.0389315 | 37.7308593210732 | -122.382381317235 | (37.7308593210732, -122.382381317235) | 10 | 3 | 8 | 58 | 1 | |||
| 58852 | 92012 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1900 Geary Blvd | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 52162 | 6002138.3 | 2113859.7 | 37.7843762313587 | -122.436323371803 | (37.7843762313587, -122.436323371803) | 13 | 6 | 11 | 29490 | 13 | ||||
| 131970 | 92011 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1900 Geary Blvd | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 52162 | 6002138.3 | 2113859.7 | 37.7843762313587 | -122.436323371803 | (37.7843762313587, -122.436323371803) | 13 | 6 | 11 | 29490 | 13 | ||||
| 157949 | 91085 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 4055 24th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2009 12:00:00 AM | 3x3 | Permit Number 51980 | 6002824 | 2101802 | 37.7513076735554 | -122.433089295463 | (37.7513076735554, -122.433089295463) | 2 | 4 | 5 | 28862 | 22 | ||
| 65187 | 91084 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 4055 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2009 12:00:00 AM | 3x3 | Permit Number 51980 | 6002824 | 2101802 | 37.7513076735554 | -122.433089295463 | (37.7513076735554, -122.433089295463) | 2 | 4 | 5 | 28862 | 22 | ||
| 137412 | 91083 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 4055 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2009 12:00:00 AM | 3x3 | Permit Number 51980 | 6002824 | 2101802 | 37.7513076735554 | -122.433089295463 | (37.7513076735554, -122.433089295463) | 2 | 4 | 5 | 28862 | 22 | ||
| 167346 | 88605 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 2719 15th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/01/2008 12:00:00 AM | 3x3 | Permit Number 52923 | 5991770.2 | 2096974.3 | 37.737418827963 | -122.470962580807 | (37.737418827963, -122.470962580807) | 1 | 8 | 4 | 29491 | 40 | ||
| 150229 | 87675 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 770 Golden Gate Ave | 11 | Front Yard : Cutout | Tree | Private 2 | 05/22/2008 12:00:00 AM | 3x3 | Permit Number 50396 | 6005860.1 | 2112469.5 | 37.7807698496384 | -122.423348359154 | (37.7807698496384, -122.423348359154) | 7 | 9 | 11 | 28852 | 41 | ||
| 42746 | 87674 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 770 Golden Gate Ave | 10 | Front Yard : Cutout | Tree | Private 2 | 05/22/2008 12:00:00 AM | 3x3 | Permit Number 50396 | 6005860.1 | 2112469.5 | 37.7807698496384 | -122.423348359154 | (37.7807698496384, -122.423348359154) | 7 | 9 | 11 | 28852 | 41 | ||
| 5768 | 87061 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | unknown : Yard | Tree | Private 2 | 3x3 | Permit Number 50003 | |||||||||||||||
| 5213 | 84938 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 145 Guerrero St | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 49347 | 6005480 | 2108218 | 37.7690748022624 | -122.42436083172 | (37.7690748022624, -122.42436083172) | 8 | 4 | 5 | 28853 | 19 | ||||
| 165498 | 75663 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 400 Duboce Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/20/1990 12:00:00 AM | 25 | 6003991.19971734 | 2108404.68072341 | 37.7695031998873 | -122.429523817606 | (37.7695031998873, -122.429523817606) | 7 | 9 | 5 | 29492 | 10 | |||
| 123761 | 69542 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 775 Edinburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | 8 | Permit Number 38643 | 6001970.16460074 | 2089302.5400568 | 37.71693856245 | -122.435148029449 | (37.71693856245, -122.435148029449) | 9 | 7 | 6 | 28861 | 5 | |
| 65900 | 69470 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1570 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/16/1994 12:00:00 AM | Permit Number 33586 | 5991155.36555461 | 2104799.07062441 | 37.7588680376507 | -122.47365896033 | (37.7588680376507, -122.47365896033) | 1 | 8 | 4 | 56 | 12 | ||
| 117164 | 69209 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1013 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1994 12:00:00 AM | Permit Number 33260 | 6008042.23882633 | 2102024.29023495 | 37.7522126526326 | -122.415059711834 | (37.7522126526326, -122.415059711834) | 2 | 4 | 7 | 28859 | 19 | ||
| 152370 | 69180 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1310 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1994 12:00:00 AM | 8 | Permit Number 33219 | 5982156.72464205 | 2106168.22486515 | 37.7621020835294 | -122.504881372035 | (37.7621020835294, -122.504881372035) | 1 | 8 | 3 | 56 | 35 | |
| 158878 | 69022 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 2094 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1994 12:00:00 AM | Permit Number 33026 | 5981407.07152231 | 2100831.13487358 | 37.7474038185251 | -122.507078153918 | (37.7474038185251, -122.507078153918) | 1 | 8 | 3 | 29491 | 35 | ||
| 70229 | 68834 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 213 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1993 12:00:00 AM | Permit Number 32785 | 5999328.0521661 | 2094050.43857188 | 37.7298248100363 | -122.444621556754 | (37.7298248100363, -122.444621556754) | 9 | 7 | 4 | 28861 | 40 | ||
| 83066 | 68706 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 3727 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/22/1993 12:00:00 AM | Permit Number 32714 | 6004057.02264849 | 2105954.86981245 | 37.7627803365256 | -122.429121438821 | (37.7627803365256, -122.429121438821) | 8 | 4 | 5 | 28862 | 3 | ||
| 156558 | 68317 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1999X 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 32130 | 5981353.71840295 | 2101490.23529545 | 37.7492103807501 | -122.507311533808 | (37.7492103807501, -122.507311533808) | 1 | 8 | 3 | 29491 | 35 | ||
| 170367 | 68260 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 330 Holyoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 32066 | 6009617.65665916 | 2092860.11678258 | 37.7271382244341 | -122.408965114302 | (37.7271382244341, -122.408965114302) | 10 | 3 | 7 | 309 | 28 | ||
| 179964 | 68255 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 235 Holyoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 32060 | 6009537.98073102 | 2093299.04188101 | 37.7283389564803 | -122.409271515047 | (37.7283389564803, -122.409271515047) | 10 | 3 | 7 | 309 | 28 | ||
| 49435 | 67842 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 3854 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1993 12:00:00 AM | Permit Number 31510 | 6004840.52212153 | 2100493.06857021 | 37.7478278305843 | -122.426022759795 | (37.7478278305843, -122.426022759795) | 2 | 4 | 5 | 63 | 22 | ||
| 106472 | 67812 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 950 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/29/1995 12:00:00 AM | Permit Number 31466 | 6003745.95469336 | 2102716.06929971 | 37.7538697471416 | -122.429966268708 | (37.7538697471416, -122.429966268708) | 2 | 4 | 5 | 28862 | 22 | ||
| 33601 | 67497 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 143 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/18/1999 12:00:00 AM | Permit Number 31025 | 5999134.28418924 | 2093760.51474913 | 37.7290176881307 | -122.445270595435 | (37.7290176881307, -122.445270595435) | 9 | 7 | 4 | 28861 | 40 | ||
| 84008 | 67301 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 110 Beulah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/1992 12:00:00 AM | Permit Number 30782 | 5997564.33795756 | 2107830.91613748 | 37.7675618065748 | -122.451712570063 | (37.7675618065748, -122.451712570063) | 15 | 5 | 11 | 29492 | 9 | |||
| 55395 | 67118 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 35 Carmel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/29/1992 12:00:00 AM | Permit Number 30538 | 5998791.80760997 | 2105372.50995466 | 37.7608818625197 | -122.44728997041 | (37.7608818625197, -122.44728997041) | 15 | 5 | 11 | 29492 | 12 | ||
| 145339 | 67105 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1205 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/1992 12:00:00 AM | Permit Number 30520 | 5992960.34916512 | 2107265.37958459 | 37.765744243823 | -122.467595898952 | (37.765744243823, -122.467595898952) | 11 | 8 | 11 | 56 | 12 | ||
| 148069 | 66850 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1880 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/15/1991 12:00:00 AM | Permit Number 30155 | 5998816.45099957 | 2110433.37978637 | 37.7747791387742 | -122.447569047166 | (37.7747791387742, -122.447569047166) | 15 | 5 | 11 | 29492 | 16 | ||
| 177890 | 66846 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 25 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/15/1991 12:00:00 AM | 14 | Permit Number 30150 | 5998189.80412132 | 2110576.56755949 | 37.7751364632784 | -122.449747058625 | (37.7751364632784, -122.449747058625) | 15 | 5 | 11 | 29492 | 16 | |
| 66384 | 66803 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 42 Woodward St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/20/1991 12:00:00 AM | Permit Number 30083 | 6006463.70585844 | 2108242.90937755 | 37.76919869647 | -122.420960014682 | (37.76919869647, -122.420960014682) | 8 | 4 | 7 | 28853 | 19 | ||
| 170435 | 66751 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1126 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/12/1991 12:00:00 AM | Permit Number 30003 | 5998922.20523511 | 2106051.2337001 | 37.7627529185657 | -122.446887825215 | (37.7627529185657, -122.446887825215) | 15 | 5 | 5 | 29492 | 9 | ||
| 105041 | 66384 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 289 Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1991 12:00:00 AM | Permit Number 29510 | 6003897.0288205 | 2108659.24127875 | 37.7701968288604 | -122.429867711068 | (37.7701968288604, -122.429867711068) | 7 | 9 | 5 | 29492 | 10 | ||
| 87134 | 66337 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1230 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/10/1990 12:00:00 AM | 12 | Permit Number 29458 | 5986478.94641131 | 2106871.16119587 | 37.7642854833106 | -122.489984375656 | (37.7642854833106, -122.489984375656) | 1 | 8 | 3 | 56 | 35 | |
| 79337 | 66246 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 50 De Montfort Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/1990 12:00:00 AM | Permit Number 29346 | 5995210.96497601 | 2091915.27509183 | 37.7237263724293 | -122.458700188143 | (37.7237263724293, -122.458700188143) | 9 | 8 | 4 | 28861 | 24 | ||
| 94023 | 65615 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 907 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/1990 12:00:00 AM | Permit Number 28522 | 6001416.70920324 | 2088928.18069936 | 37.7158792115697 | -122.437034265981 | (37.7158792115697, -122.437034265981) | 9 | 7 | 6 | 28861 | 5 | ||
| 149348 | 65614 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 901 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/1990 12:00:00 AM | 3x3 | Permit Number 28521 | 6001429.80797007 | 2088950.28994853 | 37.7159406631737 | -122.436990572562 | (37.7159406631737, -122.436990572562) | 9 | 7 | 6 | 28861 | 5 | |
| 185978 | 65605 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 138 Maynard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/1990 12:00:00 AM | Permit Number 28509 | 6004309.62922812 | 2093740.61229591 | 37.7292571013758 | -122.427377609436 | (37.7292571013758, -122.427377609436) | 9 | 7 | 6 | 28861 | 5 | ||
| 115747 | 65553 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 283 Juanita Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1990 12:00:00 AM | Permit Number 28452 | 5995572.37835094 | 2097534.90092934 | 37.7391772690895 | -122.457857313996 | (37.7391772690895, -122.457857313996) | 9 | 7 | 4 | 59 | 40 | ||
| 113696 | 65552 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 285 Juanita Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1990 12:00:00 AM | Permit Number 28451 | 5995547.56425531 | 2097511.07200024 | 37.7391104150803 | -122.457941385434 | (37.7391104150803, -122.457941385434) | 9 | 7 | 4 | 59 | 40 | ||
| 190488 | 65550 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 292 Juanita Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1990 12:00:00 AM | Permit Number 28449 | 5995404.07668865 | 2097513.82279858 | 37.7391097231572 | -122.458437696075 | (37.7391097231572, -122.458437696075) | 9 | 7 | 4 | 59 | 40 | ||
| 127142 | 65482 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 519 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/15/1989 12:00:00 AM | Permit Number 28366 | 5994743.29707293 | 2091977.51972285 | 37.7238703903851 | -122.460321333166 | (37.7238703903851, -122.460321333166) | 9 | 8 | 4 | 28861 | 24 | ||
| 130907 | 65395 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1199 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/17/1990 12:00:00 AM | Permit Number 28618 | 6006415.64200439 | 2102619.79399643 | 37.7537562275815 | -122.420727018296 | (37.7537562275815, -122.420727018296) | 2 | 4 | 7 | 28859 | 19 | ||
| 175420 | 64980 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 50 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/24/1989 12:00:00 AM | Permit Number 26018 | 6005559.62367556 | 2099364.11059581 | 37.744768585112 | -122.423455890647 | (37.744768585112, -122.423455890647) | 2 | 7 | 5 | 28859 | 22 | ||
| 29973 | 64888 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 2418 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/1989 12:00:00 AM | Permit Number 25914 | 5989547.06003251 | 2098884.34921412 | 37.7425345003811 | -122.478788583135 | (37.7425345003811, -122.478788583135) | 1 | 8 | 3 | 29491 | 35 | ||
| 104015 | 64118 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 402 30th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | Permit Number 24889 | 6003939.69845123 | 2098396.37778582 | 37.7420198489818 | -122.428988299782 | (37.7420198489818, -122.428988299782) | 2 | 7 | 5 | 63 | 22 | ||
| 153526 | 63705 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1679 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1987 12:00:00 AM | Permit Number 24365 | 5994000.03328261 | 2104083.32941502 | 37.757067134665 | -122.463768902449 | (37.757067134665, -122.463768902449) | 1 | 5 | 4 | 56 | 12 | ||
| 173405 | 63699 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1536 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/09/1987 12:00:00 AM | Permit Number 24357 | 5993400.20760956 | 2105023.79114259 | 37.7596148153145 | -122.465911644507 | (37.7596148153145, -122.465911644507) | 1 | 8 | 4 | 56 | 12 | ||
| 102135 | 63496 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1665 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/03/1993 12:00:00 AM | Permit Number 31923 | 5993996.85139129 | 2104175.81914419 | 37.7573209042452 | -122.463786619524 | (37.7573209042452, -122.463786619524) | 1 | 5 | 4 | 56 | 12 | ||
| 47929 | 63452 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 425 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/20/1991 12:00:00 AM | Permit Number 30038 | 6006658.37862364 | 2096248.30501412 | 37.7362752333103 | -122.419435593969 | (37.7362752333103, -122.419435593969) | 2 | 7 | 7 | 28859 | 2 | ||
| 30003 | 63363 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 339 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/20/1991 12:00:00 AM | Permit Number 30042 | 6006824.56139145 | 2096444.26906016 | 37.736822665934 | -122.418874924172 | (37.736822665934, -122.418874924172) | 2 | 7 | 7 | 28859 | 2 | ||
| 53053 | 63362 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 401 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/20/1991 12:00:00 AM | Permit Number 30039 | 6006709.37395927 | 2096284.55563078 | 37.7363776416136 | -122.419261852343 | (37.7363776416136, -122.419261852343) | 2 | 7 | 7 | 28859 | 2 | ||
| 101740 | 63361 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 431 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/20/1991 12:00:00 AM | Permit Number 30041 | 6006645.62978775 | 2096239.24235854 | 37.7362496311902 | -122.419479029307 | (37.7362496311902, -122.419479029307) | 2 | 7 | 7 | 28859 | 2 | ||
| 105866 | 63269 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 39 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1987 12:00:00 AM | Permit Number 23826 | 6006964.49512199 | 2099515.87189553 | 37.7452644809694 | -122.418608862279 | (37.7452644809694, -122.418608862279) | 2 | 7 | 7 | 28859 | 2 | ||
| 183690 | 63265 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1760 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/13/1987 12:00:00 AM | 25 | Permit Number 24158 | 6001156.49330664 | 2111800.30825294 | 37.7786658324282 | -122.439572390689 | (37.7786658324282, -122.439572390689) | 15 | 5 | 11 | 29490 | 41 | |
| 68180 | 63202 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 7 Shore View Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1986 12:00:00 AM | Permit Number 23744 | 5984650.0940692 | 2112837.90974399 | 37.7805615078558 | -122.496750144554 | (37.7805615078558, -122.496750144554) | 11 | 6 | 2 | 55 | 26 | ||
| 130215 | 63183 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1335 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1986 12:00:00 AM | Permit Number 23722 | 6002224.85030351 | 2113085.27883033 | 37.7822547845521 | -122.435968505977 | (37.7822547845521, -122.435968505977) | 15 | 5 | 11 | 29490 | 41 | ||
| 156878 | 63136 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 75 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/11/1986 12:00:00 AM | Permit Number 23653 | 6007261.8048924 | 2099033.40342516 | 37.7439564645667 | -122.417546624418 | (37.7439564645667, -122.417546624418) | 2 | 7 | 7 | 28859 | 2 | ||
| 182225 | 63123 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 44 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/09/1986 12:00:00 AM | Permit Number 23636 | 6007712.34207152 | 2099218.71581656 | 37.7444906318459 | -122.416001886054 | (37.7444906318459, -122.416001886054) | 2 | 7 | 7 | 28859 | 2 | ||
| 121358 | 63112 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 9 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1986 12:00:00 AM | Permit Number 23616 | 6007066.07091245 | 2099699.59516801 | 37.7457746619282 | -122.418270653095 | (37.7457746619282, -122.418270653095) | 2 | 7 | 7 | 28859 | 2 | ||
| 139377 | 63106 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 67 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1986 12:00:00 AM | Permit Number 23602 | 6006857.2853572 | 2099318.42969221 | 37.744716312649 | -122.418965575221 | (37.744716312649, -122.418965575221) | 2 | 7 | 7 | 28859 | 2 | ||
| 128038 | 63102 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 151 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/1996 12:00:00 AM | Permit Number 37593 | 6006585.95318508 | 2098816.77496864 | 37.74332359922 | -122.41986820091 | (37.74332359922, -122.41986820091) | 2 | 7 | 7 | 28859 | 2 | ||
| 43117 | 62644 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1255 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/2008 12:00:00 AM | 1 | 3x3 | Permit Number 50627 | 5983022.3246657 | 2106594.48040873 | 37.7633233458854 | -122.501919183937 | (37.7633233458854, -122.501919183937) | 1 | 8 | 3 | 56 | 35 | |
| 106918 | 62431 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 4402 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1985 12:00:00 AM | Permit Number 22591 | 5999916.26807627 | 2105779.65094566 | 37.76206395953 | -122.443430215898 | (37.76206395953, -122.443430215898) | 15 | 5 | 5 | 28862 | 3 | ||
| 52378 | 62309 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 197 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/11/1985 12:00:00 AM | Permit Number 22447 | 5996603.44612338 | 2111537.89783115 | 37.7776851364685 | -122.45530408152 | (37.7776851364685, -122.45530408152) | 11 | 6 | 2 | 54 | 16 | ||
| 4982 | 62308 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 930@ Lorraine Ct Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/11/1985 12:00:00 AM | Permit Number 22446 | 5996162.7133263 | 2112267.41531283 | 37.77966290152 | -122.456881494589 | (37.77966290152, -122.456881494589) | 11 | 6 | 2 | 54 | 16 |
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) );