trees
1,381 rows where qSpecies_id = 54 sorted by DBH descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5517 | 4664 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 600X Columbus Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 5X5 | 6009692.468 | 2119649.5892 | 37.8007001848924 | -122.410597470914 | (37.8007001848924, -122.410597470914) | 3 | 1 | 10 | 308 | 23 | |||
9158 | 4659 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 600X Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 5X5 | 6009780.1976 | 2119571.0943 | 37.8004895753531 | -122.410288343699 | (37.8004895753531, -122.410288343699) | 3 | 1 | 10 | 308 | 23 | |||
52736 | 13161 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1895 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 3X3 | 6003359.5664 | 2119590.4223 | 37.8001806439695 | -122.432507683341 | (37.8001806439695, -122.432507683341) | 13 | 9 | 1 | 57 | 17 | |||
85810 | 13105 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1530 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/26/1993 12:00:00 AM | 90 | 3X3 | 6004999.0901 | 2119899.25 | 37.8011214413621 | -122.426856296775 | (37.8011214413621, -122.426856296775) | 13 | 9 | 1 | 57 | 17 | ||
91946 | 13112 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1601 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 3x3 | 6004666.807 | 2119779.6281 | 37.8007741971938 | -122.42799761136 | (37.8007741971938, -122.42799761136) | 13 | 9 | 1 | 57 | 17 | |||
105917 | 13104 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1530 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/26/1993 12:00:00 AM | 90 | 3X3 | 6005037.4004 | 2119906.2866 | 37.8011429280885 | -122.426724227861 | (37.8011429280885, -122.426724227861) | 13 | 9 | 1 | 57 | 17 | ||
118375 | 10259 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 180 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6005281.5755 | 2109598.2125 | 37.7728533265249 | -122.425145392536 | (37.7728533265249, -122.425145392536) | 7 | 9 | 11 | 28852 | 10 | |||
2761 | 199857 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2511 Keith St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6014147.0563 | 2092057.1756 | 37.725186191812 | -122.393250745752 | (37.725186191812, -122.393250745752) | 10 | 3 | 8 | 58 | 1 | |||
16609 | 141535 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2901 TURK BLVD | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5996788.0463 | 2111499.0832 | 37.777589151551 | -122.454662685268 | (37.777589151551, -122.454662685268) | 15 | 6 | 2 | 54 | 16 | |||
20967 | 64425 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 259 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/1988 12:00:00 AM | 9 | Permit Number 25277 | 6010096.4211 | 2121261.5999 | 37.8051490065079 | -122.409313442808 | (37.8051490065079, -122.409313442808) | 3 | 1 | 10 | 308 | 23 | ||
23493 | 199735 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1500 Armstrong Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6014648.3519 | 2092320.2341 | 37.7259363350419 | -122.391536186534 | (37.7259363350419, -122.391536186534) | 10 | 3 | 8 | 58 | 1 | |||
24167 | 31656 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1708 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/1995 12:00:00 AM | 9 | 3x3 | Permit Number 35163 | 6004478.3831 | 2114720.074 | 37.7868712864461 | -122.428288835726 | (37.7868712864461, -122.428288835726) | 13 | 9 | 11 | 28858 | 27 | |
24256 | 245132 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1585 Oak St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5999461.1138 | 2109428.314 | 37.7720563046211 | -122.445266756098 | (37.7720563046211, -122.445266756098) | 15 | 5 | 11 | 29492 | 9 | |||
26414 | 143167 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 195 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6009865.9706 | 2121568.5686 | 37.8059789520686 | -122.410132633272 | (37.8059789520686, -122.410132633272) | 3 | 1 | 10 | 308 | 23 | |||
39177 | 141081 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 190 Commonwealth Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5996587.7084 | 2113030.7088 | 37.7817830987642 | -122.455466443539 | (37.7817830987642, -122.455466443539) | 11 | 6 | 1 | 54 | 31 | |||
41596 | 141533 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2901 TURK BLVD | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5996746.9 | 2111493.597 | 37.7775717277647 | -122.454804626881 | (37.7775717277647, -122.454804626881) | 15 | 6 | 2 | 54 | 16 | |||
41625 | 142631 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 241 BAY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6009683.097 | 2121540.8838 | 37.8058926846956 | -122.410763542627 | (37.8058926846956, -122.410763542627) | 3 | 1 | 10 | 308 | 23 | |||
43861 | 111731 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 313 Ivy St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 2.5x3 | 6005824.7151 | 2111202.6522 | 37.7772893974301 | -122.423380687053 | (37.7772893974301, -122.423380687053) | 7 | 9 | 11 | 28852 | 10 | |||
43953 | 138715 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2900 BUSH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5999573.0166 | 2114358.1558 | 37.7855987705543 | -122.445234179741 | (37.7855987705543, -122.445234179741) | 15 | 6 | 1 | 29490 | 31 | |||
44260 | 199854 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2505 Keith St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6014200.0457 | 2092143.0549 | 37.7254249428706 | -122.393073571548 | (37.7254249428706, -122.393073571548) | 10 | 3 | 8 | 58 | 1 | |||
46246 | 143537 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2125 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6002811.2386 | 2118507.9925 | 37.7971774642757 | -122.434327678668 | (37.7971774642757, -122.434327678668) | 13 | 9 | 1 | 57 | 17 | |||
50284 | 142633 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 241 BAY ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6009714.0145 | 2121546.0367 | 37.8059085667329 | -122.410656911507 | (37.8059085667329, -122.410656911507) | 3 | 1 | 10 | 308 | 23 | |||
51491 | 143169 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 185 Bay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6009906.0036 | 2121573.3589 | 37.8059943488203 | -122.4099944305 | (37.8059943488203, -122.4099944305) | 3 | 1 | 10 | 308 | 23 | |||
53616 | 137517 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 11 Seymour St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6001642.6038 | 2112140.9289 | 37.779628745329 | -122.437915153636 | (37.779628745329, -122.437915153636) | 15 | 5 | 11 | 29490 | 41 | |||
58961 | 247391 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 215 Scott St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6002287.9227 | 2109197.4231 | 37.7715832884679 | -122.435472094457 | (37.7715832884679, -122.435472094457) | 15 | 5 | 11 | 29492 | 9 | |||
60391 | 185225 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2519 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5985800.5083 | 2098072.0747 | 37.7400859553966 | -122.491683090969 | (37.7400859553966, -122.491683090969) | 1 | 8 | 3 | 29491 | 35 | |||
61706 | 138607 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 512 PRESIDIO AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5999174.9019 | 2114851.0194 | 37.7869293124952 | -122.446647009525 | (37.7869293124952, -122.446647009525) | 15 | 6 | 1 | 29490 | 31 | |||
62896 | 199856 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2509 Keith St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6014162.2831 | 2092076.0569 | 37.7252388819994 | -122.393199428445 | (37.7252388819994, -122.393199428445) | 10 | 3 | 8 | 58 | 1 | |||
63983 | 62369 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 137 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/1985 12:00:00 AM | 9 | 3x3 | Permit Number 22515 | 5998258.1694 | 2110129.1192 | 37.7739117964536 | -122.449478321628 | (37.7739117964536, -122.449478321628) | 15 | 5 | 11 | 29492 | 16 | |
65468 | 140144 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2077 HAYES ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5997892.6775 | 2109904.5645 | 37.7732743123753 | -122.450726418895 | (37.7732743123753, -122.450726418895) | 15 | 5 | 11 | 29492 | 16 | |||
65580 | 199722 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2300 Jennings St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6015093.5789 | 2092222.3792 | 37.72569234746 | -122.38999022092 | (37.72569234746, -122.38999022092) | 10 | 3 | 8 | 58 | 1 | |||
76001 | 115985 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 900 Kearny St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6011253.148 | 2118063.4049 | 37.7964322821358 | -122.405085093558 | (37.7964322821358, -122.405085093558) | 3 | 1 | 10 | 308 | 4 | |||
80284 | 64505 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 412 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/1988 12:00:00 AM | 9 | Permit Number 25386 | 6001213.6317 | 2110153.0182 | 37.7741460412807 | -122.439256624823 | (37.7741460412807, -122.439256624823) | 15 | 5 | 11 | 29492 | 10 | |
81765 | 141777 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 7 Hollis St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6003915.306 | 2113275.4592 | 37.7828728597693 | -122.430133856067 | (37.7828728597693, -122.430133856067) | 7 | 9 | 11 | 29490 | 41 | |||
90781 | 137519 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 11 Seymour St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6001649.8446 | 2112101.8284 | 37.7795217969961 | -122.437887303264 | (37.7795217969961, -122.437887303264) | 15 | 5 | 11 | 29490 | 41 | |||
99796 | 141765 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1529 O'Farrell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6003847.9445 | 2113512.4132 | 37.7835196607686 | -122.43038381035 | (37.7835196607686, -122.43038381035) | 13 | 9 | 11 | 29490 | 41 | |||
100603 | 66825 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2047 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1991 12:00:00 AM | 9 | Permit Number 30121 | 5998040.6169 | 2109928.3267 | 37.7733480244518 | -122.450216391954 | (37.7733480244518, -122.450216391954) | 15 | 5 | 11 | 29492 | 16 | |
104792 | 142635 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 241 BAY ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6009773.7882 | 2121554.2814 | 37.8059345556962 | -122.410450636982 | (37.8059345556962, -122.410450636982) | 3 | 1 | 10 | 308 | 23 | |||
108661 | 245025 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1215 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6001121.5198 | 2109662.8083 | 37.7727948058407 | -122.439540106785 | (37.7727948058407, -122.439540106785) | 15 | 5 | 11 | 29492 | 9 | |||
112405 | 35162 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 521 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/02/1998 12:00:00 AM | 9 | Permit Number 38693 | 6002611.6162 | 2110373.5603 | 37.7748310484791 | -122.434436527113 | (37.7748310484791, -122.434436527113) | 15 | 5 | 11 | 29492 | 10 | |
113120 | 247361 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1775 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5998529.7882 | 2109299.0887 | 37.771648279481 | -122.448478963101 | (37.771648279481, -122.448478963101) | 15 | 5 | 11 | 29492 | 9 | |||
130071 | 247312 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 240 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6002307.4921 | 2109394.2887 | 37.7721249440599 | -122.435418487892 | (37.7721249440599, -122.435418487892) | 15 | 5 | 11 | 29492 | 9 | |||
133131 | 244023 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 508 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5997999.7197 | 2108815.8239 | 37.7702910368595 | -122.450277651998 | (37.7702910368595, -122.450277651998) | 15 | 5 | 11 | 29492 | 9 | |||
133221 | 199982 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1081 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6018036.5838 | 2092513.2332 | 37.7266537566215 | -122.379836574534 | (37.7266537566215, -122.379836574534) | 10 | 3 | 8 | 58 | 1 | |||
133285 | 248371 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1609 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5997803.1717 | 2108162.5244 | 37.7684859935016 | -122.450910393182 | (37.7684859935016, -122.450910393182) | 15 | 5 | 11 | 29492 | 9 | |||
134454 | 141080 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 192 Commonwealth Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5996588.0468 | 2113019.8793 | 37.7817533832417 | -122.455464489898 | (37.7817533832417, -122.455464489898) | 11 | 6 | 1 | 54 | 31 | |||
142979 | 141344 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1391 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6001208.1693 | 2110371.5133 | 37.7747456630859 | -122.439291184524 | (37.7747456630859, -122.439291184524) | 15 | 5 | 11 | 29492 | 10 | |||
149100 | 60603 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 630 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1991 12:00:00 AM | 9 | Permit Number 29505 | 6003603.285 | 2110552.7276 | 37.775379238631 | -122.431018929857 | (37.775379238631, -122.431018929857) | 7 | 9 | 11 | 29492 | 10 | |
153516 | 142124 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1221 FULTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6001940.0404 | 2111161.7753 | 37.776957145428 | -122.436816080775 | (37.776957145428, -122.436816080775) | 15 | 5 | 11 | 29492 | 10 | |||
156904 | 4726 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1075 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | 6008251.3021 | 2120879.612 | 37.8039966159278 | -122.415671655323 | (37.8039966159278, -122.415671655323) | 5 | 1 | 10 | 308 | 32 | ||||
158536 | 138588 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1732 BAKER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6000056.8342 | 2114968.7073 | 37.7873027909955 | -122.443604192363 | (37.7873027909955, -122.443604192363) | 13 | 6 | 1 | 29490 | 27 | |||
167006 | 112132 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 630 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6003600.3374 | 2110567.9569 | 37.7754208875098 | -122.431030213476 | (37.7754208875098, -122.431030213476) | 7 | 9 | 11 | 29492 | 10 | |||
177613 | 244504 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 697 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6003691.552 | 2110018.3364 | 37.773916933054 | -122.430675451783 | (37.773916933054, -122.430675451783) | 7 | 9 | 11 | 29492 | 10 | |||
180014 | 138587 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1732 BAKER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6000059.0615 | 2114952.3738 | 37.7872580704829 | -122.443595312613 | (37.7872580704829, -122.443595312613) | 13 | 6 | 1 | 29490 | 27 | |||
182944 | 245112 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1511 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5999762.5828 | 2109470.1939 | 37.7721884999222 | -122.444226964495 | (37.7721884999222, -122.444226964495) | 15 | 5 | 11 | 29492 | 9 | |||
188527 | 247347 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1563 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5999077.9485 | 2109033.7671 | 37.7709511000472 | -122.446563758939 | (37.7709511000472, -122.446563758939) | 15 | 5 | 11 | 29492 | 9 | |||
189309 | 140143 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2077 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/06/1981 12:00:00 AM | 9 | Width 0ft | Permit Number 19125 | 5997871.2148 | 2109901.8816 | 37.7732657172386 | -122.45080046745 | (37.7732657172386, -122.45080046745) | 15 | 5 | 11 | 29492 | 16 | |
192060 | 244242 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 151 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6005776.1437 | 2110149.7201 | 37.7743955596449 | -122.423473837096 | (37.7743955596449, -122.423473837096) | 7 | 9 | 11 | 28852 | 10 | |||
192913 | 142130 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 24 HEMWAY TER | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5998647.6806 | 2110905.5745 | 37.7760660175212 | -122.448186864357 | (37.7760660175212, -122.448186864357) | 15 | 6 | 2 | 29492 | 16 | |||
5587 | 4662 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 600X Columbus Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 5X5 | 6009727.0981 | 2119617.2678 | 37.8006133797513 | -122.410475352391 | (37.8006133797513, -122.410475352391) | 3 | 1 | 10 | 308 | 23 | |||
11591 | 246388 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1640 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5997718.8338 | 2108194.9271 | 37.7685701345672 | -122.451204446298 | (37.7685701345672, -122.451204446298) | 15 | 5 | 11 | 29492 | 9 | |||
11850 | 66378 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 624 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1991 12:00:00 AM | 8 | Permit Number 29503 | 6003604.7588 | 2110527.1817 | 37.7753091794017 | -122.431012007993 | (37.7753091794017, -122.431012007993) | 7 | 9 | 11 | 29492 | 10 | |
18641 | 59622 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 448 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/1988 12:00:00 AM | 8 | Permit Number 25385 | 6001193.7685 | 2110273.1905 | 37.7744748738878 | -122.439333950555 | (37.7744748738878, -122.439333950555) | 15 | 5 | 11 | 29492 | 10 | |
22206 | 199853 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2503 Keith St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6014209.1818 | 2092155.2364 | 37.7254588983374 | -122.393042840565 | (37.7254588983374, -122.393042840565) | 10 | 3 | 8 | 58 | 1 | |||
25346 | 139115 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2613 POST ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5999526.5436 | 2113598.8751 | 37.7835113303016 | -122.445340349757 | (37.7835113303016, -122.445340349757) | 15 | 6 | 1 | 29490 | 31 | |||
30933 | 245077 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1387 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6000372.5007 | 2109554.1199 | 37.7724537171291 | -122.442123238035 | (37.7724537171291, -122.442123238035) | 15 | 5 | 11 | 29492 | 9 | |||
40875 | 138980 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 712 STEINER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6003074.6186 | 2110844.4251 | 37.7761501973749 | -122.432868552462 | (37.7761501973749, -122.432868552462) | 15 | 9 | 11 | 29492 | 10 | |||
41921 | 141342 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 454 BRODERICK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6001185.8232 | 2110322.8485 | 37.7746107701242 | -122.439364995038 | (37.7746107701242, -122.439364995038) | 15 | 5 | 11 | 29492 | 10 | |||
49867 | 247452 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 913 Oak St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6002642.725 | 2109874.1732 | 37.7734616212008 | -122.434293205315 | (37.7734616212008, -122.434293205315) | 15 | 5 | 11 | 29492 | 9 | |||
53627 | 138867 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 700 STEINER ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6003082.3731 | 2110792.3591 | 37.7760076768733 | -122.432838007184 | (37.7760076768733, -122.432838007184) | 15 | 9 | 11 | 29492 | 10 | |||
56468 | 143504 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 3 Gerke Aly | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6010525.4571 | 2120179.6266 | 37.8022022028818 | -122.407752365718 | (37.8022022028818, -122.407752365718) | 3 | 1 | 10 | 308 | 23 | |||
59474 | 49435 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1919 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/2003 12:00:00 AM | 8 | Permit Number 46373 | 6001939.0069 | 2115153.2685 | 37.7879167140987 | -122.437105502206 | (37.7879167140987, -122.437105502206) | 13 | 6 | 1 | 29490 | 27 | ||
64399 | 200832 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2000 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6010535.924 | 2106957.4024 | 37.7658976908793 | -122.406783753376 | (37.7658976908793, -122.406783753376) | 8 | 4 | 8 | 28853 | 19 | |||
70658 | 32296 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1616 16th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/1996 12:00:00 AM | 8 | Permit Number 36875 | 6011540.2459 | 2107019.2214 | 37.7661235750542 | -122.403314342162 | (37.7661235750542, -122.403314342162) | 8 | 3 | 8 | 28853 | 20 | ||
72300 | 251046 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 5625 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5989523.2215 | 2112593.8297 | 37.7801756529596 | -122.479874006145 | (37.7801756529596, -122.479874006145) | 11 | 6 | 2 | 55 | 26 | |||
74732 | 143543 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2163 UNION ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6002677.2113 | 2118490.3401 | 37.7971213870276 | -122.434790182952 | (37.7971213870276, -122.434790182952) | 13 | 9 | 1 | 57 | 17 | |||
77575 | 23736 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 815 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/15/2005 12:00:00 AM | 8 | 4X4 | 6003952.5765 | 2110750.7086 | 37.7759426316052 | -122.429824773698 | (37.7759426316052, -122.429824773698) | 7 | 9 | 11 | 29492 | 10 | ||
79951 | 248610 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 872 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5997691.4278 | 2107516.4386 | 37.7667056091614 | -122.4512503025 | (37.7667056091614, -122.4512503025) | 15 | 5 | 11 | 29492 | 9 | |||
80537 | 199852 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2501 Keith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6014213.4453 | 2092166.8088 | 37.7254909106612 | -122.393028911239 | (37.7254909106612, -122.393028911239) | 10 | 3 | 8 | 58 | 1 | |||
83301 | 139365 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1590 LYON ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5999665.9385 | 2114296.9513 | 37.7854360225018 | -122.444908296806 | (37.7854360225018, -122.444908296806) | 15 | 6 | 1 | 29490 | 31 | |||
83635 | 138691 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2844 BUSH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5999863.2879 | 2114398.2903 | 37.7857255339984 | -122.444232813751 | (37.7857255339984, -122.444232813751) | 15 | 6 | 1 | 29490 | 31 | |||
86084 | 199739 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1500 Armstrong Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6014497.7489 | 2092432.2899 | 37.7262356573725 | -122.392064648003 | (37.7262356573725, -122.392064648003) | 10 | 3 | 8 | 58 | 1 | |||
90083 | 138979 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 714 STEINER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6003072.403 | 2110865.473 | 37.7762078640198 | -122.432877720829 | (37.7762078640198, -122.432877720829) | 15 | 9 | 11 | 29492 | 10 | |||
91146 | 247383 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 221 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6002277.0684 | 2109276.7953 | 37.7718006084073 | -122.43551531912 | (37.7718006084073, -122.43551531912) | 15 | 5 | 11 | 29492 | 9 | |||
98077 | 244543 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1901 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5997870.5431 | 2109205.9484 | 37.7713548252376 | -122.450752603903 | (37.7713548252376, -122.450752603903) | 15 | 5 | 11 | 29492 | 9 | |||
102572 | 94860 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2161 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 6x4 | 5997487.0021 | 2110201.3474 | 37.7740659715368 | -122.452151115771 | (37.7740659715368, -122.452151115771) | 15 | 5 | 11 | 29492 | 16 | |||
105727 | 199855 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2507 Keith St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6014175.0737 | 2092094.9381 | 37.7252914365514 | -122.393156532831 | (37.7252914365514, -122.393156532831) | 10 | 3 | 8 | 58 | 1 | |||
106030 | 247258 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2089 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5997028.4355 | 2109091.0184 | 37.7709910168471 | -122.453657177015 | (37.7709910168471, -122.453657177015) | 15 | 5 | 11 | 29492 | 9 | |||
106377 | 138865 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 700 STEINER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6003091.7893 | 2110720.9068 | 37.775812020633 | -122.432800328558 | (37.775812020633, -122.432800328558) | 15 | 9 | 11 | 29492 | 10 | |||
108876 | 199858 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2513 Keith St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6014132.4385 | 2092038.2943 | 37.7251335354362 | -122.393299957721 | (37.7251335354362, -122.393299957721) | 10 | 3 | 8 | 58 | 1 | |||
114700 | 217547 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 102 Broad St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5995842.2441 | 2088093.8487 | 37.7132698999071 | -122.456241804318 | (37.7132698999071, -122.456241804318) | 9 | 8 | 6 | 28861 | 24 | |||
115233 | 94582 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 710 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 4.5x5 | 6003079.6036 | 2110819.4999 | 37.7760820416979 | -122.432849526968 | (37.7760820416979, -122.432849526968) | 15 | 9 | 11 | 29492 | 10 | |||
119997 | 138866 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 700 STEINER ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6003084.5886 | 2110775.7422 | 37.7759621766443 | -122.432829155834 | (37.7759621766443, -122.432829155834) | 15 | 9 | 11 | 29492 | 10 | |||
128165 | 142920 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1339 KEARNY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6011019.5196 | 2119515.0732 | 37.800405147287 | -122.405995819069 | (37.800405147287, -122.405995819069) | 3 | 1 | 10 | 308 | 23 | |||
129809 | 247451 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 915 Oak St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6002618.2019 | 2109871.0089 | 37.7734515408665 | -122.434377807884 | (37.7734515408665, -122.434377807884) | 15 | 5 | 11 | 29492 | 9 | |||
151305 | 31653 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1708 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/1995 12:00:00 AM | 8 | Permit Number 35163 | 6004466.8826 | 2114789.0769 | 37.7870601003628 | -122.428333544653 | (37.7870601003628, -122.428333544653) | 13 | 9 | 11 | 28858 | 27 | ||
153779 | 142620 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1 Scotland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6009140.6951 | 2120065.1504 | 37.8018102626301 | -122.412536232083 | (37.8018102626301, -122.412536232083) | 3 | 1 | 10 | 308 | 4 | |||
154521 | 138978 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 716 STEINER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6003068.5257 | 2110892.0599 | 37.7762806451334 | -122.432893033286 | (37.7762806451334, -122.432893033286) | 15 | 9 | 11 | 29492 | 10 | |||
156143 | 108009 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 419X Ivy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 6005268.3816 | 2111120.1092 | 37.7770313396992 | -122.425299350558 | (37.7770313396992, -122.425299350558) | 7 | 9 | 11 | 28852 | 10 | ||||
157672 | 199724 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2300 Jennings St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6015054.2433 | 2092170.681 | 37.7255482128528 | -122.390122592124 | (37.7255482128528, -122.390122592124) | 10 | 3 | 8 | 58 | 1 |
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) );