trees
26 rows where Zip Codes = 54 and qSpecies_id = 148 sorted by PermitNotes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16561 | 3199 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3700X California St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/31/2017 11:41:00 AM | 3 | 3X3 | 5996731.2206933 | 2114663.0950297 | 37.7862734316129 | -122.455087955232 | (37.7862734316129, -122.455087955232) | 11 | 6 | 1 | 54 | 31 | ||
16919 | 27303 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 4339 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 45 | 3X3 | 5994091.63002 | 2114139.77761 | 37.7846847585801 | -122.464182179248 | (37.7846847585801, -122.464182179248) | 11 | 6 | 2 | 54 | 11 | |||
18997 | 146023 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 211 Cornwall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5x5 | 5994760.92974 | 2114191.03867 | 37.7848640608675 | -122.46187036015 | (37.7848640608675, -122.46187036015) | 11 | 6 | 2 | 54 | 11 | |||
21126 | 27305 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 4405 California St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 5993893.05463 | 2114093.73932 | 37.7845469027899 | -122.464865833974 | (37.7845469027899, -122.464865833974) | 11 | 6 | 2 | 54 | 11 | |||
27210 | 111374 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 222 Stanyan St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996693 | 2111182 | 37.7767130721687 | -122.454968563419 | (37.7767130721687, -122.454968563419) | 15 | 6 | 2 | 54 | 16 | ||||
41853 | 111371 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 222 Stanyan St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996693 | 2111182 | 37.7767130721687 | -122.454968563419 | (37.7767130721687, -122.454968563419) | 15 | 6 | 2 | 54 | 16 | ||||
43845 | 3131 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3200 California St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/22/1999 12:00:00 AM | 3 | 3X3 | 5998952.52581 | 2114994.22768 | 37.7873098198001 | -122.447426688631 | (37.7873098198001, -122.447426688631) | 13 | 6 | 1 | 54 | 31 | ||
46380 | 111372 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 222 Stanyan St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996693 | 2111182 | 37.7767130721687 | -122.454968563419 | (37.7767130721687, -122.454968563419) | 15 | 6 | 2 | 54 | 16 | ||||
55898 | 111376 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 222 Stanyan St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996693 | 2111182 | 37.7767130721687 | -122.454968563419 | (37.7767130721687, -122.454968563419) | 15 | 6 | 2 | 54 | 16 | ||||
59981 | 27302 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 4327 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 45 | 3X3 | 5994140.41077 | 2114141.59782 | 37.7846925678068 | -122.464013547575 | (37.7846925678068, -122.464013547575) | 11 | 6 | 2 | 54 | 11 | |||
98837 | 111373 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 222 Stanyan St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996693 | 2111182 | 37.7767130721687 | -122.454968563419 | (37.7767130721687, -122.454968563419) | 15 | 6 | 2 | 54 | 16 | ||||
114312 | 111377 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 222 Stanyan St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996693 | 2111182 | 37.7767130721687 | -122.454968563419 | (37.7767130721687, -122.454968563419) | 15 | 6 | 2 | 54 | 16 | ||||
120706 | 111370 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 222 Stanyan St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996693 | 2111182 | 37.7767130721687 | -122.454968563419 | (37.7767130721687, -122.454968563419) | 15 | 6 | 2 | 54 | 16 | ||||
123351 | 3220 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3838 California St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2012 12:00:00 AM | 2 | 3x3 | 5995990.5445804 | 2114559.6929387 | 37.7859469971234 | -122.457643002187 | (37.7859469971234, -122.457643002187) | 11 | 6 | 1 | 54 | 31 | ||
134491 | 27307 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 4431 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 45 | 3X3 | 5993817.95209 | 2114090.93355 | 37.7845348684789 | -122.465125457344 | (37.7845348684789, -122.465125457344) | 11 | 6 | 2 | 54 | 11 | |||
150783 | 3258 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 4134 California St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/20/2000 12:00:00 AM | 8 | 3X3 | 5994723.99031 | 2114406.57793 | 37.7854537467716 | -122.46201379337 | (37.7854537467716, -122.46201379337) | 11 | 6 | 1 | 54 | 11 | ||
156969 | 27499 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3478X California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 5997784.225 | 2114880.84142 | 37.786931659649 | -122.451460562094 | (37.786931659649, -122.451460562094) | 11 | 6 | 1 | 54 | 31 | |||
168625 | 27306 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 4419 California St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 5993893.05463 | 2114093.73932 | 37.7845469027899 | -122.464865833974 | (37.7845469027899, -122.464865833974) | 11 | 6 | 2 | 54 | 11 | |||
178366 | 3212 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3800X California St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/1994 12:00:00 AM | 25 | 3X3 | 5996156.57307 | 2114605.43515 | 37.7860821290085 | -122.457071902611 | (37.7860821290085, -122.457071902611) | 11 | 6 | 1 | 54 | 31 | ||
179179 | 27304 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 4355 California St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 65 | 3X3 | 5994036.54811 | 2114137.7225 | 37.7846759409315 | -122.464372593569 | (37.7846759409315, -122.464372593569) | 11 | 6 | 2 | 54 | 11 | |||
186043 | 111375 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 222 Stanyan St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996693 | 2111182 | 37.7767130721687 | -122.454968563419 | (37.7767130721687, -122.454968563419) | 15 | 6 | 2 | 54 | 16 | ||||
191922 | 3201 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3700X California St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/2005 12:00:00 AM | 3 | 3X3 | 5996548.27505 | 2114783.92692 | 37.786594706495 | -122.455729633586 | (37.786594706495, -122.455729633586) | 11 | 6 | 1 | 54 | 31 | ||
39100 | 92566 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 222 Stanyan St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 52905 | 5996693 | 2111182 | 37.7767130721687 | -122.454968563419 | (37.7767130721687, -122.454968563419) | 15 | 6 | 2 | 54 | 16 | |||
109025 | 105854 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3440 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/05/2014 12:00:00 AM | 3x3 | Permit Number 771130 | 5998402.1 | 2115236.7 | 37.7879441154945 | -122.449348514051 | (37.7879441154945, -122.449348514051) | 13 | 6 | 1 | 54 | 31 | ||
82500 | 112842 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 604 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/24/2015 12:00:00 AM | Permit Number 773221 | 5992274.9 | 2111288.5 | 37.7767510524606 | -122.470259695975 | (37.7767510524606, -122.470259695975) | 11 | 6 | 2 | 54 | 11 | |||
159637 | 123676 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 4620 California St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 782655 | 5993209.68387 | 2114188.73207 | 37.7847683024995 | -122.467236954218 | (37.7847683024995, -122.467236954218) | 11 | 6 | 2 | 54 | 11 |
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) );