trees
26 rows where SiteOrder = 6 and qSpecies_id = 93
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2724 | 179436 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 122 Santos St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 6ft | 6006488.6944 | 2086721.59328 | 37.7101073779209 | -122.419346642943 | (37.7101073779209, -122.419346642943) | 9 | 7 | 8 | 309 | 39 | |||
4042 | 197511 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1275 Harrison St | 6 | Sidewalk: Curb side : Pot | Tree | Private 2 | 14 | 6009774.86658 | 2109479.23633 | 37.7727794523332 | -122.409594111377 | (37.7727794523332, -122.409594111377) | 14 | 2 | 9 | 28853 | 34 | ||||
7377 | 14771 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1000X McAllister St | 6 | Sidewalk: Curb side : Cutout | Tree | Office of Mayor 9 | 18 | 4x4 | 6004368.8552829 | 2111899.4426369 | 37.7791203368819 | -122.428466654288 | (37.7791203368819, -122.428466654288) | 7 | 9 | 11 | 29490 | 41 | |||
14668 | 75472 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 701 38th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5984118.82642 | 2110932.36992 | 37.7752983048778 | -122.498447232603 | (37.7752983048778, -122.498447232603) | 11 | 6 | 2 | 55 | 26 | |||
17515 | 179429 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2 Brookdale Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 6006237.48001 | 2087456.42565 | 37.7121109208587 | -122.420267010915 | (37.7121109208587, -122.420267010915) | 9 | 7 | 8 | 309 | 39 | |||
18238 | 200676 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1535 Newcomb Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6015656.8366 | 2095323.7293 | 37.7342392575487 | -122.388259416585 | (37.7342392575487, -122.388259416585) | 10 | 3 | 8 | 58 | 1 | |||
23977 | 101872 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 737 Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6012644.6557 | 2113099.5202 | 37.782880312512 | -122.39992139618 | (37.782880312512, -122.39992139618) | 6 | 2 | 9 | 28856 | 34 | |||
32589 | 183903 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2101 22nd Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5989437.5475 | 2100612.4238 | 37.7472729813132 | -122.479293631278 | (37.7472729813132, -122.479293631278) | 1 | 8 | 3 | 29491 | 35 | |||
42531 | 109301 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 251 RHODE ISLAND ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011759.4 | 2107238.5 | 37.7667379021668 | -122.402571748171 | (37.7667379021668, -122.402571748171) | 8 | 2 | 8 | 28853 | 20 | ||||
59617 | 5486 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 700X Dolores St | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 04/28/2008 12:00:00 AM | 12 | 6 | 6004966.5668947 | 2104283.6095193 | 37.7582428963987 | -122.425856676166 | (37.7582428963987, -122.425856676166) | 2 | 4 | 5 | 28862 | 3 | ||
60432 | 112026 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2101x 22nd Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 5x5 | 6011761 | 2103726 | 37.75709344993 | -122.402319220858 | (37.75709344993, -122.402319220858) | 10 | 3 | 8 | 28856 | 29 | ||||
74582 | 113594 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 370 Drumm St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3x3 | 6013595.86878 | 2118231.42432 | 37.7970243086769 | -122.396990506826 | (37.7970243086769, -122.396990506826) | 3 | 1 | 10 | 28860 | 6 | |||
90912 | 118222 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 699 37th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5984454.40833 | 2111501.37469 | 37.7768803015762 | -122.497328409687 | (37.7768803015762, -122.497328409687) | 11 | 6 | 2 | 55 | 26 | |||
98144 | 138403 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1850 PIERCE ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6002027.5911 | 2114900.905 | 37.7872288234819 | -122.436780945176 | (37.7872288234819, -122.436780945176) | 13 | 6 | 11 | 29490 | 27 | |||
100760 | 34504 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 18 Lansing St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/1997 12:00:00 AM | Permit Number 38225 | 6014460.80851138 | 2114327.15380544 | 37.7863521983391 | -122.393724169888 | (37.7863521983391, -122.393724169888) | 6 | 2 | 9 | 28855 | 6 | |||
124607 | 197559 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 200 Kansas St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 25 | Width 4ft | 6011390.59783 | 2107261.91001 | 37.7667815840329 | -122.403849027227 | (37.7667815840329, -122.403849027227) | 8 | 2 | 8 | 28853 | 20 | |||
127345 | 197565 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 100 15th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6011813.28863 | 2107500.86119 | 37.7674612952308 | -122.402403805019 | (37.7674612952308, -122.402403805019) | 8 | 2 | 8 | 28853 | 20 | |||
127434 | 136421 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 377 Drumm St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6013535.0626 | 2118179.75007 | 37.7968790384839 | -122.39719728705 | (37.7968790384839, -122.39719728705) | 3 | 1 | 10 | 28860 | 6 | |||
130739 | 197574 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 801 Howard St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6011821.05226 | 2113183.26768 | 37.7830643124058 | -122.402776628832 | (37.7830643124058, -122.402776628832) | 6 | 2 | 9 | 28853 | 34 | |||
132055 | 111031 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 150 15th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011831.59667013 | 2107504.61941603 | 37.7674726364822 | -122.402340743885 | (37.7674726364822, -122.402340743885) | 8 | 2 | 8 | 28853 | 20 | ||||
132515 | 102836 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 25X LANSING ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6014464 | 2114267 | 37.7861872071537 | -122.393708916182 | (37.7861872071537, -122.393708916182) | 6 | 2 | 9 | 28855 | 6 | |||
145852 | 123737 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 301 Cabrillo St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 5994606.64187 | 2110737.80546 | 37.7753735249534 | -122.462153618877 | (37.7753735249534, -122.462153618877) | 11 | 6 | 2 | 54 | 11 | |||
147544 | 197548 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 101 Rhode Island St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 3ft | 6011737.58275 | 2107186.12686 | 37.7665928792734 | -122.402643527378 | (37.7665928792734, -122.402643527378) | 8 | 2 | 8 | 28853 | 20 | |||
156854 | 197578 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 299x Cashmere St | 6 | Median : Yard | Tree | DPW 1 | 7 | 6016803.94707 | 2095896.67464 | 37.7358759448203 | -122.384333341329 | (37.7358759448203, -122.384333341329) | 10 | 3 | 8 | 58 | 1 | ||||
160504 | 114772 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 110 Frederick St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999469.36873216 | 2107750.31436605 | 37.7674494126495 | -122.445117544708 | (37.7674494126495, -122.445117544708) | 15 | 5 | 11 | 29492 | 9 | ||||
172994 | 30951 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2390 Bush St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | Permit Number 34752 | 6002079.96472002 | 2114704.99678528 | 37.7866938860132 | -122.436585716056 | (37.7866938860132, -122.436585716056) | 13 | 6 | 11 | 29490 | 27 |
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) );