trees
26 rows where qSpecies_id = 296
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6094 | 212854 | DPW Maintained 1 | Prunus armeniaca :: Apricot 296 | 383 Joost Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 5999561.12695 | 2094940.87947 | 37.7322830498256 | -122.443879743667 | (37.7322830498256, -122.443879743667) | 9 | 7 | 4 | 63 | 40 | |||
| 15559 | 178691 | DPW Maintained 1 | Prunus armeniaca :: Apricot 296 | 549 Cordova St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 8ft | 6002129.66344 | 2086422.57937 | 37.709039879958 | -122.434390930201 | (37.709039879958, -122.434390930201) | 9 | 7 | 6 | 28861 | 5 | |||
| 17240 | 202089 | DPW Maintained 1 | Prunus armeniaca :: Apricot 296 | 1 Gould St | 17 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6012847.10312 | 2091145.29083 | 37.7226100354079 | -122.397680651962 | (37.7226100354079, -122.397680651962) | 10 | 3 | 8 | 58 | 1 | ||||
| 39825 | 196058 | DPW Maintained 1 | Prunus armeniaca :: Apricot 296 | 2301 19th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 6010884.66338 | 2105058.48135 | 37.7607031886221 | -122.405443783305 | (37.7607031886221, -122.405443783305) | 10 | 3 | 8 | 28856 | 29 | ||||
| 56004 | 212857 | DPW Maintained 1 | Prunus armeniaca :: Apricot 296 | 326 Detroit St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 7ft | 5999454.72629 | 2094321.91638 | 37.7305774522885 | -122.444203131795 | (37.7305774522885, -122.444203131795) | 9 | 7 | 4 | 63 | 40 | |||
| 59242 | 135671 | DPW Maintained 1 | Prunus armeniaca :: Apricot 296 | 701 Buchanan St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 6ft | 6004478.12377 | 2110899.33168 | 37.7763804610255 | -122.428017362009 | (37.7763804610255, -122.428017362009) | 7 | 9 | 11 | 28852 | 10 | |||
| 73838 | 212853 | DPW Maintained 1 | Prunus armeniaca :: Apricot 296 | 162 Mangels Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 6000336.93073 | 2095252.91733 | 37.7331840553884 | -122.441220000514 | (37.7331840553884, -122.441220000514) | 9 | 7 | 5 | 63 | 40 | |||
| 79574 | 117870 | DPW Maintained 1 | Prunus armeniaca :: Apricot 296 | 850 40th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 5983580.45743 | 2110020.85288 | 37.7727639566416 | -122.500242142011 | (37.7727639566416, -122.500242142011) | 11 | 6 | 2 | 55 | 26 | |||
| 80279 | 212858 | DPW Maintained 1 | Prunus armeniaca :: Apricot 296 | 326 Detroit St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 7ft | 5999452.2625 | 2094329.12509 | 37.73059710516 | -122.444212167269 | (37.73059710516, -122.444212167269) | 9 | 7 | 4 | 63 | 40 | |||
| 82473 | 142050 | DPW Maintained 1 | Prunus armeniaca :: Apricot 296 | 32 ATALAYA TER | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5998847.8737 | 2110957.7576 | 37.776220741334 | -122.447498103076 | (37.776220741334, -122.447498103076) | 15 | 6 | 2 | 29492 | 16 | |||
| 96787 | 196057 | DPW Maintained 1 | Prunus armeniaca :: Apricot 296 | 578 San Bruno Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 4ft | 6010921.38174 | 2105592.13415 | 37.7621705323591 | -122.40535437273 | (37.7621705323591, -122.40535437273) | 8 | 3 | 8 | 28856 | 29 | |||
| 101697 | 255715 | Undocumented 4 | Prunus armeniaca :: Apricot 296 | 937x Meade Ave | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6012763 | 2089349 | 37.7176730984513 | -122.397845439416 | (37.7176730984513, -122.397845439416) | 10 | 3 | 8 | 58 | 1 | ||||
| 102178 | 212856 | DPW Maintained 1 | Prunus armeniaca :: Apricot 296 | 326 Detroit St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 7ft | 5999450.88098 | 2094315.05558 | 37.7305583947567 | -122.444215932735 | (37.7305583947567, -122.444215932735) | 9 | 7 | 4 | 63 | 40 | |||
| 105349 | 114158 | Significant Tree 6 | Prunus armeniaca :: Apricot 296 | 1200X JUNIPERO SERRA BLVD | 6 | Front Yard : Yard | Tree | Private 2 | 01/20/2017 12:00:00 AM | 3 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | |||
| 148599 | 138956 | DPW Maintained 1 | Prunus armeniaca :: Apricot 296 | 723 Buchanan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6004478.9225 | 2110904.2582 | 37.776394033229 | -122.428014950126 | (37.776394033229, -122.428014950126) | 7 | 9 | 11 | 28852 | 10 | |||
| 150484 | 196060 | DPW Maintained 1 | Prunus armeniaca :: Apricot 296 | 955 Kansas St | 1 | Front Yard : Yard | Tree | Private 2 | 4 | 6011632.64941 | 2103950.51096 | 37.757702741818 | -122.402778897843 | (37.757702741818, -122.402778897843) | 10 | 3 | 8 | 28856 | 29 | ||||
| 153656 | 212855 | DPW Maintained 1 | Prunus armeniaca :: Apricot 296 | 326 Detroit St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 7ft | 5999451.80031 | 2094287.65002 | 37.7304831979422 | -122.4442107859 | (37.7304831979422, -122.4442107859) | 9 | 7 | 4 | 63 | 40 | |||
| 154830 | 196061 | DPW Maintained 1 | Prunus armeniaca :: Apricot 296 | 2330 Lane St | 4 | Front Yard : Yard | Tree | Private 2 | 3 | 6013950.20438 | 2092923.64002 | 37.7275543902 | -122.393991875717 | (37.7275543902, -122.393991875717) | 10 | 3 | 8 | 58 | 1 | ||||
| 155102 | 178692 | DPW Maintained 1 | Prunus armeniaca :: Apricot 296 | 549 Cordova St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 8ft | 6002131.76754 | 2086425.47642 | 37.7090479540599 | -122.434383865118 | (37.7090479540599, -122.434383865118) | 9 | 7 | 6 | 28861 | 5 | |||
| 162423 | 178693 | DPW Maintained 1 | Prunus armeniaca :: Apricot 296 | 549 Cordova St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 8ft | 6002128.86761 | 2086428.02428 | 37.7090547853188 | -122.434394069733 | (37.7090547853188, -122.434394069733) | 9 | 7 | 6 | 28861 | 5 | |||
| 164583 | 234915 | DPW Maintained 1 | Prunus armeniaca :: Apricot 296 | 127 Farnum St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 3ft | 6002448.02484 | 2097346.2472 | 37.7390518862338 | -122.434070974792 | (37.7390518862338, -122.434070974792) | 2 | 7 | 5 | 63 | 7 | |||
| 164818 | 234913 | DPW Maintained 1 | Prunus armeniaca :: Apricot 296 | 277 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006752.15418 | 2102195.66936 | 37.7526106391832 | -122.419533192001 | (37.7526106391832, -122.419533192001) | 2 | 4 | 7 | 28859 | 19 | |||
| 167812 | 117742 | DPW Maintained 1 | Prunus armeniaca :: Apricot 296 | 475 39th Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5983747.94106 | 2112662.50958 | 37.7800270099537 | -122.499858102338 | (37.7800270099537, -122.499858102338) | 11 | 6 | 2 | 55 | 26 | |||
| 170502 | 196059 | DPW Maintained 1 | Prunus armeniaca :: Apricot 296 | 582 Rhode Island St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6011759.57915 | 2105642.68997 | 37.7623561758285 | -122.402458905576 | (37.7623561758285, -122.402458905576) | 8 | 3 | 8 | 28856 | 29 | ||||
| 182726 | 212852 | DPW Maintained 1 | Prunus armeniaca :: Apricot 296 | 613 Detroit St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 5999415.15878 | 2095029.40033 | 37.732517780054 | -122.444390746543 | (37.732517780054, -122.444390746543) | 9 | 7 | 4 | 59 | 40 | |||
| 183401 | 234914 | DPW Maintained 1 | Prunus armeniaca :: Apricot 296 | 2 Vicksburg St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6004059.29219 | 2103001.00468 | 37.7546698528419 | -122.428902987393 | (37.7546698528419, -122.428902987393) | 2 | 4 | 5 | 28862 | 22 |
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) );