trees

26 rows where Zip Codes = 54 and qSpecies_id = 148

✎ View and edit SQL

This data as json, CSV (advanced)

These facets timed out: Zip Codes

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
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
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
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
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
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
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
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
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

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);