trees
39 rows where qSpecies_id = 104
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 432 | 196351 | DPW Maintained 1 | Prunus lyonii :: Catalina Cherry 104 | 1900 19th St | 20 | Front Yard : Yard | Tree | Private 2 | 3 | 6011965.48 | 2105145.22305 | 37.7610017347515 | -122.401711799169 | (37.7610017347515, -122.401711799169) | 10 | 3 | 8 | 28856 | 29 | ||||
| 3195 | 261803 | DPW Maintained 1 | Prunus lyonii :: Catalina Cherry 104 | 2325 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2020 12:00:00 AM | 3 | 5x5 | 5986357 | 2099421 | 37.7438222517885 | -122.489858179287 | (37.7438222517885, -122.489858179287) | 1 | 8 | 3 | 29491 | 35 | ||
| 8483 | 196349 | DPW Maintained 1 | Prunus lyonii :: Catalina Cherry 104 | 1900 19th St | 18 | Front Yard : Yard | Tree | Private 2 | 6 | 6011979.46515 | 2105146.30626 | 37.7610054894192 | -122.401663506475 | (37.7610054894192, -122.401663506475) | 10 | 3 | 8 | 28856 | 29 | ||||
| 9555 | 196350 | DPW Maintained 1 | Prunus lyonii :: Catalina Cherry 104 | 1900 19th St | 19 | Front Yard : Yard | Tree | Private 2 | 27 | 6011973.31239 | 2105136.40204 | 37.7609779512911 | -122.401684090158 | (37.7609779512911, -122.401684090158) | 10 | 3 | 8 | 28856 | 29 | ||||
| 14015 | 67670 | DPW Maintained 1 | Prunus lyonii :: Catalina Cherry 104 | 1783 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1992 12:00:00 AM | 7 | Permit Number 31272 | 6014117.15242 | 2095094.36461 | 37.7335240360099 | -122.393566589946 | (37.7335240360099, -122.393566589946) | 10 | 3 | 8 | 58 | 1 | |
| 14676 | 135882 | DPW Maintained 1 | Prunus lyonii :: Catalina Cherry 104 | 2431 Jones St | 23 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 3ft | 6007964.86831 | 2120685.23293 | 37.8034467945858 | -122.416649103072 | (37.8034467945858, -122.416649103072) | 5 | 1 | 1 | 308 | 32 | |||
| 22813 | 196355 | DPW Maintained 1 | Prunus lyonii :: Catalina Cherry 104 | 1900 19th St | 24 | Front Yard : Yard | Tree | Private 2 | 1 | 6011948.05543 | 2105132.58444 | 37.7609660595651 | -122.401771175125 | (37.7609660595651, -122.401771175125) | 10 | 3 | 8 | 28856 | 29 | ||||
| 26018 | 83218 | Permitted Site 7 | Prunus lyonii :: Catalina Cherry 104 | 3124 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52347 | 6004253.45017179 | 2119849.79530606 | 37.8009434640556 | -122.429433004812 | (37.8009434640556, -122.429433004812) | 13 | 9 | 1 | 57 | 17 | ||
| 27634 | 102010 | DPW Maintained 1 | Prunus lyonii :: Catalina Cherry 104 | 1490United Sta Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/13/2012 12:00:00 AM | 4 | 3x3 | Permit Number 768407 | 6007074.44657 | 2117422.83586 | 37.7944389538357 | -122.419498858593 | (37.7944389538357, -122.419498858593) | 5 | 1 | 10 | 28858 | 32 | |
| 30602 | 135881 | DPW Maintained 1 | Prunus lyonii :: Catalina Cherry 104 | 2431 Jones St | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 3ft | 6007959.30516 | 2120736.41676 | 37.8035870195982 | -122.416671982741 | (37.8035870195982, -122.416671982741) | 5 | 1 | 1 | 308 | 32 | |||
| 45029 | 196354 | DPW Maintained 1 | Prunus lyonii :: Catalina Cherry 104 | 1900 19th St | 23 | Front Yard : Yard | Tree | Private 2 | 7 | 6011952.75605 | 2105133.25565 | 37.7609681648778 | -122.40175496482 | (37.7609681648778, -122.40175496482) | 10 | 3 | 8 | 28856 | 29 | ||||
| 46218 | 249707 | DPW Maintained 1 | Prunus lyonii :: Catalina Cherry 104 | 2400 Baker St | 39 | Front Yard : Yard | Tree | Private 2 | 8 | 5999697.96101 | 2117191.03981 | 37.7933842586262 | -122.445005634599 | (37.7933842586262, -122.445005634599) | 13 | 9 | 1 | 57 | 27 | ||||
| 46983 | 101712 | DPW Maintained 1 | Prunus lyonii :: Catalina Cherry 104 | 3337 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 5998802.75246 | 2115574.21948 | 37.7888937646896 | -122.447986645277 | (37.7888937646896, -122.447986645277) | 13 | 6 | 1 | 54 | 31 | |||
| 51954 | 196353 | DPW Maintained 1 | Prunus lyonii :: Catalina Cherry 104 | 1900 19th St | 22 | Front Yard : Yard | Tree | Private 2 | 5 | 6011962.81412 | 2105133.05123 | 37.7609681648715 | -122.401720163776 | (37.7609681648715, -122.401720163776) | 10 | 3 | 8 | 28856 | 29 | ||||
| 52885 | 135878 | DPW Maintained 1 | Prunus lyonii :: Catalina Cherry 104 | 3351 Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5998783.48361 | 2115572.1389 | 37.7888869505171 | -122.448053162718 | (37.7888869505171, -122.448053162718) | 13 | 6 | 1 | 54 | 31 | |||
| 62662 | 37728 | Permitted Site 7 | Prunus lyonii :: Catalina Cherry 104 | 1228 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/20/2011 12:00:00 AM | 3 | 3x3 | Permit Number 768579 | 6009213.61732255 | 2101997.11746506 | 37.7522037988138 | -122.411006967934 | (37.7522037988138, -122.411006967934) | 2 | 4 | 7 | 28859 | 19 |
| 64616 | 26725 | DPW Maintained 1 | Prunus lyonii :: Catalina Cherry 104 | 745X Lake St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 5993091.94598 | 2114811.31602 | 37.7864709501158 | -122.467689579336 | (37.7864709501158, -122.467689579336) | 11 | 6 | 2 | 54 | 11 | |||
| 74622 | 135880 | DPW Maintained 1 | Prunus lyonii :: Catalina Cherry 104 | 3573 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5997686.8627 | 2115746.51973 | 37.7893030065791 | -122.451859886822 | (37.7893030065791, -122.451859886822) | 11 | 6 | 1 | 54 | 31 | |||
| 77421 | 82350 | Permitted Site 7 | Prunus lyonii :: Catalina Cherry 104 | 315 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50646 | 6004264.94687094 | 2091428.0663806 | 37.7229048353865 | -122.427367408132 | (37.7229048353865, -122.427367408132) | 9 | 7 | 6 | 28861 | 5 | |
| 92433 | 135883 | DPW Maintained 1 | Prunus lyonii :: Catalina Cherry 104 | 2431 Jones St | 25 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6007965.36294 | 2120676.16554 | 37.8034219256369 | -122.416646748657 | (37.8034219256369, -122.416646748657) | 5 | 1 | 1 | 308 | 32 | |||
| 94632 | 81880 | Permitted Site 7 | Prunus lyonii :: Catalina Cherry 104 | 315 Athens St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50646 | 6004264.94687094 | 2091428.0663806 | 37.7229048353865 | -122.427367408132 | (37.7229048353865, -122.427367408132) | 9 | 7 | 6 | 28861 | 5 | |
| 95001 | 214373 | DPW Maintained 1 | Prunus lyonii :: Catalina Cherry 104 | 1550 15th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | 5991561.65041 | 2104917.18173 | 37.7592158610322 | -122.472262461655 | (37.7592158610322, -122.472262461655) | 1 | 8 | 4 | 56 | 12 | ||||
| 95715 | 196352 | DPW Maintained 1 | Prunus lyonii :: Catalina Cherry 104 | 1900 19th St | 21 | Front Yard : Yard | Tree | Private 2 | 1 | 6011956.0756 | 2105144.27438 | 37.7609986051092 | -122.401744258403 | (37.7609986051092, -122.401744258403) | 10 | 3 | 8 | 28856 | 29 | ||||
| 96859 | 5669 | DPW Maintained 1 | Prunus lyonii :: Catalina Cherry 104 | 1411 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6005264.89314 | 2100092.7159 | 37.7467525291076 | -122.424526830547 | (37.7467525291076, -122.424526830547) | 2 | 7 | 5 | 28859 | 22 | |||
| 117084 | 196357 | DPW Maintained 1 | Prunus lyonii :: Catalina Cherry 104 | 1900 19th St | 27 | Front Yard : Yard | Tree | Private 2 | 15 | 6011913.72494 | 2105132.82627 | 37.7609648076872 | -122.401889926984 | (37.7609648076872, -122.401889926984) | 10 | 3 | 8 | 28856 | 29 | ||||
| 121004 | 237964 | DPW Maintained 1 | Prunus lyonii :: Catalina Cherry 104 | 1459 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6009329.47807 | 2100729.50187 | 37.748729704821 | -122.410516798727 | (37.748729704821, -122.410516798727) | 2 | 4 | 7 | 28859 | 19 | |||
| 121188 | 237963 | DPW Maintained 1 | Prunus lyonii :: Catalina Cherry 104 | 1000 San Jose Ave | 106 | Front Yard : Yard | Tree | Private 2 | 4 | 6005052.98208 | 2096959.68056 | 37.7381379574049 | -122.425036718268 | (37.7381379574049, -122.425036718268) | 2 | 7 | 5 | 63 | 7 | ||||
| 133380 | 102094 | DPW Maintained 1 | Prunus lyonii :: Catalina Cherry 104 | 646 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/19/2012 12:00:00 AM | 1 | 3x3 | Permit Number 768455 | 5993542.90087 | 2111432.94304 | 37.7772208817879 | -122.465883837162 | (37.7772208817879, -122.465883837162) | 11 | 6 | 2 | 54 | 11 | |
| 133894 | 196356 | DPW Maintained 1 | Prunus lyonii :: Catalina Cherry 104 | 1900 19th St | 25 | Front Yard : Yard | Tree | Private 2 | 7 | 6011943.68488 | 2105131.53346 | 37.7609629299059 | -122.40178621716 | (37.7609629299059, -122.40178621716) | 10 | 3 | 8 | 28856 | 29 | ||||
| 143208 | 196347 | DPW Maintained 1 | Prunus lyonii :: Catalina Cherry 104 | 1900 19th St | 16 | Front Yard : Yard | Tree | Private 2 | 3 | 6011990.16114 | 2105143.23972 | 37.7609976662368 | -122.401626297942 | (37.7609976662368, -122.401626297942) | 10 | 3 | 8 | 28856 | 29 | ||||
| 149597 | 214375 | DPW Maintained 1 | Prunus lyonii :: Catalina Cherry 104 | 40 Mangels Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001152.10793 | 2095216.80224 | 37.7331312930803 | -122.438399132132 | (37.7331312930803, -122.438399132132) | 9 | 7 | 5 | 63 | 40 | |||
| 162987 | 196348 | DPW Maintained 1 | Prunus lyonii :: Catalina Cherry 104 | 1900 19th St | 17 | Front Yard : Yard | Tree | Private 2 | 9 | 6011983.22981 | 2105140.07548 | 37.7609885911574 | -122.401650048127 | (37.7609885911574, -122.401650048127) | 10 | 3 | 8 | 28856 | 29 | ||||
| 169042 | 135879 | DPW Maintained 1 | Prunus lyonii :: Catalina Cherry 104 | 3351 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 5998772.77052 | 2115570.58932 | 37.7888820833799 | -122.448090116767 | (37.7888820833799, -122.448090116767) | 13 | 6 | 1 | 54 | 31 | |||
| 176577 | 214374 | DPW Maintained 1 | Prunus lyonii :: Catalina Cherry 104 | 1670 08th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 5993737.50266 | 2104155.61578 | 37.7572504826396 | -122.464682075226 | (37.7572504826396, -122.464682075226) | 1 | 8 | 4 | 56 | 12 | |||
| 177733 | 237965 | DPW Maintained 1 | Prunus lyonii :: Catalina Cherry 104 | 447 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6000681.71243 | 2101388.64307 | 37.7500509420016 | -122.440467906489 | (37.7500509420016, -122.440467906489) | 2 | 4 | 5 | 28862 | 22 | |||
| 181236 | 82613 | Permitted Site 7 | Prunus lyonii :: Catalina Cherry 104 | 2655 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | 3x3 | Permit Number 52234 | 6008939.6637933 | 2103006.46843661 | 37.7549598834989 | -122.412025669238 | (37.7549598834989, -122.412025669238) | 2 | 4 | 7 | 28859 | 19 | ||
| 186538 | 214372 | DPW Maintained 1 | Prunus lyonii :: Catalina Cherry 104 | 1500 16th Ave | 3 | Side Yard : Yard | Tree | Private 2 | 7 | 5991179.13729 | 2105098.71656 | 37.759692162681 | -122.473598605112 | (37.759692162681, -122.473598605112) | 1 | 8 | 4 | 56 | 12 | ||||
| 186781 | 82361 | Permitted Site 7 | Prunus lyonii :: Catalina Cherry 104 | 1163 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/20/2011 12:00:00 AM | 4 | 3x3 | Permit Number 768585 | 6007677.84129717 | 2102891.68819405 | 37.7545738460199 | -122.416381291371 | (37.7545738460199, -122.416381291371) | 2 | 4 | 7 | 28859 | 19 |
| 188662 | 249703 | DPW Maintained 1 | Prunus lyonii :: Catalina Cherry 104 | 2400 Baker St | 35 | Front Yard : Yard | Tree | Private 2 | 4 | 5999691.63747 | 2117215.06978 | 37.793449877667 | -122.445029242728 | (37.793449877667, -122.445029242728) | 13 | 9 | 1 | 57 | 27 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );