trees

43 rows where SiteOrder = 2 and qSpecies_id = 63 sorted by qSpecies_id

✎ View and edit SQL

This data as json, CSV (advanced)

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)
5675 261201 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 699x Benton Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007339 2095419 37.7340364554683 -122.417023656077 (37.7340364554683, -122.417023656077) 2 7 7 28859 2
7002 262493 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1100X Portola Dr 2 Median : Yard Tree Private 2       10x10   5995372 2097783 37.7398469739468 -122.458568082407 (37.7398469739468, -122.458568082407) 9 7 4 59 40
8023 121696 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 1300x De Haro St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6012218 2102254 37.7530771598286 -122.400635326689 (37.7530771598286, -122.400635326689) 10 3 8 28856 29
8123 16369 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1400X Montgomery St 2 Median : Cutout Tree DPW 1     18 8   6011455.2971485 2120087.0441833 37.8020000032358 -122.404528131508 (37.8020000032358, -122.404528131508) 3 1 10 308 23
10489 102839 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 1101X Portola Dr 2 Sidewalk: Property side : Yard Tree DPW 1                              
12450 261565 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1801 26th St 2 Sidewalk: Property side : Yard Tree DPW 1       3x3   6013146 2101521 37.7511162126671 -122.39737469907 (37.7511162126671, -122.39737469907) 10 3 8 28856 1
12952 20300 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 50X Sunset Blvd 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 60                      
15519 262098 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 10x Cuesta Ct 2 Unaccepted Street : Yard Tree DPW 1 Private     3x3   5999757 2101744 37.7509739685765 -122.443691128062 (37.7509739685765, -122.443691128062) 2 5 5 63 38
17261 261487 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1100X Portola Dr 2 Median : Cutout Tree DPW 1 Private     3x3   5995262 2098056 37.7405902419398 -122.458968175006 (37.7405902419398, -122.458968175006) 1 7 4 59 40
18973 233322 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 51 Prentiss St 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6008884.18383 2098343.89419 37.7421543791283 -122.411888074199 (37.7421543791283, -122.411888074199) 10 7 7 28859 2
21065 201733 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 727 Jamestown Ave 2 Sidewalk: Property side : Yard Tree Private 2     18 Width 8ft   6015510.4184 2087766.77172 37.7134812286504 -122.388238406274 (37.7134812286504, -122.388238406274) 10 3 8 58 1
30931 211072 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 602x Miramar Ave 2 Median : Yard Tree DPW 1     35     5995382.34021 2093429.07469 37.7278927511259 -122.458217288807 (37.7278927511259, -122.458217288807) 9 7 4 28861 40
32960 121406 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 10X Dorchester Way 2 Median : Cutout Tree DPW 1       8x30   5994075 2098171 37.7408376984389 -122.463080674317 (37.7408376984389, -122.463080674317) 1 8 4 59 40
38246 111524 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 900x BOSWORTH ST 2 Front Yard : Yard Tree DPW 1     28     6001649 2095572 37.7341348351459 -122.436706663072 (37.7341348351459, -122.436706663072) 9 7 5 63 7
43298 23673 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 319 Virginia Ave 2 Median : Cutout Tree DPW 1     12 12   6006936.2458165 2098250.5638735 37.741788638282 -122.418616833275 (37.741788638282, -122.418616833275) 2 7 7 28859 2
49979 99473 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 600X Miramar Ave 2 Median : Cutout Tree Private 2     30 15x280   5995435.2 2093399 37.7278132105567 -122.458032376835 (37.7278132105567, -122.458032376835) 9 7 4 28861 40
58718 234516 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 90x Peralta Ave 2 Median : Yard Tree DPW 1     15 Width 10ft   6010366.95066 2100295.32111 37.7475956480377 -122.406898611185 (37.7475956480377, -122.406898611185) 2 7 7 28859 2
65583 194443 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1900 23rd St 2 Front Yard : Yard Tree Private 2     28     6012732.21441 2102858.09004 37.7547645253758 -122.398899455441 (37.7547645253758, -122.398899455441) 10 3 8 28856 29
70780 211076 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 700x Miramar Ave 2 Median : Yard Tree DPW 1     74     5995394.80602 2094076.5012 37.7296711442905 -122.458221033586 (37.7296711442905, -122.458221033586) 9 7 4 28861 40
74337 211057 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 447 Lawton St 2 Sidewalk: Curb side : Pot Tree Private 2     9 Width 3ft   5992810.26786 2104540.37946 37.7582534434534 -122.467916772063 (37.7582534434534, -122.467916772063) 1 8 4 56 12
82734 201750 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 491 Jamestown Ave 2 Sidewalk: Property side : Yard Tree Private 2     34 Width 8ft   6015853.10494 2087012.76113 37.7114298417752 -122.3870013933 (37.7114298417752, -122.3870013933) 10 3 8 58 1
87097 211066 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 500x Miramar Ave 2 Median : Yard Tree DPW 1     36     5995372.70371 2092704.86629 37.7259036953978 -122.458198208802 (37.7259036953978, -122.458198208802) 9 7 4 28861 40
92020 110148 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 90 WOODLAND AVE 2 Sidewalk: Curb side : Cutout Tree Private 2     38 4x9   5997155.9 2105983.7 37.7624664223167 -122.452991942132 (37.7624664223167, -122.452991942132) 15 5 11 29492 12
95203 141265 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 52 JORDAN AVE 2 Sidewalk: Curb side : Yard Tree Private 2     12 Width 0ft   5996227.2891 2114192.1724 37.7849514808139 -122.456797345759 (37.7849514808139, -122.456797345759) 11 6 1 54 31
96185 234523 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 90 Woodland Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     32 Width 5ft   5997132.36622 2105999.93621 37.7625096541183 -122.45307450849 (37.7625096541183, -122.45307450849) 15 5 11 29492 12
97194 24742 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 50X Point Lobos Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 12x12   5982568.63637 2112600.93828 37.7797886774071 -122.503933218017 (37.7797886774071, -122.503933218017) 11 6 2 55 26
103192 132176 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2745 Larkin St 2 Sidewalk: Property side : Yard Tree Private 2     14     6006527.83964 2120663.1294 37.8033051783476 -122.421620437537 (37.8033051783476, -122.421620437537) 5 9 1 28858 32
103781 108605 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 1140x CHESTNUT ST 2 Unaccepted Street : Yard Tree Private 2           6006369.1 2120452.7 37.8027184407042 -122.422154803739 (37.8027184407042, -122.422154803739) 5 9 1 28858 32
105484 115153 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 245x ARLINGTON ST 2 Median : Yard Tree DPW 1       3x3   6004671 2096632 37.7372166357496 -122.426334098447 (37.7372166357496, -122.426334098447) 2 7 5 63 7
106418 201754 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 2 Sidewalk: Property side : Yard Tree Private 2     15 Width 8ft   6015794.33118 2087216.37677 37.7119856767735 -122.387218726159 (37.7119856767735, -122.387218726159) 10 3 8 58 1
106870 117252 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 2500x 34TH AVE 2 Side Yard : Yard Tree SFUSD 4       3x3   5985829 2097874 37.7395437603018 -122.491570003273 (37.7395437603018, -122.491570003273) 1 8 3 29491 35
118830 211056 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1600 17th Ave 2 Sidewalk: Property side : Yard Tree Private 2     20     5990908.64637 2104472.93122 37.7579582535812 -122.474488420401 (37.7579582535812, -122.474488420401) 1 8 4 56 12
134644 12968 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 99X Lippard Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     36 4X4   6001957.7757889 2095598.483465 37.7342250957668 -122.435641023763 (37.7342250957668, -122.435641023763) 2 7 5 63 7
142225 23579 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 3100X Van Ness Ave 2 Median : Cutout Tree DPW 1     42 3x3   6005511.92719 2121098.11811 37.8044422083102 -122.425167011149 (37.8044422083102, -122.425167011149) 5 1 1 28858 32
149206 234518 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1481 Noe St 2 Sidewalk: Curb side : Pot Tree Private 2     5 Width 4ft   6003337.48877 2099628.14838 37.7453678996008 -122.431158447529 (37.7453678996008, -122.431158447529) 2 7 5 63 22
154451 178178 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 769 Cayuga Ave 2 Sidewalk: Property side : Yard Tree Private 2     4 Width 8ft   6001369.37887 2092541.7115 37.725798463024 -122.43745647446 (37.725798463024, -122.43745647446) 9 7 6 28861 25
163885 115556 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 3897 CLAY ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996199 2115222 37.7877774871206 -122.456969730492 (37.7877774871206, -122.456969730492) 11 6 1 54 31
170849 186531 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1501 Sunset Blvd 2 unknown : Yard Tree Private 2     9 Width 0ft   5984751.3064 2104919.289 37.7588251541556 -122.495815712177 (37.7588251541556, -122.495815712177) 1 8 3 56 35
176495 234508 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 201 Coso Ave 2 Side Yard : Yard Tree Private 2     28 Width 5ft   6007691.39954 2099521.32268 37.745320345265 -122.416095727735 (37.745320345265, -122.416095727735) 2 7 7 28859 2
178118 101028 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1010X Portola Dr 2 Front Yard : Yard Tree DPW 1           5995923.3 2098391.5 37.7415494342357 -122.45670592621 (37.7415494342357, -122.45670592621) 1 7 4 59 40
184680 256643 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2X Miraloma Dr 2 Side Yard : Cutout Tree DPW 1       10x10   5994995 2097925 37.7402151966004 -122.459881864698 (37.7402151966004, -122.459881864698) 9 8 4 59 40
193872 18113 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1102X PORTOLA DR 2 Median : Cutout Tree DPW 1     24 10   5995249 2098057 37.7405922403942 -122.459013196083 (37.7405922403942, -122.459013196083) 1 7 4 59 40
193997 132179 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1302 Columbus Ave 2 Sidewalk: Property side : Yard Tree Private 2     33     6007259.69894 2121860.76679 37.8066348265036 -122.419172811197 (37.8066348265036, -122.419172811197) 5 1 1 28858 32

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);