trees

24 rows where Zip Codes = 63 and qSpecies_id = 53

✎ View and edit SQL

This data as json, CSV (advanced)

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)
28234 109001 Undocumented 4 Ficus nitida :: Laurel Fig 53 525x BURNETT AVE 2 Sidewalk: Curb side : Cutout Tree Private 2       1x1   5999530 2102478 37.7529764040195 -122.444528861079 (37.7529764040195, -122.444528861079) 2 5 5 63 38
38445 4501 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1748 Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 4x4   6004612.9512322 2098708.9638206 37.74291622476 -122.4266826598 (37.74291622476, -122.4266826598) 2 7 5 63 22
57759 4493 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1616 Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6004570.9658455 2099475.4807252 37.7450185306318 -122.426882412261 (37.7450185306318, -122.426882412261) 2 7 5 63 22
61784 59066 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1658 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/16/1980 12:00:00 AM     Permit Number 18361 6003975.177671 2098610.37486855 37.7426094440159 -122.428880876877 (37.7426094440159, -122.428880876877) 2 7 5 63 22
65899 109000 Undocumented 4 Ficus nitida :: Laurel Fig 53 525x BURNETT AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     6 2x2 circle   5999530 2102478 37.7529764040195 -122.444528861079 (37.7529764040195, -122.444528861079) 2 5 5 63 38
82935 39773 Permitted Site 7 Ficus nitida :: Laurel Fig 53 112 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/29/2001 12:00:00 AM 14 6x6 Permit Number 41140 6005154.17276637 2099634.09116827 37.7454869972987 -122.424877067697 (37.7454869972987, -122.424877067697) 2 7 5 63 22
115017 4281 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 4270 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree DPW 1     3 2X2   6002137.7495821 2100347.8176818 37.7472758823749 -122.435358414005 (37.7472758823749, -122.435358414005) 2 4 5 63 22
116920 39774 Permitted Site 7 Ficus nitida :: Laurel Fig 53 112 28th St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/19/1999 12:00:00 AM 14 5.5x6 Permit Number 41140 6005154.17276637 2099634.09116827 37.7454869972987 -122.424877067697 (37.7454869972987, -122.424877067697) 2 7 5 63 22
122006 4883 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 87 Crags Ct 1 Sidewalk: Curb side : Cutout Tree DPW 1     45 2X2   6000657.5251593 2098217.505729 37.7413423773337 -122.440324154875 (37.7413423773337, -122.440324154875) 2 7 5 63 7
129658 5136 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2842 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 1x1   6002395.52907 2095496.33738 37.7339694804636 -122.434120273378 (37.7339694804636, -122.434120273378) 2 7 5 63 7
130690 109005 Undocumented 4 Ficus nitida :: Laurel Fig 53 525x BURNETT AVE 6 Sidewalk: Curb side : Cutout Tree Private 2       1x1   5999530 2102478 37.7529764040195 -122.444528861079 (37.7529764040195, -122.444528861079) 2 5 5 63 38
140034 95413 Undocumented 4 Ficus nitida :: Laurel Fig 53 691 Chenery St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/19/2016 12:00:00 AM 12 3x3 Permit Number 779045 6002523 2095666 37.7344425689427 -122.433691689524 (37.7344425689427, -122.433691689524) 2 7 5 63 7
140999 109004 Undocumented 4 Ficus nitida :: Laurel Fig 53 525x BURNETT AVE 5 Sidewalk: Curb side : Cutout Tree Private 2       1x1   5999530 2102478 37.7529764040195 -122.444528861079 (37.7529764040195, -122.444528861079) 2 5 5 63 38
141541 109003 Undocumented 4 Ficus nitida :: Laurel Fig 53 525x BURNETT AVE 4 Sidewalk: Curb side : Cutout Tree Private 2       1x1   5999530 2102478 37.7529764040195 -122.444528861079 (37.7529764040195, -122.444528861079) 2 5 5 63 38
142768 112396 Undocumented 4 Ficus nitida :: Laurel Fig 53 574 VALLEY ST 2 Sidewalk: Property side : Yard Tree Private 2       3x3   6002248 2099192 37.7441085392299 -122.434894531673 (37.7441085392299, -122.434894531673) 2 7 5 63 22
148900 57604 Permitted Site 7 Ficus nitida :: Laurel Fig 53 238 Hearst Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/12/1976 12:00:00 AM   3x3 Permit Number 16491 5999828.22001193 2094390.77346711 37.7307878188175 -122.442916855234 (37.7307878188175, -122.442916855234) 9 7 4 63 40
152624 4455 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1404 Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1   08/13/2015 12:00:00 AM 70 3X3   6004493.5375 2100668.30282 37.7482893665971 -122.427235096559 (37.7482893665971, -122.427235096559) 2 4 5 63 22
160495 5728 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1688 Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1     80 3X3   6005263.1161773 2098508.6699422 37.742402999925 -122.42442032403 (37.742402999925, -122.42442032403) 2 7 5 63 22
166856 95409 Undocumented 4 Ficus nitida :: Laurel Fig 53 2885 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3 Added tree to database on 2/28/11. Appears to be 15-20 yrs old. 6002410 2095371 37.7336261540057 -122.434061286386 (37.7336261540057, -122.434061286386) 2 7 5 63 7
170923 109294 Significant Tree 6 Ficus nitida :: Laurel Fig 53 370 27TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2     18     6004104.9 2100171.3 37.7469027259862 -122.428543573264 (37.7469027259862, -122.428543573264) 2 7 5 63 22
178363 5655 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1332 Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6005148.4988519 2100582.0357256 37.7480895150856 -122.424964119184 (37.7480895150856, -122.424964119184) 2 4 5 63 22
181257 109235 Undocumented 4 Ficus nitida :: Laurel Fig 53 670 CHENERY ST 1 Sidewalk: Curb side : Cutout Tree Private 2       2x2   6002570.3 2095716.9 37.7345850124828 -122.433531794387 (37.7345850124828, -122.433531794387) 2 7 5 63 7
184670 59431 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3033 Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/03/1980 12:00:00 AM 14 3x3 Permit Number 18793 6002899.25612306 2096070.04882186 37.7355733371118 -122.432419698468 (37.7355733371118, -122.432419698468) 2 7 5 63 7
184960 109002 Undocumented 4 Ficus nitida :: Laurel Fig 53 525x BURNETT AVE 3 Sidewalk: Curb side : Cutout Tree Private 2       1x1   5999530 2102478 37.7529764040195 -122.444528861079 (37.7529764040195, -122.444528861079) 2 5 5 63 38

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