trees

32 rows where SiteOrder = 2 and qSpecies_id = 12

✎ View and edit SQL

This data as json, CSV (advanced)

These facets timed out: 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)
15 264849 DPW Maintained 1 Tilia cordata :: Littleleaf Linden 12 15 Hale St 2 Sidewalk: Curb side : Cutout Tree DPW 1   11/01/2020 12:00:00 AM 3     6010381 2094903 37.7327902820185 -122.40647012075 (37.7327902820185, -122.40647012075) 10 3 7 309 28
2213 261044 Significant Tree 6 Tilia cordata :: Littleleaf Linden 12 499x Howard St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/10/2019 12:00:00 AM 3 3x3   6014038 2115260 37.7888900740934 -122.39525236007 (37.7888900740934, -122.39525236007) 6 2 9 28855 6
6884 259077 DPW Maintained 1 Tilia cordata :: Littleleaf Linden 12 1000 Visitacion Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   06/01/2019 12:00:00 AM 3                        
10107 259081 DPW Maintained 1 Tilia cordata :: Littleleaf Linden 12 1001 Visitacion Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   06/01/2019 12:00:00 AM 3                        
13327 197932 DPW Maintained 1 Tilia cordata :: Littleleaf Linden 12 218 Beale St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 6ft   6014511.51685 2115383.38885 37.7892551941278 -122.393622683336 (37.7892551941278, -122.393622683336) 6 2 9 28855 6
16235 112148 Undocumented 4 Tilia cordata :: Littleleaf Linden 12 101X 05TH ST 2 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     10 3x3   6010794 2113100 37.782778280213 -122.406323959165 (37.782778280213, -122.406323959165) 12 2 9 28853 34
17788 254246 DPW Maintained 1 Tilia cordata :: Littleleaf Linden 12 100x Beale St 2 Sidewalk: Curb side : Cutout Tree DPW 1   02/13/2018 12:00:00 AM 3                        
25972 121523 Planning Code 138.1 required 2 Tilia cordata :: Littleleaf Linden 12 280 Beale St 2 Sidewalk: Curb side : Cutout Tree Private 2       6x10   6014751 2115177 37.7887018021562 -122.392779649259 (37.7887018021562, -122.392779649259) 6 2 9 28855 6
37313 49455 DPW Maintained 1 Tilia cordata :: Littleleaf Linden 12 548 Brannan St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/02/2003 12:00:00 AM 6 3x3 Permit Number 46389 6013246.33649 2111139.83952 37.7775330042846 -122.39770232023 (37.7775330042846, -122.39770232023) 6 2 9 28856 34
38525 197926 DPW Maintained 1 Tilia cordata :: Littleleaf Linden 12 274 Main St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6014867.69164 2115525.84421 37.7896661285247 -122.392400319429 (37.7896661285247, -122.392400319429) 6 2 9 28855 6
40138 121526 Planning Code 138.1 required 2 Tilia cordata :: Littleleaf Linden 12 333 Beale St 2 Sidewalk: Curb side : Cutout Tree Private 2       6x10   6015114 2115064 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663) 6 2 9 28855 6
40312 197971 DPW Maintained 1 Tilia cordata :: Littleleaf Linden 12 90 04th St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6011459.89889 2113592.30017 37.7841672481653 -122.404054873931 (37.7841672481653, -122.404054873931) 12 2 9 28853 34
42591 197967 DPW Maintained 1 Tilia cordata :: Littleleaf Linden 12 153 05th St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6010879.01966 2113009.66156 37.7825349876424 -122.406023459311 (37.7825349876424, -122.406023459311) 12 2 9 28853 34
45003 197963 DPW Maintained 1 Tilia cordata :: Littleleaf Linden 12 530 Brannan St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6013370.97049 2111262.30601 37.7778762089677 -122.397279756668 (37.7778762089677, -122.397279756668) 6 2 9 28856 34
48369 256770 Undocumented 4 Tilia cordata :: Littleleaf Linden 12 300X Octavia St 2 Median : Cutout Tree Private 2       3x3   6005602 2110303 37.774806598562 -122.424087136382 (37.774806598562, -122.424087136382) 7 9 11 28852 10
53766 83269 Permitted Site 7 Tilia cordata :: Littleleaf Linden 12 2501 19th St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/20/2009 12:00:00 AM   3x3 Permit Number 52646 6010408.33356272 2105026.32367828 37.7605882462434 -122.407088935203 (37.7605882462434, -122.407088935203) 10 4 8 28859 19
62007 51401 DPW Maintained 1 Tilia cordata :: Littleleaf Linden 12 423 Tehama St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/15/2017 12:00:00 AM 3 3x3 Permit Number 774507 6011161.37558 2112281.69407 37.7805519474533 -122.404995352556 (37.7805519474533, -122.404995352556) 14 2 9 28853 34
62557 136739 DPW Maintained 1 Tilia cordata :: Littleleaf Linden 12 48 Osgood Pl 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 2ft   6011886.33726 2118519.22734 37.7977192373121 -122.402926186096 (37.7977192373121, -122.402926186096) 3 1 10 308 23
63000 197955 DPW Maintained 1 Tilia cordata :: Littleleaf Linden 12 355 Beale St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 5ft   6014952.39535 2115030.72864 37.7883113583401 -122.392072611873 (37.7883113583401, -122.392072611873) 6 2 9 28855 6
83512 197964 DPW Maintained 1 Tilia cordata :: Littleleaf Linden 12 542 Brannan St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6013328.41225 2111219.96647 37.777757584773 -122.397424011506 (37.777757584773, -122.397424011506) 6 2 9 28856 34
85936 91212 Permitted Site 7 Tilia cordata :: Littleleaf Linden 12 2901 Mission St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2009 12:00:00 AM   3x3 Permit Number 52044 6007111 2101465 37.7506245935345 -122.41824043827 (37.7506245935345, -122.41824043827) 2 4 7 28859 19
86809 250931 DPW Maintained 1 Tilia cordata :: Littleleaf Linden 12 263 28th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     6 Width 4ft   5987106.46019 2114196.92222 37.7844365852323 -122.488352423026 (37.7844365852323, -122.488352423026) 11 6 1 55 33
87447 241172 DPW Maintained 1 Tilia cordata :: Littleleaf Linden 12 29 Levant St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6000269.35575 2106710.14367 37.7646389915166 -122.442275826165 (37.7646389915166, -122.442275826165) 15 5 5 28862 3
87448 197940 DPW Maintained 1 Tilia cordata :: Littleleaf Linden 12 351 Main St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6015409.43942 2115059.04086 37.7884144620023 -122.39049328005 (37.7884144620023, -122.39049328005) 6 2 9 28855 6
91367 104739 Undocumented 4 Tilia cordata :: Littleleaf Linden 12 200X Fair Oaks St 2 Sidewalk: Curb side : Cutout Tree Private 2         On the 23rd St Side of property 6005413 2102541 37.753483315938 -122.424188782445 (37.753483315938, -122.424188782445) 2 4 5 28859 19
107947 28499 DPW Maintained 1 Tilia cordata :: Littleleaf Linden 12 270 06th St 2 Sidewalk: Curb side : Cutout Tree DPW 1     8 3X3   6010842.7805 2111615.69591 37.7787054576155 -122.406050597275 (37.7787054576155, -122.406050597275) 14 2 9 28853 34
115101 241168 DPW Maintained 1 Tilia cordata :: Littleleaf Linden 12 3387 25th St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6007165.54985 2101454.26646 37.7505981920648 -122.418051039151 (37.7505981920648, -122.418051039151) 2 4 7 28859 19
123127 34776 Permitted Site 7 Tilia cordata :: Littleleaf Linden 12 1148 Shotwell St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/28/1997 12:00:00 AM   4x4 Permit Number 38417 6008035.00461404 2101235.83901924 37.7500473368591 -122.415028926905 (37.7500473368591, -122.415028926905) 2 4 7 28859 19
126102 197948 DPW Maintained 1 Tilia cordata :: Littleleaf Linden 12 375 Beale St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 5ft   6015157.51241 2114808.67556 37.7877130375663 -122.391347405751 (37.7877130375663, -122.391347405751) 6 2 9 28855 6
130472 197923 DPW Maintained 1 Tilia cordata :: Littleleaf Linden 12 100 Beale St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/24/2019 12:00:00 AM 3 Width 5ft   6013948.03305 2115996.75839 37.7909080374275 -122.395615276145 (37.7909080374275, -122.395615276145) 12 2 9 28855 6
140184 255996 DPW Maintained 1 Tilia cordata :: Littleleaf Linden 12 276 Main St 2 Sidewalk: Curb side : Cutout Tree Private 2       Width 2ft   6014937.43234 2115453.8839 37.7894724145659 -122.392153987042 (37.7894724145659, -122.392153987042) 6 2 9 28855 6
191478 197936 DPW Maintained 1 Tilia cordata :: Littleleaf Linden 12 220 Beale St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 6ft   6014628.26894 2115262.57971 37.7889299668815 -122.393210274953 (37.7889299668815, -122.393210274953) 6 2 9 28855 6

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