trees

34 rows where Zip Codes = 28858 and qSpecies_id = 86

✎ View and edit SQL

This data as json, CSV (advanced)

Zip Codes ✖

  • 28858 · 34 ✖
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)
6411 136695 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1200 Greenwich St 1 Sidewalk: Curb side : Yard Tree Private 2     31     6007098.70591 2119850.28744 37.8011054932745 -122.419587225988 (37.8011054932745, -122.419587225988) 5 1 1 28858 32
21329 136680 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1369 Hyde St 5 Sidewalk: Property side : Yard Tree Private 2     5 Width 2ft   6007505.03866 2117018.90394 37.7933541007707 -122.417980305661 (37.7933541007707, -122.417980305661) 5 1 10 28858 32
29197 136662 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1307 Bay St 4 : Tree Private 2     1 Width 1ft   6004522.84241 2120815.90939 37.8036114118857 -122.428569697738 (37.8036114118857, -122.428569697738) 13 9 1 28858 17
31433 136684 DPW Maintained 1 Taxus baccata :: Irish Yew 86 57 Russell St 1 Sidewalk: Property side : Yard Tree Private 2     12 Width 2ft   6007021.76535 2118934.77129 37.7985873825495 -122.41978847538 (37.7985873825495, -122.41978847538) 5 1 10 28858 32
34212 136690 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1101 Green St 3 Sidewalk: Property side : Yard Tree Private 2     3 Width 2ft   6007706.55666 2118838.72504 37.7983622165993 -122.417412065427 (37.7983622165993, -122.417412065427) 5 1 10 28858 32
43003 136693 DPW Maintained 1 Taxus baccata :: Irish Yew 86 2164 Hyde St 5 Sidewalk: Property side : Yard Tree Private 2     6 Width 5ft   6007181.34298 2119779.01061 37.8009144395066 -122.41929620626 (37.8009144395066, -122.41929620626) 5 1 1 28858 32
53129 136663 DPW Maintained 1 Taxus baccata :: Irish Yew 86 3109 Franklin St 1 : Tree Private 2     7 Width 3ft   6005049.76701 2120690.58566 37.8032971105329 -122.426737318298 (37.8032971105329, -122.426737318298) 13 9 1 28858 17
53739 136691 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1101 Green St 4 Sidewalk: Property side : Yard Tree Private 2     3 Width 2ft   6007718.23454 2118839.56071 37.7983651681777 -122.417371715557 (37.7983651681777, -122.417371715557) 5 1 10 28858 32
67917 87249 Permitted Site 7 Taxus baccata :: Irish Yew 86 236323 Larkin St 8 Sidewalk: Property side : Cutout Tree Private 2       3x3   6006714 2119291 37.7995481543168 -122.420878746938 (37.7995481543168, -122.420878746938) 5 9 1 28858 32
71160 136681 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1369 Hyde St 8 Sidewalk: Property side : Yard Tree Private 2     5 Width 2ft   6007511.08374 2116974.21798 37.7932317444123 -122.41795622 (37.7932317444123, -122.41795622) 5 1 10 28858 32
71235 98244 Significant Tree 6 Taxus baccata :: Irish Yew 86 901 Bay St 1 Front Yard : Yard Tree Private 2     5     6006420.63185 2121080.7781 37.8044458892203 -122.422021121489 (37.8044458892203, -122.422021121489) 5 1 1 28858 32
75958 136705 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1120 Greenwich St 3 Front Yard : Yard Tree Private 2     14     6007496.45618 2119889.74411 37.8012362277192 -122.418213633845 (37.8012362277192, -122.418213633845) 5 1 1 28858 32
77632 136687 DPW Maintained 1 Taxus baccata :: Irish Yew 86 915 Bay St 2 Sidewalk: Property side : Yard Tree Private 2     8 Width 2ft   6006389.37934 2121076.02461 37.8044310746876 -122.422128935803 (37.8044310746876, -122.422128935803) 5 1 1 28858 32
81024 113456 DPW Maintained 1 Taxus baccata :: Irish Yew 86 6X Leroy Pl 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6008347.73797 2116436.02263 37.7918010435277 -122.415023221461 (37.7918010435277, -122.415023221461) 5 1 10 28858 21
82501 136685 DPW Maintained 1 Taxus baccata :: Irish Yew 86 929 Bay St 1 Sidewalk: Property side : Yard Tree Private 2     5 Width 2ft   6006311.09024 2121067.4414 37.8044030913911 -122.422399252223 (37.8044030913911, -122.422399252223) 5 1 1 28858 32
84969 136678 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1369 Hyde St 1 Sidewalk: Property side : Yard Tree Private 2     6 Width 2ft   6007492.70889 2117096.59509 37.7935667274799 -122.418028477839 (37.7935667274799, -122.418028477839) 5 1 10 28858 32
93014 136664 DPW Maintained 1 Taxus baccata :: Irish Yew 86 3109 Franklin St 2 : Tree Private 2     7 Width 3ft   6005052.80958 2120674.99367 37.8032544709705 -122.42672567836 (37.8032544709705, -122.42672567836) 13 9 1 28858 17
98485 104833 DPW Maintained 1 Taxus baccata :: Irish Yew 86 901 Bay St 2 Sidewalk: Curb side : Cutout Tree Private 2     6     6006442.50157 2121083.02679 37.8044532969577 -122.421945599118 (37.8044532969577, -122.421945599118) 5 1 1 28858 32
100716 136692 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1101 Green St 5 Sidewalk: Property side : Yard Tree Private 2     8 Width 2ft   6007731.45393 2118841.87046 37.7983722539254 -122.417326136092 (37.7983722539254, -122.417326136092) 5 1 10 28858 32
105016 136696 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1063 Lombard St 1 Sidewalk: Property side : Yard Tree Private 2     20 Width 6ft   6007280.02976 2120167.28303 37.8019860950362 -122.418982261931 (37.8019860950362, -122.418982261931) 5 1 1 28858 32
121616 136698 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1047 Lombard St 3 Sidewalk: Property side : Yard Tree Private 2     9 Width 6ft   6007369.77523 2120178.57084 37.802022141674 -122.418672500363 (37.802022141674, -122.418672500363) 5 1 1 28858 32
128853 136661 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1307 Bay St 3 : Tree Private 2     4 Width 1ft   6004511.51487 2120814.19666 37.8036060681264 -122.428608775088 (37.8036060681264, -122.428608775088) 13 9 1 28858 17
132265 87248 Permitted Site 7 Taxus baccata :: Irish Yew 86 236323 Larkin St 7 Sidewalk: Curb side : Cutout Tree Private 2   02/19/2008 12:00:00 AM   3x3 Permit Number 50274 6006714 2119291 37.7995481543168 -122.420878746938 (37.7995481543168, -122.420878746938) 5 9 1 28858 32
132805 136694 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1201 Greenwich St 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6007018.29249 2119785.88696 37.8009241359937 -122.41986091934 (37.8009241359937, -122.41986091934) 5 1 1 28858 32
133349 136697 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1047 Lombard St 2 Sidewalk: Property side : Yard Tree Private 2     10 Width 6ft   6007352.71781 2120177.3681 37.80201787889 -122.418731441927 (37.80201787889, -122.418731441927) 5 1 1 28858 32
134836 99719 DPW Maintained 1 Taxus baccata :: Irish Yew 86 2164 Hyde St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6007186.17673 2119740.01598 37.8008076423232 -122.419276711652 (37.8008076423232, -122.419276711652) 5 1 1 28858 32
146664 87250 Permitted Site 7 Taxus baccata :: Irish Yew 86 236323 Larkin St 8 Sidewalk: Property side : Cutout Tree Private 2   02/19/2008 12:00:00 AM   3x3 Permit Number 50274 6006714 2119291 37.7995481543168 -122.420878746938 (37.7995481543168, -122.420878746938) 5 9 1 28858 32
159941 136686 DPW Maintained 1 Taxus baccata :: Irish Yew 86 915 Bay St 1 Sidewalk: Property side : Yard Tree Private 2     7 Width 2ft   6006372.4804 2121073.97355 37.8044244898475 -122.42218727034 (37.8044244898475, -122.42218727034) 5 1 1 28858 32
168686 136707 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1155 Greenwich St 3 Sidewalk: Property side : Yard Tree Private 2     5 Width 2ft   6007381.61519 2119835.37419 37.8010804768418 -122.418607177199 (37.8010804768418, -122.418607177199) 5 1 1 28858 32
169155 136706 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1155 Greenwich St 2 Sidewalk: Property side : Yard Tree Private 2     5 Width 3ft   6007368.03811 2119831.84665 37.8010700267201 -122.418653909561 (37.8010700267201, -122.418653909561) 5 1 1 28858 32
175671 67619 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1101 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/14/1992 12:00:00 AM 11   Permit Number 31202 6007683.17057 2118835.54867 37.7983521792584 -122.417492763389 (37.7983521792584, -122.417492763389) 5 1 10 28858 32
185017 136688 DPW Maintained 1 Taxus baccata :: Irish Yew 86 777 Bay St 1 Sidewalk: Property side : Yard Tree Private 2     5 Width 2ft   6007087.93893 2121181.13167 37.8047590475447 -122.419718966771 (37.8047590475447, -122.419718966771) 5 1 1 28858 32
191106 136679 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1369 Hyde St 4 Sidewalk: Property side : Yard Tree Private 2     4 Width 2ft   6007499.46397 2117047.73589 37.7934329524128 -122.41800163939 (37.7934329524128, -122.41800163939) 5 1 10 28858 32
192961 136689 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1101 Green St 2 Sidewalk: Property side : Yard Tree Private 2     3 Width 2ft   6007697.4603 2118837.4061 37.7983580833179 -122.41744344816 (37.7983580833179, -122.41744344816) 5 1 10 28858 32

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