trees

37 rows where Supervisor Districts = 7, qLegalStatus_id = 7 and qSpecies_id = 53

✎ 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)
16900 485 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2706 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6010468.2249 2102315.41281 37.7531480416193 -122.406690748371 (37.7531480416193, -122.406690748371) 10 4 7 28859 19
21359 87146 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2405 Folsom St 5 Sidewalk: Curb side : Cutout Tree Private 2   01/18/2008 12:00:00 AM   3x3 Permit Number 50131 6008226 2104427 37.7588202724984 -122.414594246502 (37.7588202724984, -122.414594246502) 2 4 7 28859 19
23368 512 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2790 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6010086.59475 2102267.66488 37.7529955768562 -122.408007140426 (37.7529955768562, -122.408007140426) 2 4 7 28859 19
32305 173934 Permitted Site 7 Ficus nitida :: Laurel Fig 53 614 Alabama St 4 Sidewalk: Curb side : Cutout Tree Private 2       9x9   6008960.61704517 2105361.82717089 37.7614283394777 -122.412119658359 (37.7614283394777, -122.412119658359) 2 4 7 28859 19
32689 108945 Permitted Site 7 Ficus nitida :: Laurel Fig 53 105 Richland Ave 4 Sidewalk: Curb side : Cutout Tree Private 2           6005294.9 2096235.5 37.7361631827636 -122.424148798432 (37.7361631827636, -122.424148798432) 2 7 7 28859 2
34217 575 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3007 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3X3   6008864.65035 2102095.7164 37.7524549543286 -122.41222072227 (37.7524549543286, -122.41222072227) 2 4 7 28859 19
43945 573 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2990 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3 Permit Number 776380 6009007.86528 2102243.77418 37.7528695228517 -122.411735919997 (37.7528695228517, -122.411735919997) 2 4 7 28859 19
55414 61158 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3347 20TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/29/1983 12:00:00 AM 12 5x5 Permit Number 21016 6007930.5 2104397.2 37.758721842404 -122.415614115387 (37.758721842404, -122.415614115387) 2 4 7 28859 19
64328 44245 Permitted Site 7 Ficus nitida :: Laurel Fig 53 10 Brewster St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/30/2001 12:00:00 AM     Permit Number 43680 6010447.16728471 2099896.56831072 37.7465052482739 -122.406593130128 (37.7465052482739, -122.406593130128) 2 7 7 28859 2
64711 488 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2728 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3X3   6010357.12636 2102291.83707 37.7530770912847 -122.407073289419 (37.7530770912847, -122.407073289419) 10 4 7 28859 19
70728 504 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2763 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6010225.39225 2102202.2647 37.7528237725585 -122.407522539236 (37.7528237725585, -122.407522539236) 2 4 7 28859 19
71942 50566 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2295 Folsom St 9 Sidewalk: Curb side : Cutout Tree Private 2   11/18/2003 12:00:00 AM     Permit Number 47188 6008194 2105070 37.7605840051662 -122.414750422926 (37.7605840051662, -122.414750422926) 2 4 7 28859 19
76306 108943 Permitted Site 7 Ficus nitida :: Laurel Fig 53 105 Richland Ave 2 Sidewalk: Curb side : Cutout Tree Private 2           6005294.9 2096235.5 37.7361631827636 -122.424148798432 (37.7361631827636, -122.424148798432) 2 7 7 28859 2
76742 594 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3056 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6008579.28838 2102218.52685 37.7527761477761 -122.413216238549 (37.7527761477761, -122.413216238549) 2 4 7 28859 19
78273 45427 Permitted Site 7 Ficus nitida :: Laurel Fig 53 614 Alabama St 3 Sidewalk: Curb side : Cutout Tree Private 2   07/12/2001 12:00:00 AM   9x9 Permit Number 44218 6008960.61704517 2105361.82717089 37.7614283394777 -122.412119658359 (37.7614283394777, -122.412119658359) 2 4 7 28859 19
89426 65007 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1849 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/13/1989 12:00:00 AM 18 3x3 Permit Number 26048 6008683.18209706 2107760.52572873 37.7679990416006 -122.413248823154 (37.7679990416006, -122.413248823154) 8 4 7 28853 19
90722 56236 Permitted Site 7 Ficus nitida :: Laurel Fig 53 147 Bartlett St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/20/1973 12:00:00 AM 24   Permit Number 12362 6006719.97734959 2102927.77810186 37.7546190293471 -122.419696406291 (37.7546190293471, -122.419696406291) 2 4 7 28859 19
103831 58284 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1528 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/21/1978 12:00:00 AM   4x4 Permit Number 17298 6007189.64621742 2107366.09742219 37.7668320707182 -122.418386841574 (37.7668320707182, -122.418386841574) 8 4 7 28853 19
111614 87145 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2405 Folsom St 4 Sidewalk: Curb side : Cutout Tree Private 2   01/18/2008 12:00:00 AM   3x3 Permit Number 50131 6008226 2104427 37.7588202724984 -122.414594246502 (37.7588202724984, -122.414594246502) 2 4 7 28859 19
111853 99974 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2295 Folsom St 12 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 47188 6008194 2105070 37.7605840051662 -122.414750422926 (37.7605840051662, -122.414750422926) 2 4 7 28859 19
115348 50571 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2295 Folsom St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/18/2003 12:00:00 AM     Permit Number 47188 6008194 2105070 37.7605840051662 -122.414750422926 (37.7605840051662, -122.414750422926) 2 4 7 28859 19
118796 65046 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2498 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/19/1989 12:00:00 AM 18   Permit Number 26099 6008837.93100399 2103923.47328543 37.7574720629103 -122.412442306383 (37.7574720629103, -122.412442306383) 2 4 7 28859 19
121361 506 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2773 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6010149.8233 2102141.49518 37.7526526827318 -122.407779587097 (37.7526526827318, -122.407779587097) 2 4 7 28859 19
132675 45428 Permitted Site 7 Ficus nitida :: Laurel Fig 53 614 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/12/2001 12:00:00 AM     Permit Number 44218 6008960.61704517 2105361.82717089 37.7614283394777 -122.412119658359 (37.7614283394777, -122.412119658359) 2 4 7 28859 19
133311 26518 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2881 Harrison St 2 Sidewalk: Curb side : Cutout Tree Private 2     30 3X3   6009034.88918 2101730.9691 37.7514629908808 -122.411606237117 (37.7514629908808, -122.411606237117) 2 4 7 28859 19
140677 68840 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1506 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/09/1993 12:00:00 AM     Permit Number 32793 6009553.56622839 2100554.07443475 37.7482605801949 -122.4097295193 (37.7482605801949, -122.4097295193) 2 4 7 28859 2
142433 486 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2708 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6010515.41751 2102258.44338 37.7529942564805 -122.406523532023 (37.7529942564805, -122.406523532023) 10 4 7 28859 19
145968 45426 Permitted Site 7 Ficus nitida :: Laurel Fig 53 614 Alabama St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/12/2001 12:00:00 AM   9x9 Permit Number 44218 6008960.61704517 2105361.82717089 37.7614283394777 -122.412119658359 (37.7614283394777, -122.412119658359) 2 4 7 28859 19
152589 510 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2781 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6010149.8233 2102141.49518 37.7526526827318 -122.407779587097 (37.7526526827318, -122.407779587097) 2 4 7 28859 19
164080 570 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2972 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6009057.78841 2102246.54845 37.7528799408325 -122.411563471864 (37.7528799408325, -122.411563471864) 2 4 7 28859 19
165793 39111 Permitted Site 7 Ficus nitida :: Laurel Fig 53 145 Bartlett St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/19/1998 12:00:00 AM 20   Permit Number 40799 6006719.36046982 2102938.94159671 37.7546496469874 -122.41969933167 (37.7546496469874, -122.41969933167) 2 4 7 28859 19
169220 94550 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2851 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2     24 6x5   6009753.55231 2102181.05227 37.7527391057434 -122.40915275887 (37.7527391057434, -122.40915275887) 2 4 7 28859 19
172669 87144 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2405 Folsom St 3 Sidewalk: Curb side : Cutout Tree Private 2   01/18/2008 12:00:00 AM   3x3 Permit Number 50131 6008226 2104427 37.7588202724984 -122.414594246502 (37.7588202724984, -122.414594246502) 2 4 7 28859 19
172873 33586 Permitted Site 7 Ficus nitida :: Laurel Fig 53 248 Bonview St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/11/2006 12:00:00 AM   3x3 Permit Number 48813 6006863.32350459 2097675.63643968 37.7402059100197 -122.418828210102 (37.7402059100197, -122.418828210102) 2 7 7 28859 2
173070 50573 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2295 Folsom St 10 Sidewalk: Curb side : Cutout Tree Private 2   11/18/2003 12:00:00 AM     Permit Number 47188 6008194 2105070 37.7605840051662 -122.414750422926 (37.7605840051662, -122.414750422926) 2 4 7 28859 19
178044 48952 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3046 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/26/2002 12:00:00 AM 28   Permit Number 46137 6008657.12939462 2102169.92315078 37.7526470627455 -122.412943613067 (37.7526470627455, -122.412943613067) 2 4 7 28859 19
179971 634 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3194 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2     21 3X3   6007781.42285 2102140.57786 37.7525172919755 -122.415969890792 (37.7525172919755, -122.415969890792) 2 4 7 28859 19

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