trees
139 rows where qCaretaker_id = 1 and qSpecies_id = 35 sorted by qAddress
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
87630 | 243112 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 5300x Diamond Heights Blvd | 15 | Median : Yard | Tree | DPW 1 | 05/01/2017 12:00:00 AM | 3 | 6001806.81928 | 2098684.11193 | 37.7426889388393 | -122.436383692077 | (37.7426889388393, -122.436383692077) | 2 | 7 | 5 | 63 | 7 | |||
113834 | 243114 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 5300x Diamond Heights Blvd | 17 | Median : Yard | Tree | DPW 1 | 05/01/2017 12:00:00 AM | 3 | 6001830.21459 | 2098656.61242 | 37.7426147609522 | -122.436300830338 | (37.7426147609522, -122.436300830338) | 2 | 7 | 5 | 63 | 7 | |||
115061 | 243111 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 5300x Diamond Heights Blvd | 13 | Median : Yard | Tree | DPW 1 | 05/01/2017 12:00:00 AM | 3 | 6001795.3662 | 2098698.75734 | 37.7427285009166 | -122.436424341429 | (37.7427285009166, -122.436424341429) | 2 | 7 | 5 | 63 | 7 | |||
127523 | 243106 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 5300x Diamond Heights Blvd | 9 | Median : Yard | Tree | DPW 1 | 01/09/2018 12:00:00 AM | 3 | 6001667.33897 | 2098826.57882 | 37.7430721930381 | -122.436876170699 | (37.7430721930381, -122.436876170699) | 2 | 7 | 5 | 63 | 7 | |||
135146 | 243113 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 5300x Diamond Heights Blvd | 16 | Median : Yard | Tree | DPW 1 | 05/01/2017 12:00:00 AM | 3 | 6001816.52967 | 2098672.65474 | 37.7426580318326 | -122.436349296602 | (37.7426580318326, -122.436349296602) | 2 | 7 | 5 | 63 | 7 | |||
138421 | 243116 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 5300x Diamond Heights Blvd | 19 | Median : Yard | Tree | DPW 1 | 05/01/2017 12:00:00 AM | 3 | 6001856.44522 | 2098624.22352 | 37.7425273189785 | -122.436207815256 | (37.7425273189785, -122.436207815256) | 2 | 7 | 5 | 63 | 7 | |||
146907 | 243109 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 5300x Diamond Heights Blvd | 10 | Median : Yard | Tree | DPW 1 | 05/01/2017 12:00:00 AM | 3 | 6001750.32805 | 2098751.0187 | 37.7428694390712 | -122.436583810118 | (37.7428694390712, -122.436583810118) | 2 | 7 | 5 | 63 | 7 | |||
162963 | 243101 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 5300x Diamond Heights Blvd | 1 | Median : Yard | Tree | DPW 1 | 01/09/2018 12:00:00 AM | 3 | 6001501.83115 | 2098971.73396 | 37.7434613467555 | -122.437458843264 | (37.7434613467555, -122.437458843264) | 2 | 7 | 5 | 63 | 7 | |||
165450 | 243102 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 5300x Diamond Heights Blvd | 6 | Median : Yard | Tree | DPW 1 | 05/01/2017 12:00:00 AM | 3 | 6001583.44665 | 2098902.15724 | 37.7432749451763 | -122.437171657349 | (37.7432749451763, -122.437171657349) | 2 | 7 | 5 | 63 | 7 | |||
189067 | 243103 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 5300x Diamond Heights Blvd | 8 | Median : Yard | Tree | DPW 1 | 05/01/2017 12:00:00 AM | 3 | 6001619.86426 | 2098870.33574 | 37.7431896408852 | -122.437043457211 | (37.7431896408852, -122.437043457211) | 2 | 7 | 5 | 63 | 7 | |||
66177 | 109347 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 59x BURNSIDE AVE | 1 | Median : Yard | Tree | DPW 1 | 14 | 6001229.7 | 2095779.3 | 37.7346801948558 | -122.438171157158 | (37.7346801948558, -122.438171157158) | 2 | 7 | 5 | 63 | 7 | ||||
160462 | 2028 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 600X Bosworth St | 5 | Median : Cutout | Tree | DPW 1 | 12 | 10 | 6002398.10054 | 2095366.8333155 | 37.7336140379052 | -122.434102128474 | (37.7336140379052, -122.434102128474) | 2 | 7 | 5 | 63 | 7 | |||
49956 | 211007 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 600x Bosworth St | 8 | Median : Yard | Tree | DPW 1 | 26 | Width 10ft | 6002197.80666 | 2095393.39137 | 37.7336755906519 | -122.43479650017 | (37.7336755906519, -122.43479650017) | 9 | 7 | 5 | 63 | 40 | |||
145424 | 211006 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 600x Portola Dr | 1 | Median : Cutout | Tree | DPW 1 | 6 | Width 4ft | 5997174.86391 | 2099677.95775 | 37.7451535147355 | -122.452471281937 | (37.7451535147355, -122.452471281937) | 1 | 7 | 4 | 59 | 40 | |||
107565 | 252925 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700 Sanchez St | 2 | Front Yard : Yard | Tree | DPW 1 | 6003672 | 2104202 | 37.757945572264 | -122.430328029181 | (37.757945572264, -122.430328029181) | 2 | 4 | 5 | 28862 | 3 | |||||
2117 | 111271 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700X BOSWORTH ST | 9 | Front Yard : Yard | Tree | DPW 1 | 42 | 6002150 | 2095428 | 37.7337679036822 | -122.434964255854 | (37.7337679036822, -122.434964255854) | 2 | 7 | 5 | 63 | 7 | ||||
45135 | 111279 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700X BOSWORTH ST | 17 | Front Yard : Yard | Tree | DPW 1 | 24 | 6002150 | 2095428 | 37.7337679036822 | -122.434964255854 | (37.7337679036822, -122.434964255854) | 2 | 7 | 5 | 63 | 7 | ||||
175848 | 111265 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700X BOSWORTH ST | 3 | Front Yard : Yard | Tree | DPW 1 | 20 | 6002150 | 2095428 | 37.7337679036822 | -122.434964255854 | (37.7337679036822, -122.434964255854) | 2 | 7 | 5 | 63 | 7 | ||||
83122 | 2045 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700X Bosworth St | 2 | Median : Cutout | Tree | DPW 1 | 24 | 10 | 6002154.6210393 | 2095431.8532492 | 37.7337787461998 | -122.434948555048 | (37.7337787461998, -122.434948555048) | 2 | 7 | 5 | 63 | 7 | |||
103704 | 255364 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700X Brotherhood Way | 2 | Median : Cutout | Tree | DPW 1 | 6x10 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
154769 | 255363 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700X Brotherhood Way | 1 | Median : Cutout | Tree | DPW 1 | 6x10 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
164072 | 2266 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700X Brotherhood Way | 12 | Median : Cutout | Tree | DPW 1 | 04/04/2014 12:00:00 AM | 22 | 14M | Permit Number 772491 | 5991180.7931196 | 2088069.9959997 | 37.7129357180907 | -122.472351488932 | (37.7129357180907, -122.472351488932) | 1 | 8 | 4 | 64 | 14 | |
32345 | 211008 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700x Bosworth St | 2 | Median : Yard | Tree | DPW 1 | 33 | Width 10ft | 6002060.33003 | 2095430.49234 | 37.7337696552405 | -122.435274449372 | (37.7337696552405, -122.435274449372) | 9 | 7 | 5 | 63 | 40 | |||
124888 | 2268 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 750X Brotherhood Way | 2 | Median : Cutout | Tree | DPW 1 | 6 | 14M | 5991074.0426161 | 2088106.2478104 | 37.7130290777882 | -122.47272309172 | (37.7130290777882, -122.47272309172) | 1 | 8 | 4 | 64 | 14 | |||
153963 | 24789 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 7700 Geary Blvd | 1 | Median : Cutout | Tree | DPW 1 | 6 | 4X4 | 5983110.07731 | 2112460.67779 | 37.7794353864392 | -122.502049785013 | (37.7794353864392, -122.502049785013) | 11 | 6 | 2 | 55 | 26 | |||
33534 | 27300 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 7900X Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/10/1999 12:00:00 AM | 6 | 5x5 | 5982547.93354 | 2112415.51016 | 37.7792783288562 | -122.503991098801 | (37.7792783288562, -122.503991098801) | 11 | 6 | 2 | 55 | 26 | ||
144700 | 118538 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 7900x Geary Blvd | 1 | Median : Cutout | Tree | DPW 1 | 11 | Width 4ft | 5982472.23583 | 2112389.87128 | 37.7792034803758 | -122.504251064408 | (37.7792034803758, -122.504251064408) | 11 | 6 | 2 | 55 | 26 | |||
39660 | 111514 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 800x BOSWORTH ST | 9 | Front Yard : Yard | Tree | DPW 1 | 12 | 6001905 | 2095492 | 37.7339297189054 | -122.435815869962 | (37.7339297189054, -122.435815869962) | 9 | 7 | 5 | 63 | 7 | ||||
69254 | 111516 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 800x BOSWORTH ST | 11 | Front Yard : Yard | Tree | DPW 1 | 14 | 6001905 | 2095492 | 37.7339297189054 | -122.435815869962 | (37.7339297189054, -122.435815869962) | 9 | 7 | 5 | 63 | 7 | ||||
69447 | 111507 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 800x BOSWORTH ST | 2 | Front Yard : Yard | Tree | DPW 1 | 18 | 6001905 | 2095492 | 37.7339297189054 | -122.435815869962 | (37.7339297189054, -122.435815869962) | 9 | 7 | 5 | 63 | 7 | ||||
113773 | 111508 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 800x BOSWORTH ST | 3 | Front Yard : Yard | Tree | DPW 1 | 18 | 6001905 | 2095492 | 37.7339297189054 | -122.435815869962 | (37.7339297189054, -122.435815869962) | 9 | 7 | 5 | 63 | 7 | ||||
166211 | 211005 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 800x Portola Dr | 2 | Median : Cutout | Tree | DPW 1 | 7 | Width 4ft | 5996562.64616 | 2099171.26049 | 37.7437271539842 | -122.454551615288 | (37.7437271539842, -122.454551615288) | 1 | 7 | 4 | 59 | 40 | |||
37212 | 111553 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 900x BOSWORTH ST | 31 | Front Yard : Yard | Tree | DPW 1 | 12 | 6001649 | 2095572 | 37.7341348351459 | -122.436706663072 | (37.7341348351459, -122.436706663072) | 9 | 7 | 5 | 63 | 7 | ||||
101189 | 111558 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 900x BOSWORTH ST | 36 | Front Yard : Yard | Tree | DPW 1 | 15 | 6001649 | 2095572 | 37.7341348351459 | -122.436706663072 | (37.7341348351459, -122.436706663072) | 9 | 7 | 5 | 63 | 7 | ||||
147440 | 111557 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 900x BOSWORTH ST | 35 | Front Yard : Yard | Tree | DPW 1 | 12 | 6001649 | 2095572 | 37.7341348351459 | -122.436706663072 | (37.7341348351459, -122.436706663072) | 9 | 7 | 5 | 63 | 7 | ||||
150320 | 111555 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 900x BOSWORTH ST | 33 | Front Yard : Yard | Tree | DPW 1 | 24 | 6001649 | 2095572 | 37.7341348351459 | -122.436706663072 | (37.7341348351459, -122.436706663072) | 9 | 7 | 5 | 63 | 7 | ||||
171251 | 111554 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 900x BOSWORTH ST | 32 | Front Yard : Yard | Tree | DPW 1 | 26 | 6001649 | 2095572 | 37.7341348351459 | -122.436706663072 | (37.7341348351459, -122.436706663072) | 9 | 7 | 5 | 63 | 7 | ||||
9342 | 23614 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 910X Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 30X30PL | 6011300.2113585 | 2104101.3880723 | 37.7580984495586 | -122.403939228694 | (37.7580984495586, -122.403939228694) | 10 | 3 | 8 | 28856 | 29 | |||
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 |
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) );