trees
40 rows where Zip Codes = 28859 and qSpecies_id = 39 sorted by qCareAssistant
This data as json, CSV (advanced)
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 | |||
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 | |
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 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );