trees
420 rows where qSpecies_id = 116 sorted by XCoord
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
187747 | 85241 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 4331 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/28/2019 12:00:00 AM | 3 | Permit Number 784317 | 5981367.2124 | 2104841.304 | 37.7584122600662 | -122.507513483633 | (37.7584122600662, -122.507513483633) | 1 | 8 | 3 | 56 | 35 | ||
152027 | 85242 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 4331 Kirkham St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/28/2019 12:00:00 AM | 3 | Permit Number 784317 | 5981385.546 | 2104841.9152 | 37.7584150182243 | -122.507450124372 | (37.7584150182243, -122.507450124372) | 1 | 8 | 3 | 56 | 35 | ||
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 | |||
189294 | 69181 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1335 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1994 12:00:00 AM | 12 | Permit Number 33220 | 5982114.4178 | 2105957.0803 | 37.7615198518733 | -122.505012044902 | (37.7615198518733, -122.505012044902) | 1 | 8 | 3 | 56 | 35 | |
14414 | 11584 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 4001 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | 3X3 | 5982142.6866342 | 2105549.2773534 | 37.7604018044904 | -122.504884056543 | (37.7604018044904, -122.504884056543) | 1 | 8 | 3 | 56 | 35 | |||
88233 | 83362 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 3325 Rivera St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51120 | 5982822.4546 | 2100126.935 | 37.7455535383912 | -122.502131834041 | (37.7455535383912, -122.502131834041) | 1 | 8 | 3 | 29491 | 35 | |
172875 | 117708 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 4001 Clement St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 7ft | 5983029.04687 | 2113077.74857 | 37.7811249212832 | -122.502375780065 | (37.7811249212832, -122.502375780065) | 11 | 6 | 2 | 55 | 26 | |||
37911 | 117703 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 4001 Clement St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 7ft | 5983084.79003 | 2113081.26685 | 37.7811378565893 | -122.502183200126 | (37.7811378565893, -122.502183200126) | 11 | 6 | 2 | 55 | 26 | |||
108310 | 63197 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 472 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1986 12:00:00 AM | 14 | Permit Number 23738 | 5984415.83341 | 2112620.01213 | 37.7799494956437 | -122.497544458973 | (37.7799494956437, -122.497544458973) | 11 | 6 | 2 | 55 | 26 | |
90053 | 182351 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1501 35th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 0ft | 5985257.4301 | 2104935.3862 | 37.758898980602 | -122.49406651392 | (37.758898980602, -122.49406651392) | 1 | 8 | 3 | 56 | 35 | |||
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 | |||
77927 | 187639 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 1671 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/22/2017 12:00:00 AM | 3 | 3x6 | 5985585 | 2103854 | 37.7559489545124 | -122.492853989295 | (37.7559489545124, -122.492853989295) | 1 | 8 | 3 | 56 | 35 | ||
107025 | 182656 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2618 Ortega St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 0ft | 5985872.0635 | 2102330.847 | 37.7517835760889 | -122.491749119446 | (37.7517835760889, -122.491749119446) | 1 | 8 | 3 | 56 | 35 | |||
170389 | 182655 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2618 Ortega St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 0ft | 5985877.3992 | 2102330.362 | 37.7517825562574 | -122.491730632432 | (37.7517825562574, -122.491730632432) | 1 | 8 | 3 | 56 | 35 | |||
12573 | 182665 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2618 Ortega St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 0ft | 5985884.1902 | 2102331.3321 | 37.7517856167847 | -122.491707219971 | (37.7517856167847, -122.491707219971) | 1 | 8 | 3 | 56 | 35 | |||
47194 | 250756 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2900 Lake St | 1 | : | Tree | Private 2 | 6 | Width 0ft | 5986048.1037 | 2114785.2005 | 37.7859900201618 | -122.492057248563 | (37.7859900201618, -122.492057248563) | 11 | 6 | 1 | 55 | 33 | |||
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 | |||
152615 | 181644 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2520 Irving St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 5987753.3791 | 2106472.9578 | 37.7632664624287 | -122.485547304041 | (37.7632664624287, -122.485547304041) | 1 | 8 | 3 | 56 | 35 | |||
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 | ||||
104558 | 181643 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2520 Irving St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 5987777.5915 | 2106472.9578 | 37.7632678730962 | -122.485463562399 | (37.7632678730962, -122.485463562399) | 1 | 8 | 3 | 56 | 35 | |||
74382 | 181317 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2520 Irving St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5987802.3945 | 2106472.9578 | 37.7632693181117 | -122.48537777809 | (37.7632693181117, -122.48537777809) | 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 | ||||
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 | |||
169337 | 258432 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2450 Irving St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5988181.8432 | 2106487.3051 | 37.7633308106608 | -122.484066458576 | (37.7633308106608, -122.484066458576) | 1 | 8 | 3 | 56 | 35 | ||||
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 | ||||
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 | |||
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 | |||
106828 | 181621 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2340 Irving St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5988377.8972 | 2106492.1372 | 37.7633554905962 | -122.483388734412 | (37.7633554905962, -122.483388734412) | 1 | 8 | 3 | 56 | 35 | |||
82012 | 181620 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2340 Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5988409.299 | 2106492.1372 | 37.7633573181337 | -122.483280127139 | (37.7633573181337, -122.483280127139) | 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 | ||||
33664 | 181619 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2340 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5988436.1054 | 2106493.669 | 37.7633630840514 | -122.483187525947 | (37.7633630840514, -122.483187525947) | 1 | 8 | 3 | 56 | 35 | |||
174905 | 101273 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2324 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5988506 | 2106527 | 37.7634586690964 | -122.482948229193 | (37.7634586690964, -122.482948229193) | 1 | 8 | 3 | 56 | 35 | |||||
50833 | 110355 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2300 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5988563.2444 | 2106497.4984 | 37.76338099647 | -122.482748079472 | (37.76338099647, -122.482748079472) | 1 | 8 | 3 | 56 | 35 | |||
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 | |||
176061 | 34654 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2000 Kirkham St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | 3 | Permit Number 38332 | 5988619.0903 | 2105142.8889 | 37.7596648557466 | -122.482455667505 | (37.7596648557466, -122.482455667505) | 1 | 8 | 3 | 56 | 35 | |
153365 | 101268 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2240 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5988685.6106 | 2106506.2437 | 37.7634121273454 | -122.482325500356 | (37.7634121273454, -122.482325500356) | 1 | 8 | 3 | 56 | 35 | |||
163142 | 258471 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2229 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5988796 | 2106431 | 37.7632119492313 | -122.481938191449 | (37.7632119492313, -122.481938191449) | 1 | 8 | 3 | 56 | 35 | ||||
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 | |||
193222 | 258429 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2206 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5988870 | 2106540 | 37.7635155369644 | -122.481690237146 | (37.7635155369644, -122.481690237146) | 1 | 8 | 3 | 56 | 35 | ||||
107491 | 258427 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2142 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 | ||||
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 | ||||
49201 | 258472 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2181 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x4 | 5989030 | 2106439 | 37.7632475211429 | -122.481129458533 | (37.7632475211429, -122.481129458533) | 1 | 8 | 3 | 56 | 35 | ||||
165500 | 258474 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2115 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5989132 | 2106442 | 37.7632616874488 | -122.480776898017 | (37.7632616874488, -122.480776898017) | 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 | |||
188827 | 258426 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2116 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5989195 | 2106551 | 37.7635646334525 | -122.480566983887 | (37.7635646334525, -122.480566983887) | 1 | 8 | 3 | 56 | 35 | ||||
92770 | 258425 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2100 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5989196 | 2106551 | 37.7635646915697 | -122.480563525243 | (37.7635646915697, -122.480563525243) | 1 | 8 | 3 | 56 | 35 | ||||
169972 | 258424 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2050 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5989314 | 2106544 | 37.7635523285903 | -122.480154892876 | (37.7635523285903, -122.480154892876) | 1 | 8 | 3 | 56 | 35 | ||||
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 | |||
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 | |||
45448 | 258476 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2025 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5989429 | 2106452 | 37.7633064029332 | -122.479750416533 | (37.7633064029332, -122.479750416533) | 1 | 8 | 3 | 56 | 35 | ||||
10207 | 258475 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2033 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5989468 | 2106464 | 37.7633416172482 | -122.479616407921 | (37.7633416172482, -122.479616407921) | 1 | 8 | 3 | 56 | 35 | ||||
180994 | 60926 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2000 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/1983 12:00:00 AM | 13 | 3x3 | Permit Number 20727 | 5989507.2134 | 2106536.1763 | 37.7635420716385 | -122.479486064031 | (37.7635420716385, -122.479486064031) | 1 | 8 | 3 | 56 | 35 | |
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 | |||
51476 | 181337 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1945 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x4 | 5989630 | 2106459 | 37.7633372977529 | -122.479055743338 | (37.7633372977529, -122.479055743338) | 1 | 8 | 3 | 56 | 35 | |||
78212 | 110349 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1948 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5989635.8842 | 2106540.7717 | 37.7635621624427 | -122.479041373687 | (37.7635621624427, -122.479041373687) | 1 | 8 | 3 | 56 | 35 | |||
21075 | 55765 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1936 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/1973 12:00:00 AM | 8 | 3x3 | Permit Number 11801 | 5989651 | 2106567 | 37.7636350560631 | -122.478991012072 | (37.7636350560631, -122.478991012072) | 1 | 8 | 3 | 56 | 35 | |
150770 | 95069 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1924 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5989718.6012 | 2106543.0694 | 37.7635732745448 | -122.478755452983 | (37.7635732745448, -122.478755452983) | 1 | 8 | 3 | 56 | 35 | |||
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 | ||||
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 | |||
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 | |||
104861 | 258421 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1899 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 5989890 | 2106503 | 37.7634732054208 | -122.478159715367 | (37.7634732054208, -122.478159715367) | 1 | 8 | 3 | 56 | 35 | ||||
96573 | 258416 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1825 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 5990038 | 2106473 | 37.7633994233021 | -122.477645643383 | (37.7633994233021, -122.477645643383) | 1 | 8 | 3 | 56 | 35 | ||||
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 | |||
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 | ||||
174430 | 258415 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1815 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 5990072 | 2106474 | 37.7634041420481 | -122.477528122764 | (37.7634041420481, -122.477528122764) | 1 | 8 | 3 | 56 | 35 | ||||
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 | |
24867 | 215411 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1939 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5991245.12391 | 2102202.13663 | 37.7517427376545 | -122.473159145982 | (37.7517427376545, -122.473159145982) | 1 | 8 | 4 | 29491 | 12 | |||
94691 | 69068 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 1407 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1994 12:00:00 AM | Permit Number 33076 | 5991768.06854816 | 2105844.04694914 | 37.7617727319168 | -122.471616117782 | (37.7617727319168, -122.471616117782) | 1 | 8 | 4 | 56 | 12 | ||
156738 | 215412 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1407 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5991770.8881 | 2105805.69837 | 37.7616676000029 | -122.471603571552 | (37.7616676000029, -122.471603571552) | 1 | 8 | 4 | 56 | 12 | |||
164294 | 123216 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 654 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5993193.61084 | 2111027.91211 | 37.7760886204879 | -122.467062678343 | (37.7760886204879, -122.467062678343) | 11 | 6 | 2 | 54 | 11 | |||
4646 | 215421 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2085 09th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5993516.19097 | 2101401.96684 | 37.7496769094628 | -122.465247440321 | (37.7496769094628, -122.465247440321) | 1 | 8 | 4 | 29491 | 40 | |||
28741 | 215420 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2085 09th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5993528.81827 | 2101394.66819 | 37.7496575974161 | -122.465203244928 | (37.7496575974161, -122.465203244928) | 1 | 8 | 4 | 29491 | 40 | |||
181035 | 215434 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 20 Lakewood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5993586.39661 | 2092891.16546 | 37.7263124219742 | -122.464386821508 | (37.7263124219742, -122.464386821508) | 9 | 8 | 4 | 59 | 40 | |||
50185 | 215433 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 20 Lakewood Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5993594.89235 | 2092910.67012 | 37.726366466724 | -122.464358867875 | (37.726366466724, -122.464358867875) | 9 | 8 | 4 | 59 | 40 | |||
32219 | 215432 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 20 Lakewood Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5993607.07382 | 2092934.57084 | 37.7264327944236 | -122.464318491921 | (37.7264327944236, -122.464318491921) | 9 | 8 | 4 | 59 | 40 | |||
58620 | 215431 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 20 Lakewood Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5993618.37614 | 2092959.38451 | 37.7265015781724 | -122.464281221309 | (37.7265015781724, -122.464281221309) | 9 | 8 | 4 | 59 | 40 | |||
177793 | 215430 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 20 Lakewood Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5993628.72422 | 2092981.53442 | 37.7265629928729 | -122.464247056069 | (37.7265629928729, -122.464247056069) | 9 | 8 | 4 | 59 | 40 | |||
60373 | 215429 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 20 Lakewood Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5993645.02193 | 2093008.92736 | 37.726639146565 | -122.464192703738 | (37.726639146565, -122.464192703738) | 9 | 8 | 4 | 59 | 40 | |||
85554 | 215428 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 20 Lakewood Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5993651.19736 | 2093024.90181 | 37.7266833644367 | -122.464172514845 | (37.7266833644367, -122.464172514845) | 9 | 8 | 4 | 59 | 40 | |||
10106 | 49071 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 1970 Ocean Ave | 7 | 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 | ||
66523 | 49072 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 1970 Ocean Ave | 6 | 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 | ||
77367 | 49070 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 1970 Ocean Ave | 2 | 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 | ||
89349 | 49073 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 1970 Ocean Ave | 5 | 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 | ||
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 | ||
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 | ||
153581 | 49076 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 1970 Ocean Ave | 3 | 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 | ||
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 | |||
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 | |||
2455 | 215422 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 15 Fairfield Way | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5993781.00975 | 2092831.61045 | 37.7261601145848 | -122.46370973814 | (37.7261601145848, -122.46370973814) | 9 | 8 | 4 | 59 | 40 | |||
153487 | 215427 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 15 Fairfield Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5993797.5326 | 2092869.73491 | 37.7262657471456 | -122.463655385788 | (37.7262657471456, -122.463655385788) | 9 | 8 | 4 | 59 | 40 | |||
65860 | 215426 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 15 Fairfield Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5993822.27885 | 2092914.39696 | 37.7263898041365 | -122.463573079846 | (37.7263898041365, -122.463573079846) | 9 | 8 | 4 | 59 | 40 | |||
45824 | 215425 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 15 Fairfield Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5993828.92178 | 2092931.25645 | 37.7264364789445 | -122.463551338741 | (37.7264364789445, -122.463551338741) | 9 | 8 | 4 | 59 | 40 | |||
164234 | 215418 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 286 Orizaba Ave | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | 5994025.68496 | 2088506.93737 | 37.7142996980529 | -122.462550356439 | (37.7142996980529, -122.462550356439) | 9 | 8 | 6 | 28861 | 24 | ||||
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 | ||||
171280 | 215416 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 286 Orizaba Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 12 | 5994027.68196 | 2088444.22736 | 37.7141276262766 | -122.462538908049 | (37.7141276262766, -122.462538908049) | 9 | 8 | 6 | 28861 | 24 | ||||
39945 | 215415 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 484 Faxon Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 5994798.18805 | 2091784.91271 | 37.7233446951982 | -122.460117638125 | (37.7233446951982, -122.460117638125) | 9 | 8 | 4 | 28861 | 24 | |||
2544 | 49162 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 804 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/23/2003 12:00:00 AM | Permit Number 46282 | 5994926.32764665 | 2093370.69967083 | 37.7277062535492 | -122.459789497745 | (37.7277062535492, -122.459789497745) | 9 | 7 | 4 | 28861 | 40 | ||
50033 | 49161 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 804 Faxon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/23/2003 12:00:00 AM | Permit Number 46282 | 5994926.32764665 | 2093370.69967083 | 37.7277062535492 | -122.459789497745 | (37.7277062535492, -122.459789497745) | 9 | 7 | 4 | 28861 | 40 | ||
102004 | 124330 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 130 Palm Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5995934.00049 | 2113471.95009 | 37.7829570979054 | -122.457759890544 | (37.7829570979054, -122.457759890544) | 11 | 6 | 1 | 54 | 31 | |||
42342 | 215419 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1x Minerva St | 36 | Median : Cutout | Tree | DPW 1 | 10 | Width 0ft | 5996348.60637 | 2088999.95907 | 37.7157869222005 | -122.454557070559 | (37.7157869222005, -122.454557070559) | 9 | 8 | 6 | 28861 | 24 |
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) );