trees
1,024 rows where qSpecies_id = 72 sorted by SiteOrder
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 45532 | 108808 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 542 Moscow St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774650 | 6003656.47159 | 2090041.31767 | 37.7190626969286 | -122.429371938322 | (37.7190626969286, -122.429371938322) | 9 | 7 | 6 | 28861 | 5 | |
| 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 | ||||||
| 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 | |||||
| 125248 | 106038 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 72 | 230 Lakeview Ave | Front Yard : Yard | Tree | Private 2 | Permit Number 772456 | 5997013.1 | 2089546.6 | 37.7173259605404 | -122.452299707743 | (37.7173259605404, -122.452299707743) | 9 | 8 | 6 | 28861 | 24 | |||||
| 129276 | 93903 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 72 | 546 Page St | Front Yard : | Tree | Private 2 | 6003947 | 2109752 | 37.7732001072566 | -122.429772814549 | (37.7732001072566, -122.429772814549) | 7 | 9 | 11 | 29492 | 10 | ||||||
| 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 | |||||
| 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 | ||||
| 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 | ||||
| 2813 | 33314 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1229 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1996 12:00:00 AM | 18 | Permit Number 37460 | 6005325.69823 | 2120590.66128 | 37.8030383405174 | -122.425775331487 | (37.8030383405174, -122.425775331487) | 13 | 9 | 1 | 28858 | 17 | |
| 3346 | 137500 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 52 Iris Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 5997635.71873 | 2114163.76026 | 37.7849542395006 | -122.451922604659 | (37.7849542395006, -122.451922604659) | 15 | 6 | 1 | 54 | 31 | |||
| 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 | ||||
| 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 | ||||
| 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 | |
| 4402 | 27703 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1600 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/01/2003 12:00:00 AM | 30 | 5X5 | 5995069.03366 | 2092243.1445 | 37.7246184644438 | -122.459214548241 | (37.7246184644438, -122.459214548241) | 9 | 8 | 4 | 28861 | 40 | ||
| 4722 | 45307 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 561 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/2001 12:00:00 AM | 20 | 5x5 | Permit Number 44145 | 6000554.5197 | 2110946.4965 | 37.7762872030081 | -122.441593556696 | (37.7762872030081, -122.441593556696) | 15 | 5 | 11 | 29492 | 16 |
| 5038 | 15563 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2868 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6007056.0095 | 2101612.1167 | 37.751025447038 | -122.418441030738 | (37.751025447038, -122.418441030738) | 2 | 4 | 7 | 28859 | 19 | |||
| 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 | ||||
| 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 | |||
| 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 | ||||
| 6637 | 244842 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 41 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 6ft | 6006681.50629 | 2103383.71332 | 37.7558687552437 | -122.419861800707 | (37.7558687552437, -122.419861800707) | 2 | 4 | 7 | 28859 | 19 | |||
| 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 | ||
| 8541 | 15400 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2035 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6006850.0111 | 2106406.7679 | 37.7641788523727 | -122.419493518679 | (37.7641788523727, -122.419493518679) | 8 | 4 | 7 | 28859 | 19 | |||
| 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 | |||
| 9775 | 243941 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 701 Church St | 1 | Front Yard : Yard | Tree | Private 2 | 21 | Width 3ft | 6004362.39063 | 2104350.06977 | 37.7583912186868 | -122.4279509174 | (37.7583912186868, -122.4279509174) | 2 | 4 | 5 | 28862 | 3 | |||
| 9971 | 15508 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 2737 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6007147.25057 | 2102426.20721 | 37.7532658900598 | -122.418183219838 | (37.7532658900598, -122.418183219838) | 2 | 4 | 7 | 28859 | 19 | |||
| 10538 | 217451 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 248 Thrift St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 5994521.58458 | 2089667.42231 | 37.7175146601568 | -122.460920402674 | (37.7175146601568, -122.460920402674) | 9 | 8 | 6 | 28861 | 24 | ||||
| 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 | ||||
| 12578 | 247960 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 14 Joy St | 1 | Front Yard : Yard | Tree | Private 2 | 17 | 6010368.04056 | 2098905.32232 | 37.7437790754397 | -122.406796895161 | (37.7437790754397, -122.406796895161) | 2 | 7 | 7 | 28859 | 2 | ||||
| 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 | ||||
| 13473 | 105162 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1600X OAKDALE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 5x5 | 6015006 | 2095503 | 37.7346954145828 | -122.390522107646 | (37.7346954145828, -122.390522107646) | 10 | 3 | 8 | 58 | 1 | |||
| 13986 | 33558 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2400 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/11/1996 12:00:00 AM | 14 | Permit Number 37664 | 5996252.18034 | 2110425.94618 | 37.7746118487481 | -122.456438795749 | (37.7746118487481, -122.456438795749) | 11 | 5 | 2 | 54 | 16 | |
| 14425 | 582 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 3013 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/23/1992 12:00:00 AM | 12 | 3x3 | Permit Number 782763 | 6008818.92095 | 2102127.6459 | 37.7525400594852 | -122.412381119401 | (37.7525400594852, -122.412381119401) | 2 | 4 | 7 | 28859 | 19 | |
| 14583 | 28774 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 4626 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6001950.98602 | 2092007.07057 | 37.7243635086673 | -122.43540767631 | (37.7243635086673, -122.43540767631) | 9 | 7 | 6 | 28861 | 25 | |||
| 14666 | 102429 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 200 06th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2017 12:00:00 AM | 3 | 4x4 | Permit Number 770993 | 6010552.49087 | 2111923.99595 | 37.7795357369219 | -122.407076563634 | (37.7795357369219, -122.407076563634) | 14 | 2 | 9 | 28853 | 34 | |
| 16138 | 181220 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 542 Moscow St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6003657.26873 | 2090042.27022 | 37.7190653575524 | -122.429369250808 | (37.7190653575524, -122.429369250808) | 9 | 7 | 6 | 28861 | 5 | |||
| 16354 | 62210 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 280 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1985 12:00:00 AM | 18 | Permit Number 22332 | 6000793.82196 | 2093620.44436 | 37.7287276772231 | -122.439523423176 | (37.7287276772231, -122.439523423176) | 9 | 7 | 6 | 28861 | 25 | |
| 17323 | 243929 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1409 Douglass St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 6ft | 6001410.85086 | 2099557.61273 | 37.745064858666 | -122.437815383076 | (37.745064858666, -122.437815383076) | 2 | 7 | 5 | 63 | 22 | |||
| 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 | ||||
| 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 | ||||
| 20483 | 15453 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2365 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/10/1992 12:00:00 AM | 12 | 4X4 | 6006954.2705 | 2104542.6911 | 37.7590664034557 | -122.419000691119 | (37.7590664034557, -122.419000691119) | 2 | 4 | 7 | 28859 | 19 | ||
| 20875 | 15741 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 4531 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2000 12:00:00 AM | 12 | 3x3 | 6002397.2069 | 2092488.306 | 37.7257102048968 | -122.433899536724 | (37.7257102048968, -122.433899536724) | 9 | 7 | 6 | 28861 | 5 | ||
| 21612 | 108537 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 400-422X Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 6012472.22935 | 2086696.28114 | 37.7103730628368 | -122.39866445541 | (37.7103730628368, -122.39866445541) | 10 | 3 | 8 | 309 | 1 | ||||
| 21925 | 15410 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2065 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6006857.2115 | 2106321.6003 | 37.7639454076577 | -122.419462571916 | (37.7639454076577, -122.419462571916) | 8 | 4 | 7 | 28859 | 19 | |||
| 21981 | 181219 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 519 Lisbon St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 21 | Width 6ft | 6002044.02941 | 2090439.99646 | 37.720065958565 | -122.434974017336 | (37.720065958565, -122.434974017336) | 9 | 7 | 6 | 28861 | 5 | |||
| 22360 | 28610 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1107 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/29/2007 12:00:00 AM | 18 | 5X5 | 5996451.82773 | 2091748.49661 | 37.7233396801105 | -122.454398718898 | (37.7233396801105, -122.454398718898) | 9 | 8 | 4 | 28861 | 24 | ||
| 23367 | 243913 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 569 Peralta Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 14 | Width 4ft | 6009859.67236 | 2098840.49646 | 37.743572619883 | -122.408550147783 | (37.743572619883, -122.408550147783) | 2 | 7 | 7 | 28859 | 2 | |||
| 24128 | 181274 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 328 Palmetto Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 6ft | 5993286.62087 | 2087254.83892 | 37.7108191445702 | -122.46501394844 | (37.7108191445702, -122.46501394844) | 9 | 8 | 4 | 64 | 24 | |||
| 24365 | 124344 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 105 Palm Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 4ft | 5995869.2461 | 2113758.79509 | 37.7837409774514 | -122.458004677882 | (37.7837409774514, -122.458004677882) | 11 | 6 | 1 | 54 | 31 | |||
| 24428 | 15360 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1939 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6006819.3103 | 2107093.8027 | 37.7660635592898 | -122.419648453627 | (37.7660635592898, -122.419648453627) | 8 | 4 | 7 | 28853 | 19 | |||
| 25845 | 28547 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 5109 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/08/2003 12:00:00 AM | 12 | 3x3 | 6000411.4099 | 2089335.4212 | 37.7169402093066 | -122.440538230978 | (37.7169402093066, -122.440538230978) | 9 | 7 | 6 | 28861 | 5 | ||
| 26706 | 16408 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1186X Munich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 42 | TR | 6001104.60764 | 2087178.31507 | 37.7110567247495 | -122.43798776335 | (37.7110567247495, -122.43798776335) | 9 | 7 | 6 | 28861 | 5 | |||
| 26928 | 124333 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 172 Palm Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 5995945.98292 | 2113131.373 | 37.7820226523243 | -122.45769378533 | (37.7820226523243, -122.45769378533) | 11 | 6 | 1 | 54 | 31 | |||
| 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 | ||||
| 28346 | 199452 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1401 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 5ft | 6015631.41317 | 2108425.60277 | 37.7702128366907 | -122.389261893238 | (37.7702128366907, -122.389261893238) | 14 | 3 | 9 | 310 | 20 | |||
| 28378 | 95252 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 4539 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6002365.436 | 2092436.2557 | 37.7255654834992 | -122.434005647145 | (37.7255654834992, -122.434005647145) | 9 | 7 | 6 | 28861 | 5 | |||
| 28701 | 15444 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2243 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/10/1992 12:00:00 AM | 12 | 4X4 | 6006909.5324 | 2105286.5572 | 37.7611063676926 | -122.419208183326 | (37.7611063676926, -122.419208183326) | 2 | 4 | 7 | 28859 | 19 | ||
| 28973 | 199475 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1240 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6015486.6604 | 2109366.25847 | 37.7727876442643 | -122.389828310528 | (37.7727876442643, -122.389828310528) | 14 | 3 | 9 | 310 | 20 | |||
| 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 | ||||
| 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 | |||
| 29738 | 244863 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 117 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6006906.41702 | 2098789.62543 | 37.7432671013094 | -122.418758192246 | (37.7432671013094, -122.418758192246) | 2 | 7 | 7 | 28859 | 2 | |||
| 29778 | 28481 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 2073 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/2003 12:00:00 AM | 12 | 3x3 | 5993293.23217 | 2092912.55732 | 37.7263542555658 | -122.465401821504 | (37.7263542555658, -122.465401821504) | 9 | 8 | 4 | 59 | 40 | ||
| 30017 | 199467 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1050 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 5ft | 6015455.2503 | 2109935.91808 | 37.7743500616368 | -122.389976763437 | (37.7743500616368, -122.389976763437) | 14 | 3 | 9 | 310 | 20 | |||
| 30222 | 243938 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 315 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6003592.01249 | 2106424.54324 | 37.764043612454 | -122.43076326292 | (37.764043612454, -122.43076326292) | 8 | 4 | 5 | 28862 | 3 | |||
| 30573 | 28546 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 5125 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/08/2003 12:00:00 AM | 12 | 3x3 | 6000380.5163 | 2089281.6434 | 37.7167907883598 | -122.440641159733 | (37.7167907883598, -122.440641159733) | 9 | 7 | 6 | 28861 | 5 | ||
| 31737 | 15450 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2301 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/10/1992 12:00:00 AM | 12 | 4x4 | 6006934.5554 | 2104894.5299 | 37.760031361018 | -122.41909383171 | (37.760031361018, -122.41909383171) | 2 | 4 | 7 | 28859 | 19 | ||
| 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 | |||
| 33158 | 244864 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 367 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6006463.24291 | 2097111.21935 | 37.7386336115438 | -122.420171483141 | (37.7386336115438, -122.420171483141) | 2 | 7 | 7 | 28859 | 2 | |||
| 34116 | 187457 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 4787 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6001508.6333 | 2091075.849 | 37.7217814522747 | -122.436870191881 | (37.7217814522747, -122.436870191881) | 9 | 7 | 6 | 28861 | 5 | |||
| 34601 | 15464 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 2434 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2000 12:00:00 AM | 12 | 4X4 | 6006931.67181 | 2104190.23259 | 37.7580973613707 | -122.41905384857 | (37.7580973613707, -122.41905384857) | 2 | 4 | 7 | 28859 | 19 | ||
| 34666 | 28556 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 4717 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6001738.1279 | 2091443.2433 | 37.7228032751332 | -122.436103167424 | (37.7228032751332, -122.436103167424) | 9 | 7 | 6 | 28861 | 5 | ||
| 34798 | 28636 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 955 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/2003 12:00:00 AM | 20 | 5X5 | 5996968.04232 | 2091607.59469 | 37.7229823879791 | -122.452604107446 | (37.7229823879791, -122.452604107446) | 9 | 8 | 6 | 28861 | 24 | ||
| 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 |
| 36085 | 28542 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 5036 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6000555.9648 | 2089678.6918 | 37.7178909833984 | -122.440063176664 | (37.7178909833984, -122.440063176664) | 9 | 7 | 6 | 28861 | 25 | ||
| 36372 | 245975 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2832 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6007039.4939 | 2101849.6883 | 37.7516768348076 | -122.418514987752 | (37.7516768348076, -122.418514987752) | 2 | 4 | 7 | 28859 | 19 | |||
| 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 | ||
| 38025 | 28557 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 4681 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6001872.38004 | 2091652.00525 | 37.7233841148131 | -122.43565401519 | (37.7233841148131, -122.43565401519) | 9 | 7 | 6 | 28861 | 5 | ||
| 38332 | 217466 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 380 Ralston St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 6ft | 5992234.1227 | 2090402.1103 | 37.7194000456453 | -122.468880472968 | (37.7194000456453, -122.468880472968) | 9 | 8 | 6 | 64 | 24 | |||
| 38369 | 15562 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2869 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6007115.4036 | 2101660.115 | 37.7511605828473 | -122.418239042192 | (37.7511605828473, -122.418239042192) | 2 | 4 | 7 | 28859 | 19 | |||
| 38535 | 25222 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1975 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/01/2003 12:00:00 AM | 18 | 3X3 | 5993747.86942 | 2092685.5092 | 37.7257570464481 | -122.463813701632 | (37.7257570464481, -122.463813701632) | 9 | 8 | 4 | 59 | 40 | ||
| 39130 | 28550 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 4919 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6001014.7517 | 2090296.9851 | 37.7196147854688 | -122.438521631633 | (37.7196147854688, -122.438521631633) | 9 | 7 | 6 | 28861 | 5 | ||
| 39394 | 16214 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 530X Monterey Blvd | 1 | Median : Cutout | Tree | DPW 1 | 02/02/2003 12:00:00 AM | 18 | 5 | 5998569.7206668 | 2094722.0869744 | 37.7316256964467 | -122.447291505966 | (37.7316256964467, -122.447291505966) | 9 | 7 | 4 | 59 | 40 | ||
| 39827 | 15743 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 4545 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2001 12:00:00 AM | 12 | 3x3 | 6002337.7208 | 2092395.6969 | 37.7254525452522 | -122.434098558087 | (37.7254525452522, -122.434098558087) | 9 | 7 | 6 | 28861 | 5 | ||
| 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 | ||
| 41136 | 246412 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 3032 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6007104.9213 | 2100736.786 | 37.7486247408195 | -122.418209835675 | (37.7486247408195, -122.418209835675) | 2 | 4 | 7 | 28859 | 19 | |||
| 41672 | 56949 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 87 06th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/27/1974 12:00:00 AM | 16 | Permit Number 14201 | 6010069.06775 | 2112529.00786 | 37.7811698923233 | -122.408791633752 | (37.7811698923233, -122.408791633752) | 14 | 2 | 9 | 28853 | 34 | ||
| 43405 | 25280 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1970 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 5993723.9477 | 2092778.9993 | 37.7260123689359 | -122.463903179691 | (37.7260123689359, -122.463903179691) | 9 | 8 | 4 | 59 | 40 | |||
| 43523 | 122635 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 260 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6006915 | 2105702 | 37.7622473847542 | -122.419218743707 | (37.7622473847542, -122.419218743707) | 8 | 4 | 7 | 28859 | 19 | |||
| 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 | |||
| 44937 | 24508 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 5088 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/26/1995 12:00:00 AM | 3 | 3X3 | 6000357.2418 | 2089366.5868 | 37.7170226983546 | -122.440727697577 | (37.7170226983546, -122.440727697577) | 9 | 7 | 6 | 28861 | 25 | ||
| 45669 | 28545 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 5098 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6000324.7175 | 2089317.75892 | 37.7168867757364 | -122.440836617463 | (37.7168867757364, -122.440836617463) | 9 | 7 | 6 | 28861 | 25 | ||
| 45996 | 28555 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 4743 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6001652.2787 | 2091307.3716 | 37.722425324335 | -122.436390209739 | (37.722425324335, -122.436390209739) | 9 | 7 | 6 | 28861 | 5 | ||
| 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 | ||||
| 46952 | 15556 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2853 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6007106.55999 | 2101746.86 | 37.7513982670828 | -122.41827577404 | (37.7513982670828, -122.41827577404) | 2 | 4 | 7 | 28859 | 19 | |||
| 47774 | 25268 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 1770 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/2003 12:00:00 AM | 18 | 3X3 | 5994565.40331 | 2092391.50822 | 37.7249968682281 | -122.460966269529 | (37.7249968682281, -122.460966269529) | 9 | 8 | 4 | 28861 | 40 | ||
| 47822 | 15454 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2366 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/10/1992 12:00:00 AM | 18 | 4X4 | 6006889.3715 | 2104582.8537 | 37.7591730259049 | -122.419227992101 | (37.7591730259049, -122.419227992101) | 2 | 4 | 7 | 28859 | 19 | ||
| 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 | ||
| 48836 | 217479 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 158 Burnside Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 5ft | 6001063.19964 | 2095410.82809 | 37.7336589855795 | -122.438720409541 | (37.7336589855795, -122.438720409541) | 9 | 7 | 5 | 63 | 40 | |||
| 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 | |||
| 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 | ||||
| 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 |
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) );