trees
1,024 rows where qSpecies_id = 72 sorted by DBH
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||
653 | 262559 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
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 | ||||
1412 | 259415 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 900x Geneva Ave | 4 | Median : Cutout | Tree | DPW 1 | 3x3 | 6000362 | 2089058 | 37.7161756595217 | -122.440689128694 | (37.7161756595217, -122.440689128694) | 9 | 7 | 6 | 28861 | 5 | ||||
1778 | 262558 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
1943 | 262553 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
2094 | 262557 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
2398 | 262570 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
2589 | 262566 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
2966 | 259413 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 900x Geneva Ave | 2 | Median : Cutout | Tree | DPW 1 | 3x3 | 6000362 | 2089058 | 37.7161756595217 | -122.440689128694 | (37.7161756595217, -122.440689128694) | 9 | 7 | 6 | 28861 | 5 | ||||
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 | ||||
3581 | 255621 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 72 | 366 San Carlos St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 785157 | 6006692 | 2103986 | 37.7575230865131 | -122.419868246156 | (37.7575230865131, -122.419868246156) | 2 | 4 | 7 | 28859 | 19 | |||
3606 | 262564 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
3775 | 262460 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 88 06th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009992 | 2112469 | 37.7810008079546 | -122.409054015659 | (37.7810008079546, -122.409054015659) | 14 | 2 | 9 | 28853 | 34 | ||||
3869 | 96815 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 15 Hartford St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2011 12:00:00 AM | Permit Number 767914 | 6002672.5 | 2105813.7 | 37.762314246217 | -122.433899918024 | (37.762314246217, -122.433899918024) | 15 | 4 | 5 | 28862 | 3 | |||
4185 | 262568 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
4200 | 262567 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
4326 | 259417 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 900x Geneva Ave | 6 | Median : Cutout | Tree | DPW 1 | 3x3 | 6000362 | 2089058 | 37.7161756595217 | -122.440689128694 | (37.7161756595217, -122.440689128694) | 9 | 7 | 6 | 28861 | 5 | ||||
5384 | 259412 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 900x Geneva Ave | 1 | Median : Cutout | Tree | DPW 1 | 3x3 | 6000287 | 2089053 | 37.7161576592819 | -122.440948005451 | (37.7161576592819, -122.440948005451) | 9 | 7 | 6 | 28861 | 5 | ||||
5772 | 262554 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
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 | ||||
7613 | 262571 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
7628 | 262385 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 900x Geneva Ave | 12 | Median : Cutout | Tree | DPW 1 | 3x3 | 6000362 | 2089058 | 37.7161756595217 | -122.440689128694 | (37.7161756595217, -122.440689128694) | 9 | 7 | 6 | 28861 | 5 | ||||
8223 | 262569 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
8921 | 259414 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 900x Geneva Ave | 3 | Median : Cutout | Tree | DPW 1 | 3x3 | 6000362 | 2089058 | 37.7161756595217 | -122.440689128694 | (37.7161756595217, -122.440689128694) | 9 | 7 | 6 | 28861 | 5 | ||||
9069 | 255620 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 72 | 366 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 785157 | 6006692 | 2103986 | 37.7575230865131 | -122.419868246156 | (37.7575230865131, -122.419868246156) | 2 | 4 | 7 | 28859 | 19 | |||
9120 | 262556 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
10281 | 262560 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
11007 | 260556 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 10 South Van Ness Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 5ft | 6007048.80869 | 2109949.46518 | 37.7739174571708 | -122.41905723302 | (37.7739174571708, -122.41905723302) | 8 | 2 | 9 | 28853 | 19 | ||||
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 | ||||
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 | ||||
13242 | 262383 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 900x Geneva Ave | 10 | Median : Cutout | Tree | DPW 1 | 3x3 | 6000362 | 2089058 | 37.7161756595217 | -122.440689128694 | (37.7161756595217, -122.440689128694) | 9 | 7 | 6 | 28861 | 5 | ||||
13549 | 259416 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 900x Geneva Ave | 5 | Median : Cutout | Tree | DPW 1 | 3x3 | 6000362 | 2089058 | 37.7161756595217 | -122.440689128694 | (37.7161756595217, -122.440689128694) | 9 | 7 | 6 | 28861 | 5 | ||||
13777 | 261032 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 72 | 438 Roosevelt Way | 2 | Front Yard : Yard | Tree | Private 2 | Width 3ft | 6000030.97008 | 2106544.70148 | 37.7641711390149 | -122.443088453592 | (37.7641711390149, -122.443088453592) | 15 | 5 | 5 | 29492 | 3 | ||||
14100 | 262381 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 900x Geneva Ave | 8 | Median : Cutout | Tree | DPW 1 | 3x3 | 6000362 | 2089058 | 37.7161756595217 | -122.440689128694 | (37.7161756595217, -122.440689128694) | 9 | 7 | 6 | 28861 | 5 | ||||
14568 | 84716 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2007 12:00:00 AM | Permit No. 49325 | 6001553.34694 | 2108280.88879 | 37.7690249659747 | -122.437947368595 | (37.7690249659747, -122.437947368595) | 15 | 5 | 5 | 29492 | 3 | ||||
15440 | 262565 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
15813 | 262563 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
15949 | 262561 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
16740 | 262573 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 23 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
17120 | 262555 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
17227 | 43930 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 2937 24th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/10/2000 12:00:00 AM | Permit Number 43521 | 6009283.57166105 | 2102148.92556307 | 37.7526245524661 | -122.410775774269 | (37.7526245524661, -122.410775774269) | 2 | 4 | 7 | 28859 | 19 | ||
18109 | 262384 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 900x Geneva Ave | 11 | Median : Cutout | Tree | DPW 1 | 3x3 | 6000362 | 2089058 | 37.7161756595217 | -122.440689128694 | (37.7161756595217, -122.440689128694) | 9 | 7 | 6 | 28861 | 5 | ||||
18198 | 259418 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 900x Geneva Ave | 7 | Median : Cutout | Tree | DPW 1 | 3x3 | 6000362 | 2089058 | 37.7161756595217 | -122.440689128694 | (37.7161756595217, -122.440689128694) | 9 | 7 | 6 | 28861 | 5 | ||||
18473 | 262562 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
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 | ||||
18684 | 262572 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 22 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
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 | ||
19024 | 262461 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 88 06th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009992 | 2112469 | 37.7810008079546 | -122.409054015659 | (37.7810008079546, -122.409054015659) | 14 | 2 | 9 | 28853 | 34 | ||||
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 | ||||
19411 | 262382 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 900x Geneva Ave | 9 | Median : Cutout | Tree | DPW 1 | 3x3 | 6000362 | 2089058 | 37.7161756595217 | -122.440689128694 | (37.7161756595217, -122.440689128694) | 9 | 7 | 6 | 28861 | 5 | ||||
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 | ||||
27021 | 104513 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 491-497 Alvarado St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6003187 | 2102698 | 37.7537884621117 | -122.431897972615 | (37.7537884621117, -122.431897972615) | 2 | 4 | 5 | 28862 | 22 | |||
27944 | 252826 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 72 | 3852 17th St | 5 | Front Yard : Yard | Tree | Private 2 | 6003330 | 2106021 | 37.7629207320267 | -122.431640673814 | (37.7629207320267, -122.431640673814) | 15 | 4 | 5 | 28862 | 3 | |||||
28320 | 108203 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 1875 MISSION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006816.6 | 2107468.6 | 37.767092511705 | -122.41968442346 | (37.767092511705, -122.41968442346) | 8 | 4 | 7 | 28853 | 19 | ||||
28394 | 82270 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 3541 20th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/21/2007 12:00:00 AM | 3x3 | Permit Number 49902 | 6006669.42046782 | 2104344.22621121 | 37.7585054206163 | -122.419971755856 | (37.7585054206163, -122.419971755856) | 2 | 4 | 7 | 28859 | 19 | ||
29167 | 121439 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1750 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6015597 | 2107388 | 37.7673618983766 | -122.389308462256 | (37.7673618983766, -122.389308462256) | 14 | 3 | 9 | 310 | 20 | ||||
32538 | 116596 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 800x SCOTT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002075 | 2111247 | 37.7771988203893 | -122.436355315705 | (37.7771988203893, -122.436355315705) | 15 | 5 | 11 | 29492 | 41 | ||||
41098 | 43932 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 2937 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/10/2000 12:00:00 AM | Permit Number 43521 | 6009283.57166105 | 2102148.92556307 | 37.7526245524661 | -122.410775774269 | (37.7526245524661, -122.410775774269) | 2 | 4 | 7 | 28859 | 19 | ||
41268 | 43933 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 2937 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/10/2000 12:00:00 AM | Permit Number 43521 | 6009283.57166105 | 2102148.92556307 | 37.7526245524661 | -122.410775774269 | (37.7526245524661, -122.410775774269) | 2 | 4 | 7 | 28859 | 19 | ||
41555 | 84715 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2007 12:00:00 AM | Permit No. 49325 | 6001553.34694 | 2108280.88879 | 37.7690249659747 | -122.437947368595 | (37.7690249659747, -122.437947368595) | 15 | 5 | 5 | 29492 | 3 | ||||
44457 | 252830 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 72 | 3852 17th St | 9 | Front Yard : Yard | Tree | Private 2 | 6003330 | 2106021 | 37.7629207320267 | -122.431640673814 | (37.7629207320267, -122.431640673814) | 15 | 4 | 5 | 28862 | 3 | |||||
46619 | 84707 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2007 12:00:00 AM | Permit No. 49325 | 6001553.34694 | 2108280.88879 | 37.7690249659747 | -122.437947368595 | (37.7690249659747, -122.437947368595) | 15 | 5 | 5 | 29492 | 3 | ||||
47855 | 93115 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 397 San Jose Ave | 1 | Sidewalk: Curb side : | Landscaping | Private 2 | 02/02/2009 12:00:00 AM | 26x6 | Permit Number 53167 | 6006259.6 | 2100887.6 | 37.7489912240508 | -122.42114365927 | (37.7489912240508, -122.42114365927) | 2 | 4 | 5 | 28859 | 19 | ||
49323 | 258496 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 2200X Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992855 | 2093940 | 37.7291500762322 | -122.46699141973 | (37.7291500762322, -122.46699141973) | 9 | 8 | 4 | 59 | 40 | ||||
49671 | 254909 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 4620 Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 6002001.2284 | 2091970.7345 | 37.7242665912846 | -122.435231397877 | (37.7242665912846, -122.435231397877) | 9 | 7 | 6 | 28861 | 25 | ||||
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 | ||||
50152 | 173671 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 72 | 299x Beale St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014575 | 2115523 | 37.789642061391 | -122.393412811769 | (37.789642061391, -122.393412811769) | 6 | 2 | 9 | 28855 | 6 | ||||
52184 | 59584 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 491-497 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/1998 12:00:00 AM | 3x3 | Permit Number 18977 | 6003187 | 2102698 | 37.7537884621117 | -122.431897972615 | (37.7537884621117, -122.431897972615) | 2 | 4 | 5 | 28862 | 22 | |
53039 | 51058 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 2516REVISED Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2004 12:00:00 AM | Permit Number 47527 | 6006947.90092687 | 2103694.34844389 | 37.7567366918525 | -122.418962550505 | (37.7567366918525, -122.418962550505) | 2 | 4 | 7 | 28859 | 19 | |||
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 | ||||
57167 | 96817 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 15 Hartford St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2011 12:00:00 AM | Permit Number 767914 | 6002672.5 | 2105813.7 | 37.762314246217 | -122.433899918024 | (37.762314246217, -122.433899918024) | 15 | 4 | 5 | 28862 | 3 | |||
57314 | 84717 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2007 12:00:00 AM | Permit No. 49325 | 6001553.34694 | 2108280.88879 | 37.7690249659747 | -122.437947368595 | (37.7690249659747, -122.437947368595) | 15 | 5 | 5 | 29492 | 3 | ||||
57724 | 116597 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 800x SCOTT ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002075 | 2111247 | 37.7771988203893 | -122.436355315705 | (37.7771988203893, -122.436355315705) | 15 | 5 | 11 | 29492 | 41 | ||||
57862 | 96848 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 72 | 1486 Innes Ave | Front Yard : Yard | Tree | Private 2 | 6016133.4 | 2096820.6 | 37.7383757570157 | -122.386716118251 | (37.7383757570157, -122.386716118251) | 10 | 3 | 8 | 58 | 1 | ||||||
60090 | 258497 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 2200X Ocean Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992855 | 2093940 | 37.7291500762322 | -122.46699141973 | (37.7291500762322, -122.46699141973) | 9 | 8 | 4 | 59 | 40 | ||||
65946 | 104512 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 491-497 Alvarado St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6003187 | 2102698 | 37.7537884621117 | -122.431897972615 | (37.7537884621117, -122.431897972615) | 2 | 4 | 5 | 28862 | 22 | |||
67637 | 82269 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 3541 20th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/21/2007 12:00:00 AM | 3x3 | Permit Number 49902 | 6006669.42046782 | 2104344.22621121 | 37.7585054206163 | -122.419971755856 | (37.7585054206163, -122.419971755856) | 2 | 4 | 7 | 28859 | 19 | ||
68538 | 256059 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1475 Underwood Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x6 | 6015203.6 | 2093200.6 | 37.7283844479575 | -122.389678175441 | (37.7283844479575, -122.389678175441) | 10 | 3 | 8 | 58 | 1 | |||||
69345 | 252824 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 72 | 3852 17th St | 3 | Front Yard : Yard | Tree | Private 2 | 6003330 | 2106021 | 37.7629207320267 | -122.431640673814 | (37.7629207320267, -122.431640673814) | 15 | 4 | 5 | 28862 | 3 | |||||
71190 | 87751 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 19 Hartford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2011 12:00:00 AM | 3x3 | Permit Number 768033 | 6002648 | 2105790 | 37.7622477813974 | -122.433982960078 | (37.7622477813974, -122.433982960078) | 15 | 4 | 5 | 28862 | 3 | ||
72481 | 84712 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2007 12:00:00 AM | Permit No. 49325 | 6001553.34694 | 2108280.88879 | 37.7690249659747 | -122.437947368595 | (37.7690249659747, -122.437947368595) | 15 | 5 | 5 | 29492 | 3 | ||||
78991 | 252827 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 72 | 3852 17th St | 6 | Front Yard : Yard | Tree | Private 2 | 6003330 | 2106021 | 37.7629207320267 | -122.431640673814 | (37.7629207320267, -122.431640673814) | 15 | 4 | 5 | 28862 | 3 | |||||
80100 | 254362 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 239 Orizaba Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x6 | 5993970 | 2088131 | 37.7132642563577 | -122.462715568818 | (37.7132642563577, -122.462715568818) | 9 | 8 | 6 | 64 | 24 | ||||
80331 | 97445 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 1900@Gough Pacific Ave | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6004943.9 | 2117474.7 | 37.7944611255838 | -122.426874507837 | (37.7944611255838, -122.426874507837) | 13 | 9 | 1 | 28858 | 27 | |||||
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 | ||
88582 | 118306 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 399X Willard St North | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5996275.15044137 | 2110427.69020243 | 37.7746179560473 | -122.456359464233 | (37.7746179560473, -122.456359464233) | 11 | 5 | 2 | 54 | 16 | ||||
89931 | 96814 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 15 Hartford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2011 12:00:00 AM | Permit Number 767914 | 6002672.5 | 2105813.7 | 37.762314246217 | -122.433899918024 | (37.762314246217, -122.433899918024) | 15 | 4 | 5 | 28862 | 3 | |||
90115 | 121443 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1750 03rd St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6015597 | 2107388 | 37.7673618983766 | -122.389308462256 | (37.7673618983766, -122.389308462256) | 14 | 3 | 9 | 310 | 20 | ||||
97291 | 82273 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 3541 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/21/2007 12:00:00 AM | 3x3 | Permit Number 49902 | 6006669.42046782 | 2104344.22621121 | 37.7585054206163 | -122.419971755856 | (37.7585054206163, -122.419971755856) | 2 | 4 | 7 | 28859 | 19 | ||
98162 | 173886 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 72 | 2931 20th St | 1 | Front Yard : Yard | Tree | Private 2 | 6009454 | 2104482 | 37.7590402047035 | -122.410351120118 | (37.7590402047035, -122.410351120118) | 2 | 4 | 7 | 28859 | 19 | |||||
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 | |||||
100608 | 45177 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 405 Holladay Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/23/2001 12:00:00 AM | Permit Number 44025 | 6010386.35714914 | 2098720.11226765 | 37.7432715536763 | -122.406720510672 | (37.7432715536763, -122.406720510672) | 10 | 7 | 7 | 28859 | 2 | ||
104459 | 84709 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2007 12:00:00 AM | Permit No. 49325 | 6001553.34694 | 2108280.88879 | 37.7690249659747 | -122.437947368595 | (37.7690249659747, -122.437947368595) | 15 | 5 | 5 | 29492 | 3 | ||||
107642 | 251173 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 72 | 367 Jersey St | 2 | Front Yard : Yard | Tree | Private 2 | Width 3ft | 6002770.52649 | 2101500.01269 | 37.7504754543841 | -122.433252636724 | (37.7504754543841, -122.433252636724) | 2 | 4 | 5 | 28862 | 22 | ||||
112425 | 44363 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 641 HAMPSHIRE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/2001 12:00:00 AM | Permit Number 43733 | 6010162 | 2105312.9 | 37.761361331815 | -122.407961104543 | (37.761361331815, -122.407961104543) | 10 | 4 | 8 | 28859 | 19 | |||
112828 | 84714 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2007 12:00:00 AM | Permit No. 49325 | 6001553.34694 | 2108280.88879 | 37.7690249659747 | -122.437947368595 | (37.7690249659747, -122.437947368595) | 15 | 5 | 5 | 29492 | 3 | ||||
113084 | 84710 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2007 12:00:00 AM | Permit No. 49325 | 6001553.34694 | 2108280.88879 | 37.7690249659747 | -122.437947368595 | (37.7690249659747, -122.437947368595) | 15 | 5 | 5 | 29492 | 3 | ||||
113506 | 108002 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 72 | 461X Ivy St | 1 | Front Yard : Cutout | Tree | Private 2 | 6005199.36333 | 2111122.83043 | 37.7770349120596 | -122.425538300101 | (37.7770349120596, -122.425538300101) | 7 | 9 | 11 | 28852 | 10 | |||||
113552 | 98960 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 401 Grove St | 6 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6005778.2 | 2111279 | 37.7774964045324 | -122.423547027313 | (37.7774964045324, -122.423547027313) | 7 | 9 | 11 | 28852 | 10 |
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) );