Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlotSize
| Link | rowid | TreeID ▲ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3544 | 3544 | 253465 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 98X Marston Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | 5998793.0 | 2093251.0 | 37.7275991927727 | -122.446413796362 | (37.7275991927727, -122.446413796362) | ||
| 3585 | 3585 | 253464 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 98X Marston Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | 5998793.0 | 2093251.0 | 37.7275991927727 | -122.446413796362 | (37.7275991927727, -122.446413796362) | ||
| 3567 | 3567 | 253463 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 98X Marston Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | 5998793.0 | 2093251.0 | 37.7275991927727 | -122.446413796362 | (37.7275991927727, -122.446413796362) | ||
| 3561 | 3561 | 253462 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 98X Marston Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | 5998793.0 | 2093251.0 | 37.7275991927727 | -122.446413796362 | (37.7275991927727, -122.446413796362) | ||
| 130969 | 130969 | 250332 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 141 27th Ave | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5987387.77846 | 2115003.34197 | 37.786667192588894 | -122.487438428541 | (37.7866671925889, -122.487438428541) | |||
| 24900 | 24900 | 249938 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 339 Filbert St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | Width 0ft | 6011244.68883 | 2120032.5219400004 | 37.8018385261831 | -122.405253098256 | (37.8018385261831, -122.405253098256) | |||
| 35370 | 35370 | 248189 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 216 Esmeralda Ave | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | 6007400.67054 | 2098728.2959 | 37.7431265201804 | -122.417044843446 | (37.7431265201804, -122.417044843446) | ||||
| 123417 | 123417 | 247871 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 394 Mayflower St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | 6009746.3542 | 2098404.30325 | 37.742368581453704 | -122.40891120669201 | (37.7423685814537, -122.408911206692) | ||||
| 188108 | 188108 | 247870 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 394 Mayflower St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | 6009721.06953 | 2098395.0417 | 37.74234173489771 | -122.40899798048099 | (37.7423417348977, -122.408997980481) | ||||
| 33669 | 33669 | 247869 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 394 Mayflower St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 6009720.84865 | 2098403.35069 | 37.7423645372013 | -122.408999330354 | (37.7423645372013, -122.408999330354) | ||||
| 22307 | 22307 | 246123 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 35 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/06/2017 12:00:00 AM | 3 | Width 0ft | Permit Number 779621 | 5998184.8878 | 2108385.4066 | 37.7691198159889 | -122.44960613908701 | (37.7691198159889, -122.449606139087) | |
| 136946 | 136946 | 244098 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1601 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5998815.2972 | 2108995.6351 | 37.770831393246496 | -122.44746952816901 | (37.7708313932465, -122.447469528169) | |||
| 1699 | 1699 | 237552 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 102 Hancock St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779869 | 6003566.97457 | 2105097.88602 | 37.7603995118464 | -122.430755182518 | (37.7603995118464, -122.430755182518) | |
| 1709 | 1709 | 237551 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 102 Hancock St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779869 | 6003586.068 | 2105101.14828 | 37.760409550968205 | -122.430689380017 | (37.7604095509682, -122.430689380017) | |
| 26252 | 26252 | 227697 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 109 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003800.52049 | 2108768.8119 | 37.7704922173631 | -122.430209350707 | (37.7704922173631, -122.430209350707) | |||
| 32724 | 32724 | 227696 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 50 Belcher St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6003774.74871 | 2108065.2472200003 | 37.7685589402651 | -122.43024829315 | (37.7685589402651, -122.43024829315) | |||
| 3268 | 3268 | 227695 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 4250 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6001245.674269999 | 2103366.3123 | 37.7555132424609 | -122.43865939052701 | (37.7555132424609, -122.438659390527) | |||
| 163790 | 163790 | 227694 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 239 Caselli Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5999877.66163 | 2104769.07166 | 37.7592869569347 | -122.44349114479401 | (37.7592869569347, -122.443491144794) | |||
| 41282 | 41282 | 227693 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 337 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6002979.940119999 | 2100929.17253 | 37.748919939311705 | -122.432487701248 | (37.7489199393117, -122.432487701248) | |||
| 180188 | 180188 | 227692 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 75 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006684.36987 | 2096973.81613 | 37.738268789882795 | -122.419397184857 | (37.7382687898828, -122.419397184857) | |||
| 154014 | 154014 | 227691 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 309 Bocana St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 6006868.9204400005 | 2097195.64462 | 37.7388882743696 | -122.418774826116 | (37.7388882743696, -122.418774826116) | |||
| 29076 | 29076 | 227690 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 307 Bocana St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 6006885.1558 | 2097215.40267 | 37.7389434396991 | -122.41872009246299 | (37.7389434396991, -122.418720092463) | |||
| 61754 | 61754 | 227689 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 84 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008214.299790001 | 2099586.39862 | 37.7455284159971 | -122.41429222281 | (37.7455284159971, -122.41429222281) | |||
| 130073 | 130073 | 227688 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 269 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6007769.10714 | 2097866.49845 | 37.740780934479794 | -122.41570987722 | (37.7407809344798, -122.41570987722) | |||
| 44170 | 44170 | 227687 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1003 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5997630.84664 | 2107024.34604 | 37.7653509793933 | -122.45142434518401 | (37.7653509793933, -122.451424345184) | |||
| 32798 | 32798 | 227686 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1001 Shrader St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5997629.48637 | 2107046.8431599997 | 37.7654126728718 | -122.45143067278299 | (37.7654126728718, -122.451430672783) | |||
| 77293 | 77293 | 227685 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1001 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5997626.030809999 | 2107071.20572 | 37.765479368391 | -122.45144438204599 | (37.765479368391, -122.451444382046) | |||
| 61815 | 61815 | 227684 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2560 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6002253.36783 | 2096984.49578 | 37.7380475512412 | -122.434718147625 | (37.7380475512412, -122.434718147625) | |||
| 173722 | 173722 | 227683 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 923 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007409.880530001 | 2101914.88747 | 37.7518767015549 | -122.41723875888201 | (37.7518767015549, -122.417238758882) | |||
| 166550 | 166550 | 227682 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 500 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008186.7931 | 2096476.1256400002 | 37.7369867469298 | -122.41416732857999 | (37.7369867469298, -122.41416732858) | |||
| 130724 | 130724 | 227681 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 145 Alma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 5997959.25406 | 2106183.4369900003 | 37.7630608557823 | -122.450227846644 | (37.7630608557823, -122.450227846644) | |||
| 185081 | 185081 | 227680 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1541 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6003988.609540001 | 2099295.3111900003 | 37.7444908816604 | -122.428883253577 | (37.7444908816604, -122.428883253577) | |||
| 67932 | 67932 | 227679 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 361 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6003556.92712 | 2099495.0366599998 | 37.745014838355395 | -122.430390170187 | (37.7450148383554, -122.430390170187) | |||
| 123731 | 123731 | 227678 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 300 Valley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6003889.89165 | 2099268.52237 | 37.744411737711296 | -122.42922269007799 | (37.7444117377113, -122.429222690078) | |||
| 66597 | 66597 | 227677 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 300 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6003907.029080001 | 2099270.15617 | 37.7444171939021 | -122.42916354887801 | (37.7444171939021, -122.429163548878) | |||
| 159861 | 159861 | 227676 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 427 Valley St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 6003106.32375 | 2099187.31259 | 37.7441443647786 | -122.431926305762 | (37.7441443647786, -122.431926305762) | ||||
| 37269 | 37269 | 227675 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1000 San Jose Ave | 104 | Front Yard : Yard 7 | Tree 1 | Private 1 | 27 | 6005040.407269999 | 2096975.5643799999 | 37.7381808604543 | -122.425081325568 | (37.7381808604543, -122.425081325568) | ||||
| 148496 | 148496 | 227674 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1000 San Jose Ave | 83 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6005065.1015800005 | 2097012.05309 | 37.7382824451638 | -122.42499854026899 | (37.7382824451638, -122.424998540269) | ||||
| 178085 | 178085 | 227673 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1000 San Jose Ave | 64 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6005078.09924 | 2097049.5351099998 | 37.738386096529204 | -122.424956266738 | (37.7383860965292, -122.424956266738) | ||||
| 150938 | 150938 | 227672 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1000 San Jose Ave | 62 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6005095.2123 | 2097053.48648 | 37.7383979127325 | -122.42489737911801 | (37.7383979127325, -122.424897379118) | ||||
| 74734 | 74734 | 227671 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1000 San Jose Ave | 60 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6005087.18528 | 2097058.7145599998 | 37.738411814457706 | -122.42492550452101 | (37.7384118144577, -122.424925504521) | ||||
| 133879 | 133879 | 227670 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 403 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6005513.924819999 | 2101330.09926 | 37.7501641603604 | -122.423753669923 | (37.7501641603604, -122.423753669923) | |||
| 171868 | 171868 | 218294 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1 Woodacre Dr | 18 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 5991183.55146 | 2095353.09261 | 37.7329334566034 | -122.472872697534 | (37.7329334566034, -122.472872697534) | ||||
| 136052 | 136052 | 218293 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1 Woodacre Dr | 17 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 22 | 5991192.67429 | 2095369.91493 | 37.7329801745819 | -122.47284238406799 | (37.7329801745819, -122.472842384068) | ||||
| 40186 | 40186 | 218289 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1 Woodacre Dr | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | 5991265.0261699995 | 2095485.2551900002 | 37.7333010580894 | -122.472600653515 | (37.7333010580894, -122.472600653515) | ||||
| 182431 | 182431 | 218284 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 50x Junipero Serra Frontage West | 0 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | 5991438.8932 | 2095398.7783700002 | 37.7330736770928 | -122.4719932523 | (37.7330736770928, -122.4719932523) | ||||
| 55201 | 55201 | 218280 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1 Woodacre Dr | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 30 | 5991369.16642 | 2095649.3447099999 | 37.7337576340075 | -122.47225257269301 | (37.7337576340075, -122.472252572693) | ||||
| 53381 | 53381 | 217850 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1 Woodacre Dr | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | 5991375.86862 | 2095660.38148 | 37.7337883260711 | -122.47223020566999 | (37.7337883260711, -122.47223020567) | ||||
| 51787 | 51787 | 217831 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Cranleigh Dr | 21 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | 5991381.66969 | 2095739.8250799999 | 37.734006793868 | -122.472215938837 | (37.734006793868, -122.472215938837) | ||||
| 163400 | 163400 | 207139 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 208 Colon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5996097.007130001 | 2094250.7795400003 | 37.7301899955731 | -122.45580605711599 | (37.7301899955731, -122.455806057116) | |||
| 152163 | 152163 | 207138 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 700 Junipero Serra Blvd | 123 | : 4 | Tree 1 | Private 1 | 8 | Width 0ft | 5991217.227519999 | 2091775.34767 | 37.7231118130309 | -122.472495529957 | (37.7231118130309, -122.472495529957) | |||
| 148752 | 148752 | 207137 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 700 Junipero Serra Blvd | 103 | : 4 | Tree 1 | Private 1 | 12 | Width 0ft | 5991231.72322 | 2092011.81443 | 37.7237619311543 | -122.47246265254 | (37.7237619311543, -122.47246265254) | |||
| 167635 | 167635 | 207136 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 700 Junipero Serra Blvd | 100 | : 4 | Tree 1 | Private 1 | 6 | Width 0ft | 5991240.31686 | 2092039.5475299999 | 37.723838576763896 | -122.47243496690399 | (37.7238385767639, -122.472434966904) | |||
| 63860 | 63860 | 207135 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 700 Junipero Serra Blvd | 99 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5991243.409109999 | 2092046.59438 | 37.7238581046423 | -122.472424791093 | (37.7238581046423, -122.472424791093) | |||
| 148023 | 148023 | 207134 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 700 Junipero Serra Blvd | 98 | : 4 | Tree 1 | Private 1 | 12 | Width 0ft | 5991244.20773 | 2092057.90852 | 37.723889216687496 | -122.47242285485201 | (37.7238892166875, -122.472422854852) | |||
| 185196 | 185196 | 207133 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 700 Junipero Serra Blvd | 90 | : 4 | Tree 1 | Private 1 | 10 | Width 0ft | 5991231.48328 | 2092142.9158700001 | 37.724121889294295 | -122.472473035196 | (37.7241218892943, -122.472473035196) | |||
| 67484 | 67484 | 207132 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 700 Junipero Serra Blvd | 87 | : 4 | Tree 1 | Private 1 | 16 | Width 0ft | 5991236.29103 | 2092157.26983 | 37.7241615799784 | -122.472457461649 | (37.7241615799784, -122.472457461649) | |||
| 132080 | 132080 | 207131 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 500 Junipero Serra Blvd | 23 | : 4 | Tree 1 | Private 1 | 14 | Width 0ft | 5991341.745569999 | 2093676.61882 | 37.7283394372056 | -122.47220362351901 | (37.7283394372056, -122.472203623519) | |||
| 132288 | 132288 | 207130 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 300 Junipero Serra Blvd | 22 | : 4 | Tree 1 | Private 1 | 24 | Width 0ft | 5991387.56325 | 2094477.49413 | 37.7305410918021 | -122.472103582925 | (37.7305410918021, -122.472103582925) | |||
| 172053 | 172053 | 207129 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 4986 19th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 5990655.7482 | 2093855.39662 | 37.7287905920011 | -122.47458816511002 | (37.7287905920011, -122.47458816511) | |||
| 154023 | 154023 | 207128 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Cranleigh Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | Width 0ft | 5991324.62806 | 2095649.6189400002 | 37.7337558092758 | -122.472406573513 | (37.7337558092758, -122.472406573513) | |||
| 72315 | 72315 | 207127 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Cranleigh Dr | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | Width 0ft | 5991327.69264 | 2095651.06492 | 37.7337599569436 | -122.472396083831 | (37.7337599569436, -122.472396083831) | |||
| 60545 | 60545 | 207126 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Cranleigh Dr | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | Width 0ft | 5991329.52565 | 2095655.7745299998 | 37.733772994434204 | -122.472390089849 | (37.7337729944342, -122.472390089849) | |||
| 53270 | 53270 | 207125 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Cranleigh Dr | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | Width 0ft | 5991332.892440001 | 2095658.5010099998 | 37.733780675521395 | -122.47237864866001 | (37.7337806755214, -122.47237864866) | |||
| 188736 | 188736 | 207124 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Cranleigh Dr | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | Width 0ft | 5991335.55729 | 2095661.67857 | 37.7337895545331 | -122.472369667134 | (37.7337895545331, -122.472369667134) | |||
| 179845 | 179845 | 207123 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Cranleigh Dr | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 21 | Width 0ft | 5991338.6165 | 2095665.48618 | 37.733800186326604 | -122.472359368113 | (37.7338001863266, -122.472359368113) | |||
| 184814 | 184814 | 207122 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Cranleigh Dr | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | Width 0ft | 5991343.33969 | 2095670.4637 | 37.7338141267018 | -122.47234340152399 | (37.7338141267018, -122.472343401524) | |||
| 180846 | 180846 | 207121 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Cranleigh Dr | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | Width 0ft | 5991346.9817 | 2095677.27593 | 37.733833042151105 | -122.47233130655898 | (37.7338330421511, -122.472331306559) | |||
| 178438 | 178438 | 207120 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Cranleigh Dr | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 21 | Width 0ft | 5991349.86178 | 2095682.72956 | 37.7338481831293 | -122.472321746778 | (37.7338481831293, -122.472321746778) | |||
| 158536 | 158536 | 207119 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Cranleigh Dr | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | Width 0ft | 5991353.65823 | 2095688.25461 | 37.733863573243205 | -122.47230902406099 | (37.7338635732432, -122.472309024061) | |||
| 174722 | 174722 | 207118 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Cranleigh Dr | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 27 | Width 0ft | 5991361.11034 | 2095702.06647 | 37.7339019284143 | -122.472284266614 | (37.7339019284143, -122.472284266614) | |||
| 59360 | 59360 | 207117 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 41 Ralston St | 9 | Back Yard : Yard 13 | Tree 1 | Private 1 | 19 | 5992170.67066 | 2088214.0686700002 | 37.7133885481037 | -122.46894065558399 | (37.7133885481037, -122.468940655584) | ||||
| 164753 | 164753 | 207116 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 47 Ralston St | 9 | Back Yard : Yard 13 | Tree 1 | Private 1 | 8 | 5992178.8337 | 2088240.4151599999 | 37.7134613608383 | -122.46891435762801 | (37.7134613608383, -122.468914357628) | ||||
| 60662 | 60662 | 207115 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 47 Ralston St | 8 | Back Yard : Yard 13 | Tree 1 | Private 1 | 8 | 5992168.43399 | 2088239.2563900002 | 37.7134575782774 | -122.468950218099 | (37.7134575782774, -122.468950218099) | ||||
| 188129 | 188129 | 207114 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 53 Ralston St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 23 | 5992175.21623 | 2088282.1627599997 | 37.7135757806697 | -122.468929896991 | (37.7135757806697, -122.468929896991) | ||||
| 68946 | 68946 | 207113 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 53 Ralston St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | 5992170.39113 | 2088282.9530900002 | 37.7135776719473 | -122.468946631596 | (37.7135776719473, -122.468946631596) | ||||
| 31147 | 31147 | 207112 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 59 Ralston St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 12 | 5992171.746719999 | 2088295.8735200001 | 37.7136132266511 | -122.46894288591899 | (37.7136132266511, -122.468942885919) | ||||
| 171720 | 171720 | 207111 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 59 Ralston St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 11 | 5992171.5605 | 2088305.6585 | 37.713640083085 | -122.468944241206 | (37.713640083085, -122.468944241206) | ||||
| 162496 | 162496 | 207110 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 59 Ralston St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 7 | 5992170.63195 | 2088310.84387 | 37.7136542672107 | -122.468947827707 | (37.7136542672107, -122.468947827707) | ||||
| 153486 | 153486 | 207109 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 75 Ralston St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 14 | 5992170.77084 | 2088338.0326 | 37.713728928924105 | -122.46894932506599 | (37.7137289289241, -122.468949325066) | ||||
| 71643 | 71643 | 207108 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 89 Ralston St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 13 | 5992168.92954 | 2088415.8272900002 | 37.7139424279717 | -122.468961347182 | (37.7139424279717, -122.468961347182) | ||||
| 136701 | 136701 | 207107 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 89 Ralston St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 11 | 5992169.5585900005 | 2088419.4087099999 | 37.7139522980308 | -122.46895943344299 | (37.7139522980308, -122.468959433443) | ||||
| 24466 | 24466 | 207106 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 100 Tara St | 2 | : 4 | Tree 1 | Private 1 | 20 | Width 0ft | 5998100.60654 | 2090923.0946 | 37.7211677377768 | -122.448639805789 | (37.7211677377768, -122.448639805789) | |||
| 130081 | 130081 | 207105 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 242 Miramar Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5995373.148580001 | 2091601.55002 | 37.7228742787075 | -122.458116856135 | (37.7228742787075, -122.458116856135) | |||
| 37103 | 37103 | 207104 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 242 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5995372.52306 | 2091590.05793 | 37.7228426882306 | -122.458118187099 | (37.7228426882306, -122.458118187099) | |||
| 171177 | 171177 | 207103 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 40 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5995614.83933 | 2092751.51074 | 37.726045680348705 | -122.457364540844 | (37.7260456803487, -122.457364540844) | |||
| 161309 | 161309 | 207102 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1325 18th Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5990480.890819999 | 2106148.89617 | 37.7625352128593 | -122.476090170539 | (37.7625352128593, -122.476090170539) | |||
| 37042 | 37042 | 207101 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1325 18th Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5990477.30542 | 2106226.48097 | 37.7627480320102 | -122.476108237903 | (37.7627480320102, -122.476108237903) | |||
| 174088 | 174088 | 207100 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1325 18th Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5990476.61635 | 2106239.9997799997 | 37.762785111079396 | -122.476111608564 | (37.7627851110794, -122.476111608564) | |||
| 69434 | 69434 | 207099 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1325 18th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5990478.55232 | 2106260.78747 | 37.7628423007597 | -122.476106431162 | (37.7628423007597, -122.476106431162) | |||
| 154113 | 154113 | 201278 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 28 Lydia Ave | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6012862.05555 | 2092837.94578 | 37.7272585546286 | -122.397747632568 | (37.7272585546286, -122.397747632568) | |||
| 137132 | 137132 | 200619 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1400x La Salle Ave | 60 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 6016453.0429 | 2095085.1899 | 37.733628361140106 | -122.38549003320101 | (37.7336283611401, -122.385490033201) | |||
| 30866 | 30866 | 200618 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1400x La Salle Ave | 59 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6016445.2081 | 2095088.6176 | 37.733637339432 | -122.38551735943399 | (37.733637339432, -122.385517359434) | |||
| 76733 | 76733 | 200616 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1400x La Salle Ave | 57 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6016436.8835 | 2095099.8803 | 37.7336678039609 | -122.385546924914 | (37.7336678039609, -122.385546924914) | |||
| 72294 | 72294 | 200614 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1400x La Salle Ave | 55 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6016432.4764 | 2095111.6325 | 37.73369982930821 | -122.385562980445 | (37.7336998293082, -122.385562980445) | |||
| 76333 | 76333 | 200612 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1400x La Salle Ave | 53 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 6016428.558999999 | 2095128.7713 | 37.7337466722751 | -122.385577718213 | (37.7337466722751, -122.385577718213) | |||
| 38728 | 38728 | 200604 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1400x La Salle Ave | 61 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 6016455.981000001 | 2095075.886 | 37.7336029770488 | -122.385479227084 | (37.7336029770488, -122.385479227084) | |||
| 54994 | 54994 | 191408 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Tulare St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6016232.34971 | 2100308.61772 | 37.747958617113596 | -122.38661714986 | (37.7479586171136, -122.38661714986) | ||||
| 172620 | 172620 | 191407 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Tulare St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6016225.71134 | 2100306.15132 | 37.747951477381 | -122.386639933312 | (37.747951477381, -122.386639933312) | ||||
| 72105 | 72105 | 191406 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Tulare St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6016222.17813 | 2100305.9500599997 | 37.74795072915779 | -122.386652137081 | (37.7479507291578, -122.386652137081) |
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");