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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21082 | 21082 | 28787 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2518 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2X2 | 6006949.0139999995 | 2103676.1713 | 37.7566868442816 | -122.418957411892 | (37.7566868442816, -122.418957411892) | |||
21091 | 21091 | 15502 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2712 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6007019.0925 | 2102444.8849 | 37.7533099602486 | -122.41862774204901 | (37.7533099602486, -122.418627742049) | |||
21136 | 21136 | 15424 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2101 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6006867.8273 | 2106045.5888 | 37.763188142588604 | -122.419406272714 | (37.7631881425886, -122.419406272714) | |||
21146 | 21146 | 15506 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2738 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/2006 12:00:00 AM | 3 | 3x3 | 6007021.0573 | 2102399.0391 | 37.753184188782 | -122.41861769652 | (37.753184188782, -122.41861769652) | ||
21205 | 21205 | 15439 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2162 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/1992 12:00:00 AM | 18 | 4X4 | 6006823.9061 | 2105762.5248 | 37.7624084411332 | -122.41953809802901 | (37.7624084411332, -122.419538098029) | ||
21244 | 21244 | 15551 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2839 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6007105.1669 | 2101800.0164 | 37.751544144042 | -122.418284359977 | (37.751544144042, -122.418284359977) | |||
21397 | 21397 | 25282 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1970 Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 5993611.6506 | 2092838.2672 | 37.726168631945704 | -122.464295681605 | (37.7261686319457, -122.464295681605) | |||
21541 | 21541 | 15552 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2846 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6007045.846 | 2101751.2294 | 37.751406846694 | -122.418486040429 | (37.751406846694, -122.418486040429) | |||
21610 | 21610 | 15437 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2148 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/1992 12:00:00 AM | 18 | 4X4 | 6006821.0239 | 2105826.6543 | 37.762584363416295 | -122.419552616574 | (37.7625843634163, -122.419552616574) | ||
21745 | 21745 | 15549 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2840 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6007044.5756 | 2101802.0469 | 37.7515463084579 | -122.41849403667 | (37.7515463084579, -122.41849403667) | |||
22032 | 22032 | 24579 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2862 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6007054.1039 | 2101659.758 | 37.751156151932996 | -122.41845099825599 | (37.751156151933, -122.418450998256) | |||
22135 | 22135 | 15500 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2710 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6007019.0925 | 2102497.935 | 37.7534556236904 | -122.41863150374701 | (37.7534556236904, -122.418631503747) | |||
22272 | 22272 | 26854 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1850 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/2004 12:00:00 AM | 3 | 3X3 | 6006727.5247 | 2107586.953 | 37.76741246299579 | -122.42000092176201 | (37.7674124629958, -122.420000921762) | ||
23162 | 23162 | 251173 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 367 Jersey St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | Width 3ft | 6002770.52649 | 2101500.0126900002 | 37.7504754543841 | -122.43325263672399 | (37.7504754543841, -122.433252636724) | ||||
23492 | 23492 | 202174 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 100 Kalmanovitz St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 2ft | 6013138.83373 | 2093054.0318599998 | 37.7278672922301 | -122.39680594795401 | (37.7278672922301, -122.396805947954) | |||
23753 | 23753 | 199483 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1300 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6015509.13182 | 2108964.41049 | 37.7716855044225 | -122.38972250619801 | (37.7716855044225, -122.389722506198) | |||
23814 | 23814 | 247646 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 900 Duboce Ave | 2 | : 4 | Tree 1 | Private 1 | 13 | Width 5ft | 6001616.30949 | 2108303.20625 | 37.769089824469496 | -122.43773118404499 | (37.7690898244695, -122.437731184045) | |||
23991 | 23991 | 246367 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1999 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6006824.8887 | 2106890.3369 | 37.7655052042839 | -122.41961472171002 | (37.7655052042839, -122.41961472171) | |||
24106 | 24106 | 246790 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 175 Brewster St | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6010136.6415 | 2098750.10917 | 37.74333994367979 | -122.40758608083901 | (37.7433399436798, -122.407586080839) | ||||
24537 | 24537 | 217484 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 554 Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 5997767.10933 | 2095284.1068799999 | 37.7331229743458 | -122.450106772723 | (37.7331229743458, -122.450106772723) | ||||
24682 | 24682 | 203198 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 91 Market St | 8 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 15 | Width 10ft | 6013828.57328 | 2116873.69458 | 37.7933092533841 | -122.39609008760401 | (37.7933092533841, -122.396090087604) | |||
24710 | 24710 | 38696 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 442 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1998 12:00:00 AM | 8 | Permit Number 40608 | 6000200.5427 | 2110464.1107 | 37.7749425203696 | -122.442783410713 | (37.7749425203696, -122.442783410713) | |
24790 | 24790 | 199437 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 189 Hubbell St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 6013340.81155 | 2107445.60575 | 37.7673947300992 | -122.397116397514 | (37.7673947300992, -122.397116397514) | |||
25192 | 25192 | 203195 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1998 Revere Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6012994.723999999 | 2096005.499 | 37.735963390387 | -122.39751105148999 | (37.735963390387, -122.39751105149) | ||||
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) | |||
25274 | 25274 | 203174 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 331 Pennsylvania Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 7ft | 6014370.72377 | 2105559.7788 | 37.7622739427176 | -122.39342205628999 | (37.7622739427176, -122.39342205629) | |||
25608 | 25608 | 246285 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2109 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6006870.1021 | 2106021.3241 | 37.763121645518204 | -122.419396683437 | (37.7631216455182, -122.419396683437) | |||
26802 | 26802 | 243938 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 315 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6003592.012490001 | 2106424.54324 | 37.764043612453996 | -122.43076326292 | (37.764043612454, -122.43076326292) | |||
27009 | 27009 | 199444 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1515 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 5ft | 6015656.62698 | 2107992.23345 | 37.769024297155205 | -122.389144413879 | (37.7690242971552, -122.389144413879) | |||
27058 | 27058 | 247653 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 900 Duboce Ave | 9 | : 4 | Tree 1 | Private 1 | 15 | Width 5ft | 6001528.81511 | 2108296.30035 | 37.7690658872209 | -122.438033326596 | (37.7690658872209, -122.438033326596) | |||
27240 | 27240 | 73535 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2207 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 18 | 5987582.0279 | 2100272.2966 | 37.7462311393003 | -122.485684839892 | (37.7462311393003, -122.485684839892) | ||
27436 | 27436 | 244863 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 117 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6006906.41702 | 2098789.62543 | 37.7432671013094 | -122.418758192246 | (37.7432671013094, -122.418758192246) | |||
27544 | 27544 | 217486 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 134 Flood Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 27 | Width 10ft | 5999850.54516 | 2094099.6824900003 | 37.729989823555705 | -122.442818779256 | (37.7299898235557, -122.442818779256) | |||
27658 | 27658 | 246312 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1601 Mission St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6007098.251 | 2109393.5574 | 37.7723938509682 | -122.418846769596 | (37.7723938509682, -122.418846769596) | |||
27968 | 27968 | 199441 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 189 Hubbell St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6013426.97714 | 2107527.99953 | 37.767625761459705 | -122.39682413764 | (37.7676257614597, -122.39682413764) | |||
28011 | 28011 | 124342 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 105 Palm Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 4ft | 5995870.42219 | 2113701.84259 | 37.7835846686773 | -122.457996486135 | (37.7835846686773, -122.457996486135) | |||
28270 | 28270 | 217447 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 395 Faxon Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 2ft | 5994720.00419 | 2091109.04775 | 37.721484434931796 | -122.460338956771 | (37.7214844349318, -122.460338956771) | |||
28377 | 28377 | 48685 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 100 Palm Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2002 12:00:00 AM | 22 | Permit Number 45967 | 5995923.78548 | 2113769.63655 | 37.7837738786202 | -122.45781677815 | (37.7837738786202, -122.45781677815) | ||
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) | |||
28662 | 28662 | 247652 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 900 Duboce Ave | 8 | : 4 | Tree 1 | Private 1 | 14 | Width 5ft | 6001539.54665 | 2108297.82153 | 37.7690706742937 | -122.437996315894 | (37.7690706742937, -122.437996315894) | |||
29445 | 29445 | 124343 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 105 Palm Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 5995870.59128 | 2113726.09219 | 37.7836512613147 | -122.457997656644 | (37.7836512613147, -122.457997656644) | |||
29817 | 29817 | 245984 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2755 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6007074.8359 | 2102333.0826 | 37.7530061148801 | -122.418427042538 | (37.7530061148801, -122.418427042538) | |||
30281 | 30281 | 181242 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 80 Blanken Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 4ft | 6011652.37664 | 2087363.09382 | 37.7121582854612 | -122.40154488951099 | (37.7121582854612, -122.401544889511) | |||
30691 | 30691 | 244835 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1880 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6006729.90929 | 2107524.20157 | 37.7672402967355 | -122.41998822018101 | (37.7672402967355, -122.419988220181) | |||
31002 | 31002 | 203209 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 189 Hubbell St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6013274.2221800005 | 2107384.36901 | 37.767222880462796 | -122.39734242771401 | (37.7672228804628, -122.397342427714) | |||
31642 | 31642 | 217485 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 616 Joost Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 10ft | 5998040.52965 | 2095018.98025 | 37.7324106420337 | -122.449142396404 | (37.7324106420337, -122.449142396404) | |||
31746 | 31746 | 243915 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 527 Peralta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 6009846.89705 | 2099022.9743 | 37.744072948723996 | -122.408607191783 | (37.744072948724, -122.408607191783) | |||
31881 | 31881 | 199455 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1401 03rd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 5ft | 6015625.9056 | 2108540.0716 | 37.7705268376657 | -122.389288938555 | (37.7705268376657, -122.389288938555) | |||
32638 | 32638 | 199456 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1279 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6015610.82208 | 2108808.9255 | 37.77126421521471 | -122.38935989056299 | (37.7712642152147, -122.389359890563) | |||
32803 | 32803 | 243929 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1409 Douglass St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 6ft | 6001410.85086 | 2099557.6127299997 | 37.745064858666 | -122.437815383076 | (37.745064858666, -122.437815383076) | |||
32830 | 32830 | 203205 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 189 Hubbell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6013159.72459 | 2107270.14751 | 37.7669028782866 | -122.397730448328 | (37.7669028782866, -122.397730448328) | |||
33231 | 33231 | 181999 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2474 30th Ave | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 0ft | 5987078.0557 | 2098396.6732 | 37.7410517986936 | -122.487289748097 | (37.7410517986936, -122.487289748097) | |||
33282 | 33282 | 217464 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 127 Beverly St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5991405.11003 | 2090040.73714 | 37.7183598726973 | -122.471719713607 | (37.7183598726973, -122.471719713607) | |||
33283 | 33283 | 181264 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 271 Leland Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | Width 3ft | 6009517.64457 | 2087677.5938400002 | 37.712902490626895 | -122.40894535574499 | (37.7129024906269, -122.408945355745) | |||
33501 | 33501 | 199465 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1530 03rd St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6015601.020959999 | 2107350.5744 | 37.7672593587506 | -122.389291940488 | (37.7672593587506, -122.389291940488) | |||
33585 | 33585 | 137505 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2521 Leavenworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 5ft | 6007440.6556 | 2121042.48362 | 37.8043982179661 | -122.41848851434601 | (37.8043982179661, -122.418488514346) | |||
33699 | 33699 | 187438 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 4760 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6001460.7844 | 2091113.675 | 37.721882594303395 | -122.437038299541 | (37.7218825943034, -122.437038299541) | |||
33786 | 33786 | 199476 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1240 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6015490.48538 | 2109320.84762 | 37.772663168207 | -122.389811906894 | (37.772663168207, -122.389811906894) | |||
34301 | 34301 | 96815 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 15 Hartford St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2011 12:00:00 AM | Permit Number 767914 | 6002672.5 | 2105813.7 | 37.762314246216995 | -122.43389991802401 | (37.762314246217, -122.433899918024) | |||
34386 | 34386 | 199497 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 72 06th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 4ft | 6010024.2102 | 2112481.0403 | 37.7810356721041 | -122.408943433887 | (37.7810356721041, -122.408943433887) | |||
34652 | 34652 | 243942 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 701 Church St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | Width 3ft | 6004361.46086 | 2104388.80864 | 37.7584975338534 | -122.427956893407 | (37.7584975338534, -122.427956893407) | |||
34846 | 34846 | 243945 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 142 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6007159.400359999 | 2109389.15821 | 37.7723852147468 | -122.41863493565901 | (37.7723852147468, -122.418634935659) | |||
35169 | 35169 | 217430 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1113 Kirkham St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 5991534.38297 | 2105188.62915 | 37.7599596057689 | -122.47237655325 | (37.7599596057689, -122.47237655325) | |||
35626 | 35626 | 199488 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1300 03rd St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6015518.167640001 | 2108801.30732 | 37.7712381600557 | -122.38967985676099 | (37.7712381600557, -122.389679856761) | |||
35759 | 35759 | 117922 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 683 41st Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 3ft | 5983174.6969099995 | 2111166.71748 | 37.775886344567496 | -122.501730482451 | (37.7758863445675, -122.501730482451) | |||
36034 | 36034 | 187450 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 5098 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6000319.4478 | 2089309.2863 | 37.7168632117114 | -122.440854224757 | (37.7168632117114, -122.440854224757) | |||
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) | ||||
36914 | 36914 | 247654 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 900 Duboce Ave | 10 | : 4 | Tree 1 | Private 1 | 15 | Width 5ft | 6001517.12711 | 2108295.57391 | 37.7690632279012 | -122.438073702561 | (37.7690632279012, -122.438073702561) | |||
37483 | 37483 | 217487 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 15 Staples Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 8ft | 5999757.91748 | 2093744.86936 | 37.729010308071 | -122.44311353116501 | (37.729010308071, -122.443113531165) | |||
38080 | 38080 | 217478 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 51 Keystone Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 5994094.09681 | 2093023.21308 | 37.7267042448879 | -122.462641314769 | (37.7267042448879, -122.462641314769) | |||
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) | |||
38493 | 38493 | 181278 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 46 Admiral Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 8ft | 6003332.53306 | 2094181.6518 | 37.730412786411904 | -122.430786976247 | (37.7304127864119, -122.430786976247) | |||
38749 | 38749 | 181998 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2476 30th Ave | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 0ft | 5987077.3789 | 2098389.2279 | 37.7410313164056 | -122.48729154146099 | (37.7410313164056, -122.487291541461) | |||
38867 | 38867 | 199498 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1008 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 4ft | 6010028.2471900005 | 2112434.38373 | 37.780907790314394 | -122.40892617503 | (37.7809077903144, -122.40892617503) | |||
39038 | 39038 | 203204 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 189 Hubbell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6013138.407819999 | 2107249.76439 | 37.766845723690096 | -122.397802750202 | (37.7668457236901, -122.397802750202) | |||
39171 | 39171 | 181241 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 80 Blanken Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6011651.716019999 | 2087377.2812700002 | 37.712197204501294 | -122.401548169322 | (37.7121972045013, -122.401548169322) | |||
39215 | 39215 | 199440 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 189 Hubbell St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 6013418.56487 | 2107519.66805 | 37.767602416836 | -122.396852650636 | (37.767602416836, -122.396852650636) | |||
39492 | 39492 | 181267 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 271 Leland Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 3ft | 6009562.93662 | 2087661.4051599998 | 37.7128605768164 | -122.40878766951799 | (37.7128605768164, -122.408787669518) | |||
39669 | 39669 | 118709 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 4201 Balboa St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5982467.72104 | 2110969.09723 | 37.7753021852736 | -122.504161410758 | (37.7753021852736, -122.504161410758) | |||
39861 | 39861 | 65881 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 122 Palm Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 19 | 3x3 | Permit Number 53867 | 5995930.99366 | 2113550.02665 | 37.783171302573 | -122.457775944343 | (37.783171302573, -122.457775944343) |
39967 | 39967 | 199470 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1050 03rd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 5ft | 6015462.75637 | 2109791.03207 | 37.7739526530238 | -122.38994067543001 | (37.7739526530238, -122.38994067543) | |||
40393 | 40393 | 244837 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1880 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6006731.37022 | 2107461.01908 | 37.7670668948411 | -122.41997868286998 | (37.7670668948411, -122.41997868287) | |||
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) | |||
40524 | 40524 | 246614 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 405 Precita Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 2ft | 6009136.11989 | 2100236.51166 | 37.7473652210349 | -122.411150613905 | (37.7473652210349, -122.411150613905) | |||
40665 | 40665 | 244841 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1880 Mission St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6006736.38106 | 2107369.27612 | 37.766815272626296 | -122.41995484006901 | (37.7668152726263, -122.419954840069) | |||
41031 | 41031 | 182386 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1538 35th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 5985306.5492 | 2104723.6759 | 37.758320556835606 | -122.493881037718 | (37.7583205568356, -122.493881037718) | |||
41272 | 41272 | 243941 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 701 Church St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 21 | Width 3ft | 6004362.39063 | 2104350.06977 | 37.758391218686796 | -122.4279509174 | (37.7583912186868, -122.4279509174) | |||
41733 | 41733 | 203194 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1998 Revere Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 6012994.12431 | 2096000.54159 | 37.7359497449792 | -122.3975127773 | (37.7359497449792, -122.3975127773) | ||||
42207 | 42207 | 203193 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 47 Ceres St | 2 | : 4 | Tree 1 | Private 1 | 17 | Width 2ft | 6013909.9694300005 | 2093925.2511200001 | 37.7303023748506 | -122.39420106345301 | (37.7303023748506, -122.394201063453) | |||
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) | |||
42753 | 42753 | 43930 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2937 24th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/2000 12:00:00 AM | Permit Number 43521 | 6009283.57166105 | 2102148.92556307 | 37.7526245524661 | -122.41077577426901 | (37.7526245524661, -122.410775774269) | ||
43216 | 43216 | 203186 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1501 25th St | 25 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6014234.68411 | 2101965.33677 | 37.752396820871894 | -122.393640982742 | (37.7523968208719, -122.393640982742) | ||||
43226 | 43226 | 118483 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 8349 Geary Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | 5981073.18846 | 2112308.0171 | 37.7788963529663 | -122.50908477858499 | (37.7788963529663, -122.509084778585) | ||||
43297 | 43297 | 181269 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 37 Alpha St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 4ft | 6011324.26316 | 2088509.61111 | 37.7152880772715 | -122.402759532751 | (37.7152880772715, -122.402759532751) | |||
43355 | 43355 | 41527 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1038 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/2000 12:00:00 AM | 19 | Permit Number 42067 | 6018424.261969999 | 2095097.67116 | 37.7337714988594 | -122.378675747684 | (37.7337714988594, -122.378675747684) | ||
43387 | 43387 | 247655 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 900 Duboce Ave | 11 | : 4 | Tree 1 | Private 1 | 14 | Width 5ft | 6001504.48718 | 2108295.83572 | 37.769063227919105 | -122.43811744198601 | (37.7690632279191, -122.438117441986) | |||
43953 | 43953 | 249965 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 265 Filbert St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 19 | Width 0ft | 6011638.85917 | 2120086.18138 | 37.802007891017205 | -122.40389285566799 | (37.8020078910172, -122.403892855668) | |||
44059 | 44059 | 199443 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 625 King St | 23 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | Width 4ft | 6012254.773469999 | 2108757.11148 | 37.7709353106325 | -122.400965034535 | (37.7709353106325, -122.400965034535) | |||
44144 | 44144 | 184617 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1758 Lower Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5981057.9764 | 2103098.1394 | 37.753607806054 | -122.508453540189 | (37.753607806054, -122.508453540189) | |||
44198 | 44198 | 246412 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 3032 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6007104.9213 | 2100736.786 | 37.7486247408195 | -122.41820983567499 | (37.7486247408195, -122.418209835675) |
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");