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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3273 | 3273 | 499 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2751 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/29/2017 12:00:00 AM | 3 | 4x4 | Permit Number 780031 | 6010232.5569 | 2102206.4482 | 37.7528356605554 | -122.407498057365 | (37.7528356605554, -122.407498057365) | |
| 17210 | 17210 | 559 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 2933 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6009274.565719999 | 2102151.76119 | 37.7526318334984 | -122.410807118757 | (37.7526318334984, -122.410807118757) | |||
| 89121 | 89121 | 561 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 2937 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/21/2013 12:00:00 AM | 3 | 3x3 | 6009283.5604936 | 2102149.9264551 | 37.752627300065605 | -122.41077588356801 | (37.7526273000656, -122.410775883568) | ||
| 18869 | 18869 | 564 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 2951 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/21/2013 12:00:00 AM | 3 | 3x3 | 6009194.66362 | 2102148.83507 | 37.7526193185392 | -122.41108322860799 | (37.7526193185392, -122.411083228608) | ||
| 87023 | 87023 | 572 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2980X 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/02/2015 12:00:00 AM | 24 | 3x3 | Permit Number 776380 | 6009061.0945003 | 2102187.7119023 | 37.752718574309995 | -122.41154788216299 | (37.75271857431, -122.411547882163) | |
| 18411 | 18411 | 651 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 3254 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2013 12:00:00 AM | 3 | 3x3 | 6007303.38124 | 2102084.9566099998 | 37.7523376805636 | -122.417619101966 | (37.7523376805636, -122.417619101966) | ||
| 22168 | 22168 | 657 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 3262 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6007285.35691 | 2102087.12511 | 37.752342620515705 | -122.41768158684602 | (37.7523426205157, -122.417681586846) | |||
| 17607 | 17607 | 1217 | Planning Code 138.1 required 4 | Ginkgo biloba :: Maidenhair Tree 44 | 3501 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/17/2016 12:00:00 AM | 3 | 3x3 | 5993695.72185 | 2087421.0982400002 | 37.711299234146296 | -122.463612070865 | (37.7112992341463, -122.463612070865) | ||
| 10627 | 10627 | 1283 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 44 | 3995X Alemany Blvd | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10 | 10x10 | 5992081.50866 | 2087171.0422099999 | 37.710519496741206 | -122.469172961285 | (37.7105194967412, -122.469172961285) | |||
| 107859 | 107859 | 1389 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 10 Ardath Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017228.6912616 | 2095462.3520099 | 37.7347068580177 | -122.38283460251301 | (37.7347068580177, -122.382834602513) | ||
| 107138 | 107138 | 1392 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 22 Ardath Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017289.005730201 | 2095457.8512491002 | 37.7346978320202 | -122.382625759658 | (37.7346978320202, -122.382625759658) | ||
| 144982 | 144982 | 1403 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 62 Ardath Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017428.9119183 | 2095344.9938608997 | 37.734395675993795 | -122.382134203041 | (37.7343956759938, -122.382134203041) | ||
| 91616 | 91616 | 1409 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 79 Ardath Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017424.8922659 | 2095259.7862555 | 37.7341614907893 | -122.382142174898 | (37.7341614907893, -122.382142174898) | ||
| 54625 | 54625 | 1412 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 87 Ardath Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017443.0312922 | 2095232.0493547001 | 37.7340863325513 | -122.38207753310499 | (37.7340863325513, -122.382077533105) | ||
| 8029 | 8029 | 1717 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 555 Battery St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6012534.63593 | 2117926.51881 | 37.7961279804624 | -122.400641221934 | (37.7961279804624, -122.400641221934) | |||
| 111040 | 111040 | 2753 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 103 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3X3 | 5995271.42622 | 2110734.15943 | 37.7754017677407 | -122.459853726114 | (37.7754017677407, -122.459853726114) | |||
| 119885 | 119885 | 3756 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1056 Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 18 | 6012452.0863519 | 2103047.5184298 | 37.7552690413169 | -122.399881522302 | (37.7552690413169, -122.399881522302) | |||
| 110746 | 110746 | 3757 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1056 Carolina St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 18 | 6012452.0863519 | 2103047.5184298 | 37.7552690413169 | -122.399881522302 | (37.7552690413169, -122.399881522302) | |||
| 14011 | 14011 | 4036 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 2323 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X3 | 6011851.38946 | 2100896.5951099996 | 37.7493295679091 | -122.401807737936 | (37.7493295679091, -122.401807737936) | |||
| 15248 | 15248 | 4037 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 2323 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X3 | 6011877.987480001 | 2100898.0514700003 | 37.749335051069004 | -122.401715863223 | (37.749335051069, -122.401715863223) | |||
| 16628 | 16628 | 4038 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 2323 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X3 | 6011915.6161 | 2100899.61614 | 37.7493414470685 | -122.401585851825 | (37.7493414470685, -122.401585851825) | |||
| 16687 | 16687 | 4039 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 2323 Cesar Chavez St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2014 12:00:00 AM | 5 | 2X3 | 6011942.20762 | 2100900.73993 | 37.7493460165275 | -122.401493976188 | (37.7493460165275, -122.401493976188) | ||
| 98132 | 98132 | 4040 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 2323 Cesar Chavez St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X3 | 6012395.8663751 | 2100931.7625375 | 37.749456500483205 | -122.399927382488 | (37.7494565004832, -122.399927382488) | |||
| 14887 | 14887 | 4041 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 2323 Cesar Chavez St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X3 | 6012003.952769999 | 2100904.2897799998 | 37.7493592086764 | -122.40128070823401 | (37.7493592086764, -122.401280708234) | |||
| 15838 | 15838 | 4042 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 2323 Cesar Chavez St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X3 | 6012031.32912 | 2100905.9879099997 | 37.749365398695396 | -122.40118615893299 | (37.7493653986954, -122.401186158933) | |||
| 16495 | 16495 | 4043 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 2323 Cesar Chavez St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/10/2005 12:00:00 AM | 3 | 2X3 | 6012152.10777 | 2100910.4709400004 | 37.7493844454379 | -122.400768815931 | (37.7493844454379, -122.400768815931) | ||
| 14311 | 14311 | 4044 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 2323 Cesar Chavez St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2014 12:00:00 AM | 3 | 2X3 | 6012170.1171 | 2100910.58495 | 37.7493857629599 | -122.400706546863 | (37.7493857629599, -122.400706546863) | ||
| 16216 | 16216 | 4045 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 2323 Cesar Chavez St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2014 12:00:00 AM | 3 | 2X3 | 6012204.22169 | 2100912.2871 | 37.74939233879871 | -122.40058873120199 | (37.7493923387987, -122.400588731202) | ||
| 15043 | 15043 | 4046 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 2323 Cesar Chavez St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X3 | 6012224.99422 | 2100912.98992 | 37.74939542707129 | -122.40051694820801 | (37.7493954270713, -122.400516948208) | |||
| 14344 | 14344 | 4047 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 2323 Cesar Chavez St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X3 | 6012259.88232 | 2100916.2126599997 | 37.749406221625 | -122.40039652989401 | (37.749406221625, -122.400396529894) | |||
| 15660 | 15660 | 4048 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 2323 Cesar Chavez St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X3 | 6012292.256030001 | 2100918.21603 | 37.74941352772171 | -122.40028472078998 | (37.7494135277217, -122.40028472079) | |||
| 15992 | 15992 | 4049 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 2323 Cesar Chavez St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X3 | 6012317.265430001 | 2100919.43782 | 37.749418277035296 | -122.400198322911 | (37.7494182770353, -122.400198322911) | |||
| 21003 | 21003 | 4174 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 3809 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/22/2014 12:00:00 AM | 3 | 3x3 | 6005074.45285 | 2100459.68403 | 37.7477493826385 | -122.425211462866 | (37.7477493826385, -122.425211462866) | ||
| 20684 | 20684 | 4190 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 3859 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004814.55251 | 2100443.91383 | 37.7476913952396 | -122.426109062696 | (37.7476913952396, -122.426109062696) | |||
| 17434 | 17434 | 4191 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 3859 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6004825.90537 | 2100443.7423799997 | 37.747691566130904 | -122.426069792902 | (37.7476915661309, -122.426069792902) | |||
| 18182 | 18182 | 4251 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 4051 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/1999 12:00:00 AM | 3 | 3X3 | 6003561.43732 | 2100376.51565 | 37.7474354302209 | -122.43043745653799 | (37.7474354302209, -122.430437456538) | ||
| 17787 | 17787 | 4371 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1006 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/24/2011 12:00:00 AM | 3 | 3x3 | 6000975.48263 | 2096188.08245 | 37.7357881547849 | -122.439079358629 | (37.7357881547849, -122.439079358629) | ||
| 21390 | 21390 | 4433 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1238 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/21/2008 12:00:00 AM | 3 | 3X3 | 6004437.55444 | 2101698.90078 | 37.7511159830235 | -122.427502095444 | (37.7511159830235, -122.427502095444) | ||
| 2222 | 2222 | 4694 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 850X Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 4x8 | 6008940.69941 | 2120350.9777900004 | 37.802583847399 | -122.41324853649999 | (37.802583847399, -122.4132485365) | |||
| 21206 | 21206 | 4869 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 40 Crags Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6000808.022480001 | 2098114.8305900004 | 37.741069023307396 | -122.43979642947599 | (37.7410690233074, -122.439796429476) | |||
| 18692 | 18692 | 4870 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 43 Crags Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/04/2002 12:00:00 AM | 6 | 2X2 | 6000851.2827699995 | 2098123.40175 | 37.741095020030606 | -122.439647465779 | (37.7410950200306, -122.439647465779) | ||
| 17370 | 17370 | 4879 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 72 Crags Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/1992 12:00:00 AM | 20 | 3X3 | 6000878.308119999 | 2097936.4399200003 | 37.7405832050459 | -122.43954062270001 | (37.7405832050459, -122.4395406227) | ||
| 19190 | 19190 | 4880 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 72 Crags Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/1992 12:00:00 AM | 20 | 3X3 | 6000876.35717 | 2097913.9937400003 | 37.7405214620835 | -122.439545759622 | (37.7405214620835, -122.439545759622) | ||
| 128724 | 128724 | 4902 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 94 Ardath Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017502.5740617 | 2095232.3549831002 | 37.73409045999 | -122.381871694314 | (37.73409045999, -122.381871694314) | ||
| 20418 | 20418 | 5151 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 251 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/28/2002 12:00:00 AM | 3 | 3X3 | 6001783.9539 | 2109206.4501 | 37.7715794389957 | -122.437215994595 | (37.7715794389957, -122.437215994595) | ||
| 23143 | 23143 | 5166 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 300 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 6001808.2976 | 2109504.736 | 37.7723998416689 | -122.437153148887 | (37.7723998416689, -122.437153148887) | ||||
| 17150 | 17150 | 5176 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 364 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/1993 12:00:00 AM | 3 | 3x3 | 6001777.7698 | 2109730.6414 | 37.7730183862506 | -122.43727492563801 | (37.7730183862506, -122.437274925638) | ||
| 2883 | 2883 | 5188 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 506 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/1997 12:00:00 AM | 3 | 3X3 | 6001711.9462 | 2110180.0726 | 37.774248669965296 | -122.437534808127 | (37.7742486699653, -122.437534808127) | ||
| 1174 | 1174 | 5198 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 635 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/2001 12:00:00 AM | 3 | 3x3 | 6001582.4984 | 2110645.9942 | 37.775520613317 | -122.43801597154 | (37.775520613317, -122.43801597154) | ||
| 8944 | 8944 | 5220 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 998X Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/26/1995 12:00:00 AM | 3 | 3X4 | 6001495.4192 | 2111745.9646 | 37.7785359024219 | -122.438396022881 | (37.7785359024219, -122.438396022881) | ||
| 97669 | 97669 | 5246 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1101X Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/1990 12:00:00 AM | 9 | 3X3 | 6001386.14183 | 2112156.35865 | 37.779656524270294 | -122.43880347039101 | (37.7796565242703, -122.438803470391) | ||
| 90940 | 90940 | 5247 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1101X Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/1990 12:00:00 AM | 5 | 3X3 | 6001386.14183 | 2112156.35865 | 37.779656524270294 | -122.43880347039101 | (37.7796565242703, -122.438803470391) | ||
| 7767 | 7767 | 5249 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1135 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/1990 12:00:00 AM | 6 | 3X3 | 6001356.9176 | 2112269.0905 | 37.7799643946727 | -122.438912650424 | (37.7799643946727, -122.438912650424) | ||
| 7929 | 7929 | 5252 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1149 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6001343.3807 | 2112375.6934 | 37.7802563289851 | -122.43896712240499 | (37.7802563289851, -122.438967122405) | |||
| 23267 | 23267 | 5296 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1600 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | 3X3 | 6001166.5123 | 2114078.1108 | 37.7849206674566 | -122.439701075731 | (37.7849206674566, -122.439701075731) | |||
| 3464 | 3464 | 5297 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1600 Divisadero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/07/1995 12:00:00 AM | 3 | 2X3 | 6001162.4866 | 2114099.2454 | 37.7849784685073 | -122.439716519057 | (37.7849784685073, -122.439716519057) | ||
| 6469 | 6469 | 5298 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1600 Divisadero St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/26/1995 12:00:00 AM | 3 | 2X3 | 6001159.4674 | 2114123.3993 | 37.785044617067 | -122.439728696784 | (37.785044617067, -122.439728696784) | ||
| 106734 | 106734 | 5313 | Planning Code 138.1 required 4 | Ginkgo biloba :: Maidenhair Tree 44 | 1785 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2016 12:00:00 AM | 3 | 3X3 | Permit Number 770253 | 6001045.0 | 2114480.0 | 37.786017234839 | -122.440150297316 | (37.786017234839, -122.440150297316) | |
| 641 | 641 | 5315 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1820 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/22/1990 12:00:00 AM | 3 | 3X3 | 6001085.4403 | 2114655.5077 | 37.7865014360219 | -122.440022974412 | (37.7865014360219, -122.440022974412) | ||
| 8352 | 8352 | 5316 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1823 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1997 12:00:00 AM | 5 | 2X3 | 6001019.2169 | 2114657.038 | 37.786501867674495 | -122.44025220015699 | (37.7865018676745, -122.440252200157) | ||
| 20497 | 20497 | 5491 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 730 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/17/2007 12:00:00 AM | 3 | 3X3 | 6004960.448369999 | 2104097.58597 | 37.7577317737189 | -122.425864595473 | (37.7577317737189, -122.425864595473) | ||
| 20995 | 20995 | 5494 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 730 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/18/1997 12:00:00 AM | 10 | 3X3 | 6004961.0674 | 2104070.7445400003 | 37.7576581084452 | -122.425860544043 | (37.7576581084452, -122.425860544043) | ||
| 21319 | 21319 | 5526 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 879 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6005088.52719 | 2103266.35336 | 37.755456640933104 | -122.42536249410699 | (37.7554566409331, -122.425362494107) | |||
| 21561 | 21561 | 5596 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1101-1103 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/02/1994 12:00:00 AM | 8 | 3X3 | 6005167.29973 | 2101906.50174 | 37.7517272549302 | -122.424993326899 | (37.7517272549302, -122.424993326899) | ||
| 21571 | 21571 | 5603 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1126 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/08/2003 12:00:00 AM | 3 | 3x3 | 6005088.2583099995 | 2101777.30613 | 37.7513680486157 | -122.425257470357 | (37.7513680486157, -122.425257470357) | ||
| 16989 | 16989 | 5648 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1301 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/18/1997 12:00:00 AM | 12 | 3x3 | 6005228.5165 | 2100736.6422099997 | 37.748518548492996 | -122.424698417605 | (37.748518548493, -122.424698417605) | ||
| 18659 | 18659 | 5649 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1301 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/18/1997 12:00:00 AM | 6 | 3x3 | 6005228.61487 | 2100741.42475 | 37.7485316858032 | -122.424698417616 | (37.7485316858032, -122.424698417616) | ||
| 179188 | 179188 | 5676 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1442 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/11/2003 12:00:00 AM | 6 | 3X3 | 6005185.30629 | 2099958.9563 | 37.7463807610586 | -122.42479251997801 | (37.7463807610586, -122.424792519978) | ||
| 19594 | 19594 | 5690 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1542 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6005216.26062 | 2099398.74761 | 37.7448443044129 | -122.42464563910299 | (37.7448443044129, -122.424645639103) | |||
| 17432 | 17432 | 5700 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1574 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/30/1999 12:00:00 AM | 6 | 3X3 | 6005230.11909 | 2099176.7707599998 | 37.744235589305504 | -122.42458193203001 | (37.7442355893055, -122.42458193203) | ||
| 17317 | 17317 | 5713 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1629 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 6005337.04528 | 2098854.62727 | 37.743357094669705 | -122.424189297907 | (37.7433570946697, -122.424189297907) | |||
| 18543 | 18543 | 5714 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1632 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/05/2012 12:00:00 AM | 3 | 4X4 | 6005246.5883 | 2098847.7434900003 | 37.7433330854531 | -122.424501585686 | (37.7433330854531, -122.424501585686) | ||
| 19769 | 19769 | 5716 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1634 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3x3 | 6005250.99581 | 2098818.0906700003 | 37.7432519144591 | -122.424484236873 | (37.7432519144591, -122.424484236873) | |||
| 22169 | 22169 | 5735 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1731 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/28/2008 12:00:00 AM | 50 | 3x3 | 6005365.9005 | 2098299.94514 | 37.7418356926592 | -122.424050086446 | (37.7418356926592, -122.424050086446) | ||
| 21304 | 21304 | 5736 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1735 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3x3 | 6005366.76903 | 2098271.84228 | 37.74175857761 | -122.424045085308 | (37.74175857761, -122.424045085308) | |||
| 20508 | 20508 | 5739 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1747 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6005368.013730001 | 2098244.45158 | 37.7416834392278 | -122.424038834141 | (37.7416834392278, -122.424038834141) | |||
| 512 | 512 | 6424 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1100X Evans Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2017 12:46:00 PM | 3 | 3x3 | 6018234.67827 | 2096633.8011 | 37.7379789554566 | -122.37943787365299 | (37.7379789554566, -122.379437873653) | ||
| 1143 | 1143 | 6430 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1100X Evans Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/03/2017 12:48:00 PM | 3 | 3x3 | 6018115.58754 | 2096722.72512 | 37.7382165545353 | -122.379855810196 | (37.7382165545353, -122.379855810196) | ||
| 141946 | 141946 | 6433 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1100X Evans Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/10/2014 12:00:00 AM | 3 | 3x3 | 6018339.9760743 | 2096552.8140758 | 37.7377623877793 | -122.379068180173 | (37.7377623877793, -122.379068180173) | ||
| 124573 | 124573 | 6444 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1100X Evans Ave | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/11/2006 12:00:00 AM | 3 | 3x3 | 6018339.9760743 | 2096552.8140758 | 37.7377623877793 | -122.379068180173 | (37.7377623877793, -122.379068180173) | ||
| 16883 | 16883 | 6447 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1199 Evans Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/20/2015 07:28:00 AM | 3 | 3X3 | 6017815.25315 | 2096866.6700099998 | 37.7385952266854 | -122.380904232644 | (37.7385952266854, -122.380904232644) | ||
| 15184 | 15184 | 6448 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1199 Evans Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/2004 12:00:00 AM | 3 | 3X3 | 6017830.617269999 | 2096853.12584 | 37.7385588850815 | -122.380850169009 | (37.7385588850815, -122.380850169009) | ||
| 13976 | 13976 | 6449 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1199 Evans Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/2001 12:00:00 AM | 3 | 3X3 | 6017844.2154 | 2096842.4719 | 37.7385303819825 | -122.380802412295 | (37.7385303819825, -122.380802412295) | ||
| 13649 | 13649 | 6451 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1199 Evans Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/2004 12:00:00 AM | 3 | 3X3 | 6017878.64833 | 2096818.1638599997 | 37.738465537256495 | -122.38068166932399 | (37.7384655372565, -122.380681669324) | ||
| 119928 | 119928 | 6452 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1195 Evans Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/22/2012 12:00:00 AM | 3 | 3X3 | 6017800.8785909 | 2096864.2340113998 | 37.738587744527 | -122.38095376420601 | (37.738587744527, -122.380953764206) | ||
| 16673 | 16673 | 6453 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1199 Evans Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/16/2009 12:00:00 AM | 3 | 3X3 | 6017908.60089 | 2096791.35092 | 37.7383935672065 | -122.380576243601 | (37.7383935672065, -122.380576243601) | ||
| 1140 | 1140 | 6454 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1199 Evans Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/03/2017 02:46:00 PM | 3 | 3X3 | 6017932.4783 | 2096773.48366 | 37.738345824884895 | -122.380492444782 | (37.7383458248849, -122.380492444782) | ||
| 14855 | 14855 | 6455 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1199 Evans Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/2016 12:00:00 AM | 3 | 3X3 | 6017959.51846 | 2096757.36933 | 37.7383030702171 | -122.38039783251699 | (37.7383030702171, -122.380397832517) | ||
| 14037 | 14037 | 6456 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1199 Evans Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/09/2004 12:00:00 AM | 3 | 3X3 | 6017977.7328 | 2096742.9894400002 | 37.738264590924395 | -122.38033385651899 | (37.7382645909244, -122.380333856519) | ||
| 16508 | 16508 | 6457 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1199 Evans Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2012 12:00:00 AM | 3 | 3x3 | 6018005.955469999 | 2096720.8825599998 | 37.7382054470215 | -122.38023473953699 | (37.7382054470215, -122.380234739537) | ||
| 110022 | 110022 | 6466 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1200X Evans Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/10/2016 02:10:00 PM | 3 | 5x3 | 6017691.374009999 | 2097075.6460099998 | 37.7391621949376 | -122.381347079263 | (37.7391621949376, -122.381347079263) | ||
| 127207 | 127207 | 6467 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1200X Evans Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/04/2004 12:00:00 AM | 3 | 3X3 | 6017673.482009999 | 2097089.9600099998 | 37.7392005105495 | -122.381409937459 | (37.7392005105495, -122.381409937459) | ||
| 79341 | 79341 | 6471 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1200X Evans Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/11/2006 12:00:00 AM | 3 | 3X3 | 6017624.57801 | 2097125.7440099998 | 37.739296066226295 | -122.38158151514601 | (37.7392960662263, -122.381581515146) | ||
| 102084 | 102084 | 6473 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1200X Evans Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/15/2001 12:00:00 AM | 3 | 3X3 | 6017566.13101 | 2097162.72001 | 37.7393943676917 | -122.38178617198099 | (37.7393943676917, -122.381786171981) | ||
| 79314 | 79314 | 6476 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1200X Evans Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/11/2006 12:00:00 AM | 3 | 3X3 | 6017489.79301 | 2097227.1310099997 | 37.739567011757 | -122.38205459719299 | (37.739567011757, -122.382054597193) | ||
| 119286 | 119286 | 6478 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1200X Evans Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2013 12:00:00 AM | 3 | 3x3 | 6017452.81601 | 2097250.98701 | 37.739630473342 | -122.382184108102 | (37.739630473342, -122.382184108102) | ||
| 107899 | 107899 | 6481 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1200X Evans Ave | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2004 12:00:00 AM | 3 | 3X3 | 6017370.51401 | 2097316.59001 | 37.7398060600402 | -122.38247323921001 | (37.7398060600402, -122.38247323921) | ||
| 122398 | 122398 | 6482 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1200X Evans Ave | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/11/2006 12:00:00 AM | 3 | 3X3 | 6017388.40501 | 2097301.08401 | 37.739764471951396 | -122.38241030049801 | (37.7397644719514, -122.382410300498) | ||
| 102807 | 102807 | 6499 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1200X Evans Ave | 41 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/11/2006 12:00:00 AM | 3 | 3X3 | 6017004.32701 | 2097592.12501 | 37.7405423887708 | -122.38375855101201 | (37.7405423887708, -122.383758551012) | ||
| 95212 | 95212 | 6501 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1200X Evans Ave | 43 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/23/2014 12:00:00 AM | 3 | 3x3 | 6016955.42201 | 2097623.1370099997 | 37.740624838003896 | -122.383929806075 | (37.7406248380039, -122.383929806075) |
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");