trees

24 rows where qLegalStatus_id = 4 and qSpecies_id = 6

✎ View and edit SQL

This data as json, CSV (advanced)

qLegalStatus_id ✖

  • Undocumented · 24 ✖
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)
618 238270 Undocumented 4 Lagunaria patersonii :: Primrose Tree 6 4102 19th St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6002298.332 2104734.40291 37.7593295173753 -122.435116825204 (37.7593295173753, -122.435116825204) 2 4 5 28862 3
4231 261663 Undocumented 4 Lagunaria patersonii :: Primrose Tree 6 1099x Broadway   Sidewalk: Curb side : Cutout Tree Private 2   10/28/2020 12:00:00 AM 3 3x3   6008393 2118190 37.7966195766837 -122.414990814528 (37.7966195766837, -122.414990814528) 5 1 10 308 21
8363 238269 Undocumented 4 Lagunaria patersonii :: Primrose Tree 6 4102 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6002324.68279 2104735.52248 37.7593340877084 -122.435025771543 (37.7593340877084, -122.435025771543) 2 4 5 28862 3
9840 256599 Undocumented 4 Lagunaria patersonii :: Primrose Tree 6 2x Stillman St 26 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014165 2112908 37.7824390851954 -122.394648183134 (37.7824390851954, -122.394648183134) 6 2 9 28856 6
12651 261028 Undocumented 4 Lagunaria patersonii :: Primrose Tree 6 743 20th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/18/2019 12:00:00 AM 3 3x3   5989712 2110287 37.7738527032106 -122.479052157213 (37.7738527032106, -122.479052157213) 11 6 2 55 26
16338 261024 Undocumented 4 Lagunaria patersonii :: Primrose Tree 6 751 20th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/18/2019 12:00:00 AM   3x3   5989703 2110237 37.773714894321 -122.479079631213 (37.773714894321, -122.479079631213) 11 6 2 55 26
20319 106193 Undocumented 4 Lagunaria patersonii :: Primrose Tree 6 3040 TARAVAL ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5983698.2 2098878.7 37.742177638004 -122.499011481047 (37.742177638004, -122.499011481047) 1 8 3 29491 35
29256 256605 Undocumented 4 Lagunaria patersonii :: Primrose Tree 6 2x Stillman St 32 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014165 2112908 37.7824390851954 -122.394648183134 (37.7824390851954, -122.394648183134) 6 2 9 28856 6
32904 256600 Undocumented 4 Lagunaria patersonii :: Primrose Tree 6 2x Stillman St 27 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014165 2112908 37.7824390851954 -122.394648183134 (37.7824390851954, -122.394648183134) 6 2 9 28856 6
51877 256607 Undocumented 4 Lagunaria patersonii :: Primrose Tree 6 2x Stillman St 34 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014165 2112908 37.7824390851954 -122.394648183134 (37.7824390851954, -122.394648183134) 6 2 9 28856 6
54999 101252 Undocumented 4 Lagunaria patersonii :: Primrose Tree 6 1290X 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5992716.9 2106688.9 37.7641473244126 -122.468395985577 (37.7641473244126, -122.468395985577) 11 8 11 56 12
61590 256576 Undocumented 4 Lagunaria patersonii :: Primrose Tree 6 2x Stillman St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014165 2112908 37.7824390851954 -122.394648183134 (37.7824390851954, -122.394648183134) 6 2 9 28856 6
64471 207005 Undocumented 4 Lagunaria patersonii :: Primrose Tree 6 171 Wawona St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/06/2014 12:00:00 AM 1 Width 3ft Permit Number 773294 5992787.45104 2098017.32873 37.7403415032629 -122.467521326669 (37.7403415032629, -122.467521326669) 1 8 4 59 40
70541 256574 Undocumented 4 Lagunaria patersonii :: Primrose Tree 6 2x Stillman St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014165 2112908 37.7824390851954 -122.394648183134 (37.7824390851954, -122.394648183134) 6 2 9 28856 6
79736 251742 Undocumented 4 Lagunaria patersonii :: Primrose Tree 6 300 Naylor St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002771 2086560 37.7094535905361 -122.432184185389 (37.7094535905361, -122.432184185389) 9 7 6 28861 5
92562 256604 Undocumented 4 Lagunaria patersonii :: Primrose Tree 6 2x Stillman St 31 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014165 2112908 37.7824390851954 -122.394648183134 (37.7824390851954, -122.394648183134) 6 2 9 28856 6
104768 207004 Undocumented 4 Lagunaria patersonii :: Primrose Tree 6 171 Wawona St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/06/2014 12:00:00 AM 1 Width 3ft Permit Number 773294 5992803.19794 2098037.09896 37.7403966964551 -122.46746831791 (37.7403966964551, -122.46746831791) 1 8 4 59 40
111372 105757 Undocumented 4 Lagunaria patersonii :: Primrose Tree 6 1278 CLAYTON ST 1 Sidewalk: Curb side : Cutout Tree Private 2   03/03/2014 12:00:00 AM 10 3x3 Permit Number 771070 5999104.9 2105310.4 37.7607292094813 -122.446202658218 (37.7607292094813, -122.446202658218) 15 5 5 28862 3
113377 115939 Undocumented 4 Lagunaria patersonii :: Primrose Tree 6 607 34TH AVE 1 Sidewalk: Curb side : Cutout Tree Private 2   03/07/2016 12:00:00 AM 3 3x3 Permit Number 777685 5985316 2111712 37.7775090776113 -122.494363475489 (37.7775090776113, -122.494363475489) 11 6 2 55 26
134706 256601 Undocumented 4 Lagunaria patersonii :: Primrose Tree 6 2x Stillman St 28 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014165 2112908 37.7824390851954 -122.394648183134 (37.7824390851954, -122.394648183134) 6 2 9 28856 6
148332 113418 Undocumented 4 Lagunaria patersonii :: Primrose Tree 6 598X BENTON AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   6007207 2095355 37.7338532991757 -122.417475487879 (37.7338532991757, -122.417475487879) 2 7 7 28859 2
160238 256575 Undocumented 4 Lagunaria patersonii :: Primrose Tree 6 2x Stillman St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014165 2112908 37.7824390851954 -122.394648183134 (37.7824390851954, -122.394648183134) 6 2 9 28856 6
177211 102935 Undocumented 4 Lagunaria patersonii :: Primrose Tree 6 801X Church St 5 Sidewalk: Curb side : Cutout Tree Private 2     4 3x3   6004394.3 2104124.7 37.7577742117678 -122.427824502367 (37.7577742117678, -122.427824502367) 2 4 5 28862 3
183981 256606 Undocumented 4 Lagunaria patersonii :: Primrose Tree 6 2x Stillman St 33 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014165 2112908 37.7824390851954 -122.394648183134 (37.7824390851954, -122.394648183134) 6 2 9 28856 6

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