trees

22 rows where Fire Prevention Districts = 13 and qSpecies_id = 151

✎ View and edit SQL

This data as json, CSV (advanced)

Fire Prevention Districts ✖

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)
6623 42595 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 1950 Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/2000 12:00:00 AM 5   Permit Number 42667 6005494.51102 2116553.24353 37.7919621552701 -122.424903735525 (37.7919621552701, -122.424903735525) 13 9 1 28858 27
9741 131187 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 2501 Jackson St 13 Sidewalk: Curb side : Cutout Tree Private 2     22 Width 3ft   6001696.09346 2116629.35582 37.7919558582198 -122.438051712318 (37.7919558582198, -122.438051712318) 13 6 1 29490 27
15126 121049 Undocumented 4 Melaleuca ericifolia :: Heath Melaleuca 151 2650 Polk St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006281 2119745 37.8007703072153 -122.422409360755 (37.8007703072153, -122.422409360755) 13 9 1 28858 32
20236 131192 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 1700 Franklin St 1 Sidewalk: Curb side : Cutout Tree Private 2     22 Width 4ft   6005755.68073 2116051.93764 37.7906004431923 -122.423964421545 (37.7906004431923, -122.423964421545) 13 9 1 28858 27
24703 121054 Undocumented 4 Melaleuca ericifolia :: Heath Melaleuca 151 2650 Polk St 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006281 2119745 37.8007703072153 -122.422409360755 (37.8007703072153, -122.422409360755) 13 9 1 28858 32
28039 42596 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 1950 Clay St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/26/2000 12:00:00 AM 11 3x3 Permit Number 42667 6005477.78345 2116550.81967 37.7919545551073 -122.424961440544 (37.7919545551073, -122.424961440544) 13 9 1 28858 27
28120 131190 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 2451 Steiner St 9 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 4ft   6002262.78346 2116332.95188 37.7911742205576 -122.436069745025 (37.7911742205576, -122.436069745025) 13 9 1 29490 27
37383 121052 Undocumented 4 Melaleuca ericifolia :: Heath Melaleuca 151 2650 Polk St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006281 2119745 37.8007703072153 -122.422409360755 (37.8007703072153, -122.422409360755) 13 9 1 28858 32
41699 52773 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 2380@ STEINER Vallejo St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/11/2006 12:00:00 AM 5   Permit Number 48816 6002179.59387 2117772.23813 37.7951214016938 -122.436460636263 (37.7951214016938, -122.436460636263) 13 9 1 57 17
48519 131189 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 2501 Jackson St 21 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6002000.17825 2116671.28438 37.792088271701 -122.4370025821 (37.792088271701, -122.4370025821) 13 6 1 29490 27
49220 7946 Landmark tree 11 Melaleuca ericifolia :: Heath Melaleuca 151 1701 Franklin St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3X3   6005703.15328 2116043.32965 37.7905738421571 -122.424145551273 (37.7905738421571, -122.424145551273) 13 9 1 28858 27
67409 131191 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 2451 Steiner St 14 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6002287.41432 2116178.40828 37.7907512828973 -122.435973460016 (37.7907512828973, -122.435973460016) 13 9 1 29490 27
74510 121050 Undocumented 4 Melaleuca ericifolia :: Heath Melaleuca 151 2650 Polk St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006281 2119745 37.8007703072153 -122.422409360755 (37.8007703072153, -122.422409360755) 13 9 1 28858 32
83403 9925 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 2010 Gough St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/21/2008 12:00:00 AM 12 3x3   6005193.66561 2116589.42028 37.7920444900059 -122.425947239584 (37.7920444900059, -122.425947239584) 13 9 1 28858 27
97256 87303 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 2426 Vallejo St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/28/2008 12:00:00 AM 38 3x3 Permit Number 50313 6001931.96776 2117738.10536 37.7950136080408 -122.43731501379 (37.7950136080408, -122.43731501379) 13 9 1 57 27
99923 131188 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 2501 Jackson St 18 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6001926.62889 2116662.37015 37.7920596147963 -122.437256424752 (37.7920596147963, -122.437256424752) 13 6 1 29490 27
100503 121051 Undocumented 4 Melaleuca ericifolia :: Heath Melaleuca 151 2650 Polk St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006281 2119745 37.8007703072153 -122.422409360755 (37.8007703072153, -122.422409360755) 13 9 1 28858 32
110307 42646 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 1600X GREEN ST 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/26/2000 12:00:00 AM 10 3x3   6005364 2118556 37.7974538454152 -122.425497899433 (37.7974538454152, -122.425497899433) 13 9 1 57 17
154741 42598 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 1961 Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/2000 12:00:00 AM 14   Permit Number 42668 6005388.01706 2116488.54152 37.7917784840479 -122.425267599417 (37.7917784840479, -122.425267599417) 13 9 1 28858 27
160327 121053 Undocumented 4 Melaleuca ericifolia :: Heath Melaleuca 151 2650 Polk St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006281 2119745 37.8007703072153 -122.422409360755 (37.8007703072153, -122.422409360755) 13 9 1 28858 32
166834 42645 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 1600X GREEN ST 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/26/2000 12:00:00 AM 6 3x3   6005364 2118556 37.7974538454152 -122.425497899433 (37.7974538454152, -122.425497899433) 13 9 1 57 17
178828 131186 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 2501 Jackson St 3 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 3ft   6001413.74236 2116589.85963 37.7918313506904 -122.439025814797 (37.7918313506904, -122.439025814797) 13 6 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)
);