Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH
| Link | rowid | TreeID ▲ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3264 | 3264 | 253390 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2529x Lyon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/29/2017 12:00:00 AM | 3 | 3x3 | |||||||
| 1452 | 1452 | 251537 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 25 Essex St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014029.0 | 2114247.0 | 37.7861081097809 | -122.395212511502 | (37.7861081097809, -122.395212511502) | ||||
| 1371 | 1371 | 251505 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 360 Clementina St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011658.68026 | 2112523.0235200003 | 37.781242368680296 | -122.403291911611 | (37.7812423686803, -122.403291911611) | ||||
| 351 | 351 | 251213 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 210X Shipley St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | 2.5x6 | Permit Number 778048 | 6011604.0 | 2111950.0 | 37.779665925350706 | -122.40344075372101 | (37.7796659253507, -122.403440753721) | |
| 396 | 396 | 251212 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 210X Shipley St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | 2.5x6 | Permit Number 778048 | 6011604.0 | 2111950.0 | 37.779665925350706 | -122.40344075372101 | (37.7796659253507, -122.403440753721) | |
| 365 | 365 | 251211 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 210X Shipley St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | 2.5x6 | Permit Number 778048 | 6011604.0 | 2111950.0 | 37.779665925350706 | -122.40344075372101 | (37.7796659253507, -122.403440753721) | |
| 51610 | 51610 | 247891 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 300x Divisadero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 0ft | 6001766.9155 | 2109631.5958 | 37.7727458146843 | -122.43730537854401 | (37.7727458146843, -122.437305378544) | |||
| 137243 | 137243 | 247890 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 300x Divisadero St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 0ft | 6001764.2019 | 2109653.3044 | 37.772805266826 | -122.43731631988899 | (37.772805266826, -122.437316319889) | |||
| 180234 | 180234 | 247518 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 300x Divisadero St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001762.8451 | 2109678.405 | 37.7728741096846 | -122.437322810858 | (37.7728741096846, -122.437322810858) | |||
| 178382 | 178382 | 247517 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 250x Divisadero St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001820.5087 | 2109214.383 | 37.771603298669 | -122.437090117747 | (37.771603298669, -122.437090117747) | |||
| 47914 | 47914 | 247516 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 250x Divisadero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001823.2223 | 2109176.3929 | 37.7714991415406 | -122.43707801088101 | (37.7714991415406, -122.437078010881) | |||
| 170700 | 170700 | 247515 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 250x Divisadero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001817.1167 | 2109233.3781 | 37.7716552616846 | -122.437103211063 | (37.7716552616846, -122.437103211063) | |||
| 32664 | 32664 | 247514 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 300x Divisadero St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001758.7748 | 2109713.6816 | 37.7729707390414 | -122.43733941693701 | (37.7729707390414, -122.437339416937) | |||
| 150662 | 150662 | 247513 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 400x Divisadero St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001705.0206 | 2109993.3481 | 37.773735577412 | -122.437545390376 | (37.773735577412, -122.437545390376) | |||
| 55733 | 55733 | 247512 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 400x Divisadero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001707.9488 | 2109975.7789 | 37.773687503260604 | -122.437534002868 | (37.7736875032606, -122.437534002868) | |||
| 129960 | 129960 | 247511 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 400x Divisadero St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001702.677999999 | 2110029.6578 | 37.773835141586105 | -122.43755609455201 | (37.7738351415861, -122.437556094552) | |||
| 178645 | 178645 | 247510 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 400x Divisadero St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001703.2636 | 2110010.3317 | 37.7737821102395 | -122.43755268459299 | (37.7737821102395, -122.437552684593) | |||
| 158545 | 158545 | 247509 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 400x Divisadero St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001720.54 | 2109913.9939 | 37.773518572941896 | -122.4374860227 | (37.7735185729419, -122.4374860227) | |||
| 42109 | 42109 | 247508 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 400x Divisadero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001724.0539 | 2109895.2534 | 37.7734673159842 | -122.43747252535401 | (37.7734673159842, -122.437472525354) | |||
| 177449 | 177449 | 247507 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 400x Divisadero St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001724.6395 | 2109878.2699 | 37.7734207168265 | -122.437469283257 | (37.7734207168265, -122.437469283257) | |||
| 172488 | 172488 | 247421 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 541 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6003124.7415 | 2110178.9182 | 37.7743257229582 | -122.43264761463101 | (37.7743257229582, -122.432647614631) | |||
| 31777 | 31777 | 247369 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 400x Divisadero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001726.9821 | 2109863.6289 | 37.773380649478504 | -122.437460131244 | (37.7733806494785, -122.437460131244) | |||
| 152287 | 152287 | 244924 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 250x Divisadero St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 6001808.976 | 2109286.2928 | 37.771800089557296 | -122.4371351594 | (37.7718000895573, -122.4371351594) | |||
| 141528 | 141528 | 244919 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 250x Divisadero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 6001806.9408 | 2109318.1774 | 37.7718875210524 | -122.437144482547 | (37.7718875210524, -122.437144482547) | |||
| 137299 | 137299 | 244918 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 250x Divisadero St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001806.9408 | 2109337.8508 | 37.7719415393154 | -122.437145891369 | (37.7719415393154, -122.437145891369) | |||
| 71495 | 71495 | 244916 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 250x Divisadero St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001807.6192 | 2109359.5595 | 37.77200118456779 | -122.437145099308 | (37.7720011845678, -122.437145099308) | |||
| 45104 | 45104 | 244892 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 300x Divisadero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001783.197000001 | 2109529.1582 | 37.772465472110895 | -122.437241723075 | (37.7724654721109, -122.437241723075) | |||
| 66685 | 66685 | 244891 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 300x Divisadero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001778.4482 | 2109561.7211 | 37.7725546117714 | -122.437260481611 | (37.7725546117714, -122.437260481611) | |||
| 41565 | 41565 | 244890 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 300x Divisadero St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001780.4834 | 2109546.7964 | 37.772513747957 | -122.43725237282601 | (37.772513747957, -122.437252372826) | |||
| 158413 | 158413 | 244889 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 300x Divisadero St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 0ft | 6001777.0914 | 2109578.0026 | 37.7725992395847 | -122.437266340921 | (37.7725992395847, -122.437266340921) | |||
| 37536 | 37536 | 220503 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 203 States St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6001063.95053 | 2106312.4258 | 37.7635922112288 | -122.43949902816799 | (37.7635922112288, -122.439499028168) | |||
| 132111 | 132111 | 220502 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 203 States St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001052.7455400005 | 2106320.2037400003 | 37.7636129298281 | -122.439538340217 | (37.7636129298281, -122.439538340217) | |||
| 25016 | 25016 | 220501 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 14 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003128.49952 | 2108178.20652 | 37.768832473561794 | -122.432491682542 | (37.7688324735618, -122.432491682542) | |||
| 150427 | 150427 | 220500 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 12 Walter St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003126.35036 | 2108201.25772 | 37.7688956446503 | -122.43250076301001 | (37.7688956446503, -122.43250076301) | |||
| 34534 | 34534 | 220499 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 12 Walter St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003128.23781 | 2108216.38247 | 37.768937280547796 | -122.432495314901 | (37.7689372805478, -122.432495314901) | |||
| 226 | 226 | 220498 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 217 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/1972 12:00:00 AM | 8 | Width 3ft | Permit Number 11470 | 6001117.07632 | 2105053.576 | 37.760138741716794 | -122.43922504972001 | (37.7601387417168, -122.43922504972) | |
| 160060 | 160060 | 220497 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 4056 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6002735.77101 | 2104758.8012200003 | 37.7594213390286 | -122.433605693472 | (37.7594213390286, -122.433605693472) | |||
| 65235 | 65235 | 220496 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 3953 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003484.16047 | 2101832.5449 | 37.7514289677954 | -122.430808566285 | (37.7514289677954, -122.430808566285) | |||
| 149195 | 149195 | 220495 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 3310 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6007403.70638 | 2105609.21257 | 37.762020122559 | -122.41752191220199 | (37.762020122559, -122.417521912202) | |||
| 150074 | 150074 | 220494 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 3310 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6007380.34256 | 2105603.4804 | 37.7620030686973 | -122.41760231250099 | (37.7620030686973, -122.417602312501) | |||
| 66309 | 66309 | 220493 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 3316 24th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006973.322509999 | 2102070.13094 | 37.7522783945483 | -122.41875944949899 | (37.7522783945483, -122.418759449499) | |||
| 151481 | 151481 | 220492 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 3316 24th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006986.84997 | 2102068.95383 | 37.752275924113704 | -122.418712585824 | (37.7522759241137, -122.418712585824) | |||
| 62145 | 62145 | 220491 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 3316 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6007001.80578 | 2102071.34633 | 37.752283335412706 | -122.418661035797 | (37.7522833354127, -122.418661035797) | |||
| 1577 | 1577 | 220490 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 3040 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/26/2012 12:00:00 AM | 3 | Width 3ft | 6008734.34434 | 2102169.4736599997 | 37.75265016257671 | -122.41267655749901 | (37.7526501625767, -122.412676557499) | ||
| 72520 | 72520 | 220489 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 3347 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006044.722580001 | 2103141.37502 | 37.755167455821706 | -122.422046794428 | (37.7551674558217, -122.422046794428) | |||
| 181067 | 181067 | 220488 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 4276 22nd St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 4ft | 6000665.21266 | 2102890.6244900003 | 37.754174080892795 | -122.44063268295 | (37.7541740808928, -122.44063268295) | |||
| 28198 | 28198 | 220487 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 416 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6000636.08004 | 2101486.04738 | 37.7503157923525 | -122.44063269105499 | (37.7503157923525, -122.440632691055) | |||
| 165105 | 165105 | 220486 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 80 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6005005.11226 | 2096160.1953200002 | 37.73594004669339 | -122.42514535727899 | (37.7359400466934, -122.425145357279) | |||
| 66651 | 66651 | 220485 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2855 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009088.3091 | 2103314.09635 | 37.7558128992489 | -122.41153334289899 | (37.7558128992489, -122.411533342899) | |||
| 161595 | 161595 | 220484 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 3135 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6008130.03653 | 2102087.80047 | 37.752391970833294 | -122.41476058704399 | (37.7523919708333, -122.414760587044) | |||
| 69432 | 69432 | 220483 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 3135 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6008148.36276 | 2102088.69137 | 37.7523954467163 | -122.41469727478399 | (37.7523954467163, -122.414697274784) | |||
| 132940 | 132940 | 220482 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 3135 24th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6008165.93149 | 2102089.85128 | 37.7523996186474 | -122.41463660112 | (37.7523996186474, -122.41463660112) | |||
| 155790 | 155790 | 220481 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 207 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 6008827.74993 | 2097591.67105 | 37.740085772929504 | -122.41203005823601 | (37.7400857729295, -122.412030058236) | |||
| 152580 | 152580 | 220480 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 211 Prentiss St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6008820.1543 | 2097512.38681 | 37.739867649565 | -122.412050719273 | (37.739867649565, -122.412050719273) | |||
| 35513 | 35513 | 220479 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 211 Prentiss St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6008820.53272 | 2097501.66791 | 37.7398382390396 | -122.41204865353501 | (37.7398382390396, -122.412048653535) | |||
| 70375 | 70375 | 220478 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 211 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6008820.95976 | 2097493.32849 | 37.7398153647742 | -122.41204658780599 | (37.7398153647742, -122.412046587806) | |||
| 187239 | 187239 | 220477 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 851 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5998019.7394900005 | 2107271.17336 | 37.766050965816895 | -122.45009705375601 | (37.7660509658169, -122.450097053756) | |||
| 54946 | 54946 | 220476 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 849 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5998017.46753 | 2107292.9322 | 37.7661105800595 | -122.45010648043501 | (37.7661105800595, -122.450106480435) | |||
| 64160 | 64160 | 220475 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1177 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 5997354.16789 | 2106085.5022299998 | 37.7627573058278 | -122.452313556128 | (37.7627573058278, -122.452313556128) | |||
| 170038 | 170038 | 220474 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 275 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6005470.47971 | 2102115.81456 | 37.7523191005603 | -122.423959772048 | (37.7523191005603, -122.423959772048) | |||
| 147401 | 147401 | 220473 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 346 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6005455.91389 | 2101699.1842400003 | 37.7511743076669 | -122.42398051849399 | (37.7511743076669, -122.423980518494) | |||
| 64702 | 64702 | 220472 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 100 Alemany Blvd | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009413.9185 | 2095926.46105 | 37.735546336994794 | -122.409885800206 | (37.7355463369948, -122.409885800206) | |||
| 152475 | 152475 | 220471 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 100 Alemany Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009494.822380001 | 2095997.42417 | 37.735745720287106 | -122.4096110906 | (37.7357457202871, -122.4096110906) | |||
| 171009 | 171009 | 220470 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 100 Alemany Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009551.6866 | 2096070.2477900002 | 37.7359488645495 | -122.409419625821 | (37.7359488645495, -122.409419625821) | |||
| 28822 | 28822 | 220469 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2320 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6009645.3794 | 2103705.18616 | 37.756917975403205 | -122.40963440819701 | (37.7569179754032, -122.409634408197) | |||
| 73736 | 73736 | 220468 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2116 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009545.49702 | 2104860.83383 | 37.760085525251895 | -122.410061423414 | (37.7600855252519, -122.410061423414) | |||
| 38296 | 38296 | 220467 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2104 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6009541.05061 | 2104932.28838 | 37.7602814740251 | -122.41008184609699 | (37.7602814740251, -122.410081846097) | |||
| 167179 | 167179 | 220466 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2044 Bryant St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009529.8002 | 2105117.4753400004 | 37.7607893248 | -122.410133830538 | (37.7607893248, -122.410133830538) | |||
| 134712 | 134712 | 220465 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1900 Bryant St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009493.16635 | 2105815.19005 | 37.7627030371354 | -122.410309795471 | (37.7627030371354, -122.410309795471) | |||
| 188610 | 188610 | 220464 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1900 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009491.007180001 | 2105849.8478099997 | 37.762798078402795 | -122.410319710493 | (37.7627980784028, -122.410319710493) | |||
| 160703 | 160703 | 220463 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1890 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009480.69909 | 2106047.03533 | 37.763338932471704 | -122.41036928652201 | (37.7633389324717, -122.410369286522) | |||
| 177988 | 177988 | 220462 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1890 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009480.1125300005 | 2106070.9553400003 | 37.7634045784729 | -122.410373004307 | (37.7634045784729, -122.410373004307) | |||
| 70543 | 70543 | 220461 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1800 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009467.44865 | 2106293.1677599996 | 37.764014013048 | -122.410432496284 | (37.764014013048, -122.410432496284) | |||
| 66862 | 66862 | 220460 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1801 Bryant St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6009531.1613 | 2106219.4289 | 37.7638151144958 | -122.410206925636 | (37.7638151144958, -122.410206925636) | |||
| 186987 | 186987 | 220459 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1801 Bryant St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6009533.63521 | 2106182.62398 | 37.763714195267205 | -122.410195770427 | (37.7637141952672, -122.410195770427) | |||
| 68410 | 68410 | 220458 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1801 Bryant St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6009537.4352400005 | 2106105.46914 | 37.7635025587051 | -122.41017717965799 | (37.7635025587051, -122.410177179658) | |||
| 159682 | 159682 | 220457 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1801 Bryant St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6009539.42698 | 2106062.60789 | 37.7633849831425 | -122.410167264604 | (37.7633849831425, -122.410167264604) | |||
| 68607 | 68607 | 220456 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1975 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009563.97988 | 2105581.5226 | 37.762065408818394 | -122.410048378728 | (37.7620654088184, -122.410048378728) | |||
| 49678 | 49678 | 220455 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2125 Bryant St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009601.34044 | 2104903.8675599997 | 37.7602068159157 | -122.409871324719 | (37.7602068159157, -122.409871324719) | |||
| 61203 | 61203 | 220454 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2125 Bryant St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009602.63289 | 2104884.15141 | 37.7601527522694 | -122.409865462943 | (37.7601527522694, -122.409865462943) | |||
| 137784 | 137784 | 220453 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2125 Bryant St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009603.845 | 2104860.4986799997 | 37.7600878751631 | -122.409859601148 | (37.7600878751631, -122.409859601148) | |||
| 137283 | 137283 | 220452 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2125 Bryant St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009604.58986 | 2104841.63743 | 37.7600361281884 | -122.409855693597 | (37.7600361281884, -122.409855693597) | |||
| 66162 | 66162 | 220451 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2339 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009708.84031 | 2103735.16133 | 37.7570038363854 | -122.409417051059 | (37.7570038363854, -122.409417051059) | |||
| 135445 | 135445 | 220450 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2464 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009683.32663 | 2103015.52487 | 37.755026446627795 | -122.40945450063299 | (37.7550264466278, -122.409454500633) | |||
| 74647 | 74647 | 220449 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2426 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009674.55848 | 2103178.41544 | 37.7554732163381 | -122.40949631912599 | (37.7554732163381, -122.409496319126) | |||
| 152897 | 152897 | 220448 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2406 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6009671.16306 | 2103239.92595 | 37.7556419201513 | -122.40951240259301 | (37.7556419201513, -122.409512402593) | |||
| 136381 | 136381 | 220447 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2417 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009734.77872 | 2103242.6417 | 37.755652941341296 | -122.409292590292 | (37.7556529413413, -122.409292590292) | |||
| 63579 | 63579 | 220446 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2429 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6009737.03412 | 2103201.22316 | 37.7555393416751 | -122.409281867669 | (37.7555393416751, -122.409281867669) | |||
| 42641 | 42641 | 220445 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2501 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6009766.24645 | 2102672.6598 | 37.7540896615292 | -122.409143546541 | (37.7540896615292, -122.409143546541) | |||
| 68156 | 68156 | 220444 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2521 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6009768.45632 | 2102644.2094099997 | 37.754011666912604 | -122.409133896833 | (37.7540116669126, -122.409133896833) | |||
| 171758 | 171758 | 220443 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2579 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009781.64625 | 2102389.48256 | 37.75331298272479 | -122.40907031025499 | (37.7533129827248, -122.409070310255) | |||
| 36889 | 36889 | 220442 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2601 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009796.152509999 | 2102134.77376 | 37.752614421718505 | -122.40900217402799 | (37.7526144217185, -122.409002174028) | |||
| 166881 | 166881 | 220441 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2601 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009797.097580001 | 2102115.80725 | 37.75256239684371 | -122.408997567676 | (37.7525623968437, -122.408997567676) | |||
| 165470 | 165470 | 220440 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2831 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009868.71469 | 2100872.67042 | 37.7491530301063 | -122.408662212302 | (37.7491530301063, -122.408662212302) | |||
| 35436 | 35436 | 220439 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2865 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009873.7476699995 | 2100752.39413 | 37.7488230598385 | -122.408636324412 | (37.7488230598385, -122.408636324412) | |||
| 185558 | 185558 | 220438 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2814 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6009797.76242 | 2100932.26628 | 37.749312693037 | -122.40891177146001 | (37.749312693037, -122.40891177146) | |||
| 57140 | 57140 | 220437 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2806 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6009797.25951 | 2100951.65905 | 37.7493659131273 | -122.40891487861401 | (37.7493659131273, -122.408914878614) | |||
| 150236 | 150236 | 220436 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2800 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6009792.7974 | 2100982.4644299997 | 37.749450247945106 | -122.40893248196501 | (37.7494502479451, -122.408932481965) | |||
| 169901 | 169901 | 220435 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2680 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009751.75361 | 2101774.10517 | 37.7516216187644 | -122.409130266252 | (37.7516216187644, -122.409130266252) | |||
| 48244 | 48244 | 220434 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2x Coso Ave | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | 6007135.32414 | 2099827.64271 | 37.746130149684 | -122.41804026077601 | (37.746130149684, -122.418040260776) |
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");