trees

40 rows where Zip Codes = 28859 and qSpecies_id = 39

✎ View and edit SQL

This data as json, CSV (advanced)

These facets timed out: Zip Codes

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)
5839 239162 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1400 Potrero Ave 6 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6010646.64467 2101254.46555 37.7502448951922 -122.405998999548 (37.7502448951922, -122.405998999548) 10 4 7 28859 19
20785 239226 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 2851 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6010136.75438 2101030.89604 37.7496024914637 -122.407746478521 (37.7496024914637, -122.407746478521) 2 4 7 28859 19
26357 91026 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 722 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   11/18/2008 12:00:00 AM 3 3x3   6007490.257402 2105446.273959 37.7615776005454 -122.417211018518 (37.7615776005454, -122.417211018518) 2 4 7 28859 19
29978 239221 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 2810 26th St 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6010295.22869 2101085.95879 37.7497625519161 -122.407202347334 (37.7497625519161, -122.407202347334) 2 4 7 28859 19
38180 65253 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1020 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/21/2009 12:00:00 AM   3x3 Permit Number 52660 6009405.78315449 2103223.20926555 37.7555811463792 -122.410428993303 (37.7555811463792, -122.410428993303) 2 4 7 28859 19
40493 95067 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1575 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   12/15/2010 12:00:00 AM   3x3 Permit Number 54019 6007827.1 2100671.6 37.7484863781823 -122.415707927927 (37.7484863781823, -122.415707927927) 2 4 7 28859 19
40978 239166 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1400 Potrero Ave 10 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6010684.29962 2101159.52227 37.749986307743 -122.405862098468 (37.749986307743, -122.405862098468) 10 4 7 28859 19
43599 91027 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 722 South Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1   11/18/2008 12:00:00 AM 3 3x3   6007490.257402 2105446.273959 37.7615776005454 -122.417211018518 (37.7615776005454, -122.417211018518) 2 4 7 28859 19
43730 55657 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 349 Coleridge St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/14/2009 12:00:00 AM   3x3 Permit Number 52575 6006153.21523754 2098012.87204699 37.7410918742968 -122.421307424196 (37.7410918742968, -122.421307424196) 2 7 7 28859 2
50006 239167 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1400 Potrero Ave 11 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   6010693.26923 2101137.12494 37.7499253112163 -122.405829503442 (37.7499253112163, -122.405829503442) 10 4 7 28859 19
50302 239160 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1400 Potrero Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6010602.41193 2101365.81223 37.7505481546786 -122.406159803726 (37.7505481546786, -122.406159803726) 10 4 7 28859 19
55996 239170 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1400 Potrero Ave 17 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6010748.55016 2100997.3935 37.7495447307243 -122.405628497759 (37.7495447307243, -122.405628497759) 10 4 7 28859 19
61224 239222 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 2830 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6010232.06115 2101082.77231 37.749750267174 -122.407420559713 (37.749750267174, -122.407420559713) 2 4 7 28859 19
62633 239227 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 2851 26th St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6010159.00691 2101032.65482 37.7496085663777 -122.407669652152 (37.7496085663777, -122.407669652152) 2 4 7 28859 19
69110 239220 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 2730 Bryant St 6 Front Yard : Yard Tree Private 2     2 Width 7ft   6009770.49444 2101313.01983 37.7503566305768 -122.409032927236 (37.7503566305768, -122.409032927236) 2 4 7 28859 19
69432 239228 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 819 York St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6009935.7806 2104272.52927 37.7584920407792 -122.408670110163 (37.7584920407792, -122.408670110163) 2 4 7 28859 19
69789 239171 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1400 Potrero Ave 20 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6010775.13287 2100929.58266 37.7493600234457 -122.405531798154 (37.7493600234457, -122.405531798154) 10 4 7 28859 19
72149 239182 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 3599 17th St 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6005021.22782 2106010.41037 37.7629873721785 -122.425790544398 (37.7629873721785, -122.425790544398) 8 4 5 28859 19
74646 239223 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 2850 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6010195.06778 2101081.2894 37.7497441247919 -122.407548380357 (37.7497441247919, -122.407548380357) 2 4 7 28859 19
76680 239173 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 3705 25th St 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6005734.96606 2101372.66505 37.7502935116564 -122.422992320041 (37.7502935116564, -122.422992320041) 2 4 5 28859 19
83615 95066 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1575 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/15/2010 12:00:00 AM   3x3 Permit Number 54019 6007827.1 2100671.6 37.7484863781823 -122.415707927927 (37.7484863781823, -122.415707927927) 2 4 7 28859 19
93804 239165 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1400 Potrero Ave 9 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6010673.44533 2101181.95766 37.7500473033606 -122.405901213588 (37.7500473033606, -122.405901213588) 10 4 7 28859 19
98663 239224 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 2850 26th St 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6010131.27143 2101077.30272 37.7497296070346 -122.407768710669 (37.7497296070346, -122.407768710669) 2 4 7 28859 19
104140 239169 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1400 Potrero Ave 14 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6010720.15958 2101068.99531 37.7497397459909 -122.405731716554 (37.7497397459909, -122.405731716554) 10 4 7 28859 19
108064 239161 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1400 Potrero Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6010627.47447 2101300.53615 37.7503703227358 -122.406068536926 (37.7503703227358, -122.406068536926) 10 4 7 28859 19
117785 82259 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 850 South Van Ness Ave 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/23/2011 12:00:00 AM 3 4x4 Permit Number 768603 6007525.28639452 2104705.22805815 37.7595448304107 -122.417037358657 (37.7595448304107, -122.417037358657) 2 4 7 28859 19
119193 39176 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 754 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   12/15/2009 12:00:00 AM     Permit Number 53085 6007474 2105260 37.7610652207705 -122.417254045994 (37.7610652207705, -122.417254045994) 2 4 7 28859 19
120944 239168 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1400 Potrero Ave 12 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6010702.84807 2101113.77684 37.7498617381444 -122.40579473475 (37.7498617381444, -122.40579473475) 10 4 7 28859 19
122690 239164 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1400 Potrero Ave 8 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6010663.94961 2101209.37133 37.7501220442103 -122.405935981386 (37.7501220442103, -122.405935981386) 10 4 7 28859 19
126270 239219 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 2730 Bryant St 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6009767.82555 2101370.89854 37.7505154031821 -122.409046239907 (37.7505154031821, -122.409046239907) 2 4 7 28859 19
130061 239183 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 720 South Van Ness Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6007476.35772 2105397.09343 37.761441780224 -122.41725560676 (37.761441780224, -122.41725560676) 2 4 7 28859 19
142290 239184 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 754 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6007487.61608 2105246.87358 37.7610299446873 -122.417206023563 (37.7610299446873, -122.417206023563) 2 4 7 28859 19
142837 91029 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 967 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/18/2008 12:00:00 AM 5 3x3   6007608.48742 2104034.949256 37.7577090789947 -122.416702122814 (37.7577090789947, -122.416702122814) 2 4 7 28859 19
145611 239225 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 3041 26th St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6009370.46908 2100985.69041 37.7494354397039 -122.410393138328 (37.7494354397039, -122.410393138328) 2 4 7 28859 19
146320 91028 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 722 South Van Ness Ave 4 Sidewalk: Curb side : Cutout Tree DPW 1   11/18/2008 12:00:00 AM 3 3x3   6007490.257402 2105446.273959 37.7615776005454 -122.417211018518 (37.7615776005454, -122.417211018518) 2 4 7 28859 19
146783 239159 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1400 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   6010593.731 2101386.95157 37.7506057130911 -122.406191312392 (37.7506057130911, -122.406191312392) 10 4 7 28859 19
148467 239163 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1400 Potrero Ave 7 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6010654.95431 2101230.51738 37.7501796035287 -122.405968577287 (37.7501796035287, -122.405968577287) 10 4 7 28859 19
161495 239172 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 66 Dorland St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6005143.16857 2105759.69419 37.7623058551435 -122.425350950383 (37.7623058551435, -122.425350950383) 8 4 5 28859 19
176674 43127 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 8 Prospect Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/14/2009 12:00:00 AM   3x3 Permit Number 52578 6007298.20406204 2099606.09068899 37.7455309835883 -122.417461342572 (37.7455309835883, -122.417461342572) 2 7 7 28859 2
189987 82263 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 850 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/23/2011 12:00:00 AM 5 4x4 Permit Number 768603 6007525.28639452 2104705.22805815 37.7595448304107 -122.417037358657 (37.7595448304107, -122.417037358657) 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)
);