Data source: data.sfgov.org
This data as json, CSV (advanced)
These facets timed out: qSiteInfo
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 66528 | 66528 | 142128 | Undocumented 2 | :: 54 | 10 HEMWAY TER | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5998660.4892 | 2110810.2219 | 37.775804936046704 | -122.448135688829 | (37.7758049360467, -122.448135688829) | |||
| 66691 | 66691 | 142129 | Undocumented 2 | :: 54 | 10 HEMWAY TER | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5998655.1761 | 2110837.1975 | 37.775878700373895 | -122.448156010928 | (37.7758787003739, -122.448156010928) | |||
| 77581 | 77581 | 33407 | Permitted Site 1 | :: 54 | 100 Ulloa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1996 12:00:00 AM | Permit Number 37523 | 5996457.34152631 | 2099451.4193202 | 37.7444903608651 | -122.454935970247 | (37.7444903608651, -122.454935970247) | ||
| 79062 | 79062 | 33409 | Permitted Site 1 | :: 54 | 100 Ulloa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1996 12:00:00 AM | Permit Number 37523 | 5996457.34152631 | 2099451.4193202 | 37.7444903608651 | -122.454935970247 | (37.7444903608651, -122.454935970247) | ||
| 87303 | 87303 | 33408 | Permitted Site 1 | :: 54 | 100 Ulloa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1996 12:00:00 AM | Permit Number 37523 | 5996457.34152631 | 2099451.4193202 | 37.7444903608651 | -122.454935970247 | (37.7444903608651, -122.454935970247) | ||
| 91200 | 91200 | 33411 | Permitted Site 1 | :: 54 | 100 Ulloa St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1996 12:00:00 AM | Permit Number 37523 | 5996457.34152631 | 2099451.4193202 | 37.7444903608651 | -122.454935970247 | (37.7444903608651, -122.454935970247) | ||
| 99156 | 99156 | 33410 | Permitted Site 1 | :: 54 | 100 Ulloa St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1996 12:00:00 AM | Permit Number 37523 | 5996457.34152631 | 2099451.4193202 | 37.7444903608651 | -122.454935970247 | (37.7444903608651, -122.454935970247) | ||
| 140197 | 140197 | 33406 | Permitted Site 1 | :: 54 | 100 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1996 12:00:00 AM | Permit Number 37523 | 5996457.34152631 | 2099451.4193202 | 37.7444903608651 | -122.454935970247 | (37.7444903608651, -122.454935970247) | ||
| 25062 | 25062 | 247418 | Undocumented 2 | :: 54 | 1001 Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6002608.194 | 2110213.5869 | 37.7743916070028 | -122.43443692499599 | (37.7743916070028, -122.434436924996) | |||
| 34444 | 34444 | 139926 | Undocumented 2 | :: 54 | 1001 TURK ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6005215.378 | 2112666.1069 | 37.78127327564229 | -122.425592763682 | (37.7812732756423, -122.425592763682) | |||
| 64371 | 64371 | 248338 | Undocumented 2 | :: 54 | 101 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5998210.6283 | 2108198.2582 | 37.7686074267176 | -122.44950361782 | (37.7686074267176, -122.44950361782) | |||
| 171847 | 171847 | 245199 | Undocumented 2 | :: 54 | 101 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6001311.3344 | 2109146.8192 | 37.771388829884 | -122.43884653486 | (37.771388829884, -122.43884653486) | |||
| 36431 | 36431 | 137758 | Undocumented 2 | :: 54 | 101 Saint Joseph's Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000707.9938 | 2112291.934 | 37.7799901751967 | -122.44115920153799 | (37.7799901751967, -122.441159201538) | |||
| 60095 | 60095 | 137739 | Undocumented 2 | :: 54 | 101 Saint Joseph's Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000676.859 | 2112512.2466 | 37.7805933238275 | -122.441282722586 | (37.7805933238275, -122.441282722586) | |||
| 156661 | 156661 | 137740 | Undocumented 2 | :: 54 | 101 Saint Joseph's Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000679.5664 | 2112493.295 | 37.7805414418009 | -122.441271996241 | (37.7805414418009, -122.441271996241) | |||
| 153937 | 153937 | 247379 | Undocumented 2 | :: 54 | 1015 Oak St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6002146.8166 | 2109803.9081 | 37.7732405306973 | -122.436003592649 | (37.7732405306973, -122.436003592649) | |||
| 164210 | 164210 | 247384 | Undocumented 2 | :: 54 | 1021 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6002057.9469 | 2109793.0538 | 37.7732056784261 | -122.436310227416 | (37.7732056784261, -122.436310227416) | |||
| 83254 | 83254 | 110159 | Permitted Site 1 | :: 54 | 1041 Broadway | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Permit Number 55966 | 6008597.3 | 2118278.8 | 37.7968748776387 | -122.414290174718 | (37.7968748776387, -122.414290174718) | |||
| 181617 | 181617 | 200202 | Undocumented 2 | :: 54 | 1090 Ingerson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6013720.7054 | 2090215.6197 | 37.72010595277 | -122.394595711042 | (37.72010595277, -122.394595711042) | |||
| 92851 | 92851 | 7876 | DPW Maintained 3 | :: 54 | 1095X Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/04/2011 12:00:00 AM | 3 | 3x3 | 6006012.62101 | 2113826.37447 | 37.784504100894395 | -122.42291717866101 | (37.7845041008944, -122.422917178661) | ||
| 137463 | 137463 | 142105 | Undocumented 2 | :: 54 | 11 HEMWAY TER | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5998624.9098 | 2110833.4671 | 37.7758667273984 | -122.44826044071199 | (37.7758667273984, -122.448260440712) | |||
| 62615 | 62615 | 142063 | Undocumented 2 | :: 54 | 1100 GOLDEN GATE AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004132.6367 | 2112218.0001 | 37.779981646673896 | -122.42930655266399 | (37.7799816466739, -122.429306552664) | |||
| 24523 | 24523 | 141857 | Undocumented 2 | :: 54 | 1100 TURK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004651.3626 | 2112630.8889 | 37.781144690344895 | -122.42754147050199 | (37.7811446903449, -122.427541470502) | |||
| 185965 | 185965 | 140443 | Undocumented 2 | :: 54 | 1101 FILLMORE ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6003331.4074 | 2112177.9445 | 37.7798262712775 | -122.432075500833 | (37.7798262712775, -122.432075500833) | |||
| 75169 | 75169 | 141944 | Undocumented 2 | :: 54 | 1101 GOLDEN GATE AVE | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004183.4678 | 2112169.0928 | 37.779850236925 | -122.429127216952 | (37.779850236925, -122.429127216952) | |||
| 105066 | 105066 | 141940 | Undocumented 2 | :: 54 | 1101 GOLDEN GATE AVE | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004067.7741 | 2112149.004 | 37.7797885282032 | -122.42952601949499 | (37.7797885282032, -122.429526019495) | |||
| 163263 | 163263 | 141945 | Undocumented 2 | :: 54 | 1101 GOLDEN GATE AVE | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004212.2215 | 2112170.9783 | 37.7798570416861 | -122.429027879664 | (37.7798570416861, -122.429027879664) | |||
| 31028 | 31028 | 139809 | Undocumented 2 | :: 54 | 1101 GOUGH ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6005660.0139 | 2112868.3262 | 37.7818536339515 | -122.424068925498 | (37.7818536339515, -122.424068925498) | |||
| 518 | 518 | 251314 | Planning Code 138.1 required 4 | :: 54 | 1108 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001901.0 | 2100825.0 | 37.7485726639367 | -122.43621121860001 | (37.7485726639367, -122.4362112186) | ||||
| 28625 | 28625 | 217557 | Undocumented 2 | :: 54 | 111 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5995778.3452 | 2088036.9975 | 37.7131101315221 | -122.456458551068 | (37.7131101315221, -122.456458551068) | |||
| 88179 | 88179 | 105438 | Undocumented 2 | :: 54 | 1116 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002483.0 | 2102334.0 | 37.75274907025911 | -122.43430654109899 | (37.7527490702591, -122.434306541099) | ||||
| 104872 | 104872 | 105437 | Undocumented 2 | :: 54 | 1116 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002483.0 | 2102334.0 | 37.75274907025911 | -122.43430654109899 | (37.7527490702591, -122.434306541099) | ||||
| 68603 | 68603 | 142716 | DPW Maintained 3 | :: 54 | 1120 COLUMBUS AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6008073.8404 | 2121121.2819 | 37.804650203273 | -122.416302902461 | (37.804650203273, -122.416302902461) | |||
| 76283 | 76283 | 244483 | Undocumented 2 | :: 54 | 1124 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6001145.6174 | 2109366.8236 | 37.7719834774065 | -122.439435529733 | (37.7719834774065, -122.439435529733) | |||
| 127351 | 127351 | 35482 | Permitted Site 1 | :: 54 | 1136 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/16/2000 12:00:00 AM | Permit Number 40088 | 6008340.04148266 | 2093836.36406151 | 37.7297471396453 | -122.413450843683 | (37.7297471396453, -122.413450843683) | ||
| 144324 | 144324 | 120651 | Undocumented 2 | :: 54 | 114 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005371.0 | 2102934.0 | 37.7545600310384 | -122.424361977892 | (37.7545600310384, -122.424361977892) | ||||
| 37734 | 37734 | 137587 | Undocumented 2 | :: 54 | 1150 PIERCE ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6002352.8955 | 2112542.7356 | 37.78077237103221 | -122.435486703411 | (37.7807723710322, -122.435486703411) | |||
| 74459 | 74459 | 137586 | Undocumented 2 | :: 54 | 1150 PIERCE ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6002357.4789 | 2112504.0318 | 37.7806663604621 | -122.435468077701 | (37.7806663604621, -122.435468077701) | |||
| 135485 | 135485 | 137588 | Undocumented 2 | :: 54 | 1150 PIERCE ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6002345.2566 | 2112562.5967 | 37.7808264707559 | -122.435514551268 | (37.7808264707559, -122.435514551268) | |||
| 136289 | 136289 | 137589 | Undocumented 2 | :: 54 | 1150 PIERCE ST | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6002346.2752 | 2112589.0782 | 37.780899240130296 | -122.435512922421 | (37.7808992401303, -122.435512922421) | |||
| 36850 | 36850 | 141882 | Undocumented 2 | :: 54 | 1160 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6003839.6945 | 2112655.4467 | 37.7811661774464 | -122.430351190021 | (37.7811661774464, -122.430351190021) | |||
| 161 | 161 | 142720 | Undocumented 2 | :: 54 | 1170 COLUMBUS AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6007999.4825 | 2121188.7351 | 37.8048312311886 | -122.416565007078 | (37.8048312311886, -122.416565007078) | ||||
| 39749 | 39749 | 139753 | Undocumented 2 | :: 54 | 1171 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6005547.6328 | 2113641.325 | 37.7839697525349 | -122.424512713511 | (37.7839697525349, -122.424512713511) | |||
| 39107 | 39107 | 139604 | Undocumented 2 | :: 54 | 1173 SCOTT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6001838.238 | 2112425.6952 | 37.7804217645564 | -122.437258767268 | (37.7804217645564, -122.437258767268) | |||
| 172283 | 172283 | 200182 | Undocumented 2 | :: 54 | 1175 Ingerson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6013359.1884 | 2090422.8715 | 37.720654919465396 | -122.395859877099 | (37.7206549194654, -122.395859877099) | |||
| 31430 | 31430 | 141865 | Undocumented 2 | :: 54 | 1198 TURK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004361.706 | 2112589.3295 | 37.7810141909048 | -122.42854057505699 | (37.7810141909048, -122.428540575057) | |||
| 125370 | 125370 | 3826 | DPW Maintained 3 | :: 54 | 120 Cashmere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/16/1992 12:00:00 AM | 3 | 3X3 | 6016868.5122165 | 2095917.6664165 | 37.7359371538987 | -122.384111573291 | (37.7359371538987, -122.384111573291) | ||
| 33464 | 33464 | 200884 | Undocumented 2 | :: 54 | 1200 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6012817.0471 | 2107089.1245 | 37.7663867409086 | -122.39890301603998 | (37.7663867409086, -122.39890301604) | |||
| 36416 | 36416 | 183338 | Undocumented 2 | :: 54 | 1200 La Playa | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5980889.0479 | 2106803.3028 | 37.7637711641625 | -122.50931286551399 | (37.7637711641625, -122.509312865514) | |||
| 155391 | 155391 | 183316 | Undocumented 2 | :: 54 | 1201 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5983946.4232 | 2106931.1378 | 37.764301953552106 | -122.498747951587 | (37.7643019535521, -122.498747951587) | |||
| 2270 | 2270 | 253008 | Permitted Site 1 | :: 54 | 1201 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 07/10/2017 12:00:00 AM | 3 | 11x477 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | ||
| 91154 | 91154 | 109365 | Permitted Site 1 | :: 54 | 1205 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | FUF 1 | 02/11/2015 12:00:00 AM | 3 | 4.5x16 | 6007075.4 | 2119431.2 | 37.7999534721279 | -122.419638123127 | (37.7999534721279, -122.419638123127) | |
| 101115 | 101115 | 109364 | Permitted Site 1 | :: 54 | 1205 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | FUF 1 | 02/11/2015 12:00:00 AM | 3 | 4.5x6 | 6007075.4 | 2119431.2 | 37.7999534721279 | -122.419638123127 | (37.7999534721279, -122.419638123127) | |
| 116207 | 116207 | 109368 | Permitted Site 1 | :: 54 | 1205 Filbert St | 5 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | FUF 1 | 02/11/2015 12:00:00 AM | 3 | 3x22 | 6007075.4 | 2119431.2 | 37.7999534721279 | -122.419638123127 | (37.7999534721279, -122.419638123127) | |
| 124298 | 124298 | 109367 | Permitted Site 1 | :: 54 | 1205 Filbert St | 4 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | FUF 1 | 02/11/2015 12:00:00 AM | 3 | 4.5x6.5 | 6007075.4 | 2119431.2 | 37.7999534721279 | -122.419638123127 | (37.7999534721279, -122.419638123127) | |
| 43479 | 43479 | 122819 | Undocumented 2 | :: 54 | 121 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003309.0 | 2094407.0 | 37.7310302083694 | -122.430884409483 | (37.7310302083694, -122.430884409483) | ||||
| 28027 | 28027 | 140087 | Undocumented 2 | :: 54 | 1210 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6001853.1286 | 2112643.6389 | 37.781021029267706 | -122.43722286326 | (37.7810210292677, -122.43722286326) | |||
| 25969 | 25969 | 183335 | Undocumented 2 | :: 54 | 1211 43rd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5982706.9565 | 2106839.0545 | 37.7639763455704 | -122.503028028557 | (37.7639763455704, -122.503028028557) | |||
| 162629 | 162629 | 183334 | Undocumented 2 | :: 54 | 1211 43rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5982706.9565 | 2106844.4908 | 37.7639912720976 | -122.503028431048 | (37.7639912720976, -122.503028431048) | |||
| 178886 | 178886 | 183351 | Undocumented 2 | :: 54 | 1214 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5981199.8295 | 2106780.9272 | 37.7637280462203 | -122.508236325462 | (37.7637280462203, -122.508236325462) | |||
| 38433 | 38433 | 181714 | Undocumented 2 | :: 54 | 1215 29th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5987051.5149 | 2106949.2334 | 37.764533265698 | -122.488009786224 | (37.764533265698, -122.488009786224) | |||
| 170682 | 170682 | 181751 | Undocumented 2 | :: 54 | 1215 33rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5985811.8134 | 2106917.8782 | 37.764374776294396 | -122.49229520775299 | (37.7643747762944, -122.492295207753) | |||
| 71051 | 71051 | 183339 | Undocumented 2 | :: 54 | 1219 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5983948.7419 | 2106852.4379 | 37.7640860018935 | -122.498734117688 | (37.7640860018935, -122.498734117688) | |||
| 158214 | 158214 | 183340 | Undocumented 2 | :: 54 | 1219 39th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5983949.2875 | 2106832.797 | 37.7640321055392 | -122.498730779597 | (37.7640321055392, -122.498730779597) | |||
| 171383 | 171383 | 183348 | Undocumented 2 | :: 54 | 1222 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5983373.4277 | 2106798.2891 | 37.76390356553 | -122.500719925068 | (37.76390356553, -122.500719925068) | |||
| 148856 | 148856 | 139245 | Undocumented 2 | :: 54 | 1223 WEBSTER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6003686.6496 | 2113074.8565 | 37.7823091017787 | -122.430910590356 | (37.7823091017787, -122.430910590356) | |||
| 29815 | 29815 | 181758 | Undocumented 2 | :: 54 | 1230 36th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5984924.8270000005 | 2106814.5562 | 37.764039188732205 | -122.495355380579 | (37.7640391887322, -122.495355380579) | |||
| 157121 | 157121 | 181768 | Undocumented 2 | :: 54 | 1235 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5985194.4062 | 2106785.0805 | 37.7639740372115 | -122.49442082615101 | (37.7639740372115, -122.494420826151) | |||
| 53583 | 53583 | 183266 | Undocumented 2 | :: 54 | 1235 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5982090.5566 | 2106669.6909 | 37.7634750727275 | -122.50514738366999 | (37.7634750727275, -122.50514738367) | |||
| 145543 | 145543 | 111758 | Permitted Site 1 | :: 54 | 1235 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 06/23/2015 12:00:00 AM | 3 | 6x6 | 5981472.7 | 2106671.7 | 37.7634442160317 | -122.50728446314301 | (37.7634442160317, -122.507284463143) | ||
| 124217 | 124217 | 37151 | Permitted Site 1 | :: 54 | 124 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/09/2015 12:00:00 AM | 3 | 4.5x10 | Permit Number 775446 | 6005712.42544702 | 2100249.055732 | 37.7472070660376 | -122.42299041598 | (37.7472070660376, -122.42299041598) |
| 131382 | 131382 | 141119 | Undocumented 2 | :: 54 | 124 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5998714.1818 | 2112720.5452 | 37.7810532591781 | -122.448087532266 | (37.7810532591781, -122.448087532266) | |||
| 39404 | 39404 | 181754 | Undocumented 2 | :: 54 | 1240 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5987099.9397 | 2106850.6122 | 37.7642653039062 | -122.487835053811 | (37.7642653039062, -122.487835053811) | |||
| 147521 | 147521 | 183670 | Undocumented 2 | :: 54 | 1247 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5984264.9056 | 2106671.7145 | 37.7636083244569 | -122.49762727229799 | (37.7636083244569, -122.497627272298) | |||
| 175934 | 175934 | 140091 | Undocumented 2 | :: 54 | 1250 Scott St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6001831.6388 | 2112795.421 | 37.781436562836106 | -122.43730807844801 | (37.7814365628361, -122.437308078448) | |||
| 26862 | 26862 | 245988 | Undocumented 2 | :: 54 | 1250 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5999884.6674 | 2108495.9392 | 37.76952040656629 | -122.44373466044901 | (37.7695204065663, -122.443734660449) | |||
| 36422 | 36422 | 181608 | Undocumented 2 | :: 54 | 1251 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5986743.9567 | 2106741.3672 | 37.763944576281794 | -122.489058249622 | (37.7639445762818, -122.489058249622) | |||
| 170057 | 170057 | 181617 | Undocumented 2 | :: 54 | 1251 35th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5985198.7047 | 2106674.5469 | 37.7636707944731 | -122.494397810738 | (37.7636707944731, -122.494397810738) | |||
| 170815 | 170815 | 183268 | Undocumented 2 | :: 54 | 1254 45th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5982139.2748 | 2106566.1909 | 37.763193757767 | -122.504971215621 | (37.763193757767, -122.504971215621) | |||
| 36846 | 36846 | 183277 | Undocumented 2 | :: 54 | 1255 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5981785.9112 | 2106543.1909 | 37.7631098104891 | -122.506191655726 | (37.7631098104891, -122.506191655726) | |||
| 75313 | 75313 | 246042 | Undocumented 2 | :: 54 | 1257 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5999431.9379 | 2108484.7346 | 37.7694638090143 | -122.445299822785 | (37.7694638090143, -122.445299822785) | |||
| 71799 | 71799 | 183287 | Undocumented 2 | :: 54 | 1259 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5981476.8749 | 2106516.0091 | 37.7630169795519 | -122.50725847250901 | (37.7630169795519, -122.507258472509) | |||
| 9914 | 9914 | 173708 | DPW Maintained 3 | :: 54 | 126 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6001214.0 | 2098705.0 | 37.7427125900371 | -122.438434982469 | (37.7427125900371, -122.438434982469) | ||||
| 81529 | 81529 | 117591 | Undocumented 2 | :: 54 | 1262 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999100.0 | 2105386.0 | 37.7609365084256 | -122.446225043361 | (37.7609365084256, -122.446225043361) | ||||
| 40193 | 40193 | 183285 | Undocumented 2 | :: 54 | 1266 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5983382.4298 | 2106528.4997 | 37.763163328933295 | -122.50066883897 | (37.7631633289333, -122.50066883897) | |||
| 50143 | 50143 | 183305 | Undocumented 2 | :: 54 | 1270 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5982452.2839 | 2106459.7636 | 37.7629199491975 | -122.50388075683901 | (37.7629199491975, -122.503880756839) | |||
| 53717 | 53717 | 139776 | Undocumented 2 | :: 54 | 1275 Ellis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004800.935 | 2113296.4778 | 37.7829806915655 | -122.427071445409 | (37.7829806915655, -122.427071445409) | |||
| 32925 | 32925 | 200975 | Undocumented 2 | :: 54 | 1275 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6009315.029 | 2109918.3974 | 37.7739595082871 | -122.411215775633 | (37.7739595082871, -122.411215775633) | |||
| 160035 | 160035 | 181669 | Undocumented 2 | :: 54 | 1278 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5984937.1085 | 2106485.4116 | 37.7631361691005 | -122.495288628135 | (37.7631361691005, -122.495288628135) | |||
| 110521 | 110521 | 37485 | Permitted Site 1 | :: 54 | 1279 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | Permit Number 39954 | 5990777.53023366 | 2106701.87780849 | 37.7640707487715 | -122.47510458341002 | (37.7640707487715, -122.47510458341) | ||
| 181442 | 181442 | 181522 | Undocumented 2 | :: 54 | 1279 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5984580.8884 | 2106481.9946 | 37.7631059241302 | -122.496520402894 | (37.7631059241302, -122.496520402894) | |||
| 159425 | 159425 | 247892 | Undocumented 2 | :: 54 | 1283 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000447.0072 | 2109223.9761 | 37.771551471121896 | -122.441841814274 | (37.7715514711219, -122.441841814274) | |||
| 32195 | 32195 | 248555 | Undocumented 2 | :: 54 | 129 Beulah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5997396.7751 | 2107759.6103 | 37.767356421121995 | -122.452286999337 | (37.767356421122, -122.452286999337) | |||
| 64860 | 64860 | 181678 | Undocumented 2 | :: 54 | 1295 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5985204.8455 | 2106401.8973 | 37.7629225343509 | -122.49435647305 | (37.7629225343509, -122.49435647305) | |||
| 81482 | 81482 | 38110 | Permitted Site 1 | :: 54 | 1296 29th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/1998 12:00:00 AM | Permit Number 40278 | 5987114.66231835 | 2106457.26685396 | 37.763186144894 | -122.48775523264901 | (37.763186144894, -122.487755232649) | ||
| 115960 | 115960 | 38111 | Permitted Site 1 | :: 54 | 1296 29th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/1998 12:00:00 AM | Permit Number 40278 | 5987114.66231835 | 2106457.26685396 | 37.763186144894 | -122.48775523264901 | (37.763186144894, -122.487755232649) | ||
| 51060 | 51060 | 183255 | Undocumented 2 | :: 54 | 1300 La Playa | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5980911.3073 | 2106159.7216 | 37.762005388573606 | -122.509188082818 | (37.7620053885736, -122.509188082818) | |||
| 162558 | 162558 | 183254 | Undocumented 2 | :: 54 | 1300 La Playa | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5980911.6607 | 2106131.1023 | 37.76192682906861 | -122.50918473520399 | (37.7619268290686, -122.509184735204) | |||
| 164525 | 164525 | 137524 | Undocumented 2 | :: 54 | 1300 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6002282.6726 | 2113052.5281 | 37.782168143964896 | -122.435766122963 | (37.7821681439649, -122.435766122963) | |||
| 68734 | 68734 | 139765 | Undocumented 2 | :: 54 | 1306 Laguna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004663.7345 | 2113397.522 | 37.7832503745299 | -122.427553303818 | (37.7832503745299, -122.427553303818) |
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");