trees
51 rows where Neighborhoods (old) = 13 and qSpecies_id = 54
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17922 | 21738 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2045 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6002837.9936 | 2114410.7158 | 37.7859289122324 | -122.433942077336 | (37.7859289122324, -122.433942077336) | 13 | 9 | 11 | 29490 | 13 | |||
23592 | 7266 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1740 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 4X4 | 6003064.3461 | 2114369.1192 | 37.7858275412041 | -122.433155987425 | (37.7858275412041, -122.433155987425) | 13 | 9 | 11 | 29490 | 13 | |||
27001 | 7264 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1730 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6003073.6496 | 2114318.6841 | 37.78568958693 | -122.433120195092 | (37.78568958693, -122.433120195092) | 13 | 9 | 11 | 29490 | 13 | |||
27696 | 53066 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2161 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/09/2006 12:00:00 AM | 4 | Permit Number 49038 | 6002280.6463 | 2114328.4092 | 37.7856712745428 | -122.435864451687 | (37.7856712745428, -122.435864451687) | 13 | 6 | 11 | 29490 | 13 | ||
31175 | 7267 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1750 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6003061.8978 | 2114394.5816 | 37.7858973156258 | -122.433166277822 | (37.7858973156258, -122.433166277822) | 13 | 9 | 11 | 29490 | 13 | |||
34952 | 21609 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1531 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/09/1990 12:00:00 AM | 12 | 4X4 | 6005037.9058 | 2114711.086 | 37.7868782513618 | -122.42635237507 | (37.7868782513618, -122.42635237507) | 13 | 9 | 11 | 28858 | 13 | ||
38110 | 138007 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1803 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6003877.7864 | 2114559.3667 | 37.7863960226531 | -122.430355290708 | (37.7863960226531, -122.430355290708) | 13 | 9 | 11 | 29490 | 13 | |||
38247 | 21606 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1525 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6005078.2447 | 2114724.3621 | 37.7869169843519 | -122.426213757225 | (37.7869169843519, -122.426213757225) | 13 | 9 | 11 | 28858 | 13 | |||
45477 | 138501 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1799 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6002528.8099 | 2114345.6813 | 37.7857327932764 | -122.435007113669 | (37.7857327932764, -122.435007113669) | 13 | 9 | 11 | 29490 | 13 | |||
50824 | 21628 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1615 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/29/1994 12:00:00 AM | 6 | 4X4 | 6004654.6857 | 2114664.3643 | 37.7867282957499 | -122.427674898563 | (37.7867282957499, -122.427674898563) | 13 | 9 | 11 | 28858 | 13 | ||
61004 | 138507 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1701 FILLMORE ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6003042.8042 | 2114198.3962 | 37.7853575570383 | -122.433218313249 | (37.7853575570383, -122.433218313249) | 13 | 9 | 11 | 29490 | 13 | |||
62961 | 138006 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1781 SUTTER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6004101.4738 | 2114584.9413 | 37.786478912061 | -122.429583213622 | (37.786478912061, -122.429583213622) | 13 | 9 | 11 | 29490 | 13 | |||
63562 | 7252 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1701 Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003031.0875 | 2114271.6252 | 37.7855579606737 | -122.433264083866 | (37.7855579606737, -122.433264083866) | 13 | 9 | 11 | 29490 | 13 | |||
68312 | 138537 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1700 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6003095.1947 | 2114174.7238 | 37.7852955304758 | -122.433035366169 | (37.7852955304758, -122.433035366169) | 13 | 9 | 11 | 29490 | 13 | |||
68680 | 106203 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1600X Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 5x5 | 6003127.4057 | 2113944.8226 | 37.7846661068828 | -122.432907495725 | (37.7846661068828, -122.432907495725) | 13 | 9 | 11 | 29490 | 13 | |||
71416 | 138011 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1401 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6005427.9087 | 2114512.7674 | 37.7863557555391 | -122.424988938346 | (37.7863557555391, -122.424988938346) | 13 | 9 | 11 | 28858 | 13 | |||
72035 | 138503 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1799 Steiner St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6002537.1515 | 2114272.2749 | 37.7855317115931 | -122.434973002389 | (37.7855317115931, -122.434973002389) | 13 | 6 | 11 | 29490 | 13 | |||
73966 | 138009 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1803 Sutter St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6003935.4192 | 2114568.0116 | 37.7864230237501 | -122.430156512807 | (37.7864230237501, -122.430156512807) | 13 | 9 | 11 | 29490 | 13 | |||
80640 | 138473 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1749 FILLMORE ST | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 17 | Width 0ft | 6003016.4418 | 2114370.4842 | 37.7858285716099 | -122.433321820329 | (37.7858285716099, -122.433321820329) | 13 | 9 | 11 | 29490 | 13 | |||
85092 | 138010 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1401 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6005424.6122 | 2114535.843 | 37.7864189291949 | -122.425001985822 | (37.7864189291949, -122.425001985822) | 13 | 9 | 11 | 28858 | 13 | |||
86133 | 7251 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1701 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003028.1584 | 2114287.7355 | 37.7856020293142 | -122.43327536926 | (37.7856020293142, -122.43327536926) | 13 | 9 | 11 | 29490 | 13 | |||
88396 | 7257 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1714 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4X4 | 6003087.8498 | 2114225.1589 | 37.785433595884 | -122.433064381988 | (37.785433595884, -122.433064381988) | 13 | 9 | 11 | 29490 | 13 | |||
103956 | 138474 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1749 FILLMORE ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6003020.1032 | 2114355.1062 | 37.7857865552298 | -122.433308053669 | (37.7857865552298, -122.433308053669) | 13 | 9 | 11 | 29490 | 13 | |||
105113 | 7250 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1701 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/21/1990 12:00:00 AM | 12 | 4X4 | 6003025.9615 | 2114308.2396 | 37.7856582037536 | -122.433284435542 | (37.7856582037536, -122.433284435542) | 13 | 9 | 11 | 29490 | 13 | ||
112471 | 117049 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2183 Sutter St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6002213.4716 | 2114319.9367 | 37.7856441950939 | -122.436096250016 | (37.7856441950939, -122.436096250016) | 13 | 6 | 11 | 29490 | 13 | |||
113929 | 21680 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1811 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003837.4434 | 2114549.281 | 37.7863660445938 | -122.430494147332 | (37.7863660445938, -122.430494147332) | 13 | 9 | 11 | 29490 | 13 | |||
114186 | 138001 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1685 SUTTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6004515.7645 | 2114645.0665 | 37.7866674497361 | -122.428154157217 | (37.7866674497361, -122.428154157217) | 13 | 9 | 11 | 28858 | 13 | |||
115553 | 7263 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1730 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6003079.0359 | 2114300.077 | 37.7856388020777 | -122.433100230123 | (37.7856388020777, -122.433100230123) | 13 | 9 | 11 | 29490 | 13 | |||
118877 | 138505 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2199 SUTTER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6002149.3229 | 2114310.859 | 37.7856156253984 | -122.43631753578 | (37.7856156253984, -122.43631753578) | 13 | 6 | 11 | 29490 | 13 | |||
118965 | 21740 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2045 Sutter St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6002881.8287 | 2114415.6319 | 37.7859448981022 | -122.433790771597 | (37.7859448981022, -122.433790771597) | 13 | 9 | 11 | 29490 | 13 | |||
122627 | 117047 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2183 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6002170.5041 | 2114314.4901 | 37.7856267989414 | -122.436244515027 | (37.7856267989414, -122.436244515027) | 13 | 6 | 11 | 29490 | 13 | |||
124225 | 113988 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2183 Sutter St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6002243.1253 | 2114325.3833 | 37.7856608347208 | -122.435994046788 | (37.7856608347208, -122.435994046788) | 13 | 6 | 11 | 29490 | 13 | |||
129005 | 106207 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1600X Fillmore St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 5x5 | 6003107.6347 | 2114075.5662 | 37.7850239743837 | -122.43298524084 | (37.7850239743837, -122.43298524084) | 13 | 9 | 11 | 29490 | 13 | |||
130807 | 21632 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1615 Sutter St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/04/1991 12:00:00 AM | 12 | 4X4 | 6004741.4911 | 2114677.6404 | 37.7867696583856 | -122.427375518495 | (37.7867696583856, -122.427375518495) | 13 | 9 | 11 | 28858 | 13 | ||
135488 | 138471 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1749 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | Width 0ft | 6003013.5126 | 2114407.0987 | 37.7859289395771 | -122.433334571847 | (37.7859289395771, -122.433334571847) | 13 | 9 | 11 | 29490 | 13 | |||
139785 | 7265 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1740 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6003066.7944 | 2114355.8984 | 37.7857913791158 | -122.433146572029 | (37.7857913791158, -122.433146572029) | 13 | 9 | 11 | 29490 | 13 | |||
145855 | 21673 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1781 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6004071.937 | 2114582.0596 | 37.786469327183 | -122.429685197969 | (37.786469327183, -122.429685197969) | 13 | 9 | 11 | 29490 | 13 | |||
149913 | 7259 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1718 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4X4 | 6003082.9532 | 2114267.2697 | 37.7855489437372 | -122.433084332552 | (37.7855489437372, -122.433084332552) | 13 | 9 | 11 | 29490 | 13 | |||
150049 | 7258 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1714 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4X4 | 6003084.9119 | 2114241.8074 | 37.7854791418066 | -122.433075736157 | (37.7854791418066, -122.433075736157) | 13 | 9 | 11 | 29490 | 13 | |||
150683 | 138506 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1701 FILLMORE ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6003039.875 | 2114221.8295 | 37.7854217327846 | -122.43323012237 | (37.7854217327846, -122.43323012237) | 13 | 9 | 11 | 29490 | 13 | |||
154099 | 21657 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1725 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6004318.093 | 2114616.1002 | 37.7865767294467 | -122.428835987308 | (37.7865767294467, -122.428835987308) | 13 | 9 | 11 | 29490 | 13 | |||
155990 | 138472 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1749 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | Width 0ft | 6003013.5126 | 2114389.5238 | 37.785880683353 | -122.433333315539 | (37.785880683353, -122.433333315539) | 13 | 9 | 11 | 29490 | 13 | |||
164335 | 138504 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2199 SUTTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6002136.009 | 2114306.6228 | 37.7856032373843 | -122.436363294657 | (37.7856032373843, -122.436363294657) | 13 | 6 | 11 | 29490 | 13 | |||
172102 | 21739 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2045 Sutter St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6002859.7063 | 2114412.7642 | 37.785935768772 | -122.433867103908 | (37.785935768772, -122.433867103908) | 13 | 9 | 11 | 29490 | 13 | |||
174365 | 21629 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1615 Sutter St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/1994 12:00:00 AM | 12 | 4X4 | 6004674.0893 | 2114666.9174 | 37.7867364034737 | -122.427607948661 | (37.7867364034737, -122.427607948661) | 13 | 9 | 11 | 28858 | 13 | ||
177315 | 138475 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1749 FILLMORE ST | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | Width 0ft | 6003020.8355 | 2114339.7281 | 37.7857443724045 | -122.433304420865 | (37.7857443724045, -122.433304420865) | 13 | 9 | 11 | 29490 | 13 | |||
178582 | 138502 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1799 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6002532.1465 | 2114322.3247 | 37.7856688514425 | -122.434993898965 | (37.7856688514425, -122.434993898965) | 13 | 9 | 11 | 29490 | 13 | |||
179783 | 106204 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1600X Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 5x5 | 6003122.9413 | 2113972.2468 | 37.7847411535968 | -122.432924900964 | (37.7847411535968, -122.432924900964) | 13 | 9 | 11 | 29490 | 13 | |||
182903 | 21608 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1531 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/09/1990 12:00:00 AM | 12 | 4X4 | 6005005.2261 | 2114710.5754 | 37.7868750020607 | -122.42646540299 | (37.7868750020607, -122.42646540299) | 13 | 9 | 11 | 28858 | 13 | ||
185736 | 138539 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1700 FILLMORE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6003089.8085 | 2114203.6138 | 37.7853745495912 | -122.433056065597 | (37.7853745495912, -122.433056065597) | 13 | 9 | 11 | 29490 | 13 | |||
194022 | 59752 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2375 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/1981 12:00:00 AM | 11 | Permit Number 19189 | 6000826.215 | 2113783.3508 | 37.7840919573447 | -122.440857239763 | (37.7840919573447, -122.440857239763) | 15 | 6 | 11 | 29490 | 13 |
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) );