trees
420 rows where qSpecies_id = 116 sorted by rowid 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
150208 | 101279 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2301 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 5988600.1162 | 2106446.7223 | 37.7632437243179 | -122.482616832407 | (37.7632437243179, -122.482616832407) | 1 | 8 | 3 | 56 | 35 | |||
149786 | 34054 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 375 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | Permit Number 37958 | 6008950.19472335 | 2106493.86234805 | 37.7645360636147 | -122.41223571698 | (37.7645360636147, -122.41223571698) | 8 | 4 | 7 | 28859 | 19 | ||
149347 | 101281 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2049 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 5989322.9543 | 2106470.5284 | 37.7633511157788 | -122.480118545713 | (37.7633511157788, -122.480118545713) | 1 | 8 | 3 | 56 | 35 | |||
147565 | 47560 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 580 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | Permit Number 45422 | 6007250.69827751 | 2103936.71356757 | 37.7574192165742 | -122.41793254418 | (37.7574192165742, -122.41793254418) | 2 | 4 | 7 | 28859 | 19 | ||
147492 | 254374 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 343 Woolsey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781359 | 6010747.56272 | 2091896.11912 | 37.7245545163839 | -122.404991175416 | (37.7245545163839, -122.404991175416) | 10 | 3 | 7 | 309 | 28 |
146756 | 44262 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 300 Duboce Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/20/2001 12:00:00 AM | Permit Number 43693 | 6004891.25445895 | 2108442.06671817 | 37.7696567724968 | -122.426413224583 | (37.7696567724968, -122.426413224583) | 7 | 4 | 5 | 28852 | 10 | |||
145354 | 199656 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1395 Donner Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6015030.8215 | 2090912.727 | 37.7220928214053 | -122.390115718832 | (37.7220928214053, -122.390115718832) | 10 | 3 | 8 | 58 | 1 | |||
145163 | 136744 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2906 Broderick St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 6000047.06944 | 2118581.72583 | 37.7972226334754 | -122.443897661751 | (37.7972226334754, -122.443897661751) | 13 | 9 | 1 | 57 | 17 | |||
145108 | 28414 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 600X Monterey Blvd | 3 | Median : Cutout | Tree | DPW 1 | 02/02/2003 12:00:00 AM | 12 | 5 | 5998107.3609693 | 2094732.8027768 | 37.7316286888145 | -122.448890739326 | (37.7316286888145, -122.448890739326) | 9 | 7 | 4 | 59 | 40 | ||
144411 | 179957 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 162 Tunnel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6011927.16714 | 2087557.34531 | 37.7127069906044 | -122.400608764476 | (37.7127069906044, -122.400608764476) | 10 | 3 | 8 | 309 | 1 | |||
144098 | 115615 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1400 16th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 4x4 | 6012069.0366 | 2107045.8512 | 37.766226213653 | -122.401487220087 | (37.766226213653, -122.401487220087) | 14 | 3 | 8 | 28853 | 20 | |||
143055 | 49075 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 1970 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2003 12:00:00 AM | Permit Number 46231 | 5993706.31601319 | 2092791.54243423 | 37.7260457932168 | -122.46396504093 | (37.7260457932168, -122.46396504093) | 9 | 8 | 4 | 59 | 40 | ||
142699 | 52313 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 4400HOFFMAN 24th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/2009 12:00:00 AM | 3x3 | Permit Number 52154 | 6000634.55195661 | 2101724.81174328 | 37.7509712947951 | -122.440655099281 | (37.7509712947951, -122.440655099281) | 2 | 4 | 5 | 28862 | 22 | ||
142402 | 99104 | Undocumented 4 | Trachycarpus fortunei :: Windmill Palm 116 | 3644 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006000.9 | 2104423 | 37.7586840282695 | -122.422289399469 | (37.7586840282695, -122.422289399469) | 2 | 4 | 5 | 28859 | 19 | ||||
142362 | 52312 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 4400HOFFMAN 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/2009 12:00:00 AM | 3x3 | Permit Number 52154 | 6000634.55195661 | 2101724.81174328 | 37.7509712947951 | -122.440655099281 | (37.7509712947951, -122.440655099281) | 2 | 4 | 5 | 28862 | 22 | ||
142119 | 183595 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2639 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5989548.2713 | 2097387.6993 | 37.7384251583472 | -122.478674965089 | (37.7384251583472, -122.478674965089) | 1 | 8 | 3 | 29491 | 35 | |||
142005 | 83791 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 369 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50933 | 6008828.16902132 | 2097088.78446754 | 37.7387049796432 | -122.411993079981 | (37.7387049796432, -122.411993079981) | 10 | 7 | 7 | 28859 | 2 | ||
141375 | 115616 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 1400 16th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6012270.55026102 | 2107054.03832976 | 37.7662599354936 | -122.400790794031 | (37.7662599354936, -122.400790794031) | 14 | 3 | 8 | 28856 | 20 | ||||
141092 | 101260 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1900 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5989805.9135 | 2106546.133 | 37.7635867556905 | -122.478453694684 | (37.7635867556905, -122.478453694684) | 1 | 8 | 3 | 56 | 35 | |||
140476 | 258418 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1839 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 5990060 | 2106509 | 37.7634995462716 | -122.477572184802 | (37.7634995462716, -122.477572184802) | 1 | 8 | 3 | 56 | 35 | ||||
139845 | 107411 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 3634 20th St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3x3 | 6006068 | 2104353 | 37.7584956093101 | -122.422052363883 | (37.7584956093101, -122.422052363883) | 2 | 4 | 5 | 28859 | 19 | ||||
138796 | 241213 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2801 17th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6009032.16938 | 2106352.76347 | 37.7641532379917 | -122.411942216073 | (37.7641532379917, -122.411942216073) | 8 | 4 | 7 | 28859 | 19 | |||
137988 | 56678 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2400 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5988274.3719 | 2106490.5517 | 37.7633451115211 | -122.483746674042 | (37.7633451115211, -122.483746674042) | 1 | 8 | 3 | 56 | 35 | |||
137854 | 42733 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 2155 Bay Shore Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42735 | 6011836.19977805 | 2087516.89388515 | 37.7125908452343 | -122.400920338197 | (37.7125908452343, -122.400920338197) | 10 | 3 | 8 | 309 | 1 | ||
137609 | 179961 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 299 Lathrop Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6012198.83214 | 2086842.9214 | 37.7107604718955 | -122.399619668515 | (37.7107604718955, -122.399619668515) | 10 | 3 | 8 | 309 | 1 | |||
136772 | 34047 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 375 Alabama St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | Permit Number 37958 | 6008950.19472335 | 2106493.86234805 | 37.7645360636147 | -122.41223571698 | (37.7645360636147, -122.41223571698) | 8 | 4 | 7 | 28859 | 19 | ||
136184 | 43754 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 367 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/26/2000 12:00:00 AM | 14 | Permit Number 43390 | 5991197.85001 | 2112958.02747 | 37.781272787853 | -122.474107339564 | (37.781272787853, -122.474107339564) | 11 | 6 | 2 | 54 | 26 | |
136147 | 119965 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 518 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 5987217.06494 | 2112373.1551 | 37.7794354929176 | -122.487835733288 | (37.7794354929176, -122.487835733288) | 11 | 6 | 2 | 55 | 26 | |||
135898 | 34049 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 375 Alabama St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | Permit Number 37958 | 6008950.19472335 | 2106493.86234805 | 37.7645360636147 | -122.41223571698 | (37.7645360636147, -122.41223571698) | 8 | 4 | 7 | 28859 | 19 | ||
135749 | 100964 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2425 Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 5988206.1929 | 2106434.2769 | 37.7631866273281 | -122.483978353246 | (37.7631866273281, -122.483978353246) | 1 | 8 | 3 | 56 | 35 | |||
133818 | 52311 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 4400HOFFMAN 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/2009 12:00:00 AM | 3x3 | Permit Number 52154 | 6000634.55195661 | 2101724.81174328 | 37.7509712947951 | -122.440655099281 | (37.7509712947951, -122.440655099281) | 2 | 4 | 5 | 28862 | 22 | ||
132359 | 215424 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 15 Fairfield Way | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5993760.13704 | 2092800.2871 | 37.7260729055276 | -122.463779620842 | (37.7260729055276, -122.463779620842) | 9 | 8 | 4 | 59 | 40 | |||
130983 | 94950 | Significant Tree 6 | Trachycarpus fortunei :: Windmill Palm 116 | 50 Pomona St | : Cutout | Tree | SFUSD 4 | FUF | 04/04/2009 12:00:00 AM | 6014124.7 | 2094445.3 | 37.7317422564721 | -122.393495086444 | (37.7317422564721, -122.393495086444) | 10 | 3 | 8 | 58 | 1 | ||||
130970 | 197985 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 669 Mississippi St | 2 | : | Tree | Private 2 | 9 | Width 3ft | 6014155.898 | 2104063.80675 | 37.758154390328 | -122.394060332116 | (37.758154390328, -122.394060332116) | 10 | 3 | 8 | 28856 | 29 | |||
130858 | 241218 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 4130 Cesar Chavez St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 6ft | 6003089.92025 | 2100398.1705 | 37.7474681682179 | -122.432069476034 | (37.7474681682179, -122.432069476034) | 2 | 4 | 5 | 63 | 22 | |||
130826 | 115632 | Undocumented 4 | Trachycarpus fortunei :: Windmill Palm 116 | 55x 15TH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6012114 | 2107494 | 37.7674592382642 | -122.40136319642 | (37.7674592382642, -122.40136319642) | 14 | 3 | 8 | 28856 | 20 | ||||
130674 | 101284 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2034 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 5989388.4992 | 2106533.1127 | 37.7635267635243 | -122.479896429915 | (37.7635267635243, -122.479896429915) | 1 | 8 | 3 | 56 | 35 | |||
130221 | 241187 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 45 Hoff St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 6ft | 6006570.58835 | 2106391.73918 | 37.7641218444722 | -122.420458896575 | (37.7641218444722, -122.420458896575) | 8 | 4 | 7 | 28859 | 19 | |||
129962 | 34076 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 2851X 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/19/2011 12:00:00 AM | 6 | 3x3 | Permit Number 768574 | 6007780.97837226 | 2105869.55428135 | 37.7627561815899 | -122.41623551069 | (37.7627561815899, -122.41623551069) | 8 | 4 | 7 | 28859 | 19 |
129697 | 98644 | Undocumented 4 | Trachycarpus fortunei :: Windmill Palm 116 | 2391 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6008222 | 2104509 | 37.7590452010005 | -122.414613883143 | (37.7590452010005, -122.414613883143) | 2 | 4 | 7 | 28859 | 19 | |||
129342 | 44264 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 300 Duboce Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/20/2001 12:00:00 AM | Permit Number 43693 | 6004891.25445895 | 2108442.06671817 | 37.7696567724968 | -122.426413224583 | (37.7696567724968, -122.426413224583) | 7 | 4 | 5 | 28852 | 10 | |||
129318 | 197986 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 498 Mississippi St | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6014051.93568 | 2104880.86729 | 37.7603920825505 | -122.394477092339 | (37.7603920825505, -122.394477092339) | 10 | 3 | 8 | 28856 | 29 | |||
129198 | 247212 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 800 Duboce Ave | 11 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 6001824.51541 | 2108284.91798 | 37.7690514458872 | -122.437009703838 | (37.7690514458872, -122.437009703838) | 15 | 5 | 5 | 29492 | 9 | |||
129179 | 241191 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 3630 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006057.85457 | 2104359.21039 | 37.7585120893797 | -122.422087892569 | (37.7585120893797, -122.422087892569) | 2 | 4 | 5 | 28859 | 19 | |||
129119 | 108282 | Undocumented 4 | Trachycarpus fortunei :: Windmill Palm 116 | 1 HENRY ADAMS ST | 7 | Sidewalk: Property side : Cutout | Tree | Private 2 | 10 | 3x3 | 6011517.4 | 2108140.5 | 37.7692010762684 | -122.403472255644 | (37.7692010762684, -122.403472255644) | 8 | 2 | 8 | 28853 | 20 | |||
128873 | 215423 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 15 Fairfield Way | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5993769.4086 | 2092813.96021 | 37.7261109828263 | -122.46374856184 | (37.7261109828263, -122.46374856184) | 9 | 8 | 4 | 59 | 40 | |||
128857 | 181647 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1810 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5990056.3621 | 2106554.5578 | 37.763624424605 | -122.477588097139 | (37.763624424605, -122.477588097139) | 1 | 8 | 3 | 56 | 35 | |||
127993 | 241196 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 285 Mullen Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6010370.46966 | 2100029.81656 | 37.7468668275408 | -122.406867732983 | (37.7468668275408, -122.406867732983) | 2 | 7 | 7 | 28859 | 2 | |||
127894 | 97338 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1917 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 5989797.6411 | 2106487.0994 | 37.7634241851075 | -122.478477988866 | (37.7634241851075, -122.478477988866) | 1 | 8 | 3 | 56 | 35 | |||
127663 | 258439 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2341 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5988410 | 2106416 | 37.7631483069578 | -122.483272121252 | (37.7631483069578, -122.483272121252) | 1 | 8 | 3 | 56 | 35 | ||||
127274 | 143059 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 440 GREENWICH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6010738.656 | 2120349.8129 | 37.8026814253217 | -122.407026593467 | (37.8026814253217, -122.407026593467) | 3 | 1 | 10 | 308 | 23 | |||
127178 | 115617 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 1400 16th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6012270.55026102 | 2107054.03832976 | 37.7662599354936 | -122.400790794031 | (37.7662599354936, -122.400790794031) | 14 | 3 | 8 | 28856 | 20 | ||||
125141 | 182441 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1529 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5985572.6922 | 2104787.172 | 37.7585104674539 | -122.492965288536 | (37.7585104674539, -122.492965288536) | 1 | 8 | 3 | 56 | 35 | |||
124668 | 181320 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2126 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 5989173 | 2106514 | 37.7634617628894 | -122.480640365287 | (37.7634617628894, -122.480640365287) | 1 | 8 | 3 | 56 | 35 | |||
124610 | 197995 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 881 Jamestown Ave | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 6014417.48937 | 2089293.51791 | 37.717612756412 | -122.392122692435 | (37.717612756412, -122.392122692435) | 10 | 3 | 8 | 58 | 1 | |||
124321 | 136743 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2900 Broderick St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 4ft | 6000050.87786 | 2118557.23395 | 37.7971556025074 | -122.44388272313 | (37.7971556025074, -122.44388272313) | 13 | 9 | 1 | 57 | 17 | |||
124283 | 246465 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 220 Duncan St | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6005035.80445 | 2099919.28541 | 37.7462633887397 | -122.425306657892 | (37.7462633887397, -122.425306657892) | 2 | 7 | 5 | 63 | 22 | |||
123985 | 141332 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1324 HAYES ST | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 0ft | 6001489.2623 | 2110460.5875 | 37.7750062304087 | -122.438325211171 | (37.7750062304087, -122.438325211171) | 15 | 5 | 11 | 29492 | 10 | |||
123956 | 44009 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 2701X 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2015 12:00:00 AM | 3 | Permit Number 43559. Tree 1 on 17th St | 6009464.30573862 | 2106385.10315991 | 37.7642662704227 | -122.410449858863 | (37.7642662704227, -122.410449858863) | 8 | 4 | 7 | 28859 | 19 | ||
123424 | 67713 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 557 02nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1992 12:00:00 AM | Permit Number 31325 | 6014732.24235944 | 2112894.33120186 | 37.7824330740175 | -122.392684800601 | (37.7824330740175, -122.392684800601) | 6 | 2 | 9 | 28856 | 6 | ||
123376 | 113776 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1710 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6000070.198 | 2114878.1306 | 37.7870548531015 | -122.443551447546 | (37.7870548531015, -122.443551447546) | 13 | 6 | 1 | 29490 | 27 | |||
122148 | 44008 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 2701X 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2015 12:00:00 AM | 3 | Permit Number 43559. Tree 2 on 17th St | 6009464.30573862 | 2106385.10315991 | 37.7642662704227 | -122.410449858863 | (37.7642662704227, -122.410449858863) | 8 | 4 | 7 | 28859 | 19 | ||
121022 | 241220 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2800 17th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009102.18096 | 2106403.85246 | 37.7642974442959 | -122.411703675409 | (37.7642974442959, -122.411703675409) | 8 | 4 | 7 | 28859 | 19 | |||
120819 | 16366 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1306X Montgomery St | 9 | Median : Cutout | Tree | DPW 1 | 8 | 8 | 6011454.04278 | 2119896.37482 | 37.8014764015683 | -122.404519042813 | (37.8014764015683, -122.404519042813) | 3 | 1 | 10 | 308 | 23 | |||
120616 | 179966 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 716 Peru Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 2ft | 6005255.40982 | 2092462.48384 | 37.725801087223 | -122.424017104714 | (37.725801087223, -122.424017104714) | 9 | 7 | 6 | 309 | 5 | |||
119624 | 182028 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2219 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 5988830 | 2106432 | 37.7632166722568 | -122.481820671399 | (37.7632166722568, -122.481820671399) | 1 | 8 | 3 | 56 | 35 | |||
118808 | 42738 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 2155 Bay Shore Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42735 | 6011836.19977805 | 2087516.89388515 | 37.7125908452343 | -122.400920338197 | (37.7125908452343, -122.400920338197) | 10 | 3 | 8 | 309 | 1 | ||
118475 | 100963 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2495 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 5988177 | 2106369 | 37.763005695226 | -122.484074533324 | (37.763005695226, -122.484074533324) | 1 | 8 | 3 | 56 | 35 | |||
117606 | 215439 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 217 Staples Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 5998709.41817 | 2093777.72882 | 37.729040692553 | -122.44674062198 | (37.729040692553, -122.44674062198) | 9 | 7 | 4 | 28861 | 40 | |||
117066 | 179963 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 85 South Hill Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 6002963.44574 | 2087110.53022 | 37.7109761365014 | -122.431558338255 | (37.7109761365014, -122.431558338255) | 9 | 7 | 6 | 28861 | 5 | |||
116325 | 258433 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2555 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5987757 | 2106384 | 37.7630224196739 | -122.485528252067 | (37.7630224196739, -122.485528252067) | 1 | 8 | 3 | 56 | 35 | ||||
116314 | 258437 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2435 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5988177 | 2106369 | 37.763005695226 | -122.484074533324 | (37.763005695226, -122.484074533324) | 1 | 8 | 3 | 56 | 35 | ||||
116276 | 258428 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2154 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5989006 | 2106545 | 37.7635371731016 | -122.481220228107 | (37.7635371731016, -122.481220228107) | 1 | 8 | 3 | 56 | 35 | ||||
116195 | 42309 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 249 Edna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2000 12:00:00 AM | Permit Number 42531 | 5998732.34943109 | 2093642.59637242 | 37.7286709604577 | -122.446651628377 | (37.7286709604577, -122.446651628377) | 9 | 7 | 4 | 28861 | 40 | |||
116024 | 39860 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 70 13th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2008 12:00:00 AM | 3x3 | Permit Number 50122 | 6008235.62773227 | 2108364.64558499 | 37.7696326766808 | -122.414839630355 | (37.7696326766808, -122.414839630355) | 8 | 4 | 9 | 28853 | 19 | ||
115769 | 258422 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1916 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5989767 | 2106571 | 37.7636527745423 | -122.478590101352 | (37.7636527745423, -122.478590101352) | 1 | 8 | 3 | 56 | 35 | ||||
115633 | 16314 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 758X Monterey Blvd | 6 | Median : Cutout | Tree | DPW 1 | 02/02/2003 12:00:00 AM | 12 | 5 | 5997070.7706475 | 2094757.2260752 | 37.7316364140758 | -122.452476180169 | (37.7316364140758, -122.452476180169) | 9 | 7 | 4 | 59 | 40 | ||
114997 | 49998 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1101X 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2003 12:00:00 AM | 12 | 3x3 | Permit Number 46740 | 6014225.48172 | 2105233.17299 | 37.7613690835438 | -122.393901534339 | (37.7613690835438, -122.393901534339) | 10 | 3 | 8 | 28856 | 29 |
114591 | 258438 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2425 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5988206.1929 | 2106434.2769 | 37.7631866273281 | -122.483978353246 | (37.7631866273281, -122.483978353246) | 1 | 8 | 3 | 56 | 35 | ||||
114315 | 108221 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 240 Shotwell St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007737.2 | 2106597 | 37.7647511168143 | -122.416438454623 | (37.7647511168143, -122.416438454623) | 8 | 4 | 7 | 28859 | 19 | ||||
114123 | 36797 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1350 Donner Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | 8 | 3x3 | Permit Number 39527 | 6015213.5435 | 2090847.5562 | 37.7219240080036 | -122.389479539312 | (37.7219240080036, -122.389479539312) | 10 | 3 | 8 | 58 | 1 | |
114110 | 66988 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1445 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/12/1992 12:00:00 AM | 12 | Permit Number 30339 | 6006117.71616 | 2118619.27503 | 37.7976701397196 | -122.422894339811 | (37.7976701397196, -122.422894339811) | 13 | 9 | 10 | 28858 | 32 | ||
114053 | 181367 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 4019 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5982046.1498 | 2105540.3564 | 37.7603716302877 | -122.505217265817 | (37.7603716302877, -122.505217265817) | 1 | 8 | 3 | 56 | 35 | |||
113741 | 117606 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 420 Castro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6002292.2454566 | 2105806.2278627 | 37.7622721434766 | -122.435214539817 | (37.7622721434766, -122.435214539817) | 15 | 4 | 5 | 28862 | 3 | |||
112826 | 42735 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 2155 Bay Shore Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42735 | 6011836.19977805 | 2087516.89388515 | 37.7125908452343 | -122.400920338197 | (37.7125908452343, -122.400920338197) | 10 | 3 | 8 | 309 | 1 | ||
112628 | 83941 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 60 13th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2008 12:00:00 AM | 3X3 | Permit Number 50121 | 6008302.41836553 | 2108360.42350377 | 37.7696248364946 | -122.414608304259 | (37.7696248364946, -122.414608304259) | 8 | 4 | 9 | 28853 | 19 | ||
112460 | 85491 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 4400 24th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/2007 12:00:00 AM | 3x3 | Permit Number 52154 | 6000641 | 2101716 | 37.7509474670616 | -122.440632169404 | (37.7509474670616, -122.440632169404) | 2 | 4 | 5 | 28862 | 22 | |||
112047 | 66205 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 285 Mullen Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/1990 12:00:00 AM | Permit Number 29289 | 6010420.85602386 | 2100006.0506029 | 37.746804390663 | -122.406691826217 | (37.746804390663, -122.406691826217) | 2 | 7 | 7 | 28859 | 2 | |||
112010 | 136751 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1142 Filbert St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 3ft | 6007453.51921 | 2119553.70533 | 37.8003111329029 | -122.41833837522 | (37.8003111329029, -122.41833837522) | 5 | 1 | 1 | 28858 | 32 | |||
111657 | 241225 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 4049 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6001920.58101 | 2105839.72544 | 37.7623430070574 | -122.436502382779 | (37.7623430070574, -122.436502382779) | 15 | 5 | 5 | 28862 | 3 | |||
111572 | 57900 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1324 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/1977 12:00:00 AM | 5 | Permit Number 16856 | 6001502.5818 | 2110462.7186 | 37.7750128394498 | -122.438279288937 | (37.7750128394498, -122.438279288937) | 15 | 5 | 11 | 29492 | 10 | ||
111371 | 255520 | Undocumented 4 | Trachycarpus fortunei :: Windmill Palm 116 | 77 Belgrave Ave | Sidewalk: Property side : Yard | Tree | Private 2 | 10x10 | Permit Number 781419 | 5998149.61527 | 2104897.27011 | 37.7595402565853 | -122.449476776674 | (37.7595402565853, -122.449476776674) | 15 | 5 | 11 | 28862 | 12 | ||||
110970 | 65602 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 114 Maynard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/1990 12:00:00 AM | 13 | Permit Number 28504 | 6004165.03379 | 2093741.91359 | 37.729252495484 | -122.427877581308 | (37.729252495484, -122.427877581308) | 9 | 7 | 6 | 28861 | 5 | |
110955 | 49074 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 1970 Ocean Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2003 12:00:00 AM | Permit Number 46231 | 5993706.31601319 | 2092791.54243423 | 37.7260457932168 | -122.46396504093 | (37.7260457932168, -122.46396504093) | 9 | 8 | 4 | 59 | 40 | ||
110492 | 4166 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 3771 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/18/1999 12:00:00 AM | 3 | 3X3 | 6005390.77926 | 2100476.44824 | 37.747813278574 | -122.424118813557 | (37.747813278574, -122.424118813557) | 2 | 4 | 5 | 28859 | 22 | ||
110485 | 44261 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 300 Duboce Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/20/2001 12:00:00 AM | Permit Number 43693 | 6004891.25445895 | 2108442.06671817 | 37.7696567724968 | -122.426413224583 | (37.7696567724968, -122.426413224583) | 7 | 4 | 5 | 28852 | 10 | |||
110288 | 241190 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2858 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6010222.30692 | 2101664.86224 | 37.7513480117 | -122.407495323966 | (37.7513480117, -122.407495323966) | 2 | 4 | 7 | 28859 | 19 | |||
109574 | 215417 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 286 Orizaba Ave | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 12 | 5994025.97554 | 2088461.57938 | 37.7141751725286 | -122.462546063947 | (37.7141751725286, -122.462546063947) | 9 | 8 | 6 | 28861 | 24 | ||||
109219 | 241183 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1720 Dolores St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6005264.11037 | 2098316.58265 | 37.7418756279601 | -122.424403226839 | (37.7418756279601, -122.424403226839) | 2 | 7 | 5 | 63 | 7 | |||
109210 | 34079 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 240 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | 6 | 3x3 | Permit Number 37968 | 6007780.97837226 | 2105869.55428135 | 37.7627561815899 | -122.41623551069 | (37.7627561815899, -122.41623551069) | 8 | 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) );