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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 245 | 245 | 251255 | Undocumented 2 | Tree(s) :: 17 | 4089x Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991686.0 | 2086822.0 | 37.7095382490701 | -122.47051450746099 | (37.7095382490701, -122.470514507461) | ||||
| 318 | 318 | 142205 | Permitted Site 1 | Tree(s) :: 17 | 1683 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | Permit Number 779644 | 5999834.1012 | 2110180.6204 | 37.774143230926 | -122.44403063203698 | (37.774143230926, -122.444030632037) | ||
| 427 | 427 | 251307 | Undocumented 2 | Tree(s) :: 17 | 200 Cashmere St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6016315.0 | 2096328.0 | 37.7370332293639 | -122.38605389871 | (37.7370332293639, -122.38605389871) | ||||
| 588 | 588 | 251328 | Undocumented 2 | Tree(s) :: 17 | 95x Tompkins Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 779511 | 6007651.0 | 2096616.0 | 37.7373407014575 | -122.416029712695 | (37.7373407014575, -122.416029712695) | |||
| 921 | 921 | 30278 | Permitted Site 1 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 128 | ||||||||||
| 933 | 933 | 203966 | Undocumented 2 | Tree(s) :: 17 | 200 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | Permit Number 779992 | 5992562.812059999 | 2097843.65033 | 37.739851654243296 | -122.46828540055901 | (37.7398516542433, -122.468285400559) | ||
| 1039 | 1039 | 186954 | DPW Maintained 3 | Tree(s) :: 17 | 2800 Sunset Blvd | 28 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 0ft | 5985211.8854 | 2096092.27 | 37.734615522028896 | -122.493572437422 | (37.7346155220289, -122.493572437422) | |||
| 1305 | 1305 | 251497 | Undocumented 2 | Tree(s) :: 17 | 329x Warren Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 5994610.0 | 2103362.0 | 37.7551216790189 | -122.461607123764 | (37.7551216790189, -122.461607123764) | ||||
| 1483 | 1483 | 251556 | Permitted Site 1 | Tree(s) :: 17 | 299 Clinton Park | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004847.0 | 2108161.0 | 37.7688825293039 | -122.42654628279399 | (37.7688825293039, -122.426546282794) | ||||
| 1486 | 1486 | 251555 | Permitted Site 1 | Tree(s) :: 17 | 299 Clinton Park | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004847.0 | 2108161.0 | 37.7688825293039 | -122.42654628279399 | (37.7688825293039, -122.426546282794) | ||||
| 1501 | 1501 | 251554 | Permitted Site 1 | Tree(s) :: 17 | 299 Clinton Park | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004847.0 | 2108161.0 | 37.7688825293039 | -122.42654628279399 | (37.7688825293039, -122.426546282794) | ||||
| 1510 | 1510 | 251552 | Permitted Site 1 | Tree(s) :: 17 | 299 Clinton Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004847.0 | 2108161.0 | 37.7688825293039 | -122.42654628279399 | (37.7688825293039, -122.426546282794) | ||||
| 1659 | 1659 | 251643 | Undocumented 2 | Tree(s) :: 17 | 2701 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6007328.0 | 2121670.0 | 37.8061148757045 | -122.418922903139 | (37.8061148757045, -122.418922903139) | |||
| 1691 | 1691 | 251656 | Undocumented 2 | Tree(s) :: 17 | 31x Malta Dr | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 3x3 | 5999423.0 | 2096089.0 | 37.7354276387403 | -122.44443976141001 | (37.7354276387403, -122.44443976141) | ||||
| 1934 | 1934 | 252840 | Planning Code 138.1 required 4 | Tree(s) :: 17 | 80 Blake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997842.0 | 2113206.0 | 37.782336294689 | -122.45113984781099 | (37.782336294689, -122.451139847811) | ||||
| 1967 | 1967 | 138282 | DPW Maintained 3 | Tree(s) :: 17 | 1202 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | Width 0ft | 6003789.8642 | 2112168.8213 | 37.7798272025121 | -122.430488845982 | (37.7798272025121, -122.430488845982) | |||
| 1972 | 1972 | 252849 | Undocumented 2 | Tree(s) :: 17 | 200 Woodside Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5996376.0 | 2100052.0 | 37.7461347404292 | -122.455260624993 | (37.7461347404292, -122.455260624993) | ||||
| 2006 | 2006 | 252850 | Undocumented 2 | Tree(s) :: 17 | 2 Hernandez Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5996271.0 | 2100083.0 | 37.7462138338134 | -122.45562593978599 | (37.7462138338134, -122.455625939786) | ||||
| 2046 | 2046 | 131756 | Undocumented 2 | Tree(s) :: 17 | 1818 Broadway | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6004733.3748 | 2117781.6991 | 37.795292161346104 | -122.427624834041 | (37.7952921613461, -122.427624834041) | |||
| 2059 | 2059 | 173596 | Significant Tree 6 | Tree(s) :: 17 | 200 Howard St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | Permit Number 779179 | 6014439.0 | 2115766.0 | 37.790301726009204 | -122.393900378517 | (37.7903017260092, -122.393900378517) | |||
| 2228 | 2228 | 167815 | Undocumented 2 | Tree(s) :: 17 | 282 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 3ft | Permit Number 780344 | 6004374.21371 | 2109126.69451 | 37.771507353225395 | -122.42825045191799 | (37.7715073532254, -122.428250451918) | ||
| 2470 | 2470 | 211684 | Undocumented 2 | Tree(s) :: 17 | 95 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | Permit Number 780277 | 5995309.61761 | 2090529.04665 | 37.719925789337296 | -122.458258879737 | (37.7199257893373, -122.458258879737) | ||
| 2476 | 2476 | 212596 | Undocumented 2 | Tree(s) :: 17 | 310 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | Permit Number 780017 | 5994766.80041 | 2090657.2902900001 | 37.7202467087903 | -122.46014448379299 | (37.7202467087903, -122.460144483793) | ||
| 2478 | 2478 | 211685 | Undocumented 2 | Tree(s) :: 17 | 95 Miramar Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | Permit Number 780277 | 5995307.7579 | 2090507.37878 | 37.7198661876486 | -122.458263740606 | (37.7198661876486, -122.458263740606) | ||
| 2482 | 2482 | 245639 | Undocumented 2 | Tree(s) :: 17 | 910 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6007964.74692 | 2102552.0898 | 37.7536575156842 | -122.415365052856 | (37.7536575156842, -122.415365052856) | |||
| 2497 | 2497 | 252857 | Undocumented 2 | Tree(s) :: 17 | 124 Persia Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | Permit Number 780172 | 6002102.0 | 2091308.0 | 37.7224525933916 | -122.43483567372 | (37.7224525933916, -122.43483567372) | |||
| 2644 | 2644 | 124734 | Permitted Site 1 | Tree(s) :: 17 | 999 Brannan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6010535.71931722 | 2108464.76902983 | 37.7700365636667 | -122.406890710328 | (37.7700365636667, -122.406890710328) | |||||
| 2977 | 2977 | 10292 | DPW Maintained 3 | Tree(s) :: 17 | 488 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 26 | 3x4 | 6003826.4075 | 2109393.9739 | 37.7722102257422 | -122.43016441338301 | (37.7722102257422, -122.430164413383) | |||
| 3070 | 3070 | 116407 | Permitted Site 1 | Tree(s) :: 17 | 600 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 6010620.1417 | 2118945.4017 | 37.798818623722 | -122.40733765055599 | (37.798818623722, -122.407337650556) | ||||
| 3191 | 3191 | 21648 | DPW Maintained 3 | Tree(s) :: 17 | 1660 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X2 | 6004632.9541 | 2114713.0403 | 37.7868607185832 | -122.427753554263 | (37.7868607185832, -122.427753554263) | |||
| 4002 | 4002 | 253607 | Undocumented 2 | Tree(s) :: 17 | 499x Natoma St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010464.0 | 2112150.0 | 37.7801513385768 | -122.407398630227 | (37.7801513385768, -122.407398630227) | ||||
| 4085 | 4085 | 101532 | Undocumented 2 | Tree(s) :: 17 | 11323 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | |||||||||
| 4089 | 4089 | 253606 | Undocumented 2 | Tree(s) :: 17 | 499x Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010464.0 | 2112150.0 | 37.7801513385768 | -122.407398630227 | (37.7801513385768, -122.407398630227) | ||||
| 4552 | 4552 | 97357 | Permitted Site 1 | Tree(s) :: 17 | 7 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | |||||||||||
| 4719 | 4719 | 253672 | DPW Maintained 3 | Tree(s) :: 17 | 390 06th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 3x3 | 6011351.0 | 2111108.0 | 37.7773398544385 | -122.404256716486 | (37.7773398544385, -122.404256716486) | |||
| 4740 | 4740 | 124733 | Permitted Site 1 | Tree(s) :: 17 | 999 Brannan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6010535.71931722 | 2108464.76902983 | 37.7700365636667 | -122.406890710328 | (37.7700365636667, -122.406890710328) | |||||
| 4863 | 4863 | 253702 | Undocumented 2 | Tree(s) :: 17 | 293 Capp St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007203.0 | 2105623.0 | 37.76204668432629 | -122.41821705685899 | (37.7620466843263, -122.418217056859) | ||||
| 4865 | 4865 | 253699 | Undocumented 2 | Tree(s) :: 17 | 3076 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000057.0 | 2105400.0 | 37.761029556529294 | -122.44291621566002 | (37.7610295565293, -122.44291621566) | ||||
| 4870 | 4870 | 253696 | Undocumented 2 | Tree(s) :: 17 | 235 Laussat St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 3ft | 6003605.0 | 2109124.0 | 37.77145640087421 | -122.430911009882 | (37.7714564008742, -122.430911009882) | ||||
| 4871 | 4871 | 253700 | Undocumented 2 | Tree(s) :: 17 | 293 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007203.0 | 2105623.0 | 37.76204668432629 | -122.41821705685899 | (37.7620466843263, -122.418217056859) | ||||
| 4913 | 4913 | 97358 | Permitted Site 1 | Tree(s) :: 17 | 8 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | |||||||||||
| 5789 | 5789 | 48478 | Permitted Site 1 | Tree(s) :: 17 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 45832 | ||||||||||
| 6372 | 6372 | 124739 | Permitted Site 1 | Tree(s) :: 17 | 999 Brannan St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6010535.71931722 | 2108464.76902983 | 37.7700365636667 | -122.406890710328 | (37.7700365636667, -122.406890710328) | |||||
| 6539 | 6539 | 48476 | Permitted Site 1 | Tree(s) :: 17 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 45832 | ||||||||||
| 6689 | 6689 | 34917 | Permitted Site 1 | Tree(s) :: 17 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 38517 | ||||||||||
| 6769 | 6769 | 124735 | Permitted Site 1 | Tree(s) :: 17 | 999 Brannan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6010535.71931722 | 2108464.76902983 | 37.7700365636667 | -122.406890710328 | (37.7700365636667, -122.406890710328) | |||||
| 6922 | 6922 | 48488 | Permitted Site 1 | Tree(s) :: 17 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 45832 | ||||||||||
| 6984 | 6984 | 34915 | Permitted Site 1 | Tree(s) :: 17 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 38517 | ||||||||||
| 7004 | 7004 | 124738 | Permitted Site 1 | Tree(s) :: 17 | 999 Brannan St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6010535.71931722 | 2108464.76902983 | 37.7700365636667 | -122.406890710328 | (37.7700365636667, -122.406890710328) | |||||
| 7011 | 7011 | 97356 | Permitted Site 1 | Tree(s) :: 17 | 6 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | |||||||||||
| 7040 | 7040 | 97351 | Permitted Site 1 | Tree(s) :: 17 | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | |||||||||||
| 7186 | 7186 | 124737 | Permitted Site 1 | Tree(s) :: 17 | 999 Brannan St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6010535.71931722 | 2108464.76902983 | 37.7700365636667 | -122.406890710328 | (37.7700365636667, -122.406890710328) | |||||
| 7310 | 7310 | 48473 | Permitted Site 1 | Tree(s) :: 17 | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 45832 | ||||||||||
| 7352 | 7352 | 48471 | Permitted Site 1 | Tree(s) :: 17 | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 45832 | ||||||||||
| 7602 | 7602 | 124740 | Permitted Site 1 | Tree(s) :: 17 | 999 Brannan St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6010535.71931722 | 2108464.76902983 | 37.7700365636667 | -122.406890710328 | (37.7700365636667, -122.406890710328) | |||||
| 7891 | 7891 | 48474 | Permitted Site 1 | Tree(s) :: 17 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 45832 | ||||||||||
| 8467 | 8467 | 56665 | Permitted Site 1 | Tree(s) :: 17 | 4549 Callan Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | ||||||||||
| 8657 | 8657 | 97354 | Permitted Site 1 | Tree(s) :: 17 | 4 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | |||||||||||
| 8812 | 8812 | 124736 | Permitted Site 1 | Tree(s) :: 17 | 999 Brannan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6010535.71931722 | 2108464.76902983 | 37.7700365636667 | -122.406890710328 | (37.7700365636667, -122.406890710328) | |||||
| 9037 | 9037 | 169234 | Undocumented 2 | Tree(s) :: 17 | 695 Minna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6009012.0 | 2111041.0 | 37.7770249114115 | -122.41234337077199 | (37.7770249114115, -122.412343370772) | |||
| 9042 | 9042 | 27384 | DPW Maintained 3 | Tree(s) :: 17 | 2200 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | Permit Number 779236 | 6007162.48532 | 2119880.42159 | 37.801191826388504 | -122.41936866015101 | (37.8011918263885, -122.419368660151) | ||
| 9613 | 9613 | 34916 | Permitted Site 1 | Tree(s) :: 17 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 38517 | ||||||||||
| 9920 | 9920 | 173743 | Undocumented 2 | Tree(s) :: 17 | 530 Molimo Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997387.0 | 2097791.0 | 37.7399845403322 | -122.45160167056801 | (37.7399845403322, -122.451601670568) | ||||
| 9923 | 9923 | 173740 | Undocumented 2 | Tree(s) :: 17 | 2500X Lyon St | 7 | Median : Yard 3 | Tree 1 | Private 1 | 3x3 | 5999276.0 | 2117538.0 | 37.794312827392396 | -122.446490617691 | (37.7943128273924, -122.446490617691) | ||||
| 9924 | 9924 | 173738 | Undocumented 2 | Tree(s) :: 17 | 2500X Lyon St | 5 | Median : Yard 3 | Tree 1 | Private 1 | 3x3 | 5999276.0 | 2117538.0 | 37.794312827392396 | -122.446490617691 | (37.7943128273924, -122.446490617691) | ||||
| 10010 | 10010 | 173778 | Significant Tree 6 | Tree(s) :: 17 | 99X Cleveland St | 1 | Side Yard : Cutout 18 | Tree 1 | Private 1 | 3x3 | 6010549.0 | 2110746.0 | 37.7763010397716 | -122.40700558704799 | (37.7763010397716, -122.407005587048) | ||||
| 10027 | 10027 | 122385 | Undocumented 2 | Tree(s) :: 17 | 1642 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | Permit Number 778904 | 5990935.0 | 2104213.0 | 37.7572460781285 | -122.474378311379 | (37.7572460781285, -122.474378311379) | ||
| 10133 | 10133 | 173865 | Undocumented 2 | Tree(s) :: 17 | 325 Berry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013725.0 | 2109678.0 | 37.77354576620421 | -122.395943986686 | (37.7735457662042, -122.395943986686) | ||||
| 10135 | 10135 | 173864 | Undocumented 2 | Tree(s) :: 17 | 300 Berry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013804.0 | 2109844.0 | 37.7740059597011 | -122.39568234515801 | (37.7740059597011, -122.395682345158) | ||||
| 10150 | 10150 | 105688 | Undocumented 2 | Tree(s) :: 17 | 635 08TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 4x4 | Permit Number 771004 | 6011418.5 | 2109097.9 | 37.7718243537934 | -122.40388172759701 | (37.7718243537934, -122.403881727597) | ||
| 10152 | 10152 | 105682 | Undocumented 2 | Tree(s) :: 17 | 899X BRANNAN ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 4x4 | Permit Number 771004 | 6011295.0 | 2109227.0 | 37.7721719324444 | -122.40431801309799 | (37.7721719324444, -122.404318013098) | ||
| 10169 | 10169 | 105680 | Undocumented 2 | Tree(s) :: 17 | 620 07TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x3 | Permit Number 771004 | 6011709.5 | 2109428.5 | 37.7727483590072 | -122.402898388879 | (37.7727483590072, -122.402898388879) | ||
| 10176 | 10176 | 105681 | Undocumented 2 | Tree(s) :: 17 | 899X BRANNAN ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 4x4 | Permit Number 771004 | 6011295.0 | 2109227.0 | 37.7721719324444 | -122.40431801309799 | (37.7721719324444, -122.404318013098) | ||
| 10188 | 10188 | 105683 | Undocumented 2 | Tree(s) :: 17 | 899X BRANNAN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 4x4 | Permit Number 771004 | 6011295.0 | 2109227.0 | 37.7721719324444 | -122.40431801309799 | (37.7721719324444, -122.404318013098) | ||
| 10189 | 10189 | 105689 | Undocumented 2 | Tree(s) :: 17 | 635 08TH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | Permit Number 771004 | 6011418.5 | 2109097.9 | 37.7718243537934 | -122.40388172759701 | (37.7718243537934, -122.403881727597) | ||
| 10198 | 10198 | 105687 | Undocumented 2 | Tree(s) :: 17 | 635 08TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 4x4 | Permit Number 771004 | 6011418.5 | 2109097.9 | 37.7718243537934 | -122.40388172759701 | (37.7718243537934, -122.403881727597) | ||
| 10222 | 10222 | 173923 | DPW Maintained 3 | Tree(s) :: 17 | 2160X 09th Ave | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 6x10 | 5993671.0 | 2100995.0 | 37.7485684085064 | -122.464682560698 | (37.7485684085064, -122.464682560698) | ||||
| 10224 | 10224 | 173918 | DPW Maintained 3 | Tree(s) :: 17 | 2160X 09th Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 6x10 | 5993671.0 | 2100995.0 | 37.7485684085064 | -122.464682560698 | (37.7485684085064, -122.464682560698) | ||||
| 10225 | 10225 | 173920 | DPW Maintained 3 | Tree(s) :: 17 | 2160X 09th Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 6x10 | 5993671.0 | 2100995.0 | 37.7485684085064 | -122.464682560698 | (37.7485684085064, -122.464682560698) | ||||
| 10227 | 10227 | 173914 | DPW Maintained 3 | Tree(s) :: 17 | 2160X 09th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6x10 | 5993671.0 | 2100995.0 | 37.7485684085064 | -122.464682560698 | (37.7485684085064, -122.464682560698) | ||||
| 10228 | 10228 | 173922 | DPW Maintained 3 | Tree(s) :: 17 | 2160X 09th Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 6x10 | 5993671.0 | 2100995.0 | 37.7485684085064 | -122.464682560698 | (37.7485684085064, -122.464682560698) | ||||
| 10230 | 10230 | 173919 | DPW Maintained 3 | Tree(s) :: 17 | 2160X 09th Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 6x10 | 5993671.0 | 2100995.0 | 37.7485684085064 | -122.464682560698 | (37.7485684085064, -122.464682560698) | ||||
| 10232 | 10232 | 173916 | DPW Maintained 3 | Tree(s) :: 17 | 2160X 09th Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 6x10 | 5993671.0 | 2100995.0 | 37.7485684085064 | -122.464682560698 | (37.7485684085064, -122.464682560698) | ||||
| 10233 | 10233 | 173917 | DPW Maintained 3 | Tree(s) :: 17 | 2160X 09th Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 6x10 | 5993671.0 | 2100995.0 | 37.7485684085064 | -122.464682560698 | (37.7485684085064, -122.464682560698) | ||||
| 10237 | 10237 | 173915 | DPW Maintained 3 | Tree(s) :: 17 | 2160X 09th Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 6x10 | 5993671.0 | 2100995.0 | 37.7485684085064 | -122.464682560698 | (37.7485684085064, -122.464682560698) | ||||
| 10238 | 10238 | 173921 | DPW Maintained 3 | Tree(s) :: 17 | 2160X 09th Ave | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 6x10 | 5993671.0 | 2100995.0 | 37.7485684085064 | -122.464682560698 | (37.7485684085064, -122.464682560698) | ||||
| 10254 | 10254 | 173937 | Permitted Site 1 | Tree(s) :: 17 | 4695 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999956.94577188 | 2105141.0371168 | 37.7603128035628 | -122.44324365859501 | (37.7603128035628, -122.443243658595) | |||||
| 10573 | 10573 | 34914 | Permitted Site 1 | Tree(s) :: 17 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 38517 | ||||||||||
| 10631 | 10631 | 97353 | Permitted Site 1 | Tree(s) :: 17 | 3 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | |||||||||||
| 10680 | 10680 | 48485 | Permitted Site 1 | Tree(s) :: 17 | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 45832 | ||||||||||
| 10892 | 10892 | 112910 | Undocumented 2 | Tree(s) :: 17 | 1899X Beach St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | ||||||||||
| 10982 | 10982 | 34919 | Permitted Site 1 | Tree(s) :: 17 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 38517 | ||||||||||
| 11641 | 11641 | 96232 | Permitted Site 1 | Tree(s) :: 17 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | ||||||||||||
| 12108 | 12108 | 48475 | Permitted Site 1 | Tree(s) :: 17 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 45832 | ||||||||||
| 12163 | 12163 | 48472 | Permitted Site 1 | Tree(s) :: 17 | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 45832 | ||||||||||
| 12550 | 12550 | 48469 | Permitted Site 1 | Tree(s) :: 17 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 45832 | ||||||||||
| 12744 | 12744 | 56667 | Permitted Site 1 | Tree(s) :: 17 | 495 Callan Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | ||||||||||
| 12938 | 12938 | 34921 | Permitted Site 1 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 38517 | ||||||||||
| 13253 | 13253 | 187616 | Undocumented 2 | Tree(s) :: 17 | 55 Hawthorne St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013035.0 | 2114021.0 | 37.785432237020004 | -122.398635644163 | (37.78543223702, -122.398635644163) | ||||
| 13257 | 13257 | 187617 | Undocumented 2 | Tree(s) :: 17 | 55 Hawthorne St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013035.0 | 2114021.0 | 37.785432237020004 | -122.398635644163 | (37.78543223702, -122.398635644163) |
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");