Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3463 | 3463 | 25005 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 400X Dolores St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 60 | 20 | 6004909.6221900005 | 2105744.1135299997 | 37.7622498768445 | -122.426157591005 | (37.7622498768445, -122.426157591005) | |||
11148 | 11148 | 20065 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 STAIRWAY54 | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 15ST | ||||||||
13621 | 13621 | 18556 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 19 | 6014603.96741 | 2095108.67042 | 37.7335903547148 | -122.391884517749 | (37.7335903547148, -122.391884517749) | |||
14049 | 14049 | 18560 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 19 | 6014546.06488 | 2095149.2171099999 | 37.7336984729967 | -122.392087539714 | (37.7336984729967, -122.392087539714) | |||
15304 | 15304 | 19794 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 STAIRWAY19 | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 50ST | ||||||||
16559 | 16559 | 18559 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 19 | 6014565.4208 | 2095135.4289 | 37.733661688034104 | -122.392019656183 | (37.7336616880341, -122.392019656183) | |||
16918 | 16918 | 25119 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1500X Dolores St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 20 | 6005258.69008 | 2099408.1764 | 37.7448725899054 | -122.42449959638999 | (37.7448725899054, -122.42449959639) | |||
16926 | 16926 | 24992 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 340 Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004882.50848 | 2106257.6214799997 | 37.763658315014204 | -122.426287928865 | (37.7636583150142, -122.426287928865) | |||
16962 | 16962 | 25071 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 20 | 6005127.376540001 | 2101840.69033 | 37.751544296835206 | -122.42512670443001 | (37.7515442968352, -122.42512670443) | |||
17004 | 17004 | 25108 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1400 Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 20 | 6005223.671490001 | 2100130.84124 | 37.7468548845426 | -122.424672082757 | (37.7468548845426, -122.424672082757) | |||
17005 | 17005 | 25139 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005326.84877 | 2098252.91312 | 37.741704348480795 | -122.42418177058599 | (37.7417043484808, -122.424181770586) | |||
17024 | 17024 | 25136 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005320.97591 | 2098341.7574 | 37.741947963130706 | -122.424208394127 | (37.7419479631307, -122.424208394127) | |||
17056 | 17056 | 25058 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1000X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005092.48697 | 2102458.1018 | 37.753237594341996 | -122.425291287561 | (37.753237594342, -122.425291287561) | |||
17078 | 17078 | 25113 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1400 Dolores St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 20 | 6005228.94357 | 2100007.06865 | 37.7465153311328 | -122.424645049125 | (37.7465153311328, -122.424645049125) | |||
17125 | 17125 | 25503 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1900X Market St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 8 | 6005164.8443 | 2108651.7776 | 37.7702480498919 | -122.42548181214701 | (37.7702480498919, -122.425481812147) | ||
17149 | 17149 | 25538 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2200X Market St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 20 | 6003277.964 | 2106841.2745 | 37.7651700578839 | -122.431879221699 | (37.7651700578839, -122.431879221699) | ||
17224 | 17224 | 25054 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 900X Dolores St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 35 | 20 | 6005073.8483 | 2102816.15893 | 37.7542196827988 | -122.42538122246201 | (37.7542196827988, -122.425381222462) | |||
17235 | 17235 | 708 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1504X Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/06/2015 02:27:00 PM | 3 | 6x6 | 6005213.6425 | 2099570.03766 | 37.745314479891896 | -122.42466687479799 | (37.7453144798919, -122.424666874798) | ||
17252 | 17252 | 24963 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004800.736959999 | 2107633.50365 | 37.7674315357679 | -122.42666873508999 | (37.7674315357679, -122.42666873509) | |||
17260 | 17260 | 24994 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 300 Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004873.5625 | 2106448.79257 | 37.7641827195917 | -122.42633248217399 | (37.7641827195917, -122.426332482174) | |||
17276 | 17276 | 25090 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1250X Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005182.99372 | 2100845.43458 | 37.7488146961375 | -122.424863573617 | (37.7488146961375, -122.424863573617) | |||
17311 | 17311 | 25026 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 750X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6005011.77925 | 2103932.39938 | 37.7572811108424 | -122.42567531518499 | (37.7572811108424, -122.425675315185) | |||
17316 | 17316 | 25084 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1200X Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005164.22411 | 2101175.53736 | 37.7497200220711 | -122.42495196167499 | (37.7497200220711, -122.424951961675) | |||
17339 | 17339 | 25501 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1900X Market St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 8 | 6005202.0445 | 2108688.1512 | 37.770350024818704 | -122.425355725564 | (37.7703500248187, -122.425355725564) | ||
17397 | 17397 | 25527 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2300X Market St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6002730.2479 | 2106324.2376 | 37.7637193356407 | -122.433736680672 | (37.7637193356407, -122.433736680672) | ||
17398 | 17398 | 5707 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1600 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6005241.864159999 | 2098983.9941 | 37.74370693182271 | -122.424527610259 | (37.7437069318227, -122.424527610259) | |||
17405 | 17405 | 24337 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2020X Market St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/07/1993 12:00:00 AM | 36 | 8 | 6004420.4688 | 2107930.9893 | 37.7682268534635 | -122.428005232451 | (37.7682268534635, -122.428005232451) | ||
17411 | 17411 | 25526 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2300X Market St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6002746.7355 | 2106338.4868 | 37.7637593960329 | -122.43368067367201 | (37.7637593960329, -122.433680673672) | ||
17425 | 17425 | 25099 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1300X Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6005195.84744 | 2100584.78774 | 37.7480997459068 | -122.42480058509899 | (37.7480997459068, -122.424800585099) | |||
17442 | 17442 | 25157 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2X Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004782.44605 | 2108032.94108 | 37.7685272607631 | -122.42676044975201 | (37.7685272607631, -122.426760449752) | |||
17487 | 17487 | 25100 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1350X Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 60 | 20 | 6005208.528519999 | 2100314.21379 | 37.7473575282405 | -122.424737488671 | (37.7473575282405, -122.424737488671) | |||
17518 | 17518 | 25033 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 700X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6004995.411590001 | 2104224.22732 | 37.7580814768833 | -122.425752691957 | (37.7580814768833, -122.425752691957) | |||
17523 | 17523 | 5503 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 773 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 5x5 | 6005056.9343 | 2103834.44184 | 37.757014693887704 | -122.42551217994301 | (37.7570146938877, -122.425512179943) | |||
17575 | 17575 | 24996 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 400X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004898.747380001 | 2105973.30508 | 37.7628785677218 | -122.42621152066002 | (37.7628785677218, -122.42621152066) | |||
17579 | 17579 | 27481 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 850X Dolores St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/04/1999 12:00:00 AM | 90 | 20 | 6005053.38343 | 2103172.36846 | 37.755196594762 | -122.425477343801 | (37.755196594762, -122.425477343801) | ||
17620 | 17620 | 25096 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1300X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005188.030230001 | 2100718.94336 | 37.748467664846295 | -122.42483715961001 | (37.7484676648463, -122.42483715961) | |||
17621 | 17621 | 25516 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2190X Market St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6003679.0354 | 2107225.3342 | 37.7662473210814 | -122.430519419203 | (37.7662473210814, -122.430519419203) | ||
17629 | 17629 | 25102 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1400X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005226.05485 | 2100086.94121 | 37.7467344797311 | -122.424660718923 | (37.7467344797311, -122.424660718923) | |||
17694 | 17694 | 25052 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 900X Dolores St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 20 | 6005070.62845 | 2102872.02457 | 37.7543728949014 | -122.42539633287 | (37.7543728949014, -122.42539633287) | |||
17722 | 17722 | 25061 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1000X Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005097.79962 | 2102345.06954 | 37.7529275341834 | -122.425264872687 | (37.7529275341834, -122.425264872687) | |||
17756 | 17756 | 25098 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1350X Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005207.855169999 | 2100363.5353099997 | 37.7474929157794 | -122.424743325238 | (37.7474929157794, -122.424743325238) | |||
17774 | 17774 | 25504 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1950X Market St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 8 | 6005007.7768 | 2108494.7101 | 37.769807904671005 | -122.42601392538499 | (37.769807904671, -122.426013925385) | ||
17792 | 17792 | 25085 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1200X Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6005165.443630001 | 2101134.8464599997 | 37.7496083631354 | -122.424944849843 | (37.7496083631354, -122.424944849843) | |||
17821 | 17821 | 25151 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2X Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004775.21348 | 2108066.2440299997 | 37.768618293721104 | -122.42678783858999 | (37.7686182937211, -122.42678783859) | |||
17847 | 17847 | 24989 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 370X Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 60 | 20 | 6004890.15326 | 2106095.93205 | 37.7632147864474 | -122.426249975677 | (37.7632147864474, -122.426249975677) | |||
17932 | 17932 | 24987 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 340X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 20 | 6004879.52665 | 2106321.34538 | 37.7638331171148 | -122.42630277934799 | (37.7638331171148, -122.426302779348) | |||
18053 | 18053 | 24998 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 450X Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004918.80727 | 2105618.72906 | 37.7619061199926 | -122.426116896691 | (37.7619061199926, -122.426116896691) | |||
18060 | 18060 | 25021 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 750X Dolores St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6005015.543430001 | 2103801.2681 | 37.7569212678239 | -122.425652964336 | (37.7569212678239, -122.425652964336) | |||
18061 | 18061 | 25129 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1650X Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 20 | 6005306.59795 | 2098578.64869 | 37.7425976010056 | -122.424274952941 | (37.7425976010056, -122.424274952941) | |||
18120 | 18120 | 25009 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 550X Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 50 | 20 | 6004942.008669999 | 2105066.11314 | 37.7603900788595 | -122.425997312043 | (37.7603900788595, -122.425997312043) | |||
18142 | 18142 | 13388 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 218 Marietta Dr | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 5 | 5997667.5215300005 | 2098758.8322 | 37.7426580336411 | -122.45070150968999 | (37.7426580336411, -122.45070150969) | |||
18179 | 18179 | 25015 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 550X Dolores St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004955.918219999 | 2104917.6837 | 37.7599833128008 | -122.42593863935 | (37.7599833128008, -122.42593863935) | |||
18199 | 18199 | 25532 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2300X Market St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6002592.5231 | 2106186.5128 | 37.7633333608706 | -122.43420318116999 | (37.7633333608706, -122.43420318117) | ||
18227 | 18227 | 25534 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2300X Market St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6002560.5766 | 2106158.8258 | 37.763255525853296 | -122.43431169398701 | (37.7632555258533, -122.434311693987) | ||
18230 | 18230 | 25073 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100X Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005132.2187 | 2101761.89405 | 37.7513282140435 | -122.42510435359199 | (37.7513282140435, -122.425104353592) | |||
18233 | 18233 | 25024 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 700X Dolores St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6005003.848780001 | 2104046.64903 | 37.757594365417496 | -122.42571087345699 | (37.7575943654175, -122.425710873457) | |||
18236 | 18236 | 25007 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 500X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004931.59557 | 2105384.6255099997 | 37.7612640499245 | -122.426056000898 | (37.7612640499245, -122.426056000898) | |||
18284 | 18284 | 25123 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1550 Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005274.82817 | 2099143.28527 | 37.744146170621704 | -122.424424956245 | (37.7441461706217, -122.424424956245) | |||
18337 | 18337 | 25498 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1745X Market St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 24 | 20 | 6005901.64349 | 2109360.28288 | 37.7722350378549 | -122.422983588528 | (37.7722350378549, -122.422983588528) | ||
18340 | 18340 | 25152 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 50X Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004796.34623 | 2107853.39536 | 37.768035057311 | -122.42669958273999 | (37.768035057311, -122.42669958274) | |||
18432 | 18432 | 25070 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 20 | 6005125.726319999 | 2101888.99536 | 37.751676838028395 | -122.425135847862 | (37.7516768380284, -122.425135847862) | |||
18461 | 18461 | 24339 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2020X Market St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/07/1993 12:00:00 AM | 36 | 8 | 6004378.3201 | 2107887.5635 | 37.7681052320451 | -122.42814792550399 | (37.7681052320451, -122.428147925504) | ||
18527 | 18527 | 25047 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 900X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005062.19129 | 2103039.48532 | 37.754832226347396 | -122.425437427413 | (37.7548322263474, -122.425437427413) | |||
18585 | 18585 | 25121 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1500 Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 20 | 6005252.19486 | 2099522.95164 | 37.745187369700105 | -122.424530218294 | (37.7451873697001, -122.424530218294) | |||
18700 | 18700 | 25031 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 700X Dolores St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 20 | 6005006.55303 | 2104135.2293700003 | 37.7578377390251 | -122.425707825673 | (37.7578377390251, -122.425707825673) | |||
18703 | 18703 | 24975 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 200 Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004832.79825 | 2107115.15692 | 37.76601009251021 | -122.426520926121 | (37.7660100925102, -122.426520926121) | |||
18754 | 18754 | 25528 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2300X Market St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6002714.6296 | 2106302.2301 | 37.7636580221412 | -122.433789126424 | (37.7636580221412, -122.433789126424) | ||
18853 | 18853 | 24967 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 150 Dolores St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004824.658890001 | 2107297.38564 | 37.7665099887808 | -122.42656205570499 | (37.7665099887808, -122.426562055705) | |||
18866 | 18866 | 25038 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 800X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005033.4036 | 2103578.1948599997 | 37.756309770193 | -122.425575321353 | (37.756309770193, -122.425575321353) | |||
18925 | 18925 | 25041 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 800X Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005036.0793699995 | 2103453.27666 | 37.7559669252599 | -122.42555717752899 | (37.7559669252599, -122.425557177529) | |||
18928 | 18928 | 25116 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1500X Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005256.05434 | 2099495.31423 | 37.7451117016422 | -122.42451490734301 | (37.7451117016422, -122.424514907343) | |||
18948 | 18948 | 25002 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 400X Dolores St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6004897.79092 | 2105856.39656 | 37.7625575106521 | -122.42620650513001 | (37.7625575106521, -122.42620650513) | |||
19013 | 19013 | 25540 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2200X Market St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 20 | 6003208.8276 | 2106774.142 | 37.7649818088085 | -122.43211355317601 | (37.7649818088085, -122.432113553176) | ||
19053 | 19053 | 25122 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1550 Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005275.20405 | 2099188.4733700003 | 37.7442702680707 | -122.42442687003 | (37.7442702680707, -122.42442687003) | |||
19066 | 19066 | 25040 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 800X Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005037.4743800005 | 2103495.5655400003 | 37.7560831194465 | -122.42555536268499 | (37.7560831194465, -122.425555362685) | |||
19082 | 19082 | 25127 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1650X Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 20 | 6005306.7238300005 | 2098611.50649 | 37.7426878281697 | -122.424276854096 | (37.7426878281697, -122.424276854096) | |||
19160 | 19160 | 25028 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 700X Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/23/1997 12:00:00 AM | 70 | 20 | 6005001.93677 | 2104182.12883 | 37.75796625306 | -122.425727128704 | (37.75796625306, -122.425727128704) | ||
19185 | 19185 | 25013 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 550X Dolores St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004948.9055699995 | 2104970.0682099997 | 37.7601267519689 | -122.425966621772 | (37.7601267519689, -122.425966621772) | |||
19235 | 19235 | 24988 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 370X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 20 | 6004888.10333 | 2106135.4070099997 | 37.7633230594236 | -122.426259876316 | (37.7633230594236, -122.426259876316) | |||
19258 | 19258 | 25140 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1750X Dolores St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005337.960390001 | 2097982.3892099997 | 37.74096217846979 | -122.424124115947 | (37.7409621784698, -122.424124115947) | |||
19284 | 19284 | 25135 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005318.690690001 | 2098391.09531 | 37.742083304809206 | -122.424219803815 | (37.7420833048092, -122.424219803815) | |||
19325 | 19325 | 25154 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 50X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004786.45589 | 2107937.0696900003 | 37.7682642477152 | -122.42673975183901 | (37.7682642477152, -122.426739751839) | |||
19333 | 19333 | 24968 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 Dolores St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004810.58196 | 2107534.1310400004 | 37.767159239034704 | -122.426627605497 | (37.7671592390347, -122.426627605497) | |||
19334 | 19334 | 24962 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/21/2005 12:00:00 AM | 30 | 20 | 6004805.8872 | 2107667.07109 | 37.76752399506629 | -122.42665331171999 | (37.7675239950663, -122.42665331172) | ||
19402 | 19402 | 25141 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1750X Dolores St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6005346.329580001 | 2097965.45382 | 37.740916150253604 | -122.424093974258 | (37.7409161502536, -122.424093974258) | |||
19415 | 19415 | 25531 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2300X Market St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6002640.0878 | 2106231.2379 | 37.763458864653295 | -122.434041867896 | (37.7634588646533, -122.434041867896) | ||
19480 | 19480 | 25039 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 800X Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005035.06937 | 2103531.66337 | 37.756182099743 | -122.42556624900801 | (37.756182099743, -122.425566249008) | |||
19492 | 19492 | 25148 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 20 | 6004781.85822 | 2108123.31219 | 37.7687753648286 | -122.426768919571 | (37.7687753648286, -122.426768919571) | |||
19585 | 19585 | 24338 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2020X Market St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/07/1993 12:00:00 AM | 36 | 8 | 6004443.4589 | 2107950.1478 | 37.76828075872071 | -122.42792707731 | (37.7682807587207, -122.42792707731) | ||
19587 | 19587 | 25088 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1250X Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005178.85274 | 2100929.77786 | 37.7490460494561 | -122.424883892899 | (37.7490460494561, -122.424883892899) | |||
19629 | 19629 | 25032 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 750X Dolores St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6005021.65336 | 2103769.84125 | 37.756835322312604 | -122.42562959723 | (37.7568353223126, -122.42562959723) | |||
19687 | 19687 | 25091 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1350 Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 20 | 6005204.68058 | 2100428.03656 | 37.7476698420965 | -122.42475889070299 | (37.7476698420965, -122.424758890703) | |||
19826 | 19826 | 24965 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 Dolores St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004804.04595 | 2107595.6918 | 37.767327900586 | -122.42665459683799 | (37.767327900586, -122.426654596838) | |||
19857 | 19857 | 5683 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1488 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/08/1997 12:00:00 AM | 12 | 6 | 6005201.38668 | 2099720.6305299997 | 37.745727281286705 | -122.42471996446301 | (37.7457272812867, -122.424719964463) | ||
19946 | 19946 | 25514 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2100X Market St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6004037.0875 | 2107573.3112 | 37.7672230586461 | -122.429305801661 | (37.7672230586461, -122.429305801661) | ||
19960 | 19960 | 25156 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 50X Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004792.45266 | 2107880.8578 | 37.768110242434204 | -122.426715006093 | (37.7681102424342, -122.426715006093) | |||
19964 | 19964 | 703 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1375X Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6005257.21277 | 2100319.77841 | 37.747375556949 | -122.424569537574 | (37.747375556949, -122.424569537574) | |||
19989 | 19989 | 25018 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 750X Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6005012.95019 | 2103889.3731400003 | 37.757163037054 | -122.42566820334 | (37.757163037054, -122.42566820334) | |||
20060 | 20060 | 25500 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1745X Market St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 24 | 20 | 6005964.12554 | 2109421.56816 | 37.7724068380339 | -122.422771813485 | (37.7724068380339, -122.422771813485) | ||
20149 | 20149 | 25149 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20x10 | 6004775.29887 | 2108114.09165 | 37.768749676587205 | -122.42679095116002 | (37.7687496765872, -122.42679095116) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");