trees

18 rows where Police Districts = 4 and qSpecies_id = 101

✎ View and edit SQL

This data as json, CSV (advanced)

Police 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)
405 113785 Undocumented 4 Ficus Spp. :: 101 1164 SHOTWELL ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007978 2101134 37.7497645063146 -122.415218844485 (37.7497645063146, -122.415218844485) 2 4 7 28859 19
1942 113791 Undocumented 4 Ficus Spp. :: 101 1152 SHOTWELL ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008028 2101194 37.7499320627009 -122.415050188245 (37.7499320627009, -122.415050188245) 2 4 7 28859 19
11513 113786 Undocumented 4 Ficus Spp. :: 101 1164 SHOTWELL ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007978 2101134 37.7497645063146 -122.415218844485 (37.7497645063146, -122.415218844485) 2 4 7 28859 19
18212 113784 Undocumented 4 Ficus Spp. :: 101 1164 SHOTWELL ST 1 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6007978 2101134 37.7497645063146 -122.415218844485 (37.7497645063146, -122.415218844485) 2 4 7 28859 19
31980 39169 Permitted Site 7 Ficus Spp. :: 101 1176 Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/04/2004 12:00:00 AM 7   Permit Number 40832 6008043.68924223 2101079.24763886 37.7496178601646 -122.414987812819 (37.7496178601646, -122.414987812819) 2 4 7 28859 19
73906 113789 Undocumented 4 Ficus Spp. :: 101 1156 SHOTWELL ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008031 2101136 37.7497729763299 -122.415035709272 (37.7497729763299, -122.415035709272) 2 4 7 28859 19
74002 110160 Undocumented 4 Ficus Spp. :: 101 484 Sanchez St 1 Sidewalk: Property side : Cutout Tree Private 2         Permit Number 774829 6003562.4 2105468.5 37.761416869862 -122.430797452614 (37.761416869862, -122.430797452614) 15 4 5 28862 3
104149 224463 DPW Maintained 1 Ficus Spp. :: 101 998 York St 5 Sidewalk: Property side : Yard Tree Private 2     2 Width 3ft   6009934.61987 2103458.53933 37.7562569422093 -122.408616703004 (37.7562569422093, -122.408616703004) 2 4 7 28859 19
105600 114223 Undocumented 4 Ficus Spp. :: 101 3756 23RD ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004683 2102542 37.7534448164726 -122.426713351505 (37.7534448164726, -122.426713351505) 2 4 5 28862 22
121592 113788 Undocumented 4 Ficus Spp. :: 101 1156 SHOTWELL ST 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6008031 2101136 37.7497729763299 -122.415035709272 (37.7497729763299, -122.415035709272) 2 4 7 28859 19
125239 113790 Undocumented 4 Ficus Spp. :: 101 1152 SHOTWELL ST 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6008028 2101194 37.7499320627009 -122.415050188245 (37.7499320627009, -122.415050188245) 2 4 7 28859 19
126028 224466 DPW Maintained 1 Ficus Spp. :: 101 915 Florida St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   6009421.97023 2103694.42004 37.7568758925253 -122.410406283718 (37.7568758925253, -122.410406283718) 2 4 7 28859 19
130742 224461 DPW Maintained 1 Ficus Spp. :: 101 1079 Hampshire St 2 Sidewalk: Curb side : Pot Tree Private 2     3 Width 2ft   6010270.40379 2102959.48183 37.7549054419377 -122.407420259331 (37.7549054419377, -122.407420259331) 10 4 7 28859 19
136301 224464 DPW Maintained 1 Ficus Spp. :: 101 1214 York St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 5ft   6010021.64915 2102040.13849 37.7523672035078 -122.408215689896 (37.7523672035078, -122.408215689896) 2 4 7 28859 19
147349 113787 Undocumented 4 Ficus Spp. :: 101 1164 SHOTWELL ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007978 2101134 37.7497645063146 -122.415218844485 (37.7497645063146, -122.415218844485) 2 4 7 28859 19
169592 224460 DPW Maintained 1 Ficus Spp. :: 101 1079 Hampshire St 1 Sidewalk: Curb side : Pot Tree Private 2     4 Width 2ft   6010269.27051 2102947.54161 37.7548725933213 -122.407423336815 (37.7548725933213, -122.407423336815) 10 4 7 28859 19
173844 115019 Undocumented 4 Ficus Spp. :: 101 57 POND ST 1 Sidewalk: Curb side : Cutout Tree Private 2     20 3x3   6003214 2106188 37.7633726979345 -122.432053803459 (37.7633726979345, -122.432053803459) 15 4 5 28862 3
191920 224459 DPW Maintained 1 Ficus Spp. :: 101 2044 Bryant St 6 Sidewalk: Curb side : Cutout Tree Private 2     25 Width 3ft   6009528.13819 2105154.39369 37.7608906010467 -122.410142185216 (37.7608906010467, -122.410142185216) 2 4 7 28859 19

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