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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
164859 | 164859 | 246278 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2023 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6006844.3209 | 2106561.2147 | 37.7646026065706 | -122.419524157759 | (37.7646026065706, -122.419524157759) | |||
174544 | 174544 | 246364 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1940 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6006759.3529 | 2107084.7818 | 37.766035412442704 | -122.419855194529 | (37.7660354124427, -122.419855194529) | |||
186670 | 186670 | 217476 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2 Castenada Ave | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5994389.54518 | 2101808.84982 | 37.7508444327326 | -122.46225687706101 | (37.7508444327326, -122.462256877061) | |||
38378 | 38378 | 203183 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1900 03rd St | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6015658.44629 | 2106386.7571400004 | 37.7646161091615 | -122.38902601186001 | (37.7646161091615, -122.38902601186) | |||
40464 | 40464 | 199494 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 281 06th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6010924.085580001 | 2111634.58421 | 37.7787618676114 | -122.405770660782 | (37.7787618676114, -122.405770660782) | |||
42499 | 42499 | 246350 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1917 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6006813.4383 | 2107178.9472 | 37.7662970152725 | -122.419674805523 | (37.7662970152725, -122.419674805523) | |||
47352 | 47352 | 203175 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2338 Lane St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6013915.08418 | 2092868.40903 | 37.7274007851107 | -122.394109422506 | (37.7274007851107, -122.394109422506) | ||||
52123 | 52123 | 244847 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 90 Bartlett St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 8ft | 6006653.79898 | 2103383.59728 | 37.7558668756582 | -122.41995761356002 | (37.7558668756582, -122.41995761356) | |||
61712 | 61712 | 203182 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1900 03rd St | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6015656.28581 | 2106435.78787 | 37.7647506171774 | -122.38903690803998 | (37.7647506171774, -122.38903690804) | |||
64107 | 64107 | 244844 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 90 Bartlett St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 6ft | 6006630.92083 | 2103720.4372 | 37.7567904713264 | -122.420060637198 | (37.7567904713264, -122.420060637198) | |||
76881 | 76881 | 243925 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 33 Bartlett St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 6ft | 6006679.07286 | 2103590.73607 | 37.7564370548525 | -122.41988490606501 | (37.7564370548525, -122.419884906065) | |||
77716 | 77716 | 93966 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 3050X Mission St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/2010 12:00:00 AM | 10 | 3x3 | Permit Number 53400 | 6007118.1 | 2100723.5 | 37.7485890022613 | -122.418163321976 | (37.7485890022613, -122.418163321976) | |
97023 | 97023 | 93963 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 3050X Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | Permit Number 53400 | 6007118.1 | 2100723.5 | 37.7485890022613 | -122.418163321976 | (37.7485890022613, -122.418163321976) | ||
114071 | 114071 | 93964 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 3050X Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | Permit Number 53400 | 6007118.1 | 2100723.5 | 37.7485890022613 | -122.418163321976 | (37.7485890022613, -122.418163321976) | ||
114278 | 114278 | 93962 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 3050X Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | Permit Number 53400 | 6007118.1 | 2100723.5 | 37.7485890022613 | -122.418163321976 | (37.7485890022613, -122.418163321976) | ||
122080 | 122080 | 93965 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 3050X Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | Permit Number 53400 | 6007118.1 | 2100723.5 | 37.7485890022613 | -122.418163321976 | (37.7485890022613, -122.418163321976) | ||
128018 | 128018 | 93967 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 3050X Mission St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | Permit Number 53400 | 6007118.1 | 2100723.5 | 37.7485890022613 | -122.418163321976 | (37.7485890022613, -122.418163321976) | ||
133886 | 133886 | 244536 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2998 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6006910.4744 | 2106757.6793 | 37.765145778241504 | -122.419309288071 | (37.7651457782415, -122.419309288071) | |||
134129 | 134129 | 244845 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 90 Bartlett St | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 8ft | 6006641.10837 | 2103579.2022 | 37.756403246631606 | -122.42001538241999 | (37.7564032466316, -122.42001538242) | |||
135845 | 135845 | 243924 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 33 Bartlett St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 6ft | 6006678.4863599995 | 2103600.0339099998 | 37.7564625515326 | -122.419887594147 | (37.7564625515326, -122.419887594147) | |||
143894 | 143894 | 104927 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 810 Gonzalez Dr | 2 | Median : Yard 3 | Tree 1 | Private 1 | 10 | 5990385.0 | 2090588.0 | 37.7198034465129 | -122.47528570222 | (37.7198034465129, -122.47528570222) | ||||
148131 | 148131 | 244812 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 199 29th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6005383.33309 | 2099017.5847400003 | 37.743807152283296 | -122.42404083244499 | (37.7438071522833, -122.424040832445) | |||
149340 | 149340 | 203180 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1800 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6015618.5764 | 2107110.17004 | 37.7666002339304 | -122.38921442971399 | (37.7666002339304, -122.389214429714) | |||
156217 | 156217 | 181280 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 333 Peru Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 4ft | 6004524.91871 | 2092988.1896099998 | 37.727203289497794 | -122.42657977773999 | (37.7272032894978, -122.42657977774) | |||
156498 | 156498 | 245978 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2889 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6007119.1949 | 2101563.056 | 37.7508942943071 | -122.418219050821 | (37.7508942943071, -122.418219050821) | |||
159285 | 159285 | 245977 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2853 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6007107.4417 | 2101754.52 | 37.751419349330895 | -122.418273268019 | (37.7514193493309, -122.418273268019) | |||
162589 | 162589 | 246365 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1940 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6006762.2381 | 2106995.3403 | 37.7657899896764 | -122.41983886795 | (37.7657899896764, -122.41983886795) | |||
168088 | 168088 | 244811 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 199 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6005366.54273 | 2099017.13442 | 37.743804967825206 | -122.424098857596 | (37.7438049678252, -122.424098857596) | |||
177566 | 177566 | 203179 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1800 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6015617.1468 | 2107140.95711 | 37.7666846892774 | -122.38922152448099 | (37.7666846892774, -122.389221524481) | |||
334 | 334 | 246360 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1932 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6006755.8259 | 2107130.7038 | 37.76616130474321 | -122.419870652653 | (37.7661613047432, -122.419870652653) | |||
1518 | 1518 | 243948 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 10 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2004 12:00:00 AM | 11 | Width 5ft | Permit Number 47529 | 6006987.09759 | 2110205.04369 | 37.774615739356705 | -122.41928883630399 | (37.7746157393567, -122.419288836304) | |
25234 | 25234 | 244842 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 41 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 6ft | 6006681.50629 | 2103383.71332 | 37.755868755243704 | -122.419861800707 | (37.7558687552437, -122.419861800707) | |||
28387 | 28387 | 199462 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1530 03rd St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6015592.103080001 | 2107492.64638 | 37.7676489630463 | -122.389332708559 | (37.7676489630463, -122.389332708559) | |||
36738 | 36738 | 181277 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 0 Gonzalez Dr | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | 5988402.74919 | 2089827.8491900002 | 37.7176011677477 | -122.482081905481 | (37.7176011677477, -122.482081905481) | ||||
44790 | 44790 | 244846 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 90 Bartlett St | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 8ft | 6006641.954969999 | 2103569.5656 | 37.75637683445171 | -122.42001177073901 | (37.7563768344517, -122.420011770739) | |||
48660 | 48660 | 243926 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 41 Bartlett St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 6ft | 6006689.91006 | 2103386.78803 | 37.7558776711221 | -122.41983295584299 | (37.7558776711221, -122.419832955843) | |||
52430 | 52430 | 217461 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1x Minerva St | 41 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 0ft | 5996430.050430001 | 2088999.1612900002 | 37.7157894025409 | -122.454275506331 | (37.7157894025409, -122.454275506331) | |||
59728 | 59728 | 244843 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 90 Bartlett St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 9ft | 6006632.98295 | 2103729.04135 | 37.7568142125173 | -122.4200541162 | (37.7568142125173, -122.4200541162) | |||
60927 | 60927 | 243928 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 183 29th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6005387.06281 | 2099017.63808 | 37.7438075093185 | -122.424027939731 | (37.7438075093185, -122.424027939731) | |||
62394 | 62394 | 243927 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 183 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6005367.86151 | 2099016.78698 | 37.7438040882932 | -122.424094272857 | (37.7438040882932, -122.424094272857) | |||
129506 | 129506 | 246377 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1984 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6006769.0905 | 2106843.1456 | 37.7653724848572 | -122.419804366614 | (37.7653724848572, -122.419804366614) | |||
130520 | 130520 | 181272 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 4061 19th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 4ft | 5991602.94551 | 2088924.16966 | 37.7153054953149 | -122.47095459108299 | (37.7153054953149, -122.470954591083) | |||
153721 | 153721 | 203181 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1900 03rd St | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6015653.76081 | 2106475.1848299997 | 37.7648586527362 | -122.389048392363 | (37.7648586527362, -122.389048392363) | |||
156730 | 156730 | 181275 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 0 Gonzalez Dr | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | 5988424.04089 | 2089826.4329400002 | 37.7175985174299 | -122.482008206935 | (37.7175985174299, -122.482008206935) | ||||
168519 | 168519 | 181276 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 0 Gonzalez Dr | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | 5988413.87941 | 2089827.13064 | 37.7175998421416 | -122.482043381217 | (37.7175998421416, -122.482043381217) | ||||
189056 | 189056 | 246366 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1940 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6006763.6807 | 2106952.0622 | 37.7656712394659 | -122.419830807079 | (37.7656712394659, -122.419830807079) | |||
602 | 602 | 15498 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2704 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6007015.1629 | 2102569.9783 | 37.7536532168709 | -122.41865020170799 | (37.7536532168709, -122.418650201708) | |||
1519 | 1519 | 243949 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 10 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2004 12:00:00 AM | 12 | Width 5ft | Permit Number 47529 | 6006997.017419999 | 2110160.92453 | 37.7744951573695 | -122.41925139124399 | (37.7744951573695, -122.419251391244) | |
3732 | 3732 | 15513 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2763 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6007075.5942 | 2102308.8178 | 37.7529395319689 | -122.41842269980101 | (37.7529395319689, -122.418422699801) | |||
10322 | 10322 | 15786 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 4840 Mission St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/04/2013 12:00:00 AM | 12 | 3x3 | 6001077.7653 | 2090502.844 | 37.7201836118857 | -122.43831855702 | (37.7201836118857, -122.43831855702) | ||
10427 | 10427 | 28552 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4839 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3x3 | 6001308.3124 | 2090760.3284 | 37.7209037164668 | -122.437540063841 | (37.7209037164668, -122.437540063841) | ||
10432 | 10432 | 28549 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4963 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3x3 | 6000879.9631 | 2090072.8632 | 37.71899172902071 | -122.438971492831 | (37.7189917290207, -122.438971492831) | ||
10435 | 10435 | 28548 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 5095 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3x3 | 6000516.105 | 2089501.9034 | 37.7174032930481 | -122.440188283496 | (37.7174032930481, -122.440188283496) | ||
10446 | 10446 | 1841 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2200 Bay Shore Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6011283.06964 | 2087344.7309400002 | 37.712087250691 | -122.40282003911301 | (37.712087250691, -122.402820039113) | |||
10447 | 10447 | 28554 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4753 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3x3 | 6001590.7646 | 2091209.3547 | 37.722152696500004 | -122.436595837081 | (37.7221526965, -122.436595837081) | ||
10497 | 10497 | 28546 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 5125 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3x3 | 6000380.5163 | 2089281.6434 | 37.716790788359795 | -122.440641159733 | (37.7167907883598, -122.440641159733) | ||
10560 | 10560 | 95252 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 4539 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6002365.436000001 | 2092436.2557 | 37.7255654834992 | -122.434005647145 | (37.7255654834992, -122.434005647145) | |||
10709 | 10709 | 28542 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 5036 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6000555.9648 | 2089678.6918 | 37.7178909833984 | -122.44006317666401 | (37.7178909833984, -122.440063176664) | ||
10723 | 10723 | 1798 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000 Bay Shore Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/27/1991 12:00:00 AM | 12 | 6 | 6012206.26499 | 2088043.30695 | 37.714056906280604 | -122.39967820720899 | (37.7140569062806, -122.399678207209) | ||
10771 | 10771 | 28544 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 5060 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6000449.8979 | 2089508.0094 | 37.7174162891529 | -122.440417567822 | (37.7174162891529, -122.440417567822) | ||
10773 | 10773 | 28540 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4754 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6001487.6438 | 2091153.5571 | 37.7219936282262 | -122.43694830738701 | (37.7219936282262, -122.436948307387) | ||
11001 | 11001 | 15823 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 5051 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/08/2003 12:00:00 AM | 12 | 3x3 | 6000607.6416 | 2089644.9294 | 37.717801221251 | -122.439882133799 | (37.717801221251, -122.439882133799) | ||
11110 | 11110 | 28537 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4716 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6001661.0091 | 2091431.1044 | 37.7227655627881 | -122.436368881923 | (37.7227655627881, -122.436368881923) | ||
11123 | 11123 | 28555 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4743 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6001652.2787 | 2091307.3716 | 37.722425324335 | -122.436390209739 | (37.722425324335, -122.436390209739) | ||
11137 | 11137 | 28558 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4667 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6001923.346 | 2091737.9699 | 37.723623049111296 | -122.435483982262 | (37.7236230491113, -122.435483982262) | ||
11170 | 11170 | 1796 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000 Bay Shore Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6012245.53967 | 2088092.97358 | 37.714195470207 | -122.39954594300899 | (37.714195470207, -122.399545943009) | |||
11198 | 11198 | 28556 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4717 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6001738.1279 | 2091443.2433 | 37.7228032751332 | -122.436103167424 | (37.7228032751332, -122.436103167424) | ||
11400 | 11400 | 1858 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2500 Bay Shore Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6010736.7682300005 | 2086529.19155 | 37.709817424799 | -122.404650849269 | (37.709817424799, -122.404650849269) | |||
11469 | 11469 | 28551 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4885 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6001150.501 | 2090506.6381 | 37.720198166433896 | -122.438067406183 | (37.7201981664339, -122.438067406183) | ||
11567 | 11567 | 1857 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2500 Bay Shore Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6010751.52595 | 2086559.13987 | 37.7099004816803 | -122.404601950438 | (37.7099004816803, -122.404601950438) | |||
11630 | 11630 | 1793 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000 Bay Shore Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6012296.32723 | 2088174.84774 | 37.7144231111167 | -122.399376144697 | (37.7144231111167, -122.399376144697) | |||
11710 | 11710 | 1795 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000 Bay Shore Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6012264.68095 | 2088118.8470599998 | 37.714267580549105 | -122.399481598293 | (37.7142675805491, -122.399481598293) | |||
11802 | 11802 | 28539 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4734 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3x3 | 6001578.802999999 | 2091300.8769999999 | 37.7224033163499 | -122.436643733228 | (37.7224033163499, -122.436643733228) | ||
11934 | 11934 | 1822 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2100 Bay Shore Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6011791.38112 | 2087549.257 | 37.7126772077525 | -122.401077519005 | (37.7126772077525, -122.401077519005) | |||
11995 | 11995 | 15738 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4516 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/18/1997 12:00:00 AM | 12 | 3X3 | 6002290.9845 | 2092433.856 | 37.725554668943204 | -122.434262847922 | (37.7255546689432, -122.434262847922) | ||
12072 | 12072 | 28800 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4505 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002480.3523 | 2092620.1218 | 37.7260768594239 | -122.433621526187 | (37.7260768594239, -122.433621526187) | |||
12292 | 12292 | 1840 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2200 Bay Shore Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6011305.78262 | 2087356.70002 | 37.7121213835762 | -122.40274237725401 | (37.7121213835762, -122.402742377254) | |||
12396 | 12396 | 15742 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4534 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/1999 12:00:00 AM | 12 | 3X3 | 6002267.3808 | 2092395.6017 | 37.725448291506204 | -122.43434171007601 | (37.7254482915062, -122.434341710076) | ||
12407 | 12407 | 28550 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4919 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6001014.7517 | 2090296.9851 | 37.7196147854688 | -122.438521631633 | (37.7196147854688, -122.438521631633) | ||
12846 | 12846 | 15741 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4531 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/2000 12:00:00 AM | 12 | 3x3 | 6002397.2069 | 2092488.3059999999 | 37.7257102048968 | -122.433899536724 | (37.7257102048968, -122.433899536724) | ||
12880 | 12880 | 28799 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4575 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002251.5336 | 2092256.7834 | 37.7250662282166 | -122.434386571875 | (37.7250662282166, -122.434386571875) | |||
13033 | 13033 | 15743 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4545 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/2001 12:00:00 AM | 12 | 3x3 | 6002337.7208 | 2092395.6969 | 37.7254525452522 | -122.434098558087 | (37.7254525452522, -122.434098558087) | ||
13119 | 13119 | 28560 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4631 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3x3 | 6002010.8853 | 2091868.7717 | 37.7239871728 | -122.43519072585501 | (37.7239871728, -122.435190725855) | ||
13149 | 13149 | 28547 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 5109 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3x3 | 6000411.4099 | 2089335.4212 | 37.7169402093066 | -122.44053823097799 | (37.7169402093066, -122.440538230978) | ||
13232 | 13232 | 1794 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000 Bay Shore Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6012280.2141 | 2088145.3083400002 | 37.7143411037303 | -122.399429765893 | (37.7143411037303, -122.399429765893) | |||
17051 | 17051 | 15346 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1900 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6006752.3955 | 2107277.3553 | 37.766563781951106 | -122.419892925221 | (37.7665637819511, -122.419892925221) | |||
17153 | 17153 | 15563 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2868 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6007056.0095 | 2101612.1167 | 37.751025447038 | -122.418441030738 | (37.751025447038, -122.418441030738) | |||
17338 | 17338 | 15450 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2301 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/10/1992 12:00:00 AM | 12 | 4x4 | 6006934.5554 | 2104894.5299 | 37.760031361018 | -122.41909383171001 | (37.760031361018, -122.41909383171) | ||
17343 | 17343 | 15535 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2800 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6007034.0945 | 2101996.1061 | 37.752078560740706 | -122.41854404117599 | (37.7520785607407, -122.418544041176) | |||
17359 | 17359 | 15544 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2831 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6007105.1669 | 2101841.7215 | 37.7516586567519 | -122.418287316619 | (37.7516586567519, -122.418287316619) | |||
17363 | 17363 | 15360 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1939 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6006819.3103 | 2107093.8027 | 37.7660635592898 | -122.41964845362699 | (37.7660635592898, -122.419648453627) | |||
17451 | 17451 | 28453 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2070X Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/2003 12:00:00 AM | 12 | 3x3 | 5993250.12022 | 2093006.3093700001 | 37.7266091892515 | -122.465557664158 | (37.7266091892515, -122.465557664158) | ||
17504 | 17504 | 15470 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2467 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/1992 12:00:00 AM | 12 | 4X4 | 6006982.3266 | 2104010.3832 | 37.757606388854605 | -122.418865906959 | (37.7576063888546, -122.418865906959) | ||
17576 | 17576 | 15453 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2365 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/10/1992 12:00:00 AM | 12 | 4X4 | 6006954.2705 | 2104542.6911 | 37.7590664034557 | -122.41900069111901 | (37.7590664034557, -122.419000691119) | ||
17614 | 17614 | 15444 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2243 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/10/1992 12:00:00 AM | 12 | 4X4 | 6006909.5324 | 2105286.5572 | 37.7611063676926 | -122.41920818332599 | (37.7611063676926, -122.419208183326) | ||
17721 | 17721 | 15387 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000X Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6006779.91 | 2106630.7221 | 37.764789829335896 | -122.41975187054399 | (37.7647898293359, -122.419751870544) | |||
17732 | 17732 | 15383 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1999X Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6006833.6968 | 2106798.1459999997 | 37.7652525658811 | -122.419577715012 | (37.7652525658811, -122.419577715012) | |||
17740 | 17740 | 15386 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000X Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6006780.6313 | 2106653.0825 | 37.7648512663771 | -122.41975096246 | (37.7648512663771, -122.41975096246) | |||
17751 | 17751 | 15573 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2899 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6007123.7446 | 2101516.8013 | 37.7507675455055 | -122.41820003848999 | (37.7507675455055, -122.41820003849) | |||
17764 | 17764 | 25281 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1970 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 5993695.8734 | 2092795.8439 | 37.726057002173796 | -122.464001452223 | (37.7260570021738, -122.464001452223) |
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");