15 rows where Neighborhoods (old) = 22 and qSpecies_id = 47 sorted by Location

View and edit SQL

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)
92382 47550 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 1681 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/2002 12:00:00 AM     Permit Number 45414 6003392.60348895 2098449.5926945 37.7421349817765 -122.430883775787 (37.7421349817765, -122.430883775787) 2 7 5 63 22
40263 227676 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 427 Valley St 1 Sidewalk: Curb side : Yard Tree Private 2     10     6003106.32375 2099187.31259 37.7441443647786 -122.431926305762 (37.7441443647786, -122.431926305762) 2 7 5 63 22
176307 227678 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 300 Valley St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6003889.89165 2099268.52237 37.7444117377113 -122.429222690078 (37.7444117377113, -122.429222690078) 2 7 5 63 22
123108 227677 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 300 Valley St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   6003907.02908 2099270.15617 37.7444171939021 -122.429163548878 (37.7444171939021, -122.429163548878) 2 7 5 63 22
22890 50289 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 300 Valley St 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/28/2003 12:00:00 AM   3x3   6003944.88624926 2099274.1797934 37.7444303848395 -122.42903293346 (37.7444303848395, -122.42903293346) 2 7 5 63 22
84280 50293 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 300 Valley St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/28/2003 12:00:00 AM   3x3   6003944.88624926 2099274.1797934 37.7444303848395 -122.42903293346 (37.7444303848395, -122.42903293346) 2 7 5 63 22
89527 50288 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 300 Valley St 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/28/2003 12:00:00 AM   3x3   6003944.88624926 2099274.1797934 37.7444303848395 -122.42903293346 (37.7444303848395, -122.42903293346) 2 7 5 63 22
112832 50290 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 300 Valley St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/28/2003 12:00:00 AM   3x3 Permit Number 47005 6003944.88624926 2099274.1797934 37.7444303848395 -122.42903293346 (37.7444303848395, -122.42903293346) 2 7 5 63 22
113972 50292 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 300 Valley St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/28/2003 12:00:00 AM   3x3 Permit Number 47005 6003944.88624926 2099274.1797934 37.7444303848395 -122.42903293346 (37.7444303848395, -122.42903293346) 2 7 5 63 22
193338 50291 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 300 Valley St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/28/2003 12:00:00 AM   3x3   6003944.88624926 2099274.1797934 37.7444303848395 -122.42903293346 (37.7444303848395, -122.42903293346) 2 7 5 63 22
56832 227680 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1541 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   6003988.60954 2099295.31119 37.7444908816604 -122.428883253577 (37.7444908816604, -122.428883253577) 2 7 5 63 22
192707 49012 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 361 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/31/2002 12:00:00 AM     Permit Number 46198 6003561.60300767 2099494.42119752 37.7450134133041 -122.430373957908 (37.7450134133041, -122.430373957908) 2 7 5 63 22
134621 227679 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 361 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   6003556.92712 2099495.03666 37.7450148383554 -122.430390170187 (37.7450148383554, -122.430390170187) 2 7 5 63 22
137505 34621 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 370 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/2016 12:00:00 AM 3   Permit Number 778228 6003497.10528776 2099542.95496323 37.7451430220882 -122.430600441889 (37.7451430220882, -122.430600441889) 2 7 5 63 22
142493 227693 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 337 Clipper St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6002979.94012 2100929.17253 37.7489199393117 -122.432487701248 (37.7489199393117, -122.432487701248) 2 4 5 28862 22

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