trees

17 rows where Neighborhoods (old) = 22 and qSpecies_id = 143

✎ View and edit SQL

This data as json, CSV (advanced)

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)
7858 234001 DPW Maintained 1 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 4472 24th St 1 Sidewalk: Property side : Yard Tree Private 2     12 Width 3ft   6000174.51508 2101698.13826 37.750871847669 -122.442244032449 (37.750871847669, -122.442244032449) 2 4 5 28862 22
36923 233996 DPW Maintained 1 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 1145 Douglass St 5 Sidewalk: Property side : Yard Tree Private 2     17 Width 4ft   6001366.11278 2100375.0445 37.7473067884747 -122.438028621322 (37.7473067884747, -122.438028621322) 2 4 5 63 22
53113 234003 DPW Maintained 1 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 500x 27th St 17 Median : Cutout Tree DPW 1     9 Width 4ft   6002888.7683 2100065.98913 37.7465446697175 -122.432741319957 (37.7465446697175, -122.432741319957) 2 7 5 63 22
70187 234002 DPW Maintained 1 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 4472 24th St 2 Sidewalk: Property side : Yard Tree Private 2     12 Width 3ft   6000158.92491 2101697.14224 37.7508682242954 -122.442297873053 (37.7508682242954, -122.442297873053) 2 4 5 28862 22
81718 233999 DPW Maintained 1 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 744 Duncan St 1 Sidewalk: Property side : Yard Tree Private 2     12     6001714.36393 2099737.9136 37.7455771763595 -122.436778794807 (37.7455771763595, -122.436778794807) 2 7 5 63 22
86285 234007 DPW Maintained 1 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 3978 22nd St 1 : Tree Private 2     12     6001985.80169 2102958.64311 37.7544359571599 -122.436070634474 (37.7544359571599, -122.436070634474) 2 4 5 28862 22
88278 233981 DPW Maintained 1 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 3846 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 5ft   6004869.8512 2100493.03902 37.7478294069984 -122.425921339098 (37.7478294069984, -122.425921339098) 2 4 5 63 22
95366 28241 DPW Maintained 1 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 3849 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree DPW 1     3 3X6   6004869.33528 2100447.66741 37.7477047978577 -122.425919893915 (37.7477047978577, -122.425919893915) 2 4 5 63 22
127625 233980 DPW Maintained 1 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 1609 Dolores St 2 Sidewalk: Curb side : Cutout Tree Private 2     40 Width 3ft   6005332.72592 2098929.24645 37.7435617380791 -122.424209538959 (37.7435617380791, -122.424209538959) 2 7 5 28859 22
136296 233983 DPW Maintained 1 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 107 Valley St 3 Sidewalk: Curb side : Yard Tree Private 2     4 Width 4ft   6005148.37303 2099292.84889 37.7445496964121 -122.424872849196 (37.7445496964121, -122.424872849196) 2 7 5 63 22
143079 233995 DPW Maintained 1 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 1145 Douglass St 4 Sidewalk: Property side : Yard Tree Private 2     14 Width 4ft   6001366.55787 2100367.96717 37.7472873811201 -122.438026575363 (37.7472873811201, -122.438026575363) 2 4 5 63 22
155032 233982 DPW Maintained 1 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 3849 Cesar Chavez St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6004873.93248 2100447.57279 37.7477047978586 -122.425903990303 (37.7477047978586, -122.425903990303) 2 4 5 63 22
167989 233998 DPW Maintained 1 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 642 28th St 1 Sidewalk: Property side : Yard Tree Private 2     28     6001746.28209 2099445.10181 37.7447749981684 -122.43664747132 (37.7447749981684, -122.43664747132) 2 7 5 63 22
174090 234004 DPW Maintained 1 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 1300 Noe St 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6003211.15019 2100572.61203 37.7479540161859 -122.431662723473 (37.7479540161859, -122.431662723473) 2 4 5 63 22
177584 234000 Significant Tree 6 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 749 27th St 2 Front Yard : Yard Tree Private 2     10 Width 10ft   6001659.60779 2099970.43439 37.7462125114091 -122.436984776447 (37.7462125114091, -122.436984776447) 2 7 5 63 22
178773 234006 DPW Maintained 1 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 4249 21st St 1 Sidewalk: Curb side : Pot Tree Private 2     5 Width 3ft   6001270.65442 2103323.8239 37.7553980006203 -122.438569957454 (37.7553980006203, -122.438569957454) 2 4 5 28862 22
193099 234005 DPW Maintained 1 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 423 Eureka St 1 Sidewalk: Curb side : Pot Tree Private 2     2 Width 3ft   6001525.86915 2103357.05408 37.7555037573171 -122.437689728893 (37.7555037573171, -122.437689728893) 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)
);