Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 32102 | 32102 | 189290 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1 01st St | 23 | : Yard 23 | Tree 1 | Private 1 | 5 | 6014424.75736 | 2105899.2532900004 | 37.7632090676603 | -122.39325892915501 | (37.7632090676603, -122.393258929155) | ||||
| 58033 | 58033 | 189291 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1 01st St | 31 | : Yard 23 | Tree 1 | Private 1 | 5 | 6014386.77773 | 2105894.3895799997 | 37.7631936029157 | -122.39338994869 | (37.7631936029157, -122.39338994869) | ||||
| 59106 | 59106 | 189293 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1 01st St | 35 | : Yard 23 | Tree 1 | Private 1 | 8 | 6014389.3663800005 | 2105866.30731 | 37.7631166389548 | -122.39337903001801 | (37.7631166389548, -122.393379030018) | ||||
| 137382 | 137382 | 189292 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1 01st St | 33 | : Yard 23 | Tree 1 | Private 1 | 5 | 6014376.229280001 | 2105886.6133 | 37.763171664875294 | -122.393425888311 | (37.7631716648753, -122.393425888311) | ||||
| 163548 | 163548 | 189289 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1 01st St | 20 | : Yard 23 | Tree 1 | Private 1 | 10 | 6014461.84726 | 2105889.9963 | 37.76318571047079 | -122.393129998769 | (37.7631857104708, -122.393129998769) | ||||
| 172902 | 172902 | 245603 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1 Ashbury Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5999514.86648 | 2106994.77368 | 37.7653774842084 | -122.44490585663 | (37.7653774842084, -122.44490585663) | |||
| 11858 | 11858 | 111285 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1 Baltimore Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 6x10 | 6003156.565119999 | 2086725.0907599998 | 37.709928747378505 | -122.43086338266501 | (37.7099287473785, -122.430863382665) | |||
| 46537 | 46537 | 111286 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1 Baltimore Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 6x10 | 6003182.4283300005 | 2086750.5759400001 | 37.7100001895294 | -122.43077581205799 | (37.7100001895294, -122.430775812058) | |||
| 79153 | 79153 | 100847 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1 Estero Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992057.7 | 2091642.6 | 37.7227959320346 | -122.469580550695 | (37.7227959320346, -122.469580550695) | |||||
| 105655 | 105655 | 100846 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1 Estero Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992057.7 | 2091642.6 | 37.7227959320346 | -122.469580550695 | (37.7227959320346, -122.469580550695) | |||||
| 70973 | 70973 | 205373 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1 Laguna Honda Blvd | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 5995425.30717 | 2100166.2719900003 | 37.7463939109446 | -122.458556248673 | (37.7463939109446, -122.458556248673) | |||
| 147032 | 147032 | 205374 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1 Laguna Honda Blvd | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 3ft | 5995428.94316 | 2100162.07553 | 37.7463825974791 | -122.458543372197 | (37.7463825974791, -122.458543372197) | |||
| 60936 | 60936 | 205299 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1 Malta Dr | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 6ft | 5999812.60862 | 2095804.2587 | 37.7346680284999 | -122.443072299944 | (37.7346680284999, -122.443072299944) | |||
| 135051 | 135051 | 205296 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1 Malta Dr | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 5999813.31551 | 2095822.6669599998 | 37.7347186135631 | -122.443071177587 | (37.7347186135631, -122.443071177587) | |||
| 151604 | 151604 | 205297 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1 Malta Dr | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 5999812.9038 | 2095818.47395 | 37.7347070770679 | -122.443072299973 | (37.7347070770679, -122.443072299973) | |||
| 154088 | 154088 | 205295 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1 Malta Dr | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 5999812.67748 | 2095838.8409 | 37.734762987024205 | -122.44307454465401 | (37.7347629870242, -122.443074544654) | |||
| 168336 | 168336 | 205298 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1 Malta Dr | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 5999812.066980001 | 2095809.4413299998 | 37.7346822279016 | -122.443074544651 | (37.7346822279016, -122.443074544651) | |||
| 187218 | 187218 | 205386 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1 Rosewood Dr | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 3ft | 5994512.47364 | 2095959.3750900002 | 37.734790314728706 | -122.461407773158 | (37.7347903147287, -122.461407773158) | |||
| 39954 | 39954 | 245532 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6007523.94183 | 2099537.64218 | 37.745355738075 | -122.416675926256 | (37.745355738075, -122.416675926256) | |||
| 48237 | 48237 | 205333 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 10 Caine Ave | 15 | : 4 | Tree 1 | Private 1 | 1 | Width 0ft | 5997549.343280001 | 2089570.2528799998 | 37.717421611803495 | -122.45044787838002 | (37.7174216118035, -122.45044787838) | |||
| 133201 | 133201 | 126128 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 10 MacOndray Ln | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6008577.74955 | 2119176.39981 | 37.799338365924605 | -122.41442136907601 | (37.7993383659246, -122.414421369076) | ||||
| 33151 | 33151 | 205411 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 100 Joost Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 6ft | 6001323.450019999 | 2094964.8155099999 | 37.7324491402005 | -122.43778871637 | (37.7324491402005, -122.43778871637) | |||
| 174411 | 174411 | 205410 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 100 Joost Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6001330.46462 | 2094958.63518 | 37.7324325693049 | -122.437764022808 | (37.7324325693049, -122.437764022808) | |||
| 163364 | 163364 | 62036 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 100 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/25/1994 12:00:00 AM | 8 | Permit Number 22111 | 6004501.59533 | 2092915.26272 | 37.7270017298275 | -122.426655215587 | (37.7270017298275, -122.426655215587) | |
| 181965 | 181965 | 175949 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 100 Naples St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6004492.29305 | 2092899.6608099998 | 37.7269583645208 | -122.426686262865 | (37.7269583645208, -122.426686262865) | |||
| 31272 | 31272 | 246733 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 100 Ripley St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6008547.21994 | 2099053.14495 | 37.7440829149855 | -122.413103333461 | (37.7440829149855, -122.413103333461) | |||
| 130989 | 130989 | 246735 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 100 Ripley St | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6008576.96579 | 2099053.87477 | 37.744086588741396 | -122.413000530175 | (37.7440865887414, -122.413000530175) | |||
| 157455 | 157455 | 246734 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 100 Ripley St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6008557.46884 | 2099053.26982 | 37.7440838331996 | -122.41306790375299 | (37.7440838331996, -122.413067903753) | |||
| 13145 | 13145 | 19899 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 100 STAIRWAY33 | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 25ST | ||||||||
| 6655 | 6655 | 20047 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 100 STAIRWAY52 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10 | ||||||||
| 15056 | 15056 | 20048 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 100 STAIRWAY52 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10 | ||||||||
| 36842 | 36842 | 205287 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 100 Terrace Dr | 15 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 26 | 5993689.14699 | 2096660.1046799999 | 37.736666922846105 | -122.46430513247499 | (37.7366669228461, -122.464305132475) | ||||
| 23442 | 23442 | 187500 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 100 Walbridge St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6005130.65162 | 2086494.3835099998 | 37.709406927448796 | -122.424024164397 | (37.7094069274488, -122.424024164397) | ||||
| 48408 | 48408 | 187498 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 100 Walbridge St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6005143.26682 | 2086489.02091 | 37.7093929151184 | -122.42398018305599 | (37.7093929151184, -122.423980183056) | ||||
| 60503 | 60503 | 187503 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 100 Walbridge St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6005106.379430001 | 2086503.4563099998 | 37.7094304690223 | -122.424108697959 | (37.7094304690223, -122.424108697959) | ||||
| 73009 | 73009 | 187502 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 100 Walbridge St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6005111.53197 | 2086501.51554 | 37.7094254309976 | -122.424090751982 | (37.7094254309976, -122.424090751982) | ||||
| 134081 | 134081 | 187501 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 100 Walbridge St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6005123.3425 | 2086496.8566299998 | 37.7094133054443 | -122.42404960170099 | (37.7094133054443, -122.424049601701) | ||||
| 41281 | 41281 | 245490 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1001 Treat Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008635.002830001 | 2102667.8072 | 37.754012898098395 | -122.413055332141 | (37.7540128980984, -122.413055332141) | |||
| 98125 | 98125 | 102273 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 100X Casitas Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6x14 | 5995287.9 | 2097019.1 | 37.7377446590015 | -122.458803572065 | (37.7377446590015, -122.458803572065) | |||
| 54360 | 54360 | 205288 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 100x Casitas Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 4ft | 5995094.0197 | 2097032.76312 | 37.73777102860689 | -122.459474894452 | (37.7377710286069, -122.459474894452) | |||
| 60126 | 60126 | 205301 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 100x Idora Ave | 16 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | Width 9ft | 5995644.80929 | 2099340.4392 | 37.7441389922109 | -122.45773749420799 | (37.7441389922109, -122.457737494208) | |||
| 65522 | 65522 | 205300 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 100x Idora Ave | 15 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | Width 9ft | 5995637.606269999 | 2099342.55805 | 37.7441443962476 | -122.457762553794 | (37.7441443962476, -122.457762553794) | |||
| 81973 | 81973 | 24778 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 101 Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 5982415.49737 | 2112552.2939 | 37.779646108074104 | -122.50445937924201 | (37.7796461080741, -122.504459379242) | |||
| 142160 | 142160 | 24779 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 101 Point Lobos Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5982409.72971 | 2112547.84486 | 37.7796335530741 | -122.504479002029 | (37.7796335530741, -122.504479002029) | |||
| 181239 | 181239 | 118591 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 101 Point Lobos Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 5982483.315119999 | 2112527.9777 | 37.77958333161529 | -122.50422297050301 | (37.7795833316153, -122.504222970503) | ||||
| 181846 | 181846 | 118590 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 101 Point Lobos Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 5982474.39956 | 2112527.8997400003 | 37.7795825932214 | -122.504253806958 | (37.7795825932214, -122.504253806958) | ||||
| 100652 | 100652 | 101029 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1010X Portola Dr | 3 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 5995923.3 | 2098391.5 | 37.7415494342357 | -122.45670592621 | (37.7415494342357, -122.45670592621) | |||||
| 167568 | 167568 | 189317 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1015 Jamestown Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6013888.25038 | 2089668.52955 | 37.718613065116294 | -122.393978282498 | (37.7186130651163, -122.393978282498) | ||||
| 14316 | 14316 | 101784 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1017 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6012216.2726 | 2103633.6604400002 | 37.7568653093127 | -122.40073821739901 | (37.7568653093127, -122.400738217399) | |||
| 167600 | 167600 | 205322 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1022 Capitol Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 5995074.246830001 | 2090726.7523400001 | 37.720455114101796 | -122.45908677763501 | (37.7204551141018, -122.459086777635) | |||
| 133105 | 133105 | 205304 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1023 Chenery St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 4ft | 6000894.24307 | 2096169.06847 | 37.7357313239349 | -122.43935887242901 | (37.7357313239349, -122.439358872429) | |||
| 17674 | 17674 | 5570 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 1027 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/16/1998 12:00:00 AM | 8 | 3x3 | 6005145.15998 | 2102348.30914 | 37.752939104875296 | -122.42510132197701 | (37.7529391048753, -122.425101321977) | ||
| 155758 | 155758 | 245753 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 103 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6003340.66664 | 2108610.48396 | 37.7700314308381 | -122.43178868071199 | (37.7700314308381, -122.431788680712) | |||
| 164167 | 164167 | 245754 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 103 Steiner St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6003339.23771 | 2108603.67132 | 37.7700126439943 | -122.43179313686001 | (37.7700126439943, -122.43179313686) | |||
| 20463 | 20463 | 5571 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1033 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6005142.90403 | 2102326.22826 | 37.7528783484711 | -122.425107552489 | (37.7528783484711, -122.425107552489) | |||
| 89959 | 89959 | 5572 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1035 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3x3 | 6005146.9010804 | 2102326.2346427 | 37.7528785917901 | -122.42509373038601 | (37.7528785917901, -122.425093730386) | |||
| 48604 | 48604 | 205400 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 104 Omar Way | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 3ft | 5998070.50386 | 2097545.50519 | 37.739349589724895 | -122.449220725551 | (37.7393495897249, -122.449220725551) | |||
| 183226 | 183226 | 205401 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 104 Omar Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 3ft | 5998076.695180001 | 2097546.14493 | 37.739351700425104 | -122.449199364883 | (37.7393517004251, -122.449199364883) | |||
| 11441 | 11441 | 25394 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 1045 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 4X4 | 6000938.80793 | 2088782.07415 | 37.715450859936 | -122.43867564846902 | (37.715450859936, -122.438675648469) | |||
| 54928 | 54928 | 245733 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 105 Alpine Ter | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 3ft | 6001700.20179 | 2108226.0430400004 | 37.7688827231901 | -122.437435479759 | (37.7688827231901, -122.437435479759) | |||
| 166574 | 166574 | 245732 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 105 Alpine Ter | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6001698.92484 | 2108215.08897 | 37.768852573427296 | -122.43743911212 | (37.7688525734273, -122.43743911212) | |||
| 29306 | 29306 | 245536 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 105 Manchester St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6008269.316980001 | 2099343.9975400004 | 37.7448659268119 | -122.414084835556 | (37.7448659268119, -122.414084835556) | |||
| 29630 | 29630 | 245636 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 105 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6008273.01473 | 2099327.11999 | 37.7448197924968 | -122.414070855604 | (37.7448197924968, -122.414070855604) | |||
| 32398 | 32398 | 245535 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 105 Manchester St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6008270.02595 | 2099337.89362 | 37.7448492066234 | -122.414081952318 | (37.7448492066234, -122.414081952318) | |||
| 73676 | 73676 | 245633 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 105 Manchester St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008270.763830001 | 2099345.47262 | 37.7448700583192 | -122.414079936938 | (37.7448700583192, -122.414079936938) | |||
| 158320 | 158320 | 245632 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 105 Manchester St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008270.174219999 | 2099353.3303099996 | 37.7448916006749 | -122.414082531499 | (37.7448916006749, -122.414082531499) | |||
| 165597 | 165597 | 245538 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 105 Manchester St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6008268.68724 | 2099353.97452 | 37.7448932860134 | -122.414087718783 | (37.7448932860134, -122.414087718783) | |||
| 173463 | 173463 | 245635 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 105 Manchester St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008271.621619999 | 2099332.3788 | 37.7448341537755 | -122.414076044698 | (37.7448341537755, -122.414076044698) | |||
| 181629 | 181629 | 245534 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 105 Manchester St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 2ft | 6008271.48377 | 2099327.62295 | 37.7448210875245 | -122.414076184968 | (37.7448210875245, -122.414076184968) | |||
| 187781 | 187781 | 245537 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 105 Manchester St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6008269.43017 | 2099349.5308 | 37.744881126273 | -122.41408483554599 | (37.744881126273, -122.414084835546) | |||
| 188214 | 188214 | 245634 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 105 Manchester St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008270.22088 | 2099337.26438 | 37.7448474898186 | -122.41408123377701 | (37.7448474898186, -122.414081233777) | |||
| 30540 | 30540 | 37494 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 1050 Kirkham St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | Permit Number 39963 | 5991661.12122197 | 2105245.54821547 | 37.7601232248942 | -122.47194237971901 | (37.7601232248942, -122.471942379719) | ||
| 33385 | 33385 | 205269 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1050 Kirkham St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5991539.28876 | 2105242.88363 | 37.7601088581456 | -122.47236354183799 | (37.7601088581456, -122.472363541838) | |||
| 40045 | 40045 | 205265 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1050 Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5991611.69104 | 2105245.05249 | 37.760119003396795 | -122.472113297392 | (37.7601190033968, -122.472113297392) | |||
| 47157 | 47157 | 205268 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1050 Kirkham St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5991555.7567300005 | 2105242.99834 | 37.760110126206 | -122.47230659589898 | (37.760110126206, -122.472306595899) | |||
| 71625 | 71625 | 205266 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1050 Kirkham St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5991581.77291 | 2105244.99033 | 37.760117101335 | -122.472216764416 | (37.760117101335, -122.472216764416) | |||
| 101064 | 101064 | 37495 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 1050 Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42243 | 5991661.12122197 | 2105245.54821547 | 37.7601232248942 | -122.47194237971901 | (37.7601232248942, -122.471942379719) | ||
| 116601 | 116601 | 37496 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 1050 Kirkham St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | Permit Number 39963 | 5991661.12122197 | 2105245.54821547 | 37.7601232248942 | -122.47194237971901 | (37.7601232248942, -122.471942379719) | ||
| 118355 | 118355 | 41859 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 1050 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42243 | 5991661.12122197 | 2105245.54821547 | 37.7601232248942 | -122.47194237971901 | (37.7601232248942, -122.471942379719) | ||
| 130167 | 130167 | 205267 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1050 Kirkham St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5991572.93998 | 2105244.02195 | 37.7601139312335 | -122.47224724242399 | (37.7601139312335, -122.472247242424) | |||
| 169535 | 169535 | 205264 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1050 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5991629.32312 | 2105245.37395 | 37.760120906381296 | -122.47205234044701 | (37.7601209063813, -122.472052340447) | |||
| 105617 | 105617 | 97301 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 1051 Portola Dr | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 09/20/2011 12:00:00 AM | Permit Number 768134 | 5995688.7 | 2098126.6 | 37.7408086112536 | -122.457497926865 | (37.7408086112536, -122.457497926865) | |||
| 33292 | 33292 | 175977 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1053 Silver Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 51 | Width 6ft | 6007850.48463 | 2093695.0400900003 | 37.72933159448 | -122.41513330118 | (37.72933159448, -122.41513330118) | |||
| 42323 | 42323 | 126124 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1055 Lombard St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 5ft | 6007293.98833 | 2120181.06921 | 37.8020247344007 | -122.418934936917 | (37.8020247344007, -122.418934936917) | |||
| 49158 | 49158 | 126125 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1055 Lombard St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | Width 5ft | 6007295.75973 | 2120178.5361099998 | 37.8020178788931 | -122.418928627254 | (37.8020178788931, -122.418928627254) | |||
| 169500 | 169500 | 245629 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 106 Appleton Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 6005761.64201 | 2096979.60315 | 37.738232665900796 | -122.422587938083 | (37.7382326659008, -122.422587938083) | |||
| 26143 | 26143 | 245512 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 106 Chattanooga St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 4ft | 6004701.89686 | 2103004.13948 | 37.754714811762206 | -122.42668090920701 | (37.7547148117622, -122.426680909207) | |||
| 33453 | 33453 | 245507 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 107 Valley St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 6005153.22882 | 2099293.3169400003 | 37.7445512558411 | -122.424856092128 | (37.7445512558411, -122.424856092128) | |||
| 34446 | 34446 | 245509 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 107 Valley St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 6005195.418769999 | 2099296.09974 | 37.7445612796971 | -122.424710405556 | (37.7445612796971, -122.424710405556) | |||
| 63324 | 63324 | 245508 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 107 Valley St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 4ft | 6005190.34695 | 2099296.2436900004 | 37.744561388499996 | -122.424727953147 | (37.7445613885, -122.424727953147) | |||
| 38372 | 38372 | 245497 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1070 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 6ft | 6010227.41138 | 2103002.67272 | 37.755021628064 | -122.407571984862 | (37.755021628064, -122.407571984862) | |||
| 169347 | 169347 | 245628 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 108 Appleton Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 6005771.549790001 | 2096974.97237 | 37.7382205097733 | -122.42255335287099 | (37.7382205097733, -122.422553352871) | |||
| 157561 | 157561 | 189316 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1089 Jamestown Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6013485.95319 | 2089984.75612 | 37.7194589935203 | -122.39539101131099 | (37.7194589935203, -122.395391011311) | ||||
| 148817 | 148817 | 189287 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1098 Pennsylvania Ave | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 6014480.56766 | 2102060.80293 | 37.752672610575104 | -122.39279734853599 | (37.7526726105751, -122.392797348536) | |||
| 170605 | 170605 | 205413 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 11 Nordhoff St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 29 | Width 8ft | 6000405.0544 | 2095305.58104 | 37.733332537972004 | -122.44098825600099 | (37.733332537972, -122.440988256001) | |||
| 130332 | 130332 | 245617 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 110 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006667.13836 | 2099063.32987 | 37.7440051569251 | -122.41960497229799 | (37.7440051569251, -122.419604972298) | |||
| 26401 | 26401 | 189358 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1100 Fairfax Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6017825.61264 | 2096067.48761 | 37.736401402503 | -122.380812873212 | (37.736401402503, -122.380812873212) | |||
| 44509 | 44509 | 189363 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1100 Fairfax Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017807.80075 | 2096153.39811 | 37.7366363126207 | -122.38088042760799 | (37.7366363126207, -122.380880427608) | |||
| 47149 | 47149 | 189364 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1100 Fairfax Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017803.09649 | 2096176.66908 | 37.7366999504426 | -122.380898309728 | (37.7366999504426, -122.380898309728) | |||
| 53519 | 53519 | 189359 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1100 Fairfax Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6017821.04017 | 2096083.0305700002 | 37.7364438280288 | -122.380829762495 | (37.7364438280288, -122.380829762495) |
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");