trees

120 rows where Police Districts = 8 and qSpecies_id = 63 sorted by qSpecies_id

✎ View and edit SQL

This data as json, CSV (advanced)

Police Districts ✖

PlantDate ✖

  • - 20
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)
162461 120921 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 3995X Alemany Blvd 4 Sidewalk: Property side : Cutout Tree Private 2       3X3   5992394 2087287 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588) 9 8 4 64 24
164258 253422 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2X Miraloma Dr 1 Side Yard : Cutout Tree DPW 1       10x10   5994995 2097925 37.7402151966004 -122.459881864698 (37.7402151966004, -122.459881864698) 9 8 4 59 40
167835 184087 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1600 Sunset Blvd 88 Sidewalk: Property side : Yard Tree Private 2     12 Width 0ft   5984947.9817 2104096.3091 37.7565769961358 -122.495074842554 (37.7565769961358, -122.495074842554) 1 8 3 56 35
170438 96480 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 1101 Eucalyptus Dr   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF       In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.7310370666678 -122.483566221845 (37.7310370666678, -122.483566221845) 1 8 4 64 14
170803 186254 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1701 Sunset Blvd 65 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984796.5449 2103072.2391 37.7537563165951 -122.495523029283 (37.7537563165951, -122.495523029283) 1 8 3 56 35
170849 186531 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1501 Sunset Blvd 2 unknown : Yard Tree Private 2     9 Width 0ft   5984751.3064 2104919.289 37.7588251541556 -122.495815712177 (37.7588251541556, -122.495815712177) 1 8 3 56 35
172030 185637 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2100 Sunset Blvd 17 Sidewalk: Property side : Yard Tree Private 2     6 Width 0ft   5985047.0682 2100399.1831 37.7464315030837 -122.494459642192 (37.7464315030837, -122.494459642192) 1 8 3 29491 35
173494 181382 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1500 Sunset Blvd 15 Sidewalk: Property side : Yard Tree Private 2     6 Width 0ft   5984896.9779 2104470.096 37.7576003251998 -122.49527879388 (37.7576003251998, -122.49527879388) 1 8 3 56 35
173903 184079 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1600 Sunset Blvd 80 Sidewalk: Property side : Yard Tree Private 2     4 Width 0ft   5984934.15 2104045.1938 37.7564358379272 -122.49511890768 (37.7564358379272, -122.49511890768) 1 8 3 56 35
176886 117253 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 2500x 34TH AVE 3 Side Yard : Yard Tree SFUSD 4       3x3   5985829 2097874 37.7395437603018 -122.491570003273 (37.7395437603018, -122.491570003273) 1 8 3 29491 35
178211 186688 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1401 Sunset Blvd 45 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5984691.4289 2105282.7412 37.7598195855983 -122.496049606755 (37.7598195855983, -122.496049606755) 1 8 3 56 35
179563 211058 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 447 Lawton St 3 Sidewalk: Curb side : Pot Tree Private 2     15 Width 3ft   5992805.57319 2104540.3462 37.7582530810297 -122.467933005722 (37.7582530810297, -122.467933005722) 1 8 4 56 12
183575 187017 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2501 Sunset Blvd 36 Sidewalk: Property side : Yard Tree Private 2     9 Width 0ft   5984955.1646 2097931.5729 37.7396507340198 -122.494595545547 (37.7396507340198, -122.494595545547) 1 8 3 29491 35
184638 185176 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2500 Sunset Blvd 28 Sidewalk: Property side : Yard Tree Private 2     12 Width 0ft   5985156.5992 2097794.2406 37.7392854441206 -122.493888963204 (37.7392854441206, -122.493888963204) 1 8 3 29491 35
184680 256643 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2X Miraloma Dr 2 Side Yard : Cutout Tree DPW 1       10x10   5994995 2097925 37.7402151966004 -122.459881864698 (37.7402151966004, -122.459881864698) 9 8 4 59 40
188950 185409 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2300 Sunset Blvd 24 unknown : Yard Tree Private 2     8 Width 0ft   5985081.6412 2099150.9001 37.7430060796886 -122.494248101225 (37.7430060796886, -122.494248101225) 1 8 3 29491 35
189399 185410 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2300 Sunset Blvd 25 unknown : Yard Tree Private 2     8 Width 0ft   5985099.6362 2099155.3989 37.7430194852088 -122.494186211855 (37.7430194852088, -122.494186211855) 1 8 3 29491 35
190239 185656 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2100 Sunset Blvd 37 Sidewalk: Property side : Yard Tree Private 2     16 Width 0ft   5985042.305 2100549.4408 37.746843791076 -122.494487187243 (37.746843791076, -122.494487187243) 1 8 3 29491 35
192105 186099 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1901 Sunset Blvd 45 Sidewalk: Property side : Yard Tree Private 2     14 Width 0ft   5984856.2078 2101707.4688 37.7500125261534 -122.495216067916 (37.7500125261534, -122.495216067916) 1 8 3 29491 35
193239 184993 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2701 Sunset Blvd 19 Sidewalk: Property side : Yard Tree Private 2     29 Width 0ft   5985021.3833 2096558.6319 37.7358848813643 -122.494265421421 (37.7358848813643, -122.494265421421) 1 8 3 29491 35

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