trees
18 rows where SiteOrder = 7 and qSpecies_id = 93
This data as json, CSV (advanced)
These facets timed out: SiteOrder
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
32237 | 14772 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1000X McAllister St | 7 | Sidewalk: Curb side : Cutout | Tree | Office of Mayor 9 | 06/30/1994 12:00:00 AM | 18 | 4X4 | 6004368.8552829 | 2111899.4426369 | 37.7791203368819 | -122.428466654288 | (37.7791203368819, -122.428466654288) | 7 | 9 | 11 | 29490 | 41 | ||
38948 | 136422 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 377 Drumm St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6013539.98314 | 2118153.18221 | 37.7968063633679 | -122.397178396789 | (37.7968063633679, -122.397178396789) | 3 | 1 | 10 | 28860 | 6 | |||
73651 | 112027 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2101x 22nd Ave | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 5x5 | 6011761 | 2103726 | 37.75709344993 | -122.402319220858 | (37.75709344993, -122.402319220858) | 10 | 3 | 8 | 28856 | 29 | ||||
89418 | 138404 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1850 PIERCE ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6002025.4909 | 2114921.9063 | 37.7872863683147 | -122.436789715353 | (37.7872863683147, -122.436789715353) | 13 | 6 | 11 | 29490 | 27 | |||
97376 | 118223 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 699 37th Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5984452.77979 | 2111524.24348 | 37.7769429972336 | -122.49733573185 | (37.7769429972336, -122.49733573185) | 11 | 6 | 2 | 55 | 26 | |||
117041 | 183904 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2101 22nd Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5989435.9716 | 2100535.9908 | 37.7470630248592 | -122.479293489941 | (37.7470630248592, -122.479293489941) | 1 | 8 | 3 | 29491 | 35 | |||
128288 | 136391 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3395 Sacramento St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 5998783.39142 | 2115244.6481 | 37.7879877418005 | -122.448029892768 | (37.7879877418005, -122.448029892768) | 13 | 6 | 1 | 54 | 31 | |||
128505 | 113595 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 370 Drumm St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2015 12:00:00 AM | 2 | 3x3 | 6013594.82153 | 2118250.31526 | 37.7970761204252 | -122.396995455792 | (37.7970761204252, -122.396995455792) | 3 | 1 | 10 | 28860 | 6 | ||
133626 | 136415 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 640 Davis St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6013156.852 | 2118810.40691 | 37.7985896092893 | -122.398550270302 | (37.7985896092893, -122.398550270302) | 3 | 1 | 10 | 28860 | 6 | |||
135187 | 197566 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 100 15th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6011795.68975 | 2107497.96925 | 37.7674523721611 | -122.402464474151 | (37.7674523721611, -122.402464474151) | 8 | 2 | 8 | 28853 | 20 | |||
141721 | 98795 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 950@Washington Clay St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | Permit Number 768771 | 6010160.7 | 2117472.9 | 37.7947497683853 | -122.408823532788 | (37.7947497683853, -122.408823532788) | 3 | 1 | 10 | 28857 | 4 | |||
152373 | 197576 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1121 Jamestown Ave | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | 6013293.0543 | 2090118.55817 | 37.7198156565414 | -122.396067168381 | (37.7198156565414, -122.396067168381) | 10 | 3 | 8 | 58 | 1 | ||||
153237 | 30950 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2390 Bush St | 7 | 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 | ||
153490 | 197549 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 101 Rhode Island St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6011738.81307 | 2107215.77896 | 37.766674365946 | -122.402641357327 | (37.766674365946, -122.402641357327) | 8 | 2 | 8 | 28853 | 20 | |||
154229 | 114773 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 110 Frederick St | 7 | 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 | ||||
161956 | 111032 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 150 15th St | 7 | 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 | ||||
163642 | 200677 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1535 Newcomb Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6015676.0731 | 2095323.7293 | 37.7342403234109 | -122.388192909274 | (37.7342403234109, -122.388192909274) | 10 | 3 | 8 | 58 | 1 | |||
170927 | 197512 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1275 Harrison St | 7 | Sidewalk: Curb side : Pot | Tree | Private 2 | 8 | 6009788.18393 | 2109495.5877 | 37.7728250956205 | -122.409549199229 | (37.7728250956205, -122.409549199229) | 14 | 2 | 9 | 28853 | 34 |
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) );