trees
1,024 rows where qSpecies_id = 72 sorted by qLegalStatus_id
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
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 | |||
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 | ||||
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 | |||
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 | |||
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 | |
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 | |||
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 | |||
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 | |||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | ||||
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 | ||||
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 | |
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 | |||
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 | |||
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 | ||||
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 | |||
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 | ||
21185 | 15535 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2800 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6007034.0945 | 2101996.1061 | 37.7520785607407 | -122.418544041176 | (37.7520785607407, -122.418544041176) | 2 | 4 | 7 | 28859 | 19 | |||
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 | ||||
21670 | 1798 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2000 Bay Shore Blvd | 6 | Median : Cutout | Tree | DPW 1 | 12/27/1991 12:00:00 AM | 12 | 6 | 6012206.26499 | 2088043.30695 | 37.7140569062806 | -122.399678207209 | (37.7140569062806, -122.399678207209) | 10 | 3 | 8 | 309 | 39 | ||
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 | |||
22204 | 28626 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1299 Ocean Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/02/2016 08:27:00 AM | 3 | 3X | 5996084.79184 | 2091881.76593 | 37.7236845496924 | -122.455677113986 | (37.7236845496924, -122.455677113986) | 9 | 8 | 4 | 28861 | 24 | ||
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 | ||
22487 | 33555 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2400 Fulton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/11/1996 12:00:00 AM | 14 | Permit Number 37664 | 5996213.16627 | 2110420.46964 | 37.7745945717567 | -122.456573356196 | (37.7745945717567, -122.456573356196) | 11 | 5 | 2 | 54 | 16 | ||
22580 | 28406 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1735 Ocean Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/01/2003 12:00:00 AM | 18 | 5X5 | 5994613.7507 | 2092228.85982 | 37.7245530568803 | -122.46078735712 | (37.7245530568803, -122.46078735712) | 9 | 8 | 4 | 28861 | 24 | ||
23350 | 49326 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 690 05th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/21/2003 12:00:00 AM | 16 | Permit Number 46321 | 6013271.22314 | 2110393.49802 | 37.7754851058895 | -122.397563870475 | (37.7754851058895, -122.397563870475) | 14 | 2 | 9 | 28856 | 20 | ||
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 | |||
24354 | 15397 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2023 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6006842.046 | 2106580.1715 | 37.7646545293596 | -122.419533371078 | (37.7646545293596, -122.419533371078) | 8 | 4 | 7 | 28859 | 19 | |||
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 | |||
24519 | 246365 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1940 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6006762.2381 | 2106995.3403 | 37.7657899896764 | -122.41983886795 | (37.7657899896764, -122.41983886795) | 8 | 4 | 7 | 28853 | 19 | |||
24563 | 246285 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2109 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6006870.1021 | 2106021.3241 | 37.7631216455182 | -122.419396683437 | (37.7631216455182, -122.419396683437) | 8 | 4 | 7 | 28859 | 19 | |||
24566 | 199505 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 121 07th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6009689.53245 | 2111610.6533 | 37.7786270421403 | -122.410039791109 | (37.7786270421403, -122.410039791109) | 14 | 2 | 9 | 28853 | 34 | |||
24970 | 243952 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 10 South Van Ness Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/2004 12:00:00 AM | 15 | Width 5ft | Permit Number 47529 | 6007022.68787 | 2110044.22077 | 37.7741761624211 | -122.419154312126 | (37.7741761624211, -122.419154312126) | 8 | 2 | 9 | 28853 | 19 | |
25117 | 28608 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1345 Ocean Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/24/2015 09:29:00 AM | 3 | 3X3 | 5995740.3284 | 2091982.407 | 37.7239411121873 | -122.456875133176 | (37.7239411121873, -122.456875133176) | 9 | 8 | 4 | 28861 | 24 | ||
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 | ||
25995 | 25282 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1970 Ocean Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 5993611.6506 | 2092838.2672 | 37.7261686319457 | -122.464295681605 | (37.7261686319457, -122.464295681605) | 9 | 8 | 4 | 59 | 40 | |||
26368 | 21872 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1900 03rd St | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/25/1995 12:00:00 AM | 3 | 3X3 | 6015641.71858 | 2106711.03714 | 37.7655055845439 | -122.389106512866 | (37.7655055845439, -122.389106512866) | 14 | 3 | 9 | 310 | 29 | ||
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 | |||
27094 | 15498 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2704 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6007015.1629 | 2102569.9783 | 37.7536532168709 | -122.418650201708 | (37.7536532168709, -122.418650201708) | 2 | 4 | 7 | 28859 | 19 | |||
27299 | 246732 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 101 Ripley St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 8ft | 6008546.25114 | 2099104.34804 | 37.7442234529633 | -122.413110303201 | (37.7442234529633, -122.413110303201) | 2 | 7 | 7 | 28859 | 2 | |||
27471 | 244827 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1450x Dolores St | 8 | Median : Yard | Tree | DPW 1 | 17 | 6005245.25047 | 2099669.70272 | 37.7455899224496 | -122.424564667746 | (37.7455899224496, -122.424564667746) | 2 | 7 | 5 | 63 | 22 | ||||
27924 | 27101 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 675 Silver Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | 3X3 | 6005857.71837 | 2093582.84449 | 37.7289113394736 | -122.422014518651 | (37.7289113394736, -122.422014518651) | 9 | 7 | 6 | 28861 | 5 | |||
28071 | 217443 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 290 Granada Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 5995680.04385 | 2091933.48805 | 37.7238033305439 | -122.45707998906 | (37.7238033305439, -122.45707998906) | 9 | 8 | 4 | 28861 | 24 | |||
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 | |||
28477 | 244826 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 500x Dolores St | 8 | Median : Yard | Tree | DPW 1 | 20 | 6004940.86416 | 2105188.02891 | 37.760724766043 | -122.426009949295 | (37.760724766043, -122.426009949295) | 2 | 4 | 5 | 28862 | 3 | ||||
28663 | 199454 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1401 03rd St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 5ft | 6015626.42459 | 2108505.26742 | 37.7704313017932 | -122.38928471262 | (37.7704313017932, -122.38928471262) | 14 | 3 | 9 | 310 | 20 | |||
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 | ||
28944 | 181257 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2400x Bay Shore Blvd | 2 | Median : Cutout | Tree | DPW 1 | 15 | Width 6ft | 6010977.11587 | 2086929.96483 | 37.7109312981009 | -122.403848341928 | (37.7109312981009, -122.403848341928) | 10 | 7 | 8 | 309 | 1 | |||
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 | |||
28993 | 15472 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2480 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/20/1993 12:00:00 AM | 18 | 4X4 | 6006923.7988 | 2103940.4395 | 37.7574110439022 | -122.419063359319 | (37.7574110439022, -122.419063359319) | 2 | 4 | 7 | 28859 | 19 | ||
29212 | 203185 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 10 Arkansas St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 4ft | 6012813.13968 | 2106962.381 | 37.7660385137928 | -122.398907634804 | (37.7660385137928, -122.398907634804) | 14 | 3 | 8 | 28856 | 20 | |||
29229 | 28453 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2070X Ocean Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/01/2003 12:00:00 AM | 12 | 3x3 | 5993250.12022 | 2093006.30937 | 37.7266091892515 | -122.465557664158 | (37.7266091892515, -122.465557664158) | 9 | 8 | 4 | 59 | 40 | ||
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 | |||
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 |
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) );