trees

26 rows where SiteOrder = 2 and qLegalStatus_id = 8 sorted by DBH

✎ 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)
3739 261012 Property Tree 8 Pinus canariensis :: Canary Island Pine 35 170 Otis St 2 Front Yard : Cutout Tree Private 2       3x3   6006561 2108839 37.7708409033816 -122.420665800575 (37.7708409033816, -122.420665800575) 8 2 9 28853 19
7863 260451 Property Tree 8 Myoporum laetum :: Myoporum 62 3554 Alemany Blvd 2 unknown : Yard Tree Private 2       3x3   5993855 2087505 37.7115387848875 -122.463067653224 (37.7115387848875, -122.463067653224) 9 8 6 64 24
13403 261178 Property Tree 8 Phoenix canariensis :: Canary Island Date Palm 160 205 Leland Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009827 2087549 37.7125667222905 -122.407867055005 (37.7125667222905, -122.407867055005) 9 7 8 309 39
17872 258685 Property Tree 8 Metrosideros excelsa :: New Zealand Xmas Tree 16 100x Whitney Young Cir 2 Sidewalk: Curb side : Yard Tree SFUSD 4       3x3   6016360 2096059 37.7362970999571 -122.385879567348 (37.7362970999571, -122.385879567348) 10 3 8 58 1
20715 99276 Property Tree 8 Tree(s) :: 17 85X 10th St 2 Front Yard : Yard Tree Private 2   04/25/2012 12:00:00 AM     Permit Number 768878 6007907.6 2110517 37.7755240963356 -122.416126724722 (37.7755240963356, -122.416126724722) 8 2 9 28853 34
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
31670 104539 Property Tree 8 Juniperus chinensis :: Juniper 113 1101 Van Ness Ave 2 Front Yard : Yard Tree Private 2           6006375.5 2114401.9 37.7861048214583 -122.421702631224 (37.7861048214583, -122.421702631224) 13 9 11 28858 41
54121 101901 Property Tree 8 Metrosideros excelsa :: New Zealand Xmas Tree 16 1100 Ocean Ave 2 Front Yard : Yard Tree DPW 1         Permit Number 769623 5996507.7 2092470.2 37.7253245106519 -122.454257683967 (37.7253245106519, -122.454257683967) 9 7 4 28861 40
56515 102470 Property Tree 8 Pinus radiata :: Monterey Pine 15 1021 Kirkham St 2 Back Yard : Yard Tree Private 2           5991773 2105198 37.7599991432047 -122.471551983129 (37.7599991432047, -122.471551983129) 1 8 4 56 12
75714 114950 Property Tree 8 Pinus radiata :: Monterey Pine 15 1X WOODACRE DR 2 unknown : Yard Tree DPW 1       30x100   5991187 2095315 37.7328290635508 -122.472857998502 (37.7328290635508, -122.472857998502) 1 8 4 64 40
80950 255115 Property Tree 8 Lophostemon confertus :: Brisbane Box 11 301X Chester Ave 2 Sidewalk: Property side : Cutout Tree Private 2       10x10   5991786 2087190 37.7105544703116 -122.470195673297 (37.7105544703116, -122.470195673297) 9 8 4 64 24
84676 109375 Property Tree 8 Populus nigra 'Italica' :: Lombardy Poplar 59 111 BAY ST 2 Back Yard : Yard Tree Private 2           6010193.2 2121519.2 37.8058617340589 -122.408996713259 (37.8058617340589, -122.408996713259) 3 1 10 308 23
92957 257936 Property Tree 8 Pinus radiata :: Monterey Pine 15 375 Woodside Ave 2 Sidewalk: Curb side : Yard Tree Private 2       3x3   5997267 2099886 37.7457300260474 -122.452167701039 (37.7457300260474, -122.452167701039) 1 5 4 59 38
95526 100139 Property Tree 8 Tree(s) :: 17 155 05th St 2 Front Yard : Yard Tree Private 2         Permit Number 769024 6011029.6 2112857.4 37.7821253339557 -122.405491786923 (37.7821253339557, -122.405491786923) 12 2 9 28853 34
96626 91109 Property Tree 8 Tree(s) :: 17 2650 Turk Blvd 2 Front Yard : Yard Tree Private 2       On campus   5998086.4 2111055.5 37.7764455713486 -122.450139282915 (37.7764455713486, -122.450139282915) 15 6 2 29492 16
103773 252839 Property Tree 8 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 99 Pond St 2 Sidewalk: Property side : Yard Tree Private 2           6003330 2106021 37.7629207320267 -122.431640673814 (37.7629207320267, -122.431640673814) 15 4 5 28862 3
108303 102249 Property Tree 8 Olea europaea :: Olive Tree 9 125X Powhattan Ave 2 Front Yard : Yard Tree Private 2   01/07/2013 12:00:00 AM     Permit Number 768486 6007606 2098071 37.7413332800665 -122.416288322592 (37.7413332800665, -122.416288322592) 2 7 7 28859 2
136363 252834 Property Tree 8 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 98 Prosper St 2 Sidewalk: Property side : Cutout Tree Private 2           6003330 2106021 37.7629207320267 -122.431640673814 (37.7629207320267, -122.431640673814) 15 4 5 28862 3
163643 253143 Property Tree 8 Juniperus silicicola :: Southern red cedar 429 735 29th Ave 2 Sidewalk: Property side : Cutout Tree Private 2       3x3   5986898 2110914 37.7754104499772 -122.488832209773 (37.7754104499772, -122.488832209773) 11 6 2 55 26
137355 115636 Property Tree 8 Pinus radiata :: Monterey Pine 15 81x ELSIE ST 2 Back Yard : Cutout Tree DPW 1     16 3x3   6007403 2098902 37.7436036039275 -122.417049094013 (37.7436036039275, -122.417049094013) 2 7 7 28859 2
154580 224422 Property Tree 8 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3255x 24th St 2 Front Yard : Cutout Tree MTA 3     16 Width 3ft   6007298 2102020 37.7521590216883 -122.417633107694 (37.7521590216883, -122.417633107694) 2 4 7 28859 19
149052 105232 Property Tree 8 Pinus radiata :: Monterey Pine 15 460X ROOSEVELT WAY 2 Front Yard : Yard Tree Private 2     17     5999944 2106286 37.7634558498539 -122.443370673769 (37.7634558498539, -122.443370673769) 15 5 5 29492 3
129765 105353 Property Tree 8 Tree(s) :: 17 1979 SAN JOSE AVE 2 Front Yard : Yard Tree Private 2   04/16/2014 12:00:00 AM 27   Permit Number 772405 5999886.5 2092393.4 37.7253068164695 -122.442572018552 (37.7253068164695, -122.442572018552) 9 7 6 28861 25
54368 33775 Property Tree 8 Magnolia grandiflora :: Southern Magnolia 19 200x Mission St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2015 12:00:00 AM 3 3x3 Permit Number 770804 6014138 2116340 37.7918610639158 -122.394982044679 (37.7918610639158, -122.394982044679) 12 2 9 28855 6
176971 256553 Property Tree 8 Acer rubrum :: Red Maple 75 3401X 16th St 2 Side Yard : Yard Tree SFUSD 4   02/08/2019 09:24:00 AM 3 3x3   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
33251 105685 Property Tree 8 Ficus microcarpa :: Chinese Banyan 97 635 08TH ST 2 Front Yard : Pot Tree Private 2     8     6011418.5 2109097.9 37.7718243537934 -122.403881727597 (37.7718243537934, -122.403881727597) 14 2 9 28853 34

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