Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID ▲ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3316 | 3316 | 253394 | Planning Code 138.1 required 4 | Ulmus parvifolia :: Chinese Elm 46 | 115 Steuart St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/30/2017 12:00:00 AM | 3 | 3x3 | Permit Number 771767 | 6014754.163380001 | 2116767.09226 | 37.793068003154104 | -122.392879995147 | (37.7930680031541, -122.392879995147) | |
| 3293 | 3293 | 253393 | Planning Code 138.1 required 4 | Ulmus parvifolia :: Chinese Elm 46 | 115 Steuart St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/30/2017 12:00:00 AM | 3 | 3x3 | Permit Number 771767 | 6014754.163380001 | 2116767.09226 | 37.793068003154104 | -122.392879995147 | (37.7930680031541, -122.392879995147) | |
| 3289 | 3289 | 253392 | Planning Code 138.1 required 4 | Ulmus parvifolia :: Chinese Elm 46 | 115 Steuart St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/30/2017 12:00:00 AM | 3 | 3x3 | Permit Number 771767 | 6014754.163380001 | 2116767.09226 | 37.793068003154104 | -122.392879995147 | (37.7930680031541, -122.392879995147) | |
| 1525 | 1525 | 251581 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 600 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5984701.0 | 2111577.0 | 37.777102396300705 | -122.496480968893 | (37.7771023963007, -122.496480968893) | ||||
| 1395 | 1395 | 251525 | Planning Code 138.1 required 4 | Ulmus parvifolia :: Chinese Elm 46 | 173 Sanchez St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x15 | 6003549.6097 | 2107381.8851 | 37.7666698392386 | -122.430978251884 | (37.7666698392386, -122.430978251884) | ||||
| 1166 | 1166 | 251466 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 129 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008072.0 | 2112894.0 | 37.782060012266896 | -122.415726368353 | (37.7820600122669, -122.415726368353) | ||||
| 1178 | 1178 | 251465 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 129 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008072.0 | 2112894.0 | 37.782060012266896 | -122.415726368353 | (37.7820600122669, -122.415726368353) | ||||
| 22840 | 22840 | 251107 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1700X Quesada Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | ||||||||||
| 36165 | 36165 | 248389 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 729 Ashbury St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 5999024.6328 | 2108104.9869 | 37.7683978595253 | -122.44668134181101 | (37.7683978595253, -122.446681341811) | |||
| 45662 | 45662 | 248379 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 727 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 5999018.8791 | 2108145.8688 | 37.7685097822138 | -122.446704185133 | (37.7685097822138, -122.446704185133) | |||
| 69952 | 69952 | 248267 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 185 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 1ft | 6006635.01665 | 2098540.0650299997 | 37.7425665797951 | -122.41967892263901 | (37.7425665797951, -122.419678922639) | |||
| 56419 | 56419 | 248171 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 314 Franconia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6010101.97177 | 2099246.9558900003 | 37.7447022358135 | -122.407740986359 | (37.7447022358135, -122.407740986359) | |||
| 28826 | 28826 | 247019 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 530 Valley St | 1 | : 4 | Tree 1 | Private 1 | 17 | Width 3ft | 6002475.46095 | 2099175.15499 | 37.744075198804204 | -122.43410681909799 | (37.7440751988042, -122.434106819098) | |||
| 176128 | 176128 | 246976 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 221 Noe St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 6ft | 6002925.65155 | 2106953.9304400003 | 37.765459405239504 | -122.43310583406799 | (37.7654594052395, -122.433105834068) | |||
| 42863 | 42863 | 246813 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 174 Brewster St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6010206.83584 | 2098924.9753900003 | 37.7438240172737 | -122.40735569070699 | (37.7438240172737, -122.407355690707) | |||
| 175443 | 175443 | 246555 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 20x Octavia St | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | Width 8ft | 6005721.04041 | 2109575.32182 | 37.772815290316295 | -122.423623602744 | (37.7728152903163, -122.423623602744) | |||
| 136228 | 136228 | 246554 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 20x Octavia St | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | Width 8ft | 6005723.73891 | 2109547.7321 | 37.772739687913706 | -122.423612306376 | (37.7727396879137, -122.423612306376) | |||
| 57780 | 57780 | 246553 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 20x Octavia St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 8ft | 6005726.464930001 | 2109532.06592 | 37.7726968262309 | -122.42360176272699 | (37.7726968262309, -122.423601762727) | |||
| 178300 | 178300 | 246552 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 20x Octavia St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | Width 8ft | 6005729.77249 | 2109512.91923 | 37.77264444073 | -122.423588959979 | (37.77264444073, -122.423588959979) | |||
| 183718 | 183718 | 246549 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 20x Octavia St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | Width 8ft | 6005737.248 | 2109452.9268900002 | 37.77248013816789 | -122.423558835368 | (37.7724801381679, -122.423558835368) | |||
| 164702 | 164702 | 246548 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 20x Octavia St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 6ft | 6005741.17746 | 2109432.24964 | 37.772423585213794 | -122.423543772638 | (37.7724235852138, -122.423543772638) | |||
| 28092 | 28092 | 246547 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 20x Octavia St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 4ft | 6005744.74711 | 2109415.26549 | 37.772377152311705 | -122.42353021715599 | (37.7723771523117, -122.423530217156) | |||
| 40192 | 40192 | 246545 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1x Octavia St | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | Width 8ft | 6005664.26886 | 2109539.08097 | 37.7727125769595 | -122.423817404855 | (37.7727125769595, -122.423817404855) | |||
| 151969 | 151969 | 246544 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1x Octavia St | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | Width 8ft | 6005666.89387 | 2109521.5509099998 | 37.7726645918273 | -122.42380707793998 | (37.7726645918273, -122.42380707794) | |||
| 43669 | 43669 | 246542 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1x Octavia St | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | Width 8ft | 6005675.49099 | 2109463.50167 | 37.772505687922 | -122.42377321126001 | (37.772505687922, -122.42377321126) | |||
| 75717 | 75717 | 246541 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1x Octavia St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | Width 8ft | 6005680.0153 | 2109440.15852 | 37.772441848655795 | -122.423755901126 | (37.7724418486558, -122.423755901126) | |||
| 131030 | 131030 | 246540 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1x Octavia St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | Width 8ft | 6005683.44933 | 2109420.77798 | 37.7723888282128 | -122.423742644211 | (37.7723888282128, -122.423742644211) | |||
| 181312 | 181312 | 246539 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1x Octavia St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | Width 8ft | 6005686.56992 | 2109401.16217 | 37.7723351440794 | -122.423730454802 | (37.7723351440794, -122.423730454802) | |||
| 50390 | 50390 | 246538 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1x Octavia St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | Width 8ft | 6005690.17012 | 2109380.36656 | 37.7722782475712 | -122.423716522495 | (37.7722782475712, -122.423716522495) | |||
| 155019 | 155019 | 246537 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1x Octavia St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | Width 8ft | 6005694.1719 | 2109365.05441 | 37.7722364299905 | -122.423701591057 | (37.7722364299905, -122.423701591057) | |||
| 114252 | 114252 | 246419 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 400 Duncan St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 6003875.90135 | 2099856.3033 | 37.746024856155294 | -122.429312971222 | (37.7460248561553, -122.429312971222) | |||
| 39623 | 39623 | 246030 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1245 Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5999425.5785 | 2108530.7646 | 37.7695898327566 | -122.445325129643 | (37.7695898327566, -122.445325129643) | |||
| 130980 | 130980 | 245869 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 265 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6005113.693 | 2109858.5889 | 37.7735587716848 | -122.42574465422399 | (37.7735587716848, -122.425744654224) | |||
| 74887 | 74887 | 245849 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 251 Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6005124.4628 | 2109778.1319 | 37.77333846485929 | -122.42570167219401 | (37.7733384648593, -122.425701672194) | |||
| 158722 | 158722 | 245848 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 251 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6005123.1957 | 2109797.7709999997 | 37.7733923174645 | -122.42570745336201 | (37.7733923174645, -122.425707453362) | |||
| 188978 | 188978 | 245223 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 321 Laguna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6005094.6874 | 2109989.2967 | 37.7739165895729 | -122.425819703011 | (37.7739165895729, -122.425819703011) | |||
| 24769 | 24769 | 244936 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 294 Page St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 16 | Width 0ft | 6005165.6636 | 2109931.2421 | 37.7737611964044 | -122.425570051796 | (37.7737611964044, -122.425570051796) | |||
| 43457 | 43457 | 244930 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 260 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6005316.3896 | 2109945.8285 | 37.7738097625345 | -122.42504970426201 | (37.7738097625345, -122.425049704262) | |||
| 138143 | 138143 | 244478 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005577.5911 | 2110096.7762 | 37.7742389797832 | -122.424156902562 | (37.7742389797832, -122.424156902562) | |||
| 158186 | 158186 | 244477 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005574.5359 | 2110115.107 | 37.77428913922 | -122.424168774988 | (37.77428913922, -122.424168774988) | |||
| 66611 | 66611 | 244468 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005635.3174 | 2109670.3256 | 37.7730713086411 | -122.423926885709 | (37.7730713086411, -122.423926885709) | |||
| 68766 | 68766 | 244467 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6005631.8918 | 2109690.1946 | 37.7731256707262 | -122.423940148458 | (37.7731256707262, -122.423940148458) | |||
| 73396 | 73396 | 244466 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6005631.2066 | 2109707.3231 | 37.7731726627699 | -122.423943736898 | (37.7731726627699, -122.423943736898) | |||
| 174364 | 174364 | 244465 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005629.1512 | 2109732.6732 | 37.773242151986 | -122.423952649806 | (37.773242151986, -122.423952649806) | |||
| 155187 | 155187 | 244456 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6005624.3552 | 2109760.7639 | 37.773319011501705 | -122.42397123777799 | (37.7733190115017, -122.423971237778) | |||
| 161664 | 161664 | 244455 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005622.2998 | 2109777.2072 | 37.7733640447919 | -122.423979517231 | (37.7733640447919, -122.423979517231) | |||
| 133814 | 133814 | 244454 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 531 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6003599.7646 | 2110218.5739 | 37.774461535453206 | -122.43100725353202 | (37.7744615354532, -122.431007253532) | |||
| 22362 | 22362 | 244426 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 100x Octavia St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 6005680.8792 | 2109772.4112 | 37.773354183173396 | -122.423776541571 | (37.7733541831734, -122.423776541571) | |||
| 152904 | 152904 | 244425 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 100x Octavia St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6005682.2494 | 2109755.2828 | 37.7733072300695 | -122.423770583723 | (37.7733072300695, -122.423770583723) | |||
| 34532 | 34532 | 244424 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 100x Octavia St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6005686.3603 | 2109729.9326 | 37.7732378565997 | -122.42375456071301 | (37.7732378565997, -122.423754560713) | |||
| 62865 | 62865 | 244423 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 100x Octavia St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6005687.7306 | 2109711.4339 | 37.7731871409862 | -122.423748505092 | (37.7731871409862, -122.423748505092) | |||
| 25504 | 25504 | 244422 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 100x Octavia St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6005691.1562 | 2109690.8797 | 37.773130897486205 | -122.423735193743 | (37.7731308974862, -122.423735193743) | |||
| 149269 | 149269 | 244421 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 100x Octavia St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005693.2117 | 2109673.0661 | 37.773082101669296 | -122.423726816669 | (37.7730821016693, -122.423726816669) | |||
| 52888 | 52888 | 244411 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 0ft | 6005560.024 | 2110238.8403 | 37.7746280615118 | -122.424227776164 | (37.7746280615118, -122.424227776164) | |||
| 162148 | 162148 | 244410 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6005558.4964 | 2110254.116 | 37.7746699186287 | -122.424234147092 | (37.7746699186287, -122.424234147092) | |||
| 164108 | 164108 | 244401 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 200x Octavia St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6005612.7252 | 2110260.2263 | 37.7746897578806 | -122.424046993197 | (37.7746897578806, -122.424046993197) | |||
| 155394 | 155394 | 244400 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 200x Octavia St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6005615.7803 | 2110234.2576 | 37.774618626605296 | -122.42403457786301 | (37.7746186266053, -122.424034577863) | |||
| 147182 | 147182 | 244399 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 200x Octavia St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6005618.8355 | 2110208.2889 | 37.7745474953334 | -122.424022162207 | (37.7745474953334, -122.424022162207) | |||
| 69418 | 69418 | 244398 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 200x Octavia St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 6005622.6544 | 2110184.6115 | 37.7744826985313 | -122.42400726776 | (37.7744826985313, -122.42400726776) | |||
| 33227 | 33227 | 244397 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 200x Octavia St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 6005625.7095 | 2110167.0444 | 37.7744346360097 | -122.423995450078 | (37.7744346360097, -122.423995450078) | |||
| 38215 | 38215 | 244396 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 200x Octavia St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 6005626.4733 | 2110143.3671 | 37.7743696669954 | -122.42399112385799 | (37.7743696669954, -122.423991123858) | |||
| 45981 | 45981 | 244376 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005617.5038 | 2109799.1317 | 37.7734239734056 | -122.423997666684 | (37.7734239734056, -122.423997666684) | |||
| 28574 | 28574 | 244375 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6005617.5038 | 2109823.1115 | 37.773489816144796 | -122.423999372272 | (37.7734898161448, -122.423999372272) | |||
| 187415 | 187415 | 244374 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005614.0781 | 2109847.0914 | 37.7735554657504 | -122.42401292788901 | (37.7735554657504, -122.424012927889) | |||
| 176821 | 176821 | 244373 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6005612.0227 | 2109867.6455 | 37.7736117862994 | -122.424021499783 | (37.7736117862994, -122.424021499783) | |||
| 69759 | 69759 | 244364 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 6005534.4686 | 2110345.8041 | 37.774920315184396 | -122.424323786781 | (37.7749203151844, -122.424323786781) | |||
| 170608 | 170608 | 244363 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 6005533.5243 | 2110362.3292 | 37.7749656357807 | -122.42432822890801 | (37.7749656357807, -122.424328228908) | |||
| 184309 | 184309 | 244362 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6005532.1079 | 2110378.8544 | 37.7750109299929 | -122.42433430414499 | (37.7750109299929, -122.424334304145) | |||
| 51495 | 51495 | 244361 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6005527.8586 | 2110404.3503 | 37.7750806956038 | -122.424350817202 | (37.7750806956038, -122.424350817202) | |||
| 174240 | 174240 | 244360 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6005525.0257 | 2110428.4298 | 37.7751466521023 | -122.424362329876 | (37.7751466521023, -122.424362329876) | |||
| 34812 | 34812 | 244359 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6005522.1928 | 2110456.2865 | 37.7752229798737 | -122.42437411128701 | (37.7752229798737, -122.424374111287) | |||
| 66723 | 66723 | 244358 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 300x Octavia St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6005582.6276 | 2110470.923 | 37.775266580631 | -122.42416609455 | (37.775266580631, -122.42416609455) | |||
| 60342 | 60342 | 244357 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 300x Octavia St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6005584.9883 | 2110453.4536 | 37.7752187471852 | -122.424156685679 | (37.7752187471852, -122.424156685679) | |||
| 29153 | 29153 | 244356 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 300x Octavia St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005588.2934 | 2110426.5412 | 37.775145038872104 | -122.424143338216 | (37.7751450388721, -122.424143338216) | |||
| 176025 | 176025 | 244355 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 300x Octavia St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 6005591.5984 | 2110402.9339 | 37.7750804055544 | -122.42413022622601 | (37.7750804055544, -122.424130226226) | |||
| 57681 | 57681 | 244354 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 300x Octavia St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 0ft | 6005594.4313 | 2110381.2151 | 37.7750209309426 | -122.424118881689 | (37.7750209309426, -122.424118881689) | |||
| 172378 | 172378 | 244353 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 300x Octavia St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005598.6806 | 2110351.942 | 37.7749407940225 | -122.424102100187 | (37.7749407940225, -122.424102100187) | |||
| 56950 | 56950 | 244345 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005607.2268 | 2109894.3659 | 37.773684883292105 | -122.424039990106 | (37.7736848832921, -122.424039990106) | |||
| 129691 | 129691 | 244344 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005605.8565 | 2109917.6606 | 37.773748767543104 | -122.424046387097 | (37.7737487675431, -122.424046387097) | |||
| 136512 | 136512 | 244331 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 100x Octavia St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6005661.6953 | 2109906.0133 | 37.7737199393103 | -122.423852403284 | (37.7737199393103, -122.423852403284) | |||
| 69750 | 69750 | 244330 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 100x Octavia St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005665.121 | 2109878.6077 | 37.7736448835433 | -122.42383860414199 | (37.7736448835433, -122.423838604142) | |||
| 157190 | 157190 | 244329 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 100x Octavia St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6005667.8615 | 2109858.0536 | 37.773588601656996 | -122.423827662517 | (37.773588601657, -122.423827662517) | |||
| 68449 | 68449 | 244328 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 100x Octavia St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6005669.917 | 2109835.444 | 37.7735266371926 | -122.423818944241 | (37.7735266371926, -122.423818944241) | |||
| 76593 | 76593 | 244327 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 100x Octavia St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005673.3426 | 2109802.5573 | 37.773436531636 | -122.42380475570499 | (37.773436531636, -122.423804755705) | |||
| 27441 | 27441 | 244317 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6005516.527000001 | 2110492.6418 | 37.775322482765205 | -122.42439629699699 | (37.7753224827652, -122.424396296997) | |||
| 137760 | 137760 | 244316 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6005509.917 | 2110533.7186 | 37.7754348964248 | -122.424422084884 | (37.7754348964248, -122.424422084884) | |||
| 182189 | 182189 | 244315 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005508.5005 | 2110550.2437 | 37.7754801903482 | -122.42442816055599 | (37.7754801903482, -122.424428160556) | |||
| 137478 | 137478 | 244312 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6005504.7234 | 2110575.2675 | 37.7755486863335 | -122.424443006762 | (37.7755486863335, -122.424443006762) | |||
| 29392 | 29392 | 244311 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6005501.4183 | 2110598.8748 | 37.7756133196055 | -122.424456119453 | (37.7756133196055, -122.424456119453) | |||
| 42949 | 42949 | 244310 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 300x Octavia St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6005563.2696 | 2110605.957 | 37.77563625821271 | -122.424242664251 | (37.7756362582127, -122.424242664251) | |||
| 55243 | 55243 | 244309 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 300x Octavia St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6005567.5189 | 2110582.8218 | 37.7755729745028 | -122.42422631910499 | (37.7755729745028, -122.424226319105) | |||
| 166112 | 166112 | 244308 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 300x Octavia St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005570.3518 | 2110556.8538 | 37.7755018326332 | -122.424214672145 | (37.7755018326332, -122.424214672145) | |||
| 131483 | 131483 | 244307 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 300x Octavia St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6005574.129 | 2110533.2464 | 37.775437225714995 | -122.424199926569 | (37.775437225715, -122.424199926569) | |||
| 31383 | 31383 | 244306 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 300x Octavia St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 0ft | 6005576.9618 | 2110512.9441 | 37.7753816404734 | -122.42418868303001 | (37.7753816404734, -122.42418868303) | |||
| 169025 | 169025 | 244305 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 300x Octavia St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005579.7947 | 2110490.7532 | 37.775320869598204 | -122.424177304818 | (37.7753208695982, -122.424177304818) | |||
| 25458 | 25458 | 244288 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005589.8116 | 2110006.6495 | 37.7739922036556 | -122.42410821881201 | (37.7739922036556, -122.424108218812) | |||
| 67382 | 67382 | 244287 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6005585.9927 | 2110033.3819999998 | 37.7740653890161 | -122.424123330561 | (37.7740653890161, -122.424123330561) | |||
| 77107 | 77107 | 244284 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6005583.7013 | 2110055.5318 | 37.774126077633206 | -122.42413283246701 | (37.7741260776332, -122.424132832467) | |||
| 149777 | 149777 | 244283 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6005579.1186 | 2110077.6816 | 37.7741866368779 | -122.424150260413 | (37.7741866368779, -122.424150260413) | |||
| 51603 | 51603 | 244259 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 200x Octavia St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005631.8198 | 2110120.4535 | 37.7743070536408 | -122.423970999545 | (37.7743070536408, -122.423970999545) |
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");