trees

19 rows where qLegalStatus_id = 4 and qSpecies_id = 133

✎ View and edit SQL

This data as json, CSV (advanced)

qLegalStatus_id ✖

  • Undocumented · 19 ✖
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)
18421 122404 Undocumented 4 Crataegus laevigata :: English Hawthorn 133 340 Magellan Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x6   5994085 2099826 37.7453824890774 -122.46316615516 (37.7453824890774, -122.46316615516) 1 8 4 29491 40
28142 121663 Undocumented 4 Crataegus laevigata :: English Hawthorn 133 860 Teresita Blvd 4 Sidewalk: Property side : Cutout Tree Private 2       3x3   5998939 2095554 37.7339310276146 -122.446074655004 (37.7339310276146, -122.446074655004) 9 7 4 59 40
48825 116196 Undocumented 4 Crataegus laevigata :: English Hawthorn 133 3751 CLAY ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996888 2115293 37.7880119756846 -122.454591065245 (37.7880119756846, -122.454591065245) 11 6 1 54 31
55106 102412 Undocumented 4 Crataegus laevigata :: English Hawthorn 133 55X Lyon St 4 Sidewalk: Curb side : Cutout Tree Private 2           6000310.8 2109142 37.7713186232103 -122.442307075209 (37.7713186232103, -122.442307075209) 15 5 11 29492 9
62246 121661 Undocumented 4 Crataegus laevigata :: English Hawthorn 133 860 Teresita Blvd 2 Sidewalk: Property side : Cutout Tree Private 2       3x3   5998939 2095554 37.7339310276146 -122.446074655004 (37.7339310276146, -122.446074655004) 9 7 4 59 40
65411 82956 Undocumented 4 Crataegus laevigata :: English Hawthorn 133 660X Clementina St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/11/2005 12:00:00 AM 3 3x3   6009636 2110586 37.7758105844997 -122.410152621086 (37.7758105844997, -122.410152621086) 8 2 9 28853 34
77895 82955 Undocumented 4 Crataegus laevigata :: English Hawthorn 133 660X Clementina St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/11/2005 12:00:00 AM 3 3x3   6009636 2110586 37.7758105844997 -122.410152621086 (37.7758105844997, -122.410152621086) 8 2 9 28853 34
84636 82952 Undocumented 4 Crataegus laevigata :: English Hawthorn 133 660X Clementina St 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/11/2005 12:00:00 AM 3 3x3   6009636 2110586 37.7758105844997 -122.410152621086 (37.7758105844997, -122.410152621086) 8 2 9 28853 34
86826 121662 Undocumented 4 Crataegus laevigata :: English Hawthorn 133 860 Teresita Blvd 3 Sidewalk: Property side : Cutout Tree Private 2       3x3   5998939 2095554 37.7339310276146 -122.446074655004 (37.7339310276146, -122.446074655004) 9 7 4 59 40
112891 82953 Undocumented 4 Crataegus laevigata :: English Hawthorn 133 660X Clementina St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/11/2005 12:00:00 AM 3 3x3   6009636 2110586 37.7758105844997 -122.410152621086 (37.7758105844997, -122.410152621086) 8 2 9 28853 34
117633 122387 Undocumented 4 Crataegus laevigata :: English Hawthorn 133 198 Vasquez Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 779324 5994732 2099337 37.7440770679838 -122.460893516037 (37.7440770679838, -122.460893516037) 1 8 4 59 40
119767 84504 Undocumented 4 Crataegus laevigata :: English Hawthorn 133 650X Clementina St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/14/2006 12:00:00 AM 3 3x3   6009485.16866501 2110503.49163991 37.7755755804602 -122.410668559049 (37.7755755804602, -122.410668559049) 8 2 9 28853 34
128208 84505 Undocumented 4 Crataegus laevigata :: English Hawthorn 133 650 Clementina St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/14/2006 12:00:00 AM 3 3x3   6009485.16866501 2110503.49163991 37.7755755804602 -122.410668559049 (37.7755755804602, -122.410668559049) 8 2 9 28853 34
129524 117509 Undocumented 4 Crataegus laevigata :: English Hawthorn 133 300x HANOVER ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999715 2086521 37.7091727618039 -122.442743399736 (37.7091727618039, -122.442743399736) 9 7 6 28861 5
162377 121664 Undocumented 4 Crataegus laevigata :: English Hawthorn 133 860 Teresita Blvd 5 Sidewalk: Property side : Cutout Tree Private 2       3x3   5998939 2095554 37.7339310276146 -122.446074655004 (37.7339310276146, -122.446074655004) 9 7 4 59 40
167164 82954 Undocumented 4 Crataegus laevigata :: English Hawthorn 133 660X Clementina St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/11/2005 12:00:00 AM 3 3x3   6009636 2110586 37.7758105844997 -122.410152621086 (37.7758105844997, -122.410152621086) 8 2 9 28853 34
179732 121660 Undocumented 4 Crataegus laevigata :: English Hawthorn 133 860 Teresita Blvd 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5998939 2095554 37.7339310276146 -122.446074655004 (37.7339310276146, -122.446074655004) 9 7 4 59 40
185629 122405 Undocumented 4 Crataegus laevigata :: English Hawthorn 133 340 Magellan Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x6   5994085 2099826 37.7453824890774 -122.46316615516 (37.7453824890774, -122.46316615516) 1 8 4 29491 40
189944 116195 Undocumented 4 Crataegus laevigata :: English Hawthorn 133 3751 CLAY ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996888 2115293 37.7880119756846 -122.454591065245 (37.7880119756846, -122.454591065245) 11 6 1 54 31

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