trees

29 rows where DBH = 10 and qSpecies_id = 65 sorted by PlotSize

✎ View and edit SQL

This data as json, CSV (advanced)

SiteOrder ✖

DBH ✖

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)
8943 73896 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 800 Excelsior Ave 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF   10     6004393.10182 2091444.69797 37.7229577492801 -122.426925586868 (37.7229577492801, -122.426925586868) 9 7 6 28861 5
21660 65231 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 812 Silliman St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/24/1989 12:00:00 AM 10   Permit Number 28018 6008328.075 2093605.15348 37.7291116131036 -122.41347586773 (37.7291116131036, -122.41347586773) 9 3 7 309 28
183302 37071 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1426 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/15/1998 12:00:00 AM 10   Permit Number 39847 5982798.7178 2105383.4209 37.7599849826858 -122.502602909857 (37.7599849826858, -122.502602909857) 1 8 3 56 35
77808 104992 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2423 47TH AVE 1 Sidewalk: Curb side : Yard Tree Private 2   01/14/2016 12:00:00 AM 10 2x6 Permit Number 775156 5981729.7 2098576.9 37.7412333126477 -122.505795454359 (37.7412333126477, -122.505795454359) 1 8 3 29491 35
93586 102654 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 203X Farallones St 3 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   5995004 2088355 37.7139388056528 -122.459157943572 (37.7139388056528, -122.459157943572) 9 8 6 28861 24
117746 109922 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 20 Dashiell Hammett St 4 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6010385.90065 2115990.02467 37.7906907621072 -122.407939683476 (37.7906907621072, -122.407939683476) 5 1 10 28857 21
186443 83009 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 622 De Haro St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/02/2009 12:00:00 AM 10 3x3 Permit Number 52378 6012068.99141 2105489.95153 37.7619540583423 -122.401378022995 (37.7619540583423, -122.401378022995) 10 3 8 28856 29
187229 83487 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2051 44th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/23/2008 12:00:00 AM 10 3x3 Permit Number 50156 5982589.2289 2101159.5488 37.7483751044578 -122.503014711943 (37.7483751044578, -122.503014711943) 1 8 3 29491 35
158774 83067 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 624 De Haro St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/02/2009 12:00:00 AM 10 3x6 Permit Number 52379 6012068.69574 2105475.40084 37.7619140888872 -122.401378022999 (37.7619140888872, -122.401378022999) 10 3 8 28856 29
181359 107593 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1801 Anza St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 4x6   5993030.37815 2112040.04561 37.7788582423825 -122.467700965505 (37.7788582423825, -122.467700965505) 11 6 2 54 11
185738 139916 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1000 LAGUNA ST 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   6004814.4523 2112350.3862 37.7803837224117 -122.426957277261 (37.7803837224117, -122.426957277261) 7 9 11 28852 41
182873 125555 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 22 Dashiell Hammett St 4 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 1ft   6010375.3917 2116064.19944 37.7908938398292 -122.40798127711 (37.7908938398292, -122.40798127711) 5 1 10 28857 21
35034 221861 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 246 Chenery St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 2ft   6004637.65749 2096950.59035 37.7380895280136 -122.426472056954 (37.7380895280136, -122.426472056954) 2 7 5 63 7
38326 221845 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 19 Saint Marys Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 2ft   6004371.42755 2095618.1193 37.7344158100226 -122.427297656166 (37.7344158100226, -122.427297656166) 2 7 5 28861 25
95747 221850 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 19 Saint Marys Ave 6 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 2ft   6004464.56621 2095558.73638 37.7342580248697 -122.426971417216 (37.7342580248697, -122.426971417216) 2 7 5 28861 25
119492 203554 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 209 Farallones St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 2ft   5994942.92929 2088379.09284 37.7140014477918 -122.459370769157 (37.7140014477918, -122.459370769157) 9 8 6 28861 24
160387 203556 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 209 Farallones St 3 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 2ft   5994991.30881 2088378.07982 37.7140014477822 -122.45920347906 (37.7140014477822, -122.45920347906) 9 8 6 28861 24
166822 221848 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 19 Saint Marys Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 2ft   6004429.19741 2095585.11426 37.7343284525969 -122.427095576708 (37.7343284525969, -122.427095576708) 2 7 5 28861 25
168312 175182 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 647 Edinburgh St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 2ft   6002406.62971 2090005.70634 37.718894076269 -122.433689610108 (37.718894076269, -122.433689610108) 9 7 6 28861 5
172356 175209 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 9 Athens St 5 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 2ft   6005385.77988 2093250.96165 37.7279734338052 -122.423622458831 (37.7279734338052, -122.423622458831) 9 7 6 28861 5
183128 175208 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 9 Athens St 3 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 2ft   6005371.81589 2093231.88981 37.727920278496 -122.423669377345 (37.727920278496, -122.423669377345) 9 7 6 28861 5
21664 175212 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 87x Valmar Ter 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6005258.73549 2092540.80848 37.7260163372638 -122.424011175489 (37.7260163372638, -122.424011175489) 9 7 7 309 5
42770 221831 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 569 Capp St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6007292.05586 2104018.90213 37.7576472149557 -122.417795338504 (37.7576472149557, -122.417795338504) 2 4 7 28859 19
71659 221855 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 310 Hoffman Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6000611.21677 2101947.64163 37.7515818030572 -122.440751776575 (37.7515818030572, -122.440751776575) 2 4 5 28862 22
85330 221801 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 378 Valley St 3 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6003412.45231 2099242.88691 37.7443143087709 -122.430871746349 (37.7443143087709, -122.430871746349) 2 7 5 63 22
172281 203590 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 120 Judson Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   5999238.54402 2093513.75556 37.7283460957772 -122.444892431558 (37.7283460957772, -122.444892431558) 9 7 4 28861 40
10220 221824 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 199X Ogden Ave 10 Sidewalk: Curb side : Pot Tree Private 2     10 Width 4ft   6007730.82531 2096150.27006 37.7360663969372 -122.415720751814 (37.7360663969372, -122.415720751814) 2 7 7 28859 2
46734 125549 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1445 Greenwich St 7 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   6006015.52243 2119649.2025 37.8004922923456 -122.423321211112 (37.8004922923456, -122.423321211112) 13 9 1 28858 32
16727 227695 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 4250 21st St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 5ft   6001245.67427 2103366.3123 37.7555132424609 -122.438659390527 (37.7555132424609, -122.438659390527) 2 4 5 28862 3

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