trees
60 rows where Supervisor Districts = 3 and qSpecies_id = 116 sorted by qCareAssistant
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||
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 | |||
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 | |||
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 | |
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 | |||
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 | ||||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | ||
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 | |||
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 | |||
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 | |
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 | |||
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 | ||||
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 | ||||
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 | |||
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 | ||||
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 | |||
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 | |||
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 | ||||
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 | |||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||
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 | |||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | |||
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 | ||||
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 | |||||
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 | |
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 | ||
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 | ||||
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 | ||||
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 | |
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 |
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) );