trees
54 rows where qSpecies_id = 176 sorted by qSpecies_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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1175 | 217424 | DPW Maintained 1 | Washingtonia filifera :: California Fan Palm 176 | 450 Los Palmos Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 3ft | 5997245.21557 | 2095811.54229 | 37.7345413068394 | -122.451949128344 | (37.7345413068394, -122.451949128344) | 9 | 7 | 4 | 59 | 40 | |||
3926 | 15058 | DPW Maintained 1 | Washingtonia filifera :: California Fan Palm 176 | 10X Minerva St | 1 | Median : Cutout | Tree | DPW 1 | 3 | 11 | 5996572.9500165 | 2089038.2134875 | 37.7159048245128 | -122.45378440062 | (37.7159048245128, -122.45378440062) | 9 | 8 | 6 | 28861 | 24 | |||
7170 | 262304 | DPW Maintained 1 | Washingtonia filifera :: California Fan Palm 176 | 3638 Taraval St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5981882 | 2098805 | 37.741868575026 | -122.505285765985 | (37.741868575026, -122.505285765985) | 1 | 8 | 3 | 29491 | 35 | ||||
7337 | 15078 | DPW Maintained 1 | Washingtonia filifera :: California Fan Palm 176 | 60 Minerva St | 1 | Median : Cutout | Tree | DPW 1 | 3 | 11 | 5996206.9344238 | 2089043.0380608 | 37.7158970804766 | -122.455049862348 | (37.7158970804766, -122.455049862348) | 9 | 8 | 6 | 28861 | 24 | |||
7467 | 238440 | DPW Maintained 1 | Washingtonia filifera :: California Fan Palm 176 | 701 Waller St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/20/2020 04:27:00 PM | 2 | Width 3ft | 6002273.48193 | 2108783.68455 | 37.7704464445658 | -122.435492443229 | (37.7704464445658, -122.435492443229) | 15 | 5 | 5 | 29492 | 9 | ||
8742 | 262303 | DPW Maintained 1 | Washingtonia filifera :: California Fan Palm 176 | 3638 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5981882 | 2098805 | 37.741868575026 | -122.505285765985 | (37.741868575026, -122.505285765985) | 1 | 8 | 3 | 29491 | 35 | ||||
16764 | 28400 | DPW Maintained 1 | Washingtonia filifera :: California Fan Palm 176 | 1801 Ocean Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/2003 12:00:00 AM | 18 | 5X5 | 5994359.8299 | 2092387.6752 | 37.7249745123116 | -122.461676631092 | (37.7249745123116, -122.461676631092) | 9 | 8 | 4 | 28861 | 24 | ||
19058 | 19965 | DPW Maintained 1 | Washingtonia filifera :: California Fan Palm 176 | 100 STAIRWAY41 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 25ST | |||||||||||||
28472 | 108538 | Undocumented 4 | Washingtonia filifera :: California Fan Palm 176 | 400-422X Tocoloma Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012449.25025 | 2086560.52634 | 37.7099990266406 | -122.398734355673 | (37.7099990266406, -122.398734355673) | 10 | 3 | 8 | 309 | 1 | |||||
29520 | 102438 | DPW Maintained 1 | Washingtonia filifera :: California Fan Palm 176 | 999X Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6010518 | 2112007 | 37.77976171638 | -122.407201735558 | (37.77976171638, -122.407201735558) | 14 | 2 | 9 | 28853 | 34 | ||||
33455 | 25062 | DPW Maintained 1 | Washingtonia filifera :: California Fan Palm 176 | 1096X Dolores St | 5 | Median : Cutout | Tree | DPW 1 | 40 | 20 | 6005084.1647621 | 2101955.0797665 | 37.7518559425348 | -122.42528427535 | (37.7518559425348, -122.42528427535) | 2 | 4 | 5 | 28862 | 22 | |||
34275 | 25053 | DPW Maintained 1 | Washingtonia filifera :: California Fan Palm 176 | 990X Dolores St | 8 | Median : Cutout | Tree | DPW 1 | 10/20/1999 12:00:00 AM | 20 | 20 | 6005038.29077 | 2102581.9809991 | 37.7535746757806 | -122.425487524624 | (37.7535746757806, -122.425487524624) | 2 | 4 | 5 | 28862 | 22 | ||
38849 | 25068 | DPW Maintained 1 | Washingtonia filifera :: California Fan Palm 176 | 1096X Dolores St | 11 | Median : Cutout | Tree | DPW 1 | 40 | 20 | 6005084.1647621 | 2101955.0797665 | 37.7518559425348 | -122.42528427535 | (37.7518559425348, -122.42528427535) | 2 | 4 | 5 | 28862 | 22 | |||
39513 | 98455 | Significant Tree 6 | Washingtonia filifera :: California Fan Palm 176 | 2200 22nd St | 1 | Front Yard : Yard | Tree | Private 2 | 6011565.2 | 2103754.7 | 37.7571613219705 | -122.402998394603 | (37.7571613219705, -122.402998394603) | 10 | 3 | 8 | 28856 | 29 | |||||
48241 | 114478 | Undocumented 4 | Washingtonia filifera :: California Fan Palm 176 | 45 HOFF ST | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6006591 | 2106401 | 37.7641484227608 | -122.420388955837 | (37.7641484227608, -122.420388955837) | 8 | 4 | 7 | 28859 | 19 | ||||
48391 | 102422 | DPW Maintained 1 | Washingtonia filifera :: California Fan Palm 176 | 99 06th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 4x4 | 6010101 | 2112468 | 37.7810041676544 | -122.408676858386 | (37.7810041676544, -122.408676858386) | 14 | 2 | 9 | 28853 | 34 | |||
59012 | 102436 | DPW Maintained 1 | Washingtonia filifera :: California Fan Palm 176 | 1001 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6010518 | 2112007 | 37.77976171638 | -122.407201735558 | (37.77976171638, -122.407201735558) | 14 | 2 | 9 | 28853 | 34 | ||||
59165 | 28585 | DPW Maintained 1 | Washingtonia filifera :: California Fan Palm 176 | 1150 Ocean Ave | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/18/2011 12:00:00 AM | 3 | 3x3 | Permit Number 56953 | 5996248.46954 | 2091917.74069 | 37.7237927195289 | -122.455113909949 | (37.7237927195289, -122.455113909949) | 9 | 7 | 4 | 28861 | 40 | |
61508 | 1839 | DPW Maintained 1 | Washingtonia filifera :: California Fan Palm 176 | 2193X Bay Shore Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6011389.3610541 | 2087350.7454491 | 37.7121096997176 | -122.402453085787 | (37.7121096997176, -122.402453085787) | 10 | 3 | 8 | 309 | 1 | |||
65820 | 25008 | DPW Maintained 1 | Washingtonia filifera :: California Fan Palm 176 | 500X Dolores St | 2 | Median : Cutout | Tree | DPW 1 | 35 | 20 | 6004896.4850005 | 2105439.5076575 | 37.7614127588524 | -122.426181340905 | (37.7614127588524, -122.426181340905) | 2 | 4 | 5 | 28862 | 3 | |||
67202 | 109707 | Undocumented 4 | Washingtonia filifera :: California Fan Palm 176 | 850 PORTOLA DR | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5996501.5 | 2099217 | 37.7438492362387 | -122.454766346821 | (37.7438492362387, -122.454766346821) | 1 | 5 | 4 | 59 | 40 | ||||
70132 | 24970 | DPW Maintained 1 | Washingtonia filifera :: California Fan Palm 176 | 198 Dolores St | 11 | Median : Cutout | Tree | DPW 1 | 50 | 20 | 6004804.6555297 | 2107199.7616194 | 37.7662408057536 | -122.426624291348 | (37.7662408057536, -122.426624291348) | 8 | 4 | 5 | 28862 | 3 | |||
71306 | 102440 | DPW Maintained 1 | Washingtonia filifera :: California Fan Palm 176 | 1010 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6010010 | 2112396 | 37.7808013755178 | -122.408986592248 | (37.7808013755178, -122.408986592248) | 14 | 2 | 9 | 28853 | 34 | ||||
83113 | 102434 | DPW Maintained 1 | Washingtonia filifera :: California Fan Palm 176 | 1000 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6010518 | 2112007 | 37.77976171638 | -122.407201735558 | (37.77976171638, -122.407201735558) | 14 | 2 | 9 | 28853 | 34 | ||||
89841 | 253178 | Significant Tree 6 | Washingtonia filifera :: California Fan Palm 176 | 4450 24th St | 2 | Front Yard : Cutout | Tree | Private 2 | Width 0ft | Permit Number 780574 | 6000289.52403 | 2101701.02913 | 37.7508863393389 | -122.441846529398 | (37.7508863393389, -122.441846529398) | 2 | 4 | 5 | 28862 | 22 | |||
92853 | 24969 | DPW Maintained 1 | Washingtonia filifera :: California Fan Palm 176 | 198 Dolores St | 10 | Median : Cutout | Tree | DPW 1 | 50 | 20 | 6004804.6555297 | 2107199.7616194 | 37.7662408057536 | -122.426624291348 | (37.7662408057536, -122.426624291348) | 8 | 4 | 5 | 28862 | 3 | |||
96313 | 114479 | Undocumented 4 | Washingtonia filifera :: California Fan Palm 176 | 45 HOFF ST | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6006591 | 2106401 | 37.7641484227608 | -122.420388955837 | (37.7641484227608, -122.420388955837) | 8 | 4 | 7 | 28859 | 19 | ||||
100591 | 96499 | DPW Maintained 1 | Washingtonia filifera :: California Fan Palm 176 | 2500X Harrison St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5x5 | 6008744 | 2103690.4 | 37.7568268248396 | -122.412750681409 | (37.7568268248396, -122.412750681409) | 2 | 4 | 7 | 28859 | 19 | |||
103488 | 102417 | Permitted Site 7 | Washingtonia filifera :: California Fan Palm 176 | 299X 06th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6010975.6 | 2111650.5 | 37.7788084493495 | -122.405593572608 | (37.7788084493495, -122.405593572608) | 14 | 2 | 9 | 28853 | 34 | |||
105939 | 28586 | DPW Maintained 1 | Washingtonia filifera :: California Fan Palm 176 | 1150 Ocean Ave | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/18/2011 12:00:00 AM | 3 | 3x3 | Permit Number 56953 | 5996248.46954 | 2091917.74069 | 37.7237927195289 | -122.455113909949 | (37.7237927195289, -122.455113909949) | 9 | 7 | 4 | 28861 | 40 | |
109239 | 15070 | DPW Maintained 1 | Washingtonia filifera :: California Fan Palm 176 | 30X Minerva St | 2 | Median : Cutout | Tree | DPW 1 | 3 | 11 | 5996426.1222644 | 2089040.1488729 | 37.7159017196126 | -122.454292042688 | (37.7159017196126, -122.454292042688) | 9 | 8 | 6 | 28861 | 24 | |||
110679 | 24971 | DPW Maintained 1 | Washingtonia filifera :: California Fan Palm 176 | 198 Dolores St | 12 | Median : Cutout | Tree | DPW 1 | 50 | 20 | 6004804.6555297 | 2107199.7616194 | 37.7662408057536 | -122.426624291348 | (37.7662408057536, -122.426624291348) | 8 | 4 | 5 | 28862 | 3 | |||
113513 | 96492 | DPW Maintained 1 | Washingtonia filifera :: California Fan Palm 176 | 2500X Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5x5 | 6008744 | 2103690.4 | 37.7568268248396 | -122.412750681409 | (37.7568268248396, -122.412750681409) | 2 | 4 | 7 | 28859 | 19 | |||
116181 | 102425 | DPW Maintained 1 | Washingtonia filifera :: California Fan Palm 176 | 88 06th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 4x4 | 6010035 | 2112492 | 37.7810663692444 | -122.408906879924 | (37.7810663692444, -122.408906879924) | 14 | 2 | 9 | 28853 | 34 | |||
116385 | 178 | DPW Maintained 1 | Washingtonia filifera :: California Fan Palm 176 | 2900X 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3x3 | 6007426.6373058 | 2106784.9094001 | 37.7652496025139 | -122.41752593136 | (37.7652496025139, -122.41752593136) | 8 | 4 | 7 | 28853 | 19 | |||
120179 | 102423 | DPW Maintained 1 | Washingtonia filifera :: California Fan Palm 176 | 99 06th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 4x4 | 6010101 | 2112468 | 37.7810041676544 | -122.408676858386 | (37.7810041676544, -122.408676858386) | 14 | 2 | 9 | 28853 | 34 | |||
122203 | 102416 | Permitted Site 7 | Washingtonia filifera :: California Fan Palm 176 | 299X 06th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6010975.6 | 2111650.5 | 37.7788084493495 | -122.405593572608 | (37.7788084493495, -122.405593572608) | 14 | 2 | 9 | 28853 | 34 | |||
131185 | 181 | DPW Maintained 1 | Washingtonia filifera :: California Fan Palm 176 | 2900X 16th St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3x3 | 6007426.6373058 | 2106784.9094001 | 37.7652496025139 | -122.41752593136 | (37.7652496025139, -122.41752593136) | 8 | 4 | 7 | 28853 | 19 | |||
136679 | 102437 | Permitted Site 7 | Washingtonia filifera :: California Fan Palm 176 | 999X Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6010518 | 2112007 | 37.77976171638 | -122.407201735558 | (37.77976171638, -122.407201735558) | 14 | 2 | 9 | 28853 | 34 | ||||
140097 | 25010 | DPW Maintained 1 | Washingtonia filifera :: California Fan Palm 176 | 500X Dolores St | 4 | Median : Cutout | Tree | DPW 1 | 50 | 20 | 6004896.4850005 | 2105439.5076575 | 37.7614127588524 | -122.426181340905 | (37.7614127588524, -122.426181340905) | 2 | 4 | 5 | 28862 | 3 | |||
144418 | 179 | DPW Maintained 1 | Washingtonia filifera :: California Fan Palm 176 | 2900X 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3X3 | 6007426.6373058 | 2106784.9094001 | 37.7652496025139 | -122.41752593136 | (37.7652496025139, -122.41752593136) | 8 | 4 | 7 | 28853 | 19 | |||
149024 | 25125 | DPW Maintained 1 | Washingtonia filifera :: California Fan Palm 176 | 1636X Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 35 | 20 | 6005246.3113281 | 2098818.4021849 | 37.7432525052647 | -122.424500456756 | (37.7432525052647, -122.424500456756) | 2 | 7 | 5 | 63 | 22 | |||
151488 | 102439 | DPW Maintained 1 | Washingtonia filifera :: California Fan Palm 176 | 1010 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6010010 | 2112396 | 37.7808013755178 | -122.408986592248 | (37.7808013755178, -122.408986592248) | 14 | 2 | 9 | 28853 | 34 | ||||
152716 | 96497 | DPW Maintained 1 | Washingtonia filifera :: California Fan Palm 176 | 2500X Harrison St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5x5 | 6008744 | 2103690.4 | 37.7568268248396 | -122.412750681409 | (37.7568268248396, -122.412750681409) | 2 | 4 | 7 | 28859 | 19 | |||
153018 | 102435 | DPW Maintained 1 | Washingtonia filifera :: California Fan Palm 176 | 1001 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6010518 | 2112007 | 37.77976171638 | -122.407201735558 | (37.77976171638, -122.407201735558) | 14 | 2 | 9 | 28853 | 34 | ||||
156746 | 40177 | Permitted Site 7 | Washingtonia filifera :: California Fan Palm 176 | 2406 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/26/1999 12:00:00 AM | 20 | Permit Number 41368 | 6008809.43227886 | 2104437.82814434 | 37.7588827650821 | -122.412577225783 | (37.7588827650821, -122.412577225783) | 2 | 4 | 7 | 28859 | 19 | ||
157327 | 44364 | Permitted Site 7 | Washingtonia filifera :: California Fan Palm 176 | 633 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/16/2014 12:00:00 AM | 4x4 | Permit Number 772539 | 6010135.35236378 | 2105346.34168851 | 37.7614516631692 | -122.408055626463 | (37.7614516631692, -122.408055626463) | 10 | 4 | 8 | 28859 | 19 | ||
170726 | 102433 | DPW Maintained 1 | Washingtonia filifera :: California Fan Palm 176 | 1000 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6010518 | 2112007 | 37.77976171638 | -122.407201735558 | (37.77976171638, -122.407201735558) | 14 | 2 | 9 | 28853 | 34 | ||||
175843 | 102424 | Permitted Site 7 | Washingtonia filifera :: California Fan Palm 176 | 88 06th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 4x4 | 6010035 | 2112492 | 37.7810663692444 | -122.408906879924 | (37.7810663692444, -122.408906879924) | 14 | 2 | 9 | 28853 | 34 | |||
181654 | 102427 | Permitted Site 7 | Washingtonia filifera :: California Fan Palm 176 | 184 06th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 4x4 | 6010519 | 2112009 | 37.7797672638755 | -122.407198417126 | (37.7797672638755, -122.407198417126) | 14 | 2 | 9 | 28853 | 34 | |||
181980 | 15060 | DPW Maintained 1 | Washingtonia filifera :: California Fan Palm 176 | 10X Minerva St | 3 | Median : Cutout | Tree | DPW 1 | 3 | 11 | 5996572.9500165 | 2089038.2134875 | 37.7159048245128 | -122.45378440062 | (37.7159048245128, -122.45378440062) | 9 | 8 | 6 | 28861 | 24 | |||
190278 | 96494 | DPW Maintained 1 | Washingtonia filifera :: California Fan Palm 176 | 2500X Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5x5 | 6008744 | 2103690.4 | 37.7568268248396 | -122.412750681409 | (37.7568268248396, -122.412750681409) | 2 | 4 | 7 | 28859 | 19 | |||
192864 | 114481 | Undocumented 4 | Washingtonia filifera :: California Fan Palm 176 | 45 HOFF ST | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6006591 | 2106401 | 37.7641484227608 | -122.420388955837 | (37.7641484227608, -122.420388955837) | 8 | 4 | 7 | 28859 | 19 | ||||
194267 | 264981 | Permitted Site 7 | Washingtonia filifera :: California Fan Palm 176 | 106X Grand View Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/2020 12:00:00 AM | 3 | 4.5x5 | Permit Number 787721 | 6000803 | 2103641 | 37.7562422754387 | -122.440209988419 | (37.7562422754387, -122.440209988419) | 2 | 4 | 5 | 28862 | 38 |
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) );