trees

10 rows where Neighborhoods (old) = 27 and qSpecies_id = 5

✎ View and edit SQL

This data as json, CSV (advanced)

Neighborhoods (old) ✖

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)
20273 18860 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2212 Sacramento St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6004055.90045 2116026.39415 37.7904341972353 -122.429843740294 (37.7904341972353, -122.429843740294) 13 9 1 29490 27
22361 125968 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2810 Sacramento St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6001336.41783 2115647.62359 37.7892398148051 -122.439225792541 (37.7892398148051, -122.439225792541) 13 6 1 29490 27
25903 125969 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2672 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6002023.76351 2115741.9503 37.7895379005066 -122.43685441882 (37.7895379005066, -122.43685441882) 13 6 1 29490 27
56161 18866 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2241 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6004050.55009 2115976.04283 37.7902956422834 -122.429858659173 (37.7902956422834, -122.429858659173) 13 9 1 29490 27
56233 18865 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2230 Sacramento St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6003863.26827 2115999.97726 37.7903507527417 -122.430508349195 (37.7903507527417, -122.430508349195) 13 9 1 29490 27
79345 18853 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2222 Sacramento St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 3X3   6004009.33777 2116018.08762 37.7904087527096 -122.430004251319 (37.7904087527096, -122.430004251319) 13 9 1 29490 27
99121 125970 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2301 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 4ft   6003734.22562 2115934.13704 37.7901626613254 -122.430950126753 (37.7901626613254, -122.430950126753) 13 9 1 29490 27
105990 18859 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2212 Sacramento St 1 Sidewalk: Curb side : Cutout Tree DPW 1   10/13/1992 12:00:00 AM 12 3X3   6004082.46062 2116030.31556 37.7904464684691 -122.429752123658 (37.7904464684691, -122.429752123658) 13 9 1 29490 27
121999 18922 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2620 SACRAMENTO ST 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6002038.8 2115762.8 37.7895960030005 -122.436803887406 (37.7895960030005, -122.436803887406) 13 6 1 29490 27
122504 18864 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2230 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6003886.2489 2116004.41909 37.7903642506674 -122.430429154879 (37.7903642506674, -122.430429154879) 13 9 1 29490 27

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