trees
65 rows where qSiteInfo = "Sidewalk: Curb side : Cutout" and qSpecies_id = 35 sorted by Police Districts
This data as json, CSV (advanced)
These facets timed out: qSiteInfo, qLegalStatus_id
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1053 | 211003 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700 Portola Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5996800.72253 | 2099394.55039 | 37.7443539050009 | -122.453744529511 | (37.7443539050009, -122.453744529511) | 1 | 7 | 4 | 59 | 40 | |||
49925 | 211004 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700 Portola Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5996822.63607 | 2099410.87592 | 37.7443999871842 | -122.453669936126 | (37.7443999871842, -122.453669936126) | 1 | 7 | 4 | 59 | 40 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
18682 | 91505 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 1501@Clearfield Sloat Blvd | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/2009 12:00:00 AM | 3x3 | Permit Number 52122 | 5986316.3 | 2095724.7 | 37.7336708170949 | -122.489727133621 | (37.7336708170949, -122.489727133621) | 1 | 8 | 4 | 64 | 35 | ||
22467 | 211031 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2375 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 5992617.61467 | 2099318.2887 | 37.7439038024205 | -122.468203163863 | (37.7439038024205, -122.468203163863) | 1 | 8 | 4 | 29491 | 40 | |||
40897 | 21491 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2792X Sunset Blvd | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 60 | 5985060.3629888 | 2096294.4798015 | 37.7351618711636 | -122.49411119238 | (37.7351618711636, -122.49411119238) | 1 | 8 | 3 | 29491 | 35 | |||
42301 | 87834 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 1501@Ocean Sloat Blvd | 10 | 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 | ||
49351 | 21431 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2692X Sunset Blvd | 28 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 60 | 5985040.0664617 | 2096882.0619327 | 37.7367740271268 | -122.494224659054 | (37.7367740271268, -122.494224659054) | 1 | 8 | 3 | 29491 | 35 | |||
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 | ||
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 | ||||
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 | ||
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 | |||||
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 | ||
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 | ||
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 | ||||
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 | ||||
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 | |||
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 | ||||
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 | |||
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 | |
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 | |
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 |
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) );