trees
1,024 rows where qSpecies_id = 72
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 | ||||
| 662 | 181218 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 765 Delano Ave | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 26 | Width 10ft | 5998962.78764 | 2090178.02559 | 37.7191712122718 | -122.445605954547 | (37.7191712122718, -122.445605954547) | 9 | 7 | 6 | 28861 | 25 | |||
| 728 | 102430 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 200 06th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2017 12:00:00 AM | 3 | 4x4 | Permit Number 770993 | 6010566.09371 | 2111909.33227 | 37.7794962351107 | -122.407028471514 | (37.7794962351107, -122.407028471514) | 14 | 2 | 9 | 28853 | 34 | |
| 906 | 25069 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1000X Dolores St | 12 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005114.64614 | 2102050.12648 | 37.752118640771 | -122.425185628926 | (37.752118640771, -122.425185628926) | 2 | 4 | 5 | 28862 | 22 | |||
| 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 | ||||
| 1209 | 199473 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1000 03rd St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 6015478.1467 | 2109531.70871 | 37.7732414619454 | -122.389869319627 | (37.7732414619454, -122.389869319627) | 14 | 3 | 9 | 310 | 20 | |||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | |
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 3698 | 181258 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2400x Bay Shore Blvd | 3 | Median : Cutout | Tree | DPW 1 | 15 | Width 6ft | 6010956.04386 | 2086896.41565 | 37.7108380015362 | -122.403918812817 | (37.7108380015362, -122.403918812817) | 9 | 7 | 8 | 309 | 1 | |||
| 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 | |||
| 4004 | 244831 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 3048 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6007103.14556 | 2100672.23049 | 37.748447386038 | -122.41821139994 | (37.748447386038, -122.41821139994) | 2 | 4 | 7 | 28859 | 19 | |||
| 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 | |
| 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 | ||||
| 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 |
| 4818 | 102421 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 101 06th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 4x4 | 6010161.06831 | 2112431.87946 | 37.7809083532874 | -122.408466502752 | (37.7809083532874, -122.408466502752) | 14 | 2 | 9 | 28853 | 34 | |||
| 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 | |||
| 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 | ||||
| 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 | |||
| 6999 | 137503 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1142 Filbert St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 28 | Width 3ft | 6007446.54333 | 2119552.35251 | 37.8003070257165 | -122.418362418606 | (37.8003070257165, -122.418362418606) | 5 | 1 | 1 | 28858 | 32 | |||
| 7287 | 199483 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1300 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 6015509.13182 | 2108964.41049 | 37.7716855044225 | -122.389722506198 | (37.7716855044225, -122.389722506198) | 14 | 3 | 9 | 310 | 20 | |||
| 7466 | 203179 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1800 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 5ft | 6015617.1468 | 2107140.95711 | 37.7666846892774 | -122.389221524481 | (37.7666846892774, -122.389221524481) | 14 | 3 | 9 | 310 | 29 | |||
| 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 | ||||
| 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 | ||
| 8185 | 247646 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 900 Duboce Ave | 2 | : | Tree | Private 2 | 13 | Width 5ft | 6001616.30949 | 2108303.20625 | 37.7690898244695 | -122.437731184045 | (37.7690898244695, -122.437731184045) | 15 | 5 | 5 | 29492 | 9 | |||
| 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 | ||||
| 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 | |||
| 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 | ||||
| 9365 | 247654 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 900 Duboce Ave | 10 | : | Tree | Private 2 | 15 | Width 5ft | 6001517.12711 | 2108295.57391 | 37.7690632279012 | -122.438073702561 | (37.7690632279012, -122.438073702561) | 15 | 5 | 5 | 29492 | 9 | |||
| 9685 | 187439 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 4620 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6002001.2284 | 2091970.7345 | 37.7242665912846 | -122.435231397877 | (37.7242665912846, -122.435231397877) | 9 | 7 | 6 | 28861 | 25 | |||
| 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 | |||
| 10028 | 181241 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 80 Blanken Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6011651.71602 | 2087377.28127 | 37.7121972045013 | -122.401548169322 | (37.7121972045013, -122.401548169322) | 10 | 3 | 8 | 309 | 1 | |||
| 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 | ||||
| 10473 | 217439 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 601x Monterey Blvd | 8 | Median : Cutout | Tree | DPW 1 | 12 | Width 4ft | 5997627.34725 | 2094709.1564 | 37.7315362986663 | -122.450548529595 | (37.7315362986663, -122.450548529595) | 9 | 7 | 4 | 59 | 40 | |||
| 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 | ||||
| 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 | ||||
| 12306 | 243933 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 784 Duncan St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 6ft | 6001410.80109 | 2099722.64145 | 37.7455179856652 | -122.437827372845 | (37.7455179856652, -122.437827372845) | 2 | 7 | 5 | 63 | 22 | |||
| 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 | ||||
| 12871 | 24346 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 95 Duboce Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6006149.34547 | 2108468.08439 | 37.7697992483598 | -122.422063370746 | (37.7697992483598, -122.422063370746) | 8 | 4 | 7 | 28853 | 19 | |||
| 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 | ||||
| 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 | |||
| 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 | ||||
| 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 | |
| 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 | ||||
| 14282 | 84749 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 170 King St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/2007 12:00:00 AM | 21 | Permit No. 49304 | 6015056.82948 | 2111496.40969 | 37.7786127186366 | -122.391464102698 | (37.7786127186366, -122.391464102698) | 6 | 2 | 9 | 28856 | 20 | ||
| 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 | |
| 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 | ||||
| 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 | |
| 15043 | 217457 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1x Minerva St | 18 | Median : Cutout | Tree | DPW 1 | 20 | Width 0ft | 5996170.11239 | 2089001.42717 | 37.7157807141869 | -122.455174130483 | (37.7157807141869, -122.455174130483) | 9 | 8 | 6 | 28861 | 24 | |||
| 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 | ||||
| 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 | |
| 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 | ||
| 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 | |||
| 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 | ||||
| 18703 | 1859 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2500 Bay Shore Blvd | 3 | Median : Cutout | Tree | DPW 1 | 18 | 6 | 6010721.13652 | 2086497.18877 | 37.7097286779125 | -122.404702624138 | (37.7097286779125, -122.404702624138) | 9 | 7 | 8 | 309 | 1 | |||
| 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 | ||||
| 19309 | 246367 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1999 Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6006824.8887 | 2106890.3369 | 37.7655052042839 | -122.41961472171 | (37.7655052042839, -122.41961472171) | 8 | 4 | 7 | 28853 | 19 | |||
| 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 | ||||
| 19678 | 1841 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2200 Bay Shore Blvd | 2 | Median : Cutout | Tree | DPW 1 | 12 | 6 | 6011283.06964 | 2087344.73094 | 37.712087250691 | -122.402820039113 | (37.712087250691, -122.402820039113) | 10 | 7 | 8 | 309 | 1 | |||
| 20345 | 243951 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 10 South Van Ness Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/2004 12:00:00 AM | 14 | Width 5ft | Permit Number 47529 | 6007014.66541 | 2110083.11128 | 37.7742824946758 | -122.419184822535 | (37.7742824946758, -122.419184822535) | 8 | 2 | 9 | 28853 | 19 | |
| 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 | ||
| 21038 | 21865 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1900 03rd St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/25/1995 12:00:00 AM | 3 | 3X3 | 6015619.46662 | 2106949.47478 | 37.7661590490173 | -122.389200128686 | (37.7661590490173, -122.389200128686) | 14 | 3 | 9 | 310 | 29 |
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) );