65 rows where qSiteInfo = "Sidewalk: Curb side : Cutout" and qSpecies_id = 35

View and edit SQL

qSiteInfo

  • Sidewalk: Curb side : Cutout · 41
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)
53868 91504 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 1501@Clearfield Sloat Blvd 18 Sidewalk: Curb side : Cutout Tree Private 2   05/04/2009 12:00:00 AM   3x3 Permit Number 52122 5986536.9 2095861.8 37.7340601352242 -122.488974540344 (37.7340601352242, -122.488974540344) 1 8 4 64 35
63272 4532 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 45 Cleary Ct 3 Sidewalk: Curb side : Cutout Tree Private 2   06/07/2018 12:00:00 AM 3 3X3 Permit Number 781999 6005027.0371 2113673.2533 37.784028006638 -122.42631605912 (37.784028006638, -122.42631605912) 7 9 11 28858 41
65012 254798 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 700 Brotherhood Way 22 Sidewalk: Curb side : Cutout Tree Private 2       4x9   5991178 2088065 37.7129218386335 -122.472360778797 (37.7129218386335, -122.472360778797) 1 8 4 64 14
66433 8563 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2200 Geary Blvd 4 Sidewalk: Curb side : Cutout Tree DPW 1     36 3X3   6001214.79121 2113518.75863 37.7833875775095 -122.439493935571 (37.7833875775095, -122.439493935571) 15 5 11 29490 13
71757 8562 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2200 Geary Blvd 3 Sidewalk: Curb side : Cutout Tree DPW 1     48 3X3   6001214.79121 2113518.75863 37.7833875775095 -122.439493935571 (37.7833875775095, -122.439493935571) 15 5 11 29490 13
72849 91503 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 1501@Clearfield Sloat Blvd 15 Sidewalk: Curb side : Cutout Tree Private 2   05/04/2009 12:00:00 AM   3x3 Permit Number 52122 5986536.9 2095861.8 37.7340601352242 -122.488974540344 (37.7340601352242, -122.488974540344) 1 8 4 64 35
77378 211002 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 700 Portola Dr 3 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5996779.38475 2099373.51377 37.744294920285 -122.453816791818 (37.744294920285, -122.453816791818) 1 7 4 59 40
80290 200146 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 6101 03rd St 2 Sidewalk: Curb side : Cutout Tree Private 2     22 Width 0ft   6013586.8559 2091305.2042 37.7230902914135 -122.395134667477 (37.7230902914135, -122.395134667477) 10 3 8 58 1
85596 87013 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 1184 Oakdale Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   12/05/2007 12:00:00 AM     Permit Number 49946 6017813.5 2093492.6 37.7293305991048 -122.380675823117 (37.7293305991048, -122.380675823117) 10 3 8 58 1
86234 173745 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 500X Grand View Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6000114 2102099 37.7519690677882 -122.442482075417 (37.7519690677882, -122.442482075417) 2 4 5 28862 22
90902 194427 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 905 Minna St 3 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6008110 2110227 37.7747392032863 -122.415406037323 (37.7747392032863, -122.415406037323) 8 2 9 28853 34
92672 254785 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 700 Brotherhood Way 8 Sidewalk: Curb side : Cutout Tree Private 2       4x9   5991178 2088065 37.7129218386335 -122.472360778797 (37.7129218386335, -122.472360778797) 1 8 4 64 14
96966 254788 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 700 Brotherhood Way 11 Sidewalk: Curb side : Cutout Tree Private 2       4x9   5991178 2088065 37.7129218386335 -122.472360778797 (37.7129218386335, -122.472360778797) 1 8 4 64 14
103504 254796 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 700 Brotherhood Way 19 Sidewalk: Curb side : Cutout Tree Private 2       4x9   5991178 2088065 37.7129218386335 -122.472360778797 (37.7129218386335, -122.472360778797) 1 8 4 64 14
105094 96843 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 417 Dewey Blvd 3 Sidewalk: Curb side : Cutout Tree Private 2           5995136 2100316.9 37.7467908665237 -122.459567540316 (37.7467908665237, -122.459567540316) 1 8 4 59 40
107231 8560 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2200 Geary Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1   06/01/1994 12:00:00 AM 6 3X3   6001214.79121 2113518.75863 37.7833875775095 -122.439493935571 (37.7833875775095, -122.439493935571) 15 5 11 29490 13
109718 87015 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 35 Whitfield Ct 2 Sidewalk: Curb side : Cutout Tree Private 2   12/05/2007 12:00:00 AM     Permit Number 49947 6017543.1 2094109.3 37.7310090102049 -122.381653502791 (37.7310090102049, -122.381653502791) 10 3 8 58 1
113256 8561 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2200 Geary Blvd 2 Sidewalk: Curb side : Cutout Tree DPW 1   06/01/1994 12:00:00 AM 6 3X3   6001214.79121 2113518.75863 37.7833875775095 -122.439493935571 (37.7833875775095, -122.439493935571) 15 5 11 29490 13
116936 100068 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 303 Serrano Dr 1 Sidewalk: Curb side : Cutout Tree Private 2   07/13/2012 12:00:00 AM     Permit Number 769006 5990392 2090762 37.720281613079 -122.47527420247 (37.720281613079, -122.47527420247) 1 8 4 64 40
122904 96844 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 417 Dewey Blvd 4 Sidewalk: Curb side : Cutout Tree Private 2           5995136 2100316.9 37.7467908665237 -122.459567540316 (37.7467908665237, -122.459567540316) 1 8 4 59 40
125671 91502 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 1501@Clearfield Sloat Blvd 12 Sidewalk: Curb side : Cutout Tree Private 2   05/04/2009 12:00:00 AM   3x3 Permit Number 52122 5986536.9 2095861.8 37.7340601352242 -122.488974540344 (37.7340601352242, -122.488974540344) 1 8 4 64 35
127704 4530 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 45 Cleary Ct 1 Sidewalk: Curb side : Cutout Tree Private 2   06/07/2018 12:00:00 AM 3 3X3 Permit Number 781999 6004963.1338 2113665.364 37.7840027322121 -122.426536579485 (37.7840027322121, -122.426536579485) 7 9 11 28858 41
129439 4367 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 973 Chenery St 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X3   6001101.12966 2096102.69208 37.7355608412513 -122.438638832041 (37.7355608412513, -122.438638832041) 2 7 5 63 7
134883 87835 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 1501@Ocean Sloat Blvd 11 Sidewalk: Curb side : Cutout Tree Private 2   06/06/2008 12:00:00 AM   3x3 Permit Number 50721 5986536.9 2095861.8 37.7340601352242 -122.488974540344 (37.7340601352242, -122.488974540344) 1 8 4 64 35
137065 4531 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 45 Cleary Ct 2 Sidewalk: Curb side : Cutout Tree Private 2   06/07/2018 12:00:00 AM 3 3X3 Permit Number 781999 6004996.2689 2113667.7308 37.7840111039908 -122.426422112629 (37.7840111039908, -122.426422112629) 7 9 11 28858 41
141899 254786 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 700 Brotherhood Way 9 Sidewalk: Curb side : Cutout Tree Private 2       4x9   5991178 2088065 37.7129218386335 -122.472360778797 (37.7129218386335, -122.472360778797) 1 8 4 64 14
144504 254787 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 700 Brotherhood Way 10 Sidewalk: Curb side : Cutout Tree Private 2       4x9   5991178 2088065 37.7129218386335 -122.472360778797 (37.7129218386335, -122.472360778797) 1 8 4 64 14
145411 254797 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 700 Brotherhood Way 21 Sidewalk: Curb side : Cutout Tree Private 2       4x9   5991178 2088065 37.7129218386335 -122.472360778797 (37.7129218386335, -122.472360778797) 1 8 4 64 14
147596 234475 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 378 Highland Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6007368.44216 2096501.62636 37.7370107660349 -122.416998547241 (37.7370107660349, -122.416998547241) 2 7 7 28859 2
148334 254794 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 700 Brotherhood Way 20 Sidewalk: Curb side : Cutout Tree Private 2       4x9   5991178 2088065 37.7129218386335 -122.472360778797 (37.7129218386335, -122.472360778797) 1 8 4 64 14
152315 254800 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 700 Brotherhood Way 23 Sidewalk: Curb side : Cutout Tree Private 2       4x9   5991178 2088065 37.7129218386335 -122.472360778797 (37.7129218386335, -122.472360778797) 1 8 4 64 14
160963 87014 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 35 Whitfield Ct 1 Sidewalk: Curb side : Cutout Tree Private 2   12/05/2007 12:00:00 AM     Permit Number 49947 6017543.1 2094109.3 37.7310090102049 -122.381653502791 (37.7310090102049, -122.381653502791) 10 3 8 58 1
162497 211001 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 700 Portola Dr 4 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5996755.51144 2099350.67627 37.7442308453761 -122.45389769125 (37.7442308453761, -122.45389769125) 1 7 4 59 40
165176 87017 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 1200 Oakdale Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/05/2007 12:00:00 AM     Permit Number 49948 6017188.8 2093995.7 37.7306775177665 -122.382870487304 (37.7306775177665, -122.382870487304) 10 3 8 58 1
168039 21429 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2692X Sunset Blvd 26 Sidewalk: Curb side : Cutout Tree DPW 1     48 60   5985040.0664617 2096882.0619327 37.7367740271268 -122.494224659054 (37.7367740271268, -122.494224659054) 1 8 3 29491 35
170250 234474 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 72 Santa Marina St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6006078.82979 2097595.56477 37.7399418481504 -122.421534992063 (37.7399418481504, -122.421534992063) 2 7 7 28859 2
179255 254795 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 700 Brotherhood Way 18 Sidewalk: Curb side : Cutout Tree Private 2       4x9   5991178 2088065 37.7129218386335 -122.472360778797 (37.7129218386335, -122.472360778797) 1 8 4 64 14
186953 173744 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 500X Grand View Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000114 2102099 37.7519690677882 -122.442482075417 (37.7519690677882, -122.442482075417) 2 4 5 28862 22
187095 21459 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2701X Sunset Blvd 12 Sidewalk: Curb side : Cutout Tree DPW 1     12 40   5985119.0068215 2096832.7848434 37.7366433445438 -122.493948101207 (37.7366433445438, -122.493948101207) 1 8 3 29491 35
192931 173637 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1155 Market St 99 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008672 2111900 37.779364436223 -122.4135803097 (37.779364436223, -122.4135803097) 8 2 9 28853 34
193081 173746 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 500X Grand View Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6000114 2102099 37.7519690677882 -122.442482075417 (37.7519690677882, -122.442482075417) 2 4 5 28862 22

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