24 rows where SiteOrder = 9 and qSpecies_id = 5

View and edit SQL

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)
372 189871 DPW Maintained 1 Ceratonia siliqua :: Carob 5 400 Newhall St 9 : Tree Private 2     7 Width 3ft   6016028.58203 2097927.48174 37.7414092251604 -122.387155715173 (37.7414092251604, -122.387155715173) 10 3 8 58 1
438 16548 Permitted Site 7 Ceratonia siliqua :: Carob 5 400X Newhall St 9 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6016043.45751 2097947.55726 37.7414651721818 -122.387105680372 (37.7414651721818, -122.387105680372) 10 3 8 58 1
1256 97187 Undocumented 4 Ceratonia siliqua :: Carob 5 10X Fremont St 9 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6013222.5 2116242.1 37.7915413037038 -122.398142826086 (37.7915413037038, -122.398142826086) 12 2 9 28855 6
12741 188474 DPW Maintained 1 Ceratonia siliqua :: Carob 5 255 12th St 9 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 5ft   6007923.25888 2109012.80714 37.7713948192467 -122.415966013116 (37.7713948192467, -122.415966013116) 8 2 9 28853 19
35125 4920 DPW Maintained 1 Ceratonia siliqua :: Carob 5 195X Newhall St 9 Sidewalk: Curb side : Cutout Tree DPW 1   01/26/2015 05:54:00 AM 3 3X3   6017015.0972074 2098230.5166868 37.742295878473 -122.383765748687 (37.742295878473, -122.383765748687) 10 3 8 58 1
44548 189913 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1 Flora St 9 : Tree Private 2     6 Width 3ft   6013888.27035 2094422.90108 37.731667614051 -122.39431091023 (37.731667614051, -122.39431091023) 10 3 8 58 1
49970 2531 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1570 Burke Ave 9 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6016273.7509883 2099134.0637751 37.7447358261247 -122.386392104106 (37.7447358261247, -122.386392104106) 10 3 8 58 1
54911 16498 DPW Maintained 1 Ceratonia siliqua :: Carob 5 305X Newhall St 9 Sidewalk: Curb side : Cutout Tree DPW 1     6 3x3   6016898.45948 2098256.16023 37.7423598423185 -122.384170835605 (37.7423598423185, -122.384170835605) 10 3 8 58 1
55015 20969 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2002X Sunset Blvd 9 Sidewalk: Curb side : Cutout Tree DPW 1     3 40   5984887.6165706 2101567.3225095 37.7496295616808 -122.495097123245 (37.7496295616808, -122.495097123245) 1 8 3 29491 35
62892 16507 DPW Maintained 1 Ceratonia siliqua :: Carob 5 325 Newhall St 9 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6016604.68474 2098314.93369 37.7425049753024 -122.385190723599 (37.7425049753024, -122.385190723599) 10 3 8 58 1
70275 189859 DPW Maintained 1 Ceratonia siliqua :: Carob 5 102 Newhall St 9 : Tree Private 2     7 Width 3ft   6017171.36242 2098242.65136 37.7423378345214 -122.38322627048 (37.7423378345214, -122.38322627048) 10 3 8 58 1
102144 14932 DPW Maintained 1 Ceratonia siliqua :: Carob 5 320X Newhall St 9 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016461.7664057 2098387.7906821 37.7426971185746 -122.385689974252 (37.7426971185746, -122.385689974252) 10 3 8 58 1
120516 189836 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1698 Galvez Ave 9 : Tree Private 2     13 Width 4ft   6015406.79125 2098034.46628 37.7416685302756 -122.389313139314 (37.7416685302756, -122.389313139314) 10 3 8 58 1
123783 2521 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1555 Burke Ave 9 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016567.75907 2098840.98498 37.7439473619958 -122.385355052105 (37.7439473619958, -122.385355052105) 10 3 8 58 1
126551 125995 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2501 Taylor St 9 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6008349.66203 2121453.17315 37.8055769989413 -122.415371902112 (37.8055769989413, -122.415371902112) 5 1 10 308 23
139429 2541 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1575 Burke Ave 9 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016218.6051359 2099112.8628025 37.7446745598911 -122.386581311559 (37.7446745598911, -122.386581311559) 10 3 8 58 1
146281 189940 DPW Maintained 1 Ceratonia siliqua :: Carob 5 28 Fremont St 9 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 5ft   6013316.29733 2116121.55291 37.791215533629 -122.39780982696 (37.791215533629, -122.39780982696) 12 2 9 28855 6
162198 189923 DPW Maintained 1 Ceratonia siliqua :: Carob 5 45 Fremont St 9 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 5ft   6013419.15414 2116110.66886 37.7911913760301 -122.397453179235 (37.7911913760301, -122.397453179235) 12 2 9 28855 6
166358 189847 DPW Maintained 1 Ceratonia siliqua :: Carob 5 101 Newhall St 9 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6017231.39271 2098158.22234 37.7421093266962 -122.383012827183 (37.7421093266962, -122.383012827183) 10 3 8 58 1
167962 189908 DPW Maintained 1 Ceratonia siliqua :: Carob 5 350 Newhall St 9 Sidewalk: Curb side : Cutout Tree DPW 1     8 Width 3ft   6016294.30511 2098287.70361 37.7424130322313 -122.38626203637 (37.7424130322313, -122.38626203637) 10 3 8 58 1
168987 222912 DPW Maintained 1 Ceratonia siliqua :: Carob 5 363 Page St 9 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 4ft   6004886.98291 2109837.99569 37.7734894140273 -122.42652741201 (37.7734894140273, -122.42652741201) 7 9 11 28852 10
191303 14915 DPW Maintained 1 Ceratonia siliqua :: Carob 5 110X Newhall St 9 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6017191.33538 2098236.4203 37.7423218290085 -122.383156775767 (37.7423218290085, -122.383156775767) 10 3 8 58 1
191380 123914 DPW Maintained 1 Ceratonia siliqua :: Carob 5 389 09th Ave 9 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5993078.53663 2112857.80843 37.7811063777719 -122.467593853963 (37.7811063777719, -122.467593853963) 11 6 2 54 11
194211 189883 DPW Maintained 1 Ceratonia siliqua :: Carob 5 325 Newhall St 9 : Tree Private 2     8 Width 3ft   6016619.88237 2098309.8227 37.7424917822737 -122.385137818162 (37.7424917822737, -122.385137818162) 10 3 8 58 1

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