26 rows where Neighborhoods (old) = 23 and qSpecies_id = 63 sorted by qSpecies_id

View and edit SQL

Neighborhoods (old)

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)
6278 132178 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2449 Mason St 1 Sidewalk: Property side : Yard Tree Private 2     36     6008741.74811 2122071.63658 37.807297172691 -122.414058809171 (37.807297172691, -122.414058809171) 3 1 10 308 23
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
9224 132190 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1306x Montgomery St 44 Median : Yard Tree DPW 1     15 Width 8ft   6011409.46246 2120250.86119 37.802447243101 -122.40469828132 (37.802447243101, -122.40469828132) 3 1 10 308 23
26810 16373 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1400X Montgomery St 6 Median : Cutout Tree DPW 1     18 8   6011455.2971485 2120087.0441833 37.8020000032358 -122.404528131508 (37.8020000032358, -122.404528131508) 3 1 10 308 23
33573 107492 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1306x Montgomery St 21 Median : Cutout Tree DPW 1     26     6011443.89272 2119983.46704 37.8017149683182 -122.404560301033 (37.8017149683182, -122.404560301033) 3 1 10 308 23
41784 16362 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1306X Montgomery St 14 Median : Cutout Tree DPW 1     18 8   6011452.97865 2119928.00722 37.8015631969572 -122.404524953159 (37.8015631969572, -122.404524953159) 3 1 10 308 23
42925 256615 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1541x Montgomery St 1 Front Yard : Yard Tree DPW 1 DPW for City Agency         6011315 2120446 37.8029777664724 -122.405038917948 (37.8029777664724, -122.405038917948) 3 1 10 308 23
47375 132184 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1306x Montgomery St 25 Median : Yard Tree DPW 1     29 Width 8ft   6011444.3716 2120015.20461 37.8018021387065 -122.404560879294 (37.8018021387065, -122.404560879294) 3 1 10 308 23
50112 109625 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 312x FILBERT ST 1 Unaccepted Street : Yard Tree Private 2     14     6011362.9 2120079.8 37.801974948341 -122.40484736081 (37.801974948341, -122.40484736081) 3 1 10 308 23
51624 16371 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1400X Montgomery St 4 Median : Cutout Tree DPW 1     18 8   6011455.2971485 2120087.0441833 37.8020000032358 -122.404528131508 (37.8020000032358, -122.404528131508) 3 1 10 308 23
55393 16363 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1300X Montgomery St 16 Median : Cutout Tree DPW 1     12 8   6011500.9168661 2119743.0722499 37.8010580895294 -122.404346040012 (37.8010580895294, -122.404346040012) 3 1 10 308 23
61019 132188 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1306x Montgomery St 42 Median : Yard Tree DPW 1     17 Width 8ft   6011420.08981 2120201.09522 37.8023111918729 -122.404657999787 (37.8023111918729, -122.404657999787) 3 1 10 308 23
68881 16368 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1400X Montgomery St 1 Median : Cutout Tree DPW 1     26 8   6011455.2971485 2120087.0441833 37.8020000032358 -122.404528131508 (37.8020000032358, -122.404528131508) 3 1 10 308 23
70483 132187 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1306x Montgomery St 40 Median : Yard Tree DPW 1     14 Width 8ft   6011421.2833 2120182.68985 37.8022607219264 -122.404652573264 (37.8022607219264, -122.404652573264) 3 1 10 308 23
73714 132189 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1306x Montgomery St 43 Median : Yard Tree DPW 1     12 Width 8ft   6011411.36798 2120233.14388 37.8023987021982 -122.404690439238 (37.8023987021982, -122.404690439238) 3 1 10 308 23
80305 111179 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 400 NORTH POINT ST 1 Sidewalk: Curb side : Cutout Tree Private 2   03/01/2016 12:00:00 AM 3 9x6   6008572 2121805 37.806555520543 -122.414627380808 (37.806555520543, -122.414627380808) 3 1 10 308 23
85334 256616 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 1541X Montgomery St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011315 2120446 37.8029777664724 -122.405038917948 (37.8029777664724, -122.405038917948) 3 1 10 308 23
90211 96976 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 390X Filbert St 1 Median : Yard Tree Rec/Park 5     28     6010951.1 2119992.4 37.8017119430502 -122.406266229116 (37.8017119430502, -122.406266229116) 3 1 10 308 23
113826 16372 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1400X Montgomery St 5 Median : Cutout Tree DPW 1     12 8   6011455.2971485 2120087.0441833 37.8020000032358 -122.404528131508 (37.8020000032358, -122.404528131508) 3 1 10 308 23
114548 132185 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1306x Montgomery St 32 Median : Yard Tree DPW 1     31 Width 8ft   6011428.32338 2120121.70557 37.8020936674502 -122.404623915473 (37.8020936674502, -122.404623915473) 3 1 10 308 23
140100 132186 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1306x Montgomery St 34 Median : Yard Tree DPW 1     20 Width 8ft   6011427.66353 2120140.51179 37.8021452678603 -122.404627523539 (37.8021452678603, -122.404627523539) 3 1 10 308 23
140332 16374 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1400X Montgomery St 7 Median : Cutout Tree DPW 1     12 8   6011455.2971485 2120087.0441833 37.8020000032358 -122.404528131508 (37.8020000032358, -122.404528131508) 3 1 10 308 23
144960 16370 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1400X Montgomery St 3 Median : Cutout Tree DPW 1     18 8   6011455.2971485 2120087.0441833 37.8020000032358 -122.404528131508 (37.8020000032358, -122.404528131508) 3 1 10 308 23
146463 107487 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1306x Montgomery St 12 Median : Cutout Tree DPW 1     23     6011454.1798 2119912.99001 37.801522030487 -122.40451973891 (37.801522030487, -122.40451973891) 3 1 10 308 23
164190 16364 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1300X Montgomery St 17 Median : Cutout Tree DPW 1     12 8   6011500.9168661 2119743.0722499 37.8010580895294 -122.404346040012 (37.8010580895294, -122.404346040012) 3 1 10 308 23
190898 132183 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1306x Montgomery St 23 Median : Yard Tree DPW 1     26 Width 8ft   6011446.11989 2119998.19994 37.8017555457373 -122.404553631656 (37.8017555457373, -122.404553631656) 3 1 10 308 23

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