trees
1,024 rows where qSpecies_id = 72 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
151969 | 118484 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 8349 Geary Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | 5981049.15965 | 2112307.0389 | 37.7788922504996 | -122.509167829635 | (37.7788922504996, -122.509167829635) | 11 | 6 | 2 | 55 | 26 | ||||
175610 | 184617 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1758 Lower Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5981057.9764 | 2103098.1394 | 37.753607806054 | -122.508453540189 | (37.753607806054, -122.508453540189) | 1 | 8 | 3 | 56 | 35 | |||
188474 | 118483 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 8349 Geary Blvd | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | 5981073.18846 | 2112308.0171 | 37.7788963529663 | -122.509084778585 | (37.7788963529663, -122.509084778585) | 11 | 6 | 2 | 55 | 26 | ||||
35898 | 109279 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 4205 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773691 | 5981200.9 | 2104121 | 37.7564247125175 | -122.508035196592 | (37.7564247125175, -122.508035196592) | 1 | 8 | 3 | 56 | 35 |
94788 | 109281 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 4205 Lawton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773691 | 5981200.9 | 2104121 | 37.7564247125175 | -122.508035196592 | (37.7564247125175, -122.508035196592) | 1 | 8 | 3 | 56 | 35 |
167927 | 109280 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 4205 Lawton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773691 | 5981200.9 | 2104121 | 37.7564247125175 | -122.508035196592 | (37.7564247125175, -122.508035196592) | 1 | 8 | 3 | 56 | 35 |
57795 | 68285 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1894 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | 9 | Permit Number 32094 | 5981358.7272 | 2102199.6882 | 37.7511586335316 | -122.50734684264 | (37.7511586335316, -122.50734684264) | 1 | 8 | 3 | 56 | 35 | |
164986 | 184517 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 4046 Ortega St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5981383.432 | 2102173.6297 | 37.7510885394032 | -122.507259479265 | (37.7510885394032, -122.507259479265) | 1 | 8 | 3 | 56 | 35 | |||
131004 | 184516 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 4044 Ortega St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5981414.9052 | 2102173.2913 | 37.7510894639912 | -122.507150618506 | (37.7510894639912, -122.507150618506) | 1 | 8 | 3 | 56 | 35 | |||
74542 | 184444 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2131 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5981678.0282 | 2100560.0346 | 37.7466754073158 | -122.50612112236 | (37.7466754073158, -122.50612112236) | 1 | 8 | 3 | 29491 | 35 | |||
3419 | 259044 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 3649 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5981832 | 2098708 | 37.7415992976029 | -122.505451458513 | (37.7415992976029, -122.505451458513) | 1 | 8 | 3 | 29491 | 35 | ||||
910 | 259043 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 3639 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5981868 | 2098709 | 37.7416041617746 | -122.505327058934 | (37.7416041617746, -122.505327058934) | 1 | 8 | 3 | 29491 | 35 | ||||
12436 | 259039 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 3627 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5981920 | 2098711 | 37.7416127129705 | -122.505147411787 | (37.7416127129705, -122.505147411787) | 1 | 8 | 3 | 29491 | 35 | ||||
19150 | 259041 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 3614 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5981967 | 2098808 | 37.7418818134636 | -122.504992090975 | (37.7418818134636, -122.504992090975) | 1 | 8 | 3 | 29491 | 35 | ||||
18670 | 259040 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 3615 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5981969 | 2098712 | 37.7416183416682 | -122.504978063323 | (37.7416183416682, -122.504978063323) | 1 | 8 | 3 | 29491 | 35 | ||||
6440 | 259042 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 3612 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5981996 | 2098820 | 37.7419164682935 | -122.504892709134 | (37.7419164682935, -122.504892709134) | 1 | 8 | 3 | 29491 | 35 | ||||
157709 | 46396 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 2363 46th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/05/2002 12:00:00 AM | Permit Number 44628 | 5982038.69993379 | 2099019.08157606 | 37.7424656032555 | -122.504759817001 | (37.7424656032555, -122.504759817001) | 1 | 8 | 3 | 29491 | 35 | ||
172900 | 183162 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2401 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 5982053.1688 | 2098706.8368 | 37.7416091165514 | -122.504686658504 | (37.7416091165514, -122.504686658504) | 1 | 8 | 3 | 29491 | 35 | |||
30447 | 184459 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2170 45th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 23 | Width 0ft | 5982352.1644 | 2100338.7067 | 37.7461073638547 | -122.503773678611 | (37.7461073638547, -122.503773678611) | 1 | 8 | 3 | 29491 | 35 | |||
59325 | 118709 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 4201 Balboa St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5982467.72104 | 2110969.09723 | 37.7753021852736 | -122.504161410758 | (37.7753021852736, -122.504161410758) | 11 | 6 | 2 | 55 | 26 | |||
29353 | 117922 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 683 41st Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 3ft | 5983174.69691 | 2111166.71748 | 37.7758863445675 | -122.501730482451 | (37.7758863445675, -122.501730482451) | 11 | 6 | 2 | 55 | 26 | |||
172630 | 65148 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 7330 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/1989 12:00:00 AM | 17 | Permit Number 27125 | 5984217.18812 | 2112512.23092 | 37.7796419140825 | -122.498223688652 | (37.7796419140825, -122.498223688652) | 11 | 6 | 2 | 55 | 26 | ||
188619 | 118014 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 472 37th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 21 | Width 6ft | 5984415.81444 | 2112632.82053 | 37.7799846626847 | -122.49754547051 | (37.7799846626847, -122.49754547051) | 11 | 6 | 2 | 55 | 26 | |||
105640 | 182350 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1501 35th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 0ft | 5985255.7552 | 2104953.475 | 37.7589485494212 | -122.494073639597 | (37.7589485494212, -122.494073639597) | 1 | 8 | 3 | 56 | 35 | |||
100945 | 182386 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1538 35th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 0ft | 5985306.5492 | 2104723.6759 | 37.7583205568356 | -122.493881037718 | (37.7583205568356, -122.493881037718) | 1 | 8 | 3 | 56 | 35 | |||
162489 | 115081 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1546 33RD AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | 5985952 | 2104698 | 37.7582878007794 | -122.491646926351 | (37.7582878007794, -122.491646926351) | 1 | 8 | 3 | 56 | 35 | |||
131497 | 119374 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 866 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 5986063.1424 | 2109995.79652 | 37.7728405660437 | -122.491652532111 | (37.7728405660437, -122.491652532111) | 11 | 6 | 2 | 55 | 26 | |||
31051 | 6108 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 600X El Camino Del Mar | 2 | Median : Cutout | Tree | DPW 1 | 24 | 15-HOA | 5986691.267885 | 2115146.1691739 | 37.787018710699 | -122.489858663161 | (37.787018710699, -122.489858663161) | 11 | 6 | 1 | 55 | 33 | |||
32490 | 27696 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 600X El Camino Del Mar | 11 | Median : Cutout | Tree | DPW 1 | 24 | 15-HOA | 5986691.267885 | 2115146.1691739 | 37.787018710699 | -122.489858663161 | (37.787018710699, -122.489858663161) | 11 | 6 | 1 | 55 | 33 | |||
41933 | 6115 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 600X El Camino Del Mar | 10 | Median : Cutout | Tree | DPW 1 | 24 | 15-HOA | 5986691.267885 | 2115146.1691739 | 37.787018710699 | -122.489858663161 | (37.787018710699, -122.489858663161) | 11 | 6 | 1 | 55 | 33 | |||
54669 | 6116 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 600X El Camino Del Mar | 13 | Median : Cutout | Tree | DPW 1 | 24 | 15-HOA | 5986691.267885 | 2115146.1691739 | 37.787018710699 | -122.489858663161 | (37.787018710699, -122.489858663161) | 11 | 6 | 1 | 55 | 33 | |||
66388 | 27695 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 600X El Camino Del Mar | 12 | Median : Cutout | Tree | DPW 1 | 24 | 15-HOA | 5986691.267885 | 2115146.1691739 | 37.787018710699 | -122.489858663161 | (37.787018710699, -122.489858663161) | 11 | 6 | 1 | 55 | 33 | |||
82870 | 6109 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 600X El Camino Del Mar | 3 | Median : Cutout | Tree | DPW 1 | 24 | 15-HOA | 5986691.267885 | 2115146.1691739 | 37.787018710699 | -122.489858663161 | (37.787018710699, -122.489858663161) | 11 | 6 | 1 | 55 | 33 | |||
101350 | 6110 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 600X El Camino Del Mar | 4 | Median : Cutout | Tree | DPW 1 | 18 | 15-HOA | 5986691.267885 | 2115146.1691739 | 37.787018710699 | -122.489858663161 | (37.787018710699, -122.489858663161) | 11 | 6 | 1 | 55 | 33 | |||
118393 | 27693 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 600X El Camino Del Mar | 15 | Median : Cutout | Tree | DPW 1 | 24 | 15-HOA | 5986691.267885 | 2115146.1691739 | 37.787018710699 | -122.489858663161 | (37.787018710699, -122.489858663161) | 11 | 6 | 1 | 55 | 33 | |||
132471 | 6113 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 600X El Camino Del Mar | 7 | Median : Cutout | Tree | DPW 1 | 18 | 15-HOA | 5986691.267885 | 2115146.1691739 | 37.787018710699 | -122.489858663161 | (37.787018710699, -122.489858663161) | 11 | 6 | 1 | 55 | 33 | |||
141462 | 6112 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 600X El Camino Del Mar | 6 | Median : Cutout | Tree | DPW 1 | 24 | 15-HOA | 5986691.267885 | 2115146.1691739 | 37.787018710699 | -122.489858663161 | (37.787018710699, -122.489858663161) | 11 | 6 | 1 | 55 | 33 | |||
143682 | 6111 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 600X El Camino Del Mar | 5 | Median : Cutout | Tree | DPW 1 | 18 | 15-HOA | 5986691.267885 | 2115146.1691739 | 37.787018710699 | -122.489858663161 | (37.787018710699, -122.489858663161) | 11 | 6 | 1 | 55 | 33 | |||
145542 | 27692 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 600X El Camino Del Mar | 14 | Median : Cutout | Tree | DPW 1 | 24 | 15-HOA | 5986691.267885 | 2115146.1691739 | 37.787018710699 | -122.489858663161 | (37.787018710699, -122.489858663161) | 11 | 6 | 1 | 55 | 33 | |||
156490 | 6114 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 600X El Camino Del Mar | 9 | Median : Cutout | Tree | DPW 1 | 24 | 15-HOA | 5986691.267885 | 2115146.1691739 | 37.787018710699 | -122.489858663161 | (37.787018710699, -122.489858663161) | 11 | 6 | 1 | 55 | 33 | |||
190532 | 6107 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 600X El Camino Del Mar | 1 | Median : Cutout | Tree | DPW 1 | 24 | 15-HOA | 5986691.267885 | 2115146.1691739 | 37.787018710699 | -122.489858663161 | (37.787018710699, -122.489858663161) | 11 | 6 | 1 | 55 | 33 | |||
59555 | 181997 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2478 30th Ave | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 0ft | 5987077.3789 | 2098383.8132 | 37.7410164490743 | -122.487291143841 | (37.7410164490743, -122.487291143841) | 1 | 8 | 3 | 29491 | 35 | |||
184563 | 181998 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2476 30th Ave | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 0ft | 5987077.3789 | 2098389.2279 | 37.7410313164056 | -122.487291541461 | (37.7410313164056, -122.487291541461) | 1 | 8 | 3 | 29491 | 35 | |||
146727 | 181999 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2474 30th Ave | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 0ft | 5987078.0557 | 2098396.6732 | 37.7410517986936 | -122.487289748097 | (37.7410517986936, -122.487289748097) | 1 | 8 | 3 | 29491 | 35 | |||
48087 | 181995 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2482 30th Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 0ft | 5987079.071 | 2098350.9862 | 37.7409264135054 | -122.487282882666 | (37.7409264135054, -122.487282882666) | 1 | 8 | 3 | 29491 | 35 | |||
146618 | 181992 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2490 30th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 0ft | 5987079.071 | 2098310.7141 | 37.7408158369886 | -122.487279925369 | (37.7408158369886, -122.487279925369) | 1 | 8 | 3 | 29491 | 35 | |||
91349 | 181996 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2480 30th Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 0ft | 5987079.7478 | 2098357.7547 | 37.7409450374803 | -122.487281039603 | (37.7409450374803, -122.487281039603) | 1 | 8 | 3 | 29491 | 35 | |||
147682 | 181991 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2492 30th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 0ft | 5987080.0862 | 2098302.9304 | 37.7407945242111 | -122.487275843656 | (37.7407945242111, -122.487275843656) | 1 | 8 | 3 | 29491 | 35 | |||
191736 | 181993 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2488 30th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 0ft | 5987080.4247 | 2098320.1899 | 37.7408419339653 | -122.487275940676 | (37.7408419339653, -122.487275940676) | 1 | 8 | 3 | 29491 | 35 | |||
49151 | 183526 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2550 30th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 0ft | 5987093.1088 | 2097910.6765 | 37.7397182581953 | -122.487202013829 | (37.7397182581953, -122.487202013829) | 1 | 8 | 3 | 29491 | 35 | |||
129600 | 181989 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2850 Ulloa St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 0ft | 5987109.8673 | 2098288.0398 | 37.7407553751877 | -122.48717177975 | (37.7407553751877, -122.48717177975) | 1 | 8 | 3 | 29491 | 35 | |||
5485 | 73535 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2207 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 18 | 5987582.0279 | 2100272.2966 | 37.7462311393003 | -122.485684839892 | (37.7462311393003, -122.485684839892) | 1 | 8 | 3 | 29491 | 35 | |||
36842 | 181277 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 0 Gonzalez Dr | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | 5988402.74919 | 2089827.84919 | 37.7176011677477 | -122.482081905481 | (37.7176011677477, -122.482081905481) | 1 | 8 | 4 | 64 | 14 | ||||
92455 | 181276 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 0 Gonzalez Dr | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | 5988413.87941 | 2089827.13064 | 37.7175998421416 | -122.482043381217 | (37.7175998421416, -122.482043381217) | 1 | 8 | 4 | 64 | 14 | ||||
71490 | 181275 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 0 Gonzalez Dr | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | 5988424.04089 | 2089826.43294 | 37.7175985174299 | -122.482008206935 | (37.7175985174299, -122.482008206935) | 1 | 8 | 4 | 64 | 14 | ||||
171329 | 98922 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2507 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | 6x6 | 5989831.2863 | 2098268.2421 | 37.7408593296697 | -122.477760796416 | (37.7408593296697, -122.477760796416) | 1 | 8 | 3 | 29491 | 35 | |||
197 | 104920 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 750 Gonzalez Dr | 1 | Median : Yard | Tree | Private 2 | 5990385 | 2090588 | 37.7198034465129 | -122.47528570222 | (37.7198034465129, -122.47528570222) | 1 | 8 | 4 | 64 | 14 | |||||
1969 | 104927 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 810 Gonzalez Dr | 2 | Median : Yard | Tree | Private 2 | 10 | 5990385 | 2090588 | 37.7198034465129 | -122.47528570222 | (37.7198034465129, -122.47528570222) | 1 | 8 | 4 | 64 | 14 | ||||
33112 | 104928 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 810 Gonzalez Dr | 3 | Median : Yard | Tree | Private 2 | 12 | 5990385 | 2090588 | 37.7198034465129 | -122.47528570222 | (37.7198034465129, -122.47528570222) | 1 | 8 | 4 | 64 | 14 | ||||
99190 | 104921 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 750 Gonzalez Dr | 2 | Median : Yard | Tree | Private 2 | 5990385 | 2090588 | 37.7198034465129 | -122.47528570222 | (37.7198034465129, -122.47528570222) | 1 | 8 | 4 | 64 | 14 | |||||
145777 | 104922 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 750 Gonzalez Dr | 3 | Median : Yard | Tree | Private 2 | missing? | 5990385 | 2090588 | 37.7198034465129 | -122.47528570222 | (37.7198034465129, -122.47528570222) | 1 | 8 | 4 | 64 | 14 | ||||
182377 | 104926 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 810 Gonzalez Dr | 1 | Median : Yard | Tree | Private 2 | 5990385 | 2090588 | 37.7198034465129 | -122.47528570222 | (37.7198034465129, -122.47528570222) | 1 | 8 | 4 | 64 | 14 | |||||
4163 | 31376 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 634 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/1995 12:00:00 AM | 18 | 3x3 | Permit Number 34978 | 5991167.87172 | 2099111.64976 | 37.7432525889424 | -122.473200923103 | (37.7432525889424, -122.473200923103) | 1 | 8 | 4 | 29491 | 40 | |
184495 | 217464 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 127 Beverly St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5991405.11003 | 2090040.73714 | 37.7183598726973 | -122.471719713607 | (37.7183598726973, -122.471719713607) | 9 | 8 | 6 | 64 | 24 | |||
139501 | 217428 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1113 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 5991492.83801 | 2105186.64815 | 37.7599517618807 | -122.472520091336 | (37.7599517618807, -122.472520091336) | 1 | 8 | 4 | 56 | 12 | |||
18914 | 48631 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 1501 15th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/30/2002 12:00:00 AM | Permit Number 45927 | 5991498.56479756 | 2105191.60606182 | 37.7599657064663 | -122.472500646803 | (37.7599657064663, -122.472500646803) | 1 | 8 | 4 | 56 | 12 | ||
88013 | 48632 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 1501 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/30/2002 12:00:00 AM | Permit Number 45927 | 5991498.56479756 | 2105191.60606182 | 37.7599657064663 | -122.472500646803 | (37.7599657064663, -122.472500646803) | 1 | 8 | 4 | 56 | 12 | ||
182425 | 48630 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 1501 15th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/30/2002 12:00:00 AM | Permit Number 45927 | 5991498.56479756 | 2105191.60606182 | 37.7599657064663 | -122.472500646803 | (37.7599657064663, -122.472500646803) | 1 | 8 | 4 | 56 | 12 | ||
148209 | 217429 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1113 Kirkham St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 3ft | 5991520.38705 | 2105187.01956 | 37.7599543762085 | -122.472424840551 | (37.7599543762085, -122.472424840551) | 1 | 8 | 4 | 56 | 12 | |||
172189 | 217430 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1113 Kirkham St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 5991534.38297 | 2105188.62915 | 37.7599596057689 | -122.47237655325 | (37.7599596057689, -122.47237655325) | 1 | 8 | 4 | 56 | 12 | |||
32838 | 181272 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 4061 19th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 5991602.94551 | 2088924.16966 | 37.7153054953149 | -122.470954591083 | (37.7153054953149, -122.470954591083) | 9 | 8 | 6 | 64 | 24 | |||
7745 | 28428 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2499 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/01/2003 12:00:00 AM | 12 | 3X3 | 5991618.4954 | 2094538.91045 | 37.7307230868187 | -122.471309697155 | (37.7307230868187, -122.471309697155) | 9 | 8 | 4 | 59 | 40 | ||
180148 | 28429 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2499 Ocean Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/01/2003 12:00:00 AM | 12 | 3X3 | 5991627.58277 | 2094536.00687 | 37.7307156399791 | -122.471278069527 | (37.7307156399791, -122.471278069527) | 9 | 8 | 4 | 59 | 40 | ||
182217 | 217830 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2400 Ocean Ave | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 5991664.0561 | 2094598.00072 | 37.730887969306 | -122.471156491586 | (37.730887969306, -122.471156491586) | 9 | 8 | 4 | 59 | 40 | ||||
102003 | 217829 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2400 Ocean Ave | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 5991671.86156 | 2094594.42406 | 37.7308786001697 | -122.471129246615 | (37.7308786001697, -122.471129246615) | 9 | 8 | 4 | 59 | 40 | ||||
185679 | 28469 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2400X Ocean Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/01/2003 12:00:00 AM | 16 | 3x3 | 5991803.10743 | 2094513.52119 | 37.7306640516002 | -122.470669622002 | (37.7306640516002, -122.470669622002) | 9 | 8 | 4 | 59 | 40 | ||
36554 | 28430 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 2439 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/2003 12:00:00 AM | 12 | 3X3 | 5991842.51952 | 2094406.3714 | 37.730372124061 | -122.47052556873 | (37.730372124061, -122.47052556873) | 9 | 8 | 4 | 59 | 40 | ||
169156 | 28431 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 2439 Ocean Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/2003 12:00:00 AM | 12 | 3X3 | 5991850.14781 | 2094403.36446 | 37.7303643088426 | -122.470498978 | (37.7303643088426, -122.470498978) | 9 | 8 | 4 | 59 | 40 | ||
123079 | 28466 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2400X Ocean Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/01/2003 12:00:00 AM | 12 | 3X3 | 5991883.04052 | 2094469.18562 | 37.7305469391855 | -122.470390056066 | (37.7305469391855, -122.470390056066) | 9 | 8 | 4 | 59 | 40 | ||
78712 | 28465 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2400X Ocean Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/01/2003 12:00:00 AM | 20 | 3X3 | 5991890.46795 | 2094463.91119 | 37.7305328863621 | -122.470363994616 | (37.7305328863621, -122.470363994616) | 9 | 8 | 4 | 59 | 40 | ||
89253 | 28432 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2425 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/01/2003 12:00:00 AM | 12 | 3X3 | 5991942.44608 | 2094354.15031 | 37.730234515527 | -122.47017631066 | (37.730234515527, -122.47017631066) | 9 | 8 | 4 | 59 | 40 | ||
12714 | 253262 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2425 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991946 | 2094328 | 37.7301629187609 | -122.470162120918 | (37.7301629187609, -122.470162120918) | 9 | 8 | 4 | 59 | 40 | ||||
49995 | 253264 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2425 Ocean Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991946 | 2094328 | 37.7301629187609 | -122.470162120918 | (37.7301629187609, -122.470162120918) | 9 | 8 | 4 | 59 | 40 | ||||
65437 | 28433 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2425 Ocean Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/01/2003 12:00:00 AM | 12 | 3X3 | 5991953.12175 | 2094350.44875 | 37.7302249691509 | -122.470139134356 | (37.7302249691509, -122.470139134356) | 9 | 8 | 4 | 59 | 40 | ||
36322 | 217470 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 870 Judah St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 5991963.05013 | 2105942.50613 | 37.7620543534437 | -122.470948933465 | (37.7620543534437, -122.470948933465) | 1 | 8 | 11 | 56 | 12 | |||
62592 | 28464 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2400X Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/01/2003 12:00:00 AM | 12 | 3X3 | 5991972.6774974 | 2094408.8386933 | 37.7303864239 | -122.470075778183 | (37.7303864239, -122.470075778183) | 9 | 8 | 4 | 59 | 40 | ||
146283 | 28467 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2400X Ocean Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/01/2003 12:00:00 AM | 20 | 3X3 | 5991972.6774974 | 2094408.8386933 | 37.7303864239 | -122.470075778183 | (37.7303864239, -122.470075778183) | 9 | 8 | 4 | 59 | 40 | ||
165433 | 28468 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2400X Ocean Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/01/2003 12:00:00 AM | 17 | 3X3 | 5991972.6774974 | 2094408.8386933 | 37.7303864239 | -122.470075778183 | (37.7303864239, -122.470075778183) | 9 | 8 | 4 | 59 | 40 | ||
134168 | 217465 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 270 Byxbee St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 10ft | 5991973.31902 | 2090312.5132 | 37.7191389625614 | -122.469775446797 | (37.7191389625614, -122.469775446797) | 9 | 8 | 6 | 64 | 24 | |||
119907 | 217469 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 870 Judah St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 5991984.27655 | 2105943.70129 | 37.7620588626465 | -122.470875607232 | (37.7620588626465, -122.470875607232) | 1 | 8 | 11 | 56 | 12 | |||
161148 | 217468 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 870 Judah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 5992024.34962 | 2105944.96823 | 37.7620646587918 | -122.47073710354 | (37.7620646587918, -122.47073710354) | 1 | 8 | 11 | 56 | 12 | |||
44504 | 217467 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 870 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 5992049.56384 | 2105945.37558 | 37.7620672353458 | -122.470649927768 | (37.7620672353458, -122.470649927768) | 1 | 8 | 11 | 56 | 12 | |||
25128 | 99842 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 810 Judah St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 44828 | 5992070 | 2105943 | 37.7620618943588 | -122.470579074603 | (37.7620618943588, -122.470579074603) | 1 | 8 | 11 | 56 | 12 | ||||
54866 | 99843 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 810 Judah St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 44828 | 5992070 | 2105943 | 37.7620618943588 | -122.470579074603 | (37.7620618943588, -122.470579074603) | 1 | 8 | 11 | 56 | 12 | ||||
171418 | 99840 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 810 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 44828 | 5992070 | 2105943 | 37.7620618943588 | -122.470579074603 | (37.7620618943588, -122.470579074603) | 1 | 8 | 11 | 56 | 12 | ||||
184220 | 99841 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 810 Judah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 44828 | 5992070 | 2105943 | 37.7620618943588 | -122.470579074603 | (37.7620618943588, -122.470579074603) | 1 | 8 | 11 | 56 | 12 | ||||
78270 | 28425 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2390X Ocean Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/01/2003 12:00:00 AM | 12 | 3X3 | 5992110.49901 | 2094330.64063 | 37.7301796779751 | -122.469593623835 | (37.7301796779751, -122.469593623835) | 9 | 8 | 4 | 59 | 40 | ||
185989 | 28424 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2390X Ocean Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/01/2003 12:00:00 AM | 12 | 3X3 | 5992122.7651 | 2094324.99132 | 37.7301648752963 | -122.469550807661 | (37.7301648752963, -122.469550807661) | 9 | 8 | 4 | 59 | 40 | ||
161813 | 28435 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 2383 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/2003 12:00:00 AM | 12 | 3X3 | 5992163.86638 | 2094231.44033 | 37.7299103829045 | -122.469401909547 | (37.7299103829045, -122.469401909547) | 9 | 8 | 4 | 59 | 40 | ||
92862 | 28436 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 2383 Ocean Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/2003 12:00:00 AM | 12 | 3X3 | 5992168.55554 | 2094228.20045 | 37.729901757986 | -122.469385462977 | (37.729901757986, -122.469385462977) | 9 | 8 | 4 | 59 | 40 |
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) );