trees

Custom SQL query returning 23 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
32072 197024 1 39 2 Waterloo St 1 Sidewalk: Curb side : Cutout Tree 2     3 Width 4ft   6010624.95454 2097233.34103 37.7392025469594 -122.405790793937 (37.7392025469594, -122.405790793937) 10 3 8 58 1
62409 197026 1 39 2 Waterloo St 3 : Tree 2     3 Width 4ft   6010467.19371 2097248.77404 37.7392360988707 -122.406337349712 (37.7392360988707, -122.406337349712) 10 3 8 58 1
66871 239150 1 39 100 Octavia St 1 Sidewalk: Curb side : Cutout Tree 1     4 Width 4ft   6005732.39027 2109686.64828 37.7731216065951 -122.4235922587 (37.7731216065951, -122.4235922587) 7 9 11 28852 10
68141 239174 1 39 1714 15th St 1 Sidewalk: Curb side : Cutout Tree 2     3 Width 4ft   6005940.64905 2107290.54233 37.7665542255162 -122.422701553932 (37.7665542255162, -122.422701553932) 8 4 5 28853 19
90422 197030 1 39 1601 Kirkwood Ave 2 : Tree 2     4 Width 4ft   6015124.98776 2096779.46594 37.7382069300149 -122.390199871734 (37.7382069300149, -122.390199871734) 10 3 8 58 1
95826 239156 4 39 101 Octavia St 4 : Tree 2     5 Width 4ft   6005612.49957 2109700.10187 37.7731517788755 -122.42400793342 (37.7731517788755, -122.42400793342) 7 9 11 28852 10
109559 197029 1 39 1601 Kirkwood Ave 1 : Tree 2     4 Width 4ft   6015115.28126 2096786.01211 37.7382243660701 -122.390233889493 (37.7382243660701, -122.390233889493) 10 3 8 58 1
110773 239176 1 39 1748 15th St 1 Sidewalk: Curb side : Cutout Tree 2     4 Width 4ft   6005773.30835 2107281.96849 37.7665212410869 -122.423279746972 (37.7665212410869, -122.423279746972) 8 4 5 28853 19
126270 239219 1 39 2730 Bryant St 3 Sidewalk: Curb side : Cutout Tree 2     4 Width 4ft   6009767.82555 2101370.89854 37.7505154031821 -122.409046239907 (37.7505154031821, -122.409046239907) 2 4 7 28859 19
128429 239175 1 39 1742 15th St 1 Sidewalk: Curb side : Cutout Tree 2     3 Width 4ft   6005792.61573 2107282.25816 37.7665231260736 -122.423212986701 (37.7665231260736, -122.423212986701) 8 4 5 28853 19
136407 197025 1 39 2 Waterloo St 2 Sidewalk: Curb side : Cutout Tree 2     3 Width 4ft   6010590.71236 2097235.47599 37.7392064940954 -122.405909338939 (37.7392064940954, -122.405909338939) 10 3 8 58 1
145499 239158 4 39 101 Octavia St 6 : Tree 2     4 Width 4ft   6005617.18186 2109670.50026 37.7730707643493 -122.423989631326 (37.7730707643493, -122.423989631326) 7 9 11 28852 10
145611 239225 1 39 3041 26th St 2 Sidewalk: Curb side : Cutout Tree 2     2 Width 4ft   6009370.46908 2100985.69041 37.7494354397039 -122.410393138328 (37.7494354397039, -122.410393138328) 2 4 7 28859 19
154733 197028 1 39 2 Waterloo St 5 Sidewalk: Curb side : Cutout Tree 2     4 Width 4ft   6010376.04785 2097256.74048 37.7392528739127 -122.406653054018 (37.7392528739127, -122.406653054018) 10 3 8 58 1
158340 197035 1 39 1751 Armstrong Ave 1 Sidewalk: Curb side : Yard Tree 2     4 Width 4ft   6013551.1098 2093063.74117 37.7279168907351 -122.395381369648 (37.7279168907351, -122.395381369648) 10 3 8 58 1
160035 239155 1 39 150 Octavia St 7 : Tree 2     7 Width 4ft   6005700.01949 2109925.21059 37.7737748138817 -122.423721198991 (37.7737748138817, -122.423721198991) 7 9 11 28852 10
162569 197034 1 39 1777 Armstrong Ave 1 Sidewalk: Curb side : Yard Tree 2     5 Width 4ft   6013492.1426 2093105.49396 37.7280282555765 -122.395588146293 (37.7280282555765, -122.395588146293) 10 3 8 58 1
167653 239153 1 39 150 Octavia St 5 : Tree 2     3 Width 4ft   6005703.32038 2109897.04283 37.7736976583474 -122.423707777507 (37.7736976583474, -122.423707777507) 7 9 11 28852 10
168474 239177 1 39 1778 15th St 1 Sidewalk: Curb side : Cutout Tree 2     1 Width 4ft   6005631.82803 2107273.89376 37.7664910841327 -122.423768528492 (37.7664910841327, -122.423768528492) 8 4 5 28853 19
171926 197027 1 39 2 Waterloo St 4 Sidewalk: Curb side : Cutout Tree 2     3 Width 4ft   6010417.49048 2097253.73995 37.7392469536854 -122.406509551872 (37.7392469536854, -122.406509551872) 10 3 8 58 1
181021 239152 1 39 100 Octavia St 3 : Tree 2     4 Width 4ft   6005729.11778 2109714.63204 37.7731982585339 -122.423605568636 (37.7731982585339, -122.423605568636) 7 9 11 28852 10
186345 239157 4 39 101 Octavia St 5 : Tree 2     3 Width 4ft   6005616.09638 2109686.32891 37.7731141647188 -122.423994511963 (37.7731141647188, -122.423994511963) 7 9 11 28852 10
190063 197036 1 39 1751 Armstrong Ave 2 Sidewalk: Curb side : Yard Tree 2     3 Width 4ft   6013567.34491 2093051.01085 37.7278828388179 -122.395324352636 (37.7278828388179, -122.395324352636) 10 3 8 58 1