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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3168 | 3168 | 33093 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
| 4009 | 4009 | 34002 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 37940 | ||||||||||
| 4171 | 4171 | 39901 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/03/2002 12:00:00 AM | Permit Number 41185 | |||||||||
| 5912 | 5912 | 35691 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 6766 | 6766 | 33092 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
| 7580 | 7580 | 33091 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
| 7627 | 7627 | 33085 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
| 7750 | 7750 | 33087 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
| 8822 | 8822 | 36564 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1998 12:00:00 AM | Permit Number 39428 | |||||||||
| 10191 | 10191 | 35689 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 10366 | 10366 | 46719 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2002 12:00:00 AM | Permit Number 44843 | |||||||||
| 10578 | 10578 | 39903 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/03/2002 12:00:00 AM | Permit Number 41185 | |||||||||
| 10962 | 10962 | 33089 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
| 11036 | 11036 | 36559 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1998 12:00:00 AM | Permit Number 39428 | |||||||||
| 11116 | 11116 | 34003 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 37940 | ||||||||||
| 12200 | 12200 | 46197 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2001 12:00:00 AM | Permit Number 44518 | |||||||||
| 12311 | 12311 | 39902 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/03/2002 12:00:00 AM | Permit Number 41185 | |||||||||
| 12475 | 12475 | 36562 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1998 12:00:00 AM | Permit Number 39428 | |||||||||
| 13380 | 13380 | 36560 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1998 12:00:00 AM | Permit Number 39428 | |||||||||
| 13386 | 13386 | 46196 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2001 12:00:00 AM | Permit Number 44518 | |||||||||
| 13673 | 13673 | 33088 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
| 14741 | 14741 | 33082 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
| 14773 | 14773 | 46721 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2002 12:00:00 AM | Permit Number 44843 | |||||||||
| 15188 | 15188 | 34004 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 37940 | ||||||||||
| 15368 | 15368 | 33086 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
| 15698 | 15698 | 46198 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2001 12:00:00 AM | Permit Number 44518 | |||||||||
| 15858 | 15858 | 33090 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
| 16147 | 16147 | 36565 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1998 12:00:00 AM | Permit Number 39428 | |||||||||
| 16437 | 16437 | 36563 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1998 12:00:00 AM | Permit Number 39428 | |||||||||
| 16615 | 16615 | 46720 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2002 12:00:00 AM | Permit Number 44843 | |||||||||
| 81010 | 81010 | 34857 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 38478 | 6007910.36416897 | 2111288.85125958 | 37.777643571368706 | -122.41617183970699 | (37.7776435713687, -122.416171839707) | |||||
| 86858 | 86858 | 34858 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 38478 | 6007910.36416897 | 2111288.85125958 | 37.777643571368706 | -122.41617183970699 | (37.7776435713687, -122.416171839707) | |||||
| 89396 | 89396 | 34859 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 38478 | 6007910.36416897 | 2111288.85125958 | 37.777643571368706 | -122.41617183970699 | (37.7776435713687, -122.416171839707) | |||||
| 90532 | 90532 | 34860 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 38478 | 6007910.36416897 | 2111288.85125958 | 37.777643571368706 | -122.41617183970699 | (37.7776435713687, -122.416171839707) | |||||
| 103571 | 103571 | 34855 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 38478 | 6007910.36416897 | 2111288.85125958 | 37.777643571368706 | -122.41617183970699 | (37.7776435713687, -122.416171839707) | |||||
| 113996 | 113996 | 34861 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 38478 | 6007910.36416897 | 2111288.85125958 | 37.777643571368706 | -122.41617183970699 | (37.7776435713687, -122.416171839707) | |||||
| 127906 | 127906 | 34856 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 38478 | 6007910.36416897 | 2111288.85125958 | 37.777643571368706 | -122.41617183970699 | (37.7776435713687, -122.416171839707) | |||||
| 24035 | 24035 | 178607 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5990327.66617 | 2089955.55198 | 37.7180635775375 | -122.47543773036101 | (37.7180635775375, -122.475437730361) | ||||
| 63730 | 63730 | 178606 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 0 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5989765.07873 | 2089203.5232 | 37.715966065363205 | -122.47732740025499 | (37.7159660653632, -122.477327400255) | ||||
| 146394 | 146394 | 178605 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 0 Gonzalez Dr | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5988508.8443599995 | 2089780.72483 | 37.71747794624039 | -122.48171173733299 | (37.7174779462404, -122.481711737333) | ||||
| 148106 | 148106 | 178604 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5988124.07873 | 2089803.3530000001 | 37.7175176953569 | -122.48304333649999 | (37.7175176953569, -122.4830433365) | ||||
| 35905 | 35905 | 195913 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 Ardath Ct | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017397.96951 | 2095379.8404599999 | 37.7344896488605 | -122.382243605578 | (37.7344896488605, -122.382243605578) | |||
| 47367 | 47367 | 195914 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 Ardath Ct | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017370.42366 | 2095423.7832799999 | 37.7346087856535 | -122.382341897873 | (37.7346087856535, -122.382341897873) | |||
| 47956 | 47956 | 195906 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 Ardath Ct | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6017536.5163900005 | 2095200.72855 | 37.734005494361895 | -122.381752144972 | (37.7340054943619, -122.381752144972) | |||
| 56264 | 56264 | 195915 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 Ardath Ct | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6017365.99395 | 2095418.6411400002 | 37.7345944216785 | -122.382356855387 | (37.7345944216785, -122.382356855387) | |||
| 60850 | 60850 | 195910 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 Ardath Ct | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6017434.18901 | 2095336.95373 | 37.734373890838 | -122.38211539910499 | (37.734373890838, -122.382115399105) | |||
| 62718 | 62718 | 195916 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 Ardath Ct | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017317.30726 | 2095456.23934 | 37.734694969487 | -122.382527798526 | (37.734694969487, -122.382527798526) | |||
| 75761 | 75761 | 195904 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 Ardath Ct | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6017314.87785 | 2095412.28408 | 37.7345741428666 | -122.382533140509 | (37.7345741428666, -122.382533140509) | |||
| 115835 | 115835 | 195911 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 Ardath Ct | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017428.56702 | 2095333.9897 | 37.7343654417004 | -122.382134630227 | (37.7343654417004, -122.382134630227) | |||
| 125312 | 125312 | 195917 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 Ardath Ct | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6017301.45491 | 2095451.6349 | 37.734681450894705 | -122.382582285768 | (37.7346814508947, -122.382582285768) | |||
| 136950 | 136950 | 195918 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 Ardath Ct | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6017279.62246 | 2095456.9975299998 | 37.7346949695032 | -122.382658141758 | (37.7346949695032, -122.382658141758) | |||
| 148682 | 148682 | 195912 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 Ardath Ct | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6017403.30116 | 2095383.73362 | 37.7345006331863 | -122.382225442864 | (37.7345006331863, -122.382225442864) | |||
| 149855 | 149855 | 195901 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 Ardath Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6017261.3966 | 2095426.5921599998 | 37.7346104754941 | -122.38271904027599 | (37.7346104754941, -122.382719040276) | |||
| 150878 | 150878 | 195909 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 Ardath Ct | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6017488.13797 | 2095238.32055 | 37.7341060430571 | -122.38192201971 | (37.7341060430571, -122.38192201971) | |||
| 156048 | 156048 | 195905 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 Ardath Ct | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6017408.623790001 | 2095295.0022200001 | 37.7342572883311 | -122.382200869793 | (37.7342572883311, -122.382200869793) | |||
| 158074 | 158074 | 195903 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 Ardath Ct | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6017292.8048 | 2095421.03653 | 37.7345969559879 | -122.38261006402 | (37.7345969559879, -122.38261006402) | |||
| 170411 | 170411 | 195908 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 Ardath Ct | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017495.96555 | 2095243.39437 | 37.734120407024704 | -122.38189530983699 | (37.7341204070247, -122.381895309837) | |||
| 177087 | 177087 | 195907 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 Ardath Ct | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6017530.876630001 | 2095227.61395 | 37.7340790049315 | -122.381773512858 | (37.7340790049315, -122.381773512858) | |||
| 184843 | 184843 | 195902 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 Ardath Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6017277.44673 | 2095425.6538 | 37.734608785648206 | -122.382663483745 | (37.7346087856482, -122.382663483745) | |||
| 77230 | 77230 | 235587 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 6007111.06981 | 2107271.06482 | 37.76656670991979 | -122.41865188518 | (37.7665667099198, -122.41865188518) | |||
| 50779 | 50779 | 134383 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 Cedar St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6007352.8337199995 | 2114556.88578 | 37.7865854379092 | -122.41833230212099 | (37.7865854379092, -122.418332302121) | |||
| 13586 | 13586 | 12949 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 Lindsay Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6016403.18992 | 2095651.77267 | 37.7351813255446 | -122.38570186665501 | (37.7351813255446, -122.385701866655) | |||
| 43171 | 43171 | 105076 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 MATEO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | 3x3 | 6003644.6 | 2096720.9 | 37.7374026627639 | -122.42988917159799 | (37.7374026627639, -122.429889171598) | |||
| 13384 | 13384 | 13425 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 Market St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/10/2007 12:00:00 AM | 25 | 4x4 | 6014152.78687 | 2117194.5214299997 | 37.7942082021958 | -122.39499075902599 | (37.7942082021958, -122.394990759026) | ||
| 13475 | 13475 | 13427 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 Market St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 4x4 | 6014172.84776 | 2117212.91542 | 37.7942598232708 | -122.394922634488 | (37.7942598232708, -122.394922634488) | |||
| 13620 | 13620 | 13426 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 Market St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/29/2003 12:00:00 AM | 8 | 4x4 | 6014161.01916 | 2117188.17749 | 37.7941912409866 | -122.394961829643 | (37.7941912409866, -122.394961829643) | ||
| 14334 | 14334 | 13428 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 Market St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/29/2003 12:00:00 AM | 6 | 4x4 | 6014180.24954 | 2117205.51401 | 37.7942399123011 | -122.394896504683 | (37.7942399123011, -122.394896504683) | ||
| 14650 | 14650 | 13430 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 Market St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 4x4 | 6014204.722019999 | 2117228.6530400002 | 37.7943048073789 | -122.394813447799 | (37.7943048073789, -122.394813447799) | |||
| 14759 | 14759 | 13420 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 Market St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/18/1991 12:00:00 AM | 30 | 4x4 | 6014066.39965 | 2117110.5956099997 | 37.7939729575322 | -122.395283788713 | (37.7939729575322, -122.395283788713) | ||
| 15013 | 15013 | 13423 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 Market St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2002 12:00:00 AM | 20 | 4x4 | 6014116.98151 | 2117144.48589 | 37.7940688252683 | -122.39511114407699 | (37.7940688252683, -122.395111144077) | ||
| 15024 | 15024 | 13424 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 Market St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/02/2003 12:00:00 AM | 20 | 4x4 | 6014140.16579 | 2117170.60528 | 37.7941418322359 | -122.395032753763 | (37.7941418322359, -122.395032753763) | ||
| 15548 | 15548 | 13429 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 Market St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 4x4 | 6014197.04513 | 2117235.7914400003 | 37.7943239809064 | -122.39484051109501 | (37.7943239809064, -122.394840511095) | |||
| 15704 | 15704 | 13419 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/10/1991 12:00:00 AM | 20 | 4x4 | 6014048.53109 | 2117080.6085599996 | 37.7938896263516 | -122.395343514492 | (37.7938896263516, -122.395343514492) | ||
| 15964 | 15964 | 13422 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 Market St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/10/2007 12:00:00 AM | 3 | 4x4 | 6014092.01898 | 2117123.77404 | 37.7940105671925 | -122.39519606616999 | (37.7940105671925, -122.39519606617) | ||
| 16385 | 16385 | 27316 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 4x4 | 6014028.45913 | 2117061.6774 | 37.7938365294714 | -122.39541163905199 | (37.7938365294714, -122.395411639052) | |||
| 16449 | 16449 | 13418 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4x4 | 6014042.20206 | 2117087.71971 | 37.7939087999011 | -122.395365912104 | (37.7939087999011, -122.395365912104) | |||
| 16600 | 16600 | 13421 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 Market St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/02/1991 12:00:00 AM | 30 | 4x4 | 6014072.44813 | 2117102.953 | 37.793952309100206 | -122.395262324595 | (37.7939523091002, -122.395262324595) | ||
| 179006 | 179006 | 238635 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 Mateo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 4ft | 6003627.19927 | 2096721.571 | 37.7374035197462 | -122.429949381872 | (37.7374035197462, -122.429949381872) | |||
| 70378 | 70378 | 133453 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 Presidio Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5998880.22963 | 2116633.28355 | 37.79180610312579 | -122.44779486036 | (37.7918061031258, -122.44779486036) | |||
| 149655 | 149655 | 133452 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 Presidio Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5998879.78479 | 2116645.46463 | 37.791839523718 | -122.44779727682301 | (37.791839523718, -122.447797276823) | |||
| 179370 | 179370 | 238646 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 Roanoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6003249.79131 | 2096430.02106 | 37.736581609537 | -122.43123345187401 | (37.736581609537, -122.431233451874) | |||
| 63754 | 63754 | 250007 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 Starr King Way | 2 | : 4 | Tree 1 | Private 1 | 18 | Width 3ft | 6005970.87651 | 2113821.19628 | 37.784487527310795 | -122.423061232398 | (37.7844875273108, -122.423061232398) | |||
| 169165 | 169165 | 250006 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 Starr King Way | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6005940.10765 | 2113829.6095 | 37.784508891608 | -122.423168280499 | (37.784508891608, -122.423168280499) | |||
| 30194 | 30194 | 234648 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 10 Ford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6003406.84007 | 2105674.0833799997 | 37.761972537618604 | -122.431350145198 | (37.7619725376186, -122.431350145198) | |||
| 23718 | 23718 | 195634 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 10 King St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6015922.53539 | 2112520.9791099997 | 37.7814739683895 | -122.388540802429 | (37.7814739683895, -122.388540802429) | |||
| 29798 | 29798 | 195642 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 10 King St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6015873.18226 | 2112320.09829 | 37.7809196595661 | -122.388697514702 | (37.7809196595661, -122.388697514702) | |||
| 42669 | 42669 | 195637 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 10 King St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6015914.47489 | 2112443.6683400003 | 37.781261243656296 | -122.388563289988 | (37.7812612436563, -122.388563289988) | |||
| 43502 | 43502 | 195640 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 10 King St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6015892.82601 | 2112367.4405 | 37.7810507393377 | -122.38863286241998 | (37.7810507393377, -122.38863286242) | |||
| 45064 | 45064 | 195644 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 10 King St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6015847.2765 | 2112274.5008099996 | 37.7807930233285 | -122.38878395211799 | (37.7807930233285, -122.388783952118) | |||
| 49801 | 49801 | 195645 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 10 King St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6015833.63304 | 2112252.7275900003 | 37.7807324827572 | -122.38882963140101 | (37.7807324827572, -122.388829631401) | |||
| 51639 | 51639 | 195632 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 10 King St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6015928.19981 | 2112561.72047 | 37.7815861489313 | -122.388524050751 | (37.7815861489313, -122.388524050751) | |||
| 75144 | 75144 | 195643 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 10 King St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6015861.55733 | 2112297.6774 | 37.7808574525459 | -122.388736165764 | (37.7808574525459, -122.388736165764) | |||
| 75905 | 75905 | 195641 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 10 King St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6015884.8235 | 2112343.32817 | 37.7809840887822 | -122.388658863641 | (37.7809840887822, -122.388658863641) | |||
| 77086 | 77086 | 195646 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 10 King St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6015816.94411 | 2112231.01553 | 37.7806719412978 | -122.38888585071699 | (37.7806719412978, -122.388885850717) | |||
| 135257 | 135257 | 195639 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 10 King St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6015901.23898 | 2112391.74663 | 37.7811179447654 | -122.388605454684 | (37.7811179447654, -122.388605454684) | |||
| 147693 | 147693 | 195635 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 10 King St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6015919.251069999 | 2112489.08509 | 37.781386212554295 | -122.388549937747 | (37.7813862125543, -122.388549937747) | |||
| 150021 | 150021 | 195633 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 10 King St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6015927.61372 | 2112541.10483 | 37.7815295105284 | -122.388524638927 | (37.7815295105284, -122.388524638927) | |||
| 156723 | 156723 | 195636 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 10 King St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6015918.13161 | 2112463.82242 | 37.7813167848887 | -122.388552046646 | (37.7813167848887, -122.388552046646) | |||
| 175749 | 175749 | 195638 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 10 King St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6015907.59674 | 2112414.88075 | 37.781181818212794 | -122.388585075135 | (37.7811818182128, -122.388585075135) | |||
| 58215 | 58215 | 238639 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 10 Mateo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 4ft | 6003641.796019999 | 2096645.51755 | 37.7371955209567 | -122.429893490793 | (37.7371955209567, -122.429893490793) |
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");