trees
139 rows where qCaretaker_id = 1 and qSpecies_id = 35 sorted by rowid descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
54682 | 8393 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1500 Geary Blvd | 4 | Median : Cutout | Tree | DPW 1 | 36 | 8 | 6004320.9581 | 2113985.4149 | 37.7848451877241 | -122.428781097193 | (37.7848451877241, -122.428781097193) | 13 | 9 | 11 | 29490 | 41 | |||
54454 | 200536 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1400x La Salle Ave | 12 | Median : Cutout | Tree | DPW 1 | 8 | Width 0ft | 6016175.6148 | 2095666.5235 | 37.7352092330314 | -122.38648971191 | (37.7352092330314, -122.38648971191) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
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 | |||
45559 | 8390 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1500 Geary Blvd | 1 | Median : Cutout | Tree | DPW 1 | 36 | 8 | 6004488.7034 | 2114010.5767 | 37.7849237683164 | -122.428202546761 | (37.7849237683164, -122.428202546761) | 13 | 9 | 11 | 29490 | 41 | |||
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 | ||||
43907 | 8339 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1300 Geary Blvd | 5 | Median : Cutout | Tree | DPW 1 | 06/08/1994 12:00:00 AM | 18 | 6 | 6005496.3592183 | 2114176.6024527 | 37.7854365962768 | -122.424728193484 | (37.7854365962768, -122.424728193484) | 13 | 9 | 11 | 28858 | 13 | ||
43150 | 8574 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2200 Geary Blvd | 1 | Median : Cutout | Tree | DPW 1 | 6 | 6 | 6001134.4053 | 2113480.979 | 37.7832792690603 | -122.439769329053 | (37.7832792690603, -122.439769329053) | 15 | 5 | 11 | 29490 | 41 | |||
41737 | 115997 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 20X Park St | 2 | Median : Yard | Tree | DPW 1 | 08/30/2016 09:25:00 AM | 3 | 6004982.6 | 2096420.1 | 37.7366524147431 | -122.425241679782 | (37.7366524147431, -122.425241679782) | 2 | 7 | 5 | 28859 | 2 | |||
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 | |||
40576 | 120625 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1500 Geary Blvd | 2 | Median : Cutout | Tree | DPW 1 | 6004349 | 2113949 | 37.7847467885767 | -122.428681484586 | (37.7847467885767, -122.428681484586) | 13 | 9 | 11 | 29490 | 41 | |||||
39949 | 8349 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1300 Geary Blvd | 15 | Median : Cutout | Tree | DPW 1 | 24 | 6 | 6005496.3592183 | 2114176.6024527 | 37.7854365962768 | -122.424728193484 | (37.7854365962768, -122.424728193484) | 13 | 9 | 11 | 28858 | 13 | |||
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 | ||||
38568 | 8471 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1900 Geary Blvd | 8 | Median : Cutout | Tree | DPW 1 | 06/03/1994 12:00:00 AM | 6 | 8 | 6002124.2891 | 2113678.9558 | 37.7838791576421 | -122.43635890448 | (37.7838791576421, -122.43635890448) | 13 | 5 | 11 | 29490 | 41 | ||
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 | ||||
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 | ||
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 | |||
26940 | 8472 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1900 Geary Blvd | 9 | Median : Cutout | Tree | DPW 1 | 6 | 8 | 6002074.2026 | 2113678.2789 | 37.7838744530021 | -122.436532136471 | (37.7838744530021, -122.436532136471) | 13 | 5 | 11 | 29490 | 41 | |||
23996 | 8576 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2200 Geary Blvd | 3 | Median : Cutout | Tree | DPW 1 | 48 | 6 | 6001010.5429 | 2113459.32 | 37.7832127479531 | -122.440196288881 | (37.7832127479531, -122.440196288881) | 15 | 5 | 11 | 29490 | 41 | |||
22825 | 200547 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1400x La Salle Ave | 23 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6016201.7309 | 2095635.0286 | 37.7351242000527 | -122.386397222999 | (37.7351242000527, -122.386397222999) | 10 | 3 | 8 | 58 | 1 | |||
21559 | 8344 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1300 Geary Blvd | 10 | Median : Cutout | Tree | DPW 1 | 06/08/1994 12:00:00 AM | 12 | 6 | 6005496.3592183 | 2114176.6024527 | 37.7854365962768 | -122.424728193484 | (37.7854365962768, -122.424728193484) | 13 | 9 | 11 | 28858 | 13 | ||
20185 | 8536 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2100 Geary Blvd | 7 | Median : Cutout | Tree | DPW 1 | 06/10/1994 12:00:00 AM | 6 | 6 | 6001688.6684406 | 2113658.1430724 | 37.7837972495813 | -122.43786449651 | (37.7837972495813, -122.43786449651) | 15 | 5 | 11 | 29490 | 13 | ||
15936 | 19986 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 100 STAIRWAY46 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 40 | |||||||||||||
14131 | 258121 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 500X Clarendon Ave | 3 | Median : Cutout | Tree | DPW 1 | 05/26/2019 09:09:00 PM | 3 | 5x5 | ||||||||||||
13843 | 20301 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 50X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 60 | |||||||||||||
13326 | 258119 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 500X Clarendon Ave | 1 | Median : Cutout | Tree | DPW 1 | 05/26/2019 09:14:00 PM | 3 | 5x5 | ||||||||||||
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 | |||
7975 | 19667 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 100 STAIRWAY5 | 66 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
7691 | 19980 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 100 STAIRWAY45 | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30ST | |||||||||||||
6935 | 258120 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 500X Clarendon Ave | 2 | Median : Cutout | Tree | DPW 1 | 05/26/2019 09:06:00 PM | 3 | 5x5 | ||||||||||||
6613 | 19666 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 100 STAIRWAY5 | 65 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60ST | |||||||||||||
6586 | 258122 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 500X Clarendon Ave | 4 | Median : Cutout | Tree | DPW 1 | 05/26/2019 09:11:00 PM | 3 | 5x5 | ||||||||||||
5625 | 19976 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 100 STAIRWAY45 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30ST | |||||||||||||
5212 | 19664 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 100 STAIRWAY5 | 63 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
4106 | 19663 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 100 STAIRWAY5 | 62 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
3808 | 20305 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 50X Sunset Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 60 | |||||||||||||
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 | ||||
1049 | 120626 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1500 Geary Blvd | 3 | Median : Cutout | Tree | DPW 1 | 6004397 | 2113949 | 37.7847495050096 | -122.428515420401 | (37.7847495050096, -122.428515420401) | 13 | 9 | 11 | 29490 | 41 | |||||
436 | 120628 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1500 Geary Blvd | 5 | Median : Cutout | Tree | DPW 1 | 6004397 | 2113949 | 37.7847495050096 | -122.428515420401 | (37.7847495050096, -122.428515420401) | 13 | 9 | 11 | 29490 | 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) );