trees

24 rows where Police Districts = 5, qLegalStatus_id = 8 and qSiteInfo = "Back Yard : Yard"

✎ View and edit SQL

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)
628 256542 Property Tree 8 Pinus radiata :: Monterey Pine 15 133 Olympia Way 1 Back Yard : Yard Tree Private 2       3x3   5996852 2101844 37.7510824274474 -122.453744067192 (37.7510824274474, -122.453744067192) 1 5 4 63 38
4239 258982 Property Tree 8 Pinus radiata :: Monterey Pine 15 239 Panorama Dr 1 Back Yard : Yard Tree Private 2       3x3   5997275 2101153 37.7492093542443 -122.452231443092 (37.7492093542443, -122.452231443092) 1 5 4 63 38
6585 260539 Property Tree 8 Pinus radiata :: Monterey Pine 15 1230 Twin Peaks Blvd 1 Back Yard : Yard Tree Private 2       3x3   5997905 2100119 37.7464063138276 -122.449978390477 (37.7464063138276, -122.449978390477) 2 5 4 63 38
15601 99374 Property Tree 8 Pinus radiata :: Monterey Pine 15 21 Panorama Dr   Back Yard : Yard Tree Private 2     24     5998009 2100230 37.7467170430405 -122.449626769288 (37.7467170430405, -122.449626769288) 1 5 4 63 38
28314 256608 Property Tree 8 Pinus radiata :: Monterey Pine 15 279 Oak Park Dr 2 Back Yard : Yard Tree Private 2       10x10   5995764 2102990 37.7541666190925 -122.457589367448 (37.7541666190925, -122.457589367448) 1 5 4 63 12
30200 98503 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 208 Glenview Dr   Back Yard : Yard Tree Private 2           5998871 2100779 37.7482737407191 -122.446685565827 (37.7482737407191, -122.446685565827) 2 5 5 63 38
45129 98465 Property Tree 8 Tree(s) :: 17 190 Portola Dr   Back Yard : Yard Landscaping Private 2           5999550.3 2100620.3 37.7478767693988 -122.444325170302 (37.7478767693988, -122.444325170302) 2 5 5 63 38
54211 98502 Property Tree 8 Tree(s) :: 17 244 Glenview Dr   Back Yard : Yard Landscaping Private 2           5999066 2100737 37.7481695560511 -122.446008243376 (37.7481695560511, -122.446008243376) 2 5 5 63 38
87678 254111 Property Tree 8 Pinus radiata :: Monterey Pine 15 279 Oak Park Dr 1 Back Yard : Yard Tree Private 2       10x10   5995764 2102990 37.7541666190925 -122.457589367448 (37.7541666190925, -122.457589367448) 1 5 4 63 12
89545 256543 Property Tree 8 Pinus radiata :: Monterey Pine 15 139 Olympia Way 1 Back Yard : Yard Tree Private 2       3x3   5996818 2101849 37.7510942069084 -122.453862003079 (37.7510942069084, -122.453862003079) 1 5 4 63 38
90504 98893 Property Tree 8 Tree(s) :: 17 216 Glenview Dr   Back Yard : Yard Landscaping Private 2           5998910 2100761 37.7482265448319 -122.446549410607 (37.7482265448319, -122.446549410607) 2 5 5 63 38
92154 97177 Property Tree 8 Tree(s) :: 17 257 Roosevelt Way   Back Yard : Yard Tree Private 2         Monterey cypress tree in backyard on private property; not a Significant tree 6000848.1 2107127.9 37.7658190148973 -122.440304070451 (37.7658190148973, -122.440304070451) 15 5 5 28862 3
99841 98436 Property Tree 8 Tree(s) :: 17 238 Glenview Dr   Back Yard : Yard Tree Private 2           5999035 2100736 37.7481650400364 -122.446115368035 (37.7481650400364, -122.446115368035) 2 5 5 63 38
101829 257926 Property Tree 8 Pinus radiata :: Monterey Pine 15 8 Hill Point Ave 1 Back Yard : Yard Tree Private 2       3x3   5996384 2106804 37.7646744896132 -122.455720942569 (37.7646744896132, -122.455720942569) 15 5 11 29492 12
105747 98892 Property Tree 8 Tree(s) :: 17 220 Glenview Dr   Back Yard : Yard Landscaping Private 2           5998935 2100753 37.7482060067302 -122.44646238624 (37.7482060067302, -122.44646238624) 2 5 5 63 38
113384 98890 Property Tree 8 Tree(s) :: 17 256 Glenview Dr   Back Yard : Yard Landscaping Private 2           5999134 2100748 37.7482036421854 -122.44577389345 (37.7482036421854, -122.44577389345) 2 5 5 63 38
113507 253768 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 100 Raccoon Dr 1 Back Yard : Yard Tree Private 2           5998692 2104165 37.7575606372552 -122.447548237739 (37.7575606372552, -122.447548237739) 15 5 5 28862 3
116904 105236 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 235X STATES ST 1 Back Yard : Yard Tree Private 2     30     6001213 2106258 37.7634512529938 -122.438979613423 (37.7634512529938, -122.438979613423) 15 5 5 28862 3
134313 255008 Property Tree 8 Pittosporum undulatum :: Victorian Box 36 1 Villa Ter 1 Back Yard : Yard Tree Private 2       3x3   5998933 2105018 37.7599165333482 -122.446776141106 (37.7599165333482, -122.446776141106) 15 5 5 28862 12
137488 98501 Property Tree 8 Tree(s) :: 17 232 Glenview Dr   Back Yard : Yard Landscaping Private 2           5998998 2100740 37.7481739100487 -122.446243600021 (37.7481739100487, -122.446243600021) 2 5 5 63 38
155860 96938 Property Tree 8 Tree(s) :: 17 1306 Cole St   Back Yard : Yard Tree Private 2         Backyard tree on private property 5998246 2105961 37.7624665052811 -122.449220068104 (37.7624665052811, -122.449220068104) 15 5 11 29492 9
163139 112668 Property Tree 8 Pinus radiata :: Monterey Pine 15 129 Henry St   Back Yard : Yard Tree Private 2           6002668 2107340.8 37.7665070360696 -122.434024647923 (37.7665070360696, -122.434024647923) 15 5 5 28862 3
179317 103673 Property Tree 8 :: 45 64 Henry St   Back Yard : Yard Tree Private 2           6003097 2107420 37.7667488371496 -122.432546472662 (37.7667488371496, -122.432546472662) 15 5 5 28862 3
192149 98878 Property Tree 8 Tree(s) :: 17 11 Panorama Dr   Back Yard : Yard Landscaping Private 2           5998029 2100213 37.7466715093679 -122.449556386849 (37.7466715093679, -122.449556386849) 2 5 4 63 38

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