trees

18 rows where Zip Codes = 59 and qSpecies_id = 5 sorted by Longitude

✎ View and edit SQL

This data as json, CSV (advanced)

Zip Codes ✖

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)
6377 82142 Permitted Site 7 Ceratonia siliqua :: Carob 5 30 Molimo Dr 2 Sidewalk: Curb side : Cutout Tree Private 2   10/25/2007 12:00:00 AM   3x3 Permit Number 49838 5998889.06181671 2096571.98929044 37.736723332936 -122.446320512355 (37.736723332936, -122.446320512355) 9 7 4 59 40
115939 82092 Permitted Site 7 Ceratonia siliqua :: Carob 5 30 Molimo Dr 4 Sidewalk: Curb side : Cutout Tree Private 2   10/25/2007 12:00:00 AM   3x3 Permit Number 49838 5998889.06181671 2096571.98929044 37.736723332936 -122.446320512355 (37.736723332936, -122.446320512355) 9 7 4 59 40
146949 82141 Permitted Site 7 Ceratonia siliqua :: Carob 5 30 Molimo Dr 3 Sidewalk: Curb side : Cutout Tree Private 2   10/25/2007 12:00:00 AM   3x3 Permit Number 49838 5998889.06181671 2096571.98929044 37.736723332936 -122.446320512355 (37.736723332936, -122.446320512355) 9 7 4 59 40
150580 82143 Permitted Site 7 Ceratonia siliqua :: Carob 5 30 Molimo Dr 1 Sidewalk: Curb side : Cutout Tree Private 2   10/25/2007 12:00:00 AM   3x3 Permit Number 49838 5998889.06181671 2096571.98929044 37.736723332936 -122.446320512355 (37.736723332936, -122.446320512355) 9 7 4 59 40
152645 205995 DPW Maintained 1 Ceratonia siliqua :: Carob 5 30 Molimo Dr 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   5998862.6525 2096533.61775 37.7366164654663 -122.446409060855 (37.7366164654663, -122.446409060855) 9 7 4 59 40
174999 205996 DPW Maintained 1 Ceratonia siliqua :: Carob 5 30 Molimo Dr 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   5998822.4881 2096514.65172 37.7365620951723 -122.446546561796 (37.7365620951723, -122.446546561796) 9 7 4 59 40
37929 82121 Permitted Site 7 Ceratonia siliqua :: Carob 5 44 Molimo Dr 1 Sidewalk: Curb side : Cutout Tree Private 2   10/25/2007 12:00:00 AM   3x3 Permit Number 49840 5998809.17063994 2096527.78133102 37.7365973852663 -122.446593550118 (37.7365973852663, -122.446593550118) 9 7 4 59 40
47524 205997 DPW Maintained 1 Ceratonia siliqua :: Carob 5 30 Molimo Dr 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   5998801.07075 2096511.79706 37.7365530335853 -122.446620405109 (37.7365530335853, -122.446620405109) 9 7 4 59 40
46538 205998 DPW Maintained 1 Ceratonia siliqua :: Carob 5 30 Molimo Dr 4 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   5998781.20203 2096512.57724 37.7365540408212 -122.446689155601 (37.7365540408212, -122.446689155601) 9 7 4 59 40
63208 206021 DPW Maintained 1 Ceratonia siliqua :: Carob 5 42 Stanford Heights Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   5997867.55836 2095818.65061 37.7345964514605 -122.449798003996 (37.7345964514605, -122.449798003996) 9 7 4 59 40
11562 206018 DPW Maintained 1 Ceratonia siliqua :: Carob 5 99 Merced Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   5994828.29695 2099714.01169 37.7451177882671 -122.460587859436 (37.7451177882671, -122.460587859436) 1 8 4 59 40
111983 206019 DPW Maintained 1 Ceratonia siliqua :: Carob 5 99 Merced Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   5994816.51833 2099704.78199 37.7450917681756 -122.460627918846 (37.7450917681756, -122.460627918846) 1 8 4 59 40
169891 205990 DPW Maintained 1 Ceratonia siliqua :: Carob 5 452 Kenwood Way 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5993405.09676 2093676.51676 37.7284583518695 -122.46507057606 (37.7284583518695, -122.46507057606) 9 8 4 59 40
149414 205991 DPW Maintained 1 Ceratonia siliqua :: Carob 5 452 Kenwood Way 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5993388.91946 2093682.37508 37.7284735045328 -122.465126926677 (37.7284735045328, -122.465126926677) 9 8 4 59 40
71731 205992 DPW Maintained 1 Ceratonia siliqua :: Carob 5 452 Kenwood Way 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5993371.39802 2093686.31414 37.728483309841 -122.465187784693 (37.728483309841, -122.465187784693) 9 8 4 59 40
67228 206013 DPW Maintained 1 Ceratonia siliqua :: Carob 5 130 San Benito Way 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   5992845.13508 2095810.81929 37.7342863121439 -122.467161490835 (37.7342863121439, -122.467161490835) 9 8 4 59 40
24361 206014 DPW Maintained 1 Ceratonia siliqua :: Carob 5 120 San Benito Way 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5992843.12782 2095854.05613 37.7344049138512 -122.467171573123 (37.7344049138512, -122.467171573123) 9 8 4 59 40
159417 57469 Permitted Site 7 Ceratonia siliqua :: Carob 5 71 Cerritos Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/08/1987 12:00:00 AM     Permit Number 24965 5992451.26080169 2092911.00734917 37.7263014049972 -122.468312338233 (37.7263014049972, -122.468312338233) 9 8 4 59 40

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