Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23613 | 23613 | 177549 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1212 Sunnydale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6008302.63413 | 2087080.3017900002 | 37.7111943147388 | -122.41310263557502 | (37.7111943147388, -122.413102635575) | |||
| 26099 | 26099 | 202241 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 33 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6013196.57345 | 2093194.11858 | 37.728255155426 | -122.396616155019 | (37.728255155426, -122.396616155019) | |||
| 26699 | 26699 | 177553 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1252 Sunnydale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6008169.89589 | 2087127.62977 | 37.7113168149851 | -122.413564758528 | (37.7113168149851, -122.413564758528) | |||
| 26909 | 26909 | 193581 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 500 24th St | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 6016627.824130001 | 2102624.40575 | 37.754339175729704 | -122.38541095757 | (37.7543391757297, -122.38541095757) | ||||
| 28957 | 28957 | 177550 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1232 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6008203.75149 | 2087114.38987 | 37.7112823619554 | -122.41344680884899 | (37.7112823619554, -122.413446808849) | |||
| 29537 | 29537 | 202192 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1928 Armstrong Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6013154.16149 | 2093432.6773299999 | 37.728907828517706 | -122.396779493476 | (37.7289078285177, -122.396779493476) | ||||
| 29584 | 29584 | 202251 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 43 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6013208.3513 | 2093289.05623 | 37.728516490324395 | -122.396582090505 | (37.7285164903244, -122.396582090505) | |||
| 30262 | 30262 | 177548 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1212 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 6008309.89956 | 2087076.14497 | 37.7111833088358 | -122.413077230629 | (37.7111833088358, -122.413077230629) | |||
| 31449 | 31449 | 202248 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 40 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 2ft | 6013204.66207 | 2093259.83536 | 37.72843605046 | -122.396592796933 | (37.72843605046, -122.396592796933) | |||
| 31950 | 31950 | 202214 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6013163.74677 | 2092935.74492 | 37.727543887034294 | -122.396711533513 | (37.7275438870343, -122.396711533513) | |||
| 32468 | 32468 | 193582 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 500 24th St | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6016596.341630001 | 2102622.43103 | 37.7543320117256 | -122.385519695483 | (37.7543320117256, -122.385519695483) | ||||
| 32748 | 32748 | 210125 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 451 Hearst Ave | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 4ft | 5998401.39485 | 2094357.9622 | 37.7306162760214 | -122.447847234167 | (37.7306162760214, -122.447847234167) | |||
| 34092 | 34092 | 193607 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 2001 25th St | 27 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 6ft | 6012652.93364 | 2101843.19483 | 37.7519734254466 | -122.39910239827101 | (37.7519734254466, -122.399102398271) | |||
| 36935 | 36935 | 193602 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 2001 25th St | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 8ft | 6012511.98937 | 2101837.38508 | 37.751949617685106 | -122.399589399153 | (37.7519496176851, -122.399589399153) | |||
| 37143 | 37143 | 202191 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1900 Armstrong Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6013172.4275 | 2093425.71658 | 37.7288897323776 | -122.39671585835698 | (37.7288897323776, -122.396715858357) | ||||
| 38181 | 38181 | 210126 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 331 Hearst Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 4ft | 5999202.63629 | 2094344.01733 | 37.730623751181604 | -122.445076229583 | (37.7306237511816, -122.445076229583) | |||
| 40619 | 40619 | 193584 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 500 24th St | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 6016537.00465 | 2102619.7128 | 37.7543212648174 | -122.385724710323 | (37.7543212648174, -122.385724710323) | ||||
| 41252 | 41252 | 193603 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 2001 25th St | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 8ft | 6012529.65643 | 2101837.23343 | 37.7519501860606 | -122.399528292892 | (37.7519501860606, -122.399528292892) | |||
| 41936 | 41936 | 202255 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 47 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 2ft | 6013211.70344 | 2093322.48938 | 37.728608477487604 | -122.396572844555 | (37.7286084774876, -122.396572844555) | |||
| 42017 | 42017 | 202232 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 24 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6013184.92926 | 2093105.76578 | 37.7280119086008 | -122.396650218641 | (37.7280119086008, -122.396650218641) | |||
| 42368 | 42368 | 202256 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 48 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6013218.75497 | 2093350.94152 | 37.7286869936936 | -122.39655046045701 | (37.7286869936936, -122.396550460457) | |||
| 44645 | 44645 | 202250 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 42 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6013206.90035 | 2093279.9745 | 37.7284914729969 | -122.39658647018999 | (37.7284914729969, -122.39658647019) | |||
| 47095 | 47095 | 250014 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Peter Yorke Way | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 10ft | 6005647.6336900005 | 2114206.58605 | 37.7855274664505 | -122.424206961487 | (37.7855274664505, -122.424206961487) | |||
| 47652 | 47652 | 202182 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1900 Armstrong Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6013216.00577 | 2093392.0868099998 | 37.7287998172575 | -122.39656284771401 | (37.7287998172575, -122.396562847714) | ||||
| 47744 | 47744 | 177551 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1232 Sunnydale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 6ft | 6008194.37646 | 2087118.0668 | 37.711291931647104 | -122.4134794713 | (37.7112919316471, -122.4134794713) | |||
| 47951 | 47951 | 202233 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 25 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | 6013185.992269999 | 2093116.5375599999 | 37.728041544874294 | -122.39664729856001 | (37.7280415448743, -122.39664729856) | |||
| 48951 | 48951 | 210183 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 601 Foerster St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 5998096.056580001 | 2095294.6170700002 | 37.7331706509866 | -122.448970276062 | (37.7331706509866, -122.448970276062) | |||
| 49456 | 49456 | 202243 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 35 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6013198.7947 | 2093213.4173 | 37.7283082693961 | -122.39660982829399 | (37.7283082693961, -122.396609828294) | |||
| 51187 | 51187 | 202223 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6013174.84825 | 2093025.0903 | 37.72778982911289 | -122.396679416033 | (37.7277898291129, -122.396679416033) | |||
| 53130 | 53130 | 177558 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1272 Sunnydale Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 6ft | 6007990.6783 | 2087195.6021 | 37.7114933878791 | -122.41418898783701 | (37.7114933878791, -122.414188987837) | |||
| 54110 | 54110 | 202228 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6013179.65142 | 2093067.6055 | 37.7279068345108 | -122.396665790418 | (37.7279068345108, -122.396665790418) | |||
| 54497 | 54497 | 193604 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 2001 25th St | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 8ft | 6012551.652419999 | 2101838.54345 | 37.7519550091186 | -122.39945231908001 | (37.7519550091186, -122.39945231908) | |||
| 55278 | 55278 | 177556 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1272 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 6008061.6956 | 2087168.1827200002 | 37.711422088742104 | -122.413941594254 | (37.7114220887421, -122.413941594254) | |||
| 56603 | 56603 | 210159 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 201 Judson Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 10ft | 5998628.98147 | 2093469.7258900001 | 37.7281903934576 | -122.446996541164 | (37.7281903934576, -122.446996541164) | |||
| 56626 | 56626 | 202219 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6013170.94879 | 2092985.5006 | 37.7276809068355 | -122.396690122445 | (37.7276809068355, -122.396690122445) | |||
| 57838 | 57838 | 202215 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6013165.33275 | 2092944.54355 | 37.72756813455079 | -122.396706667284 | (37.7275681345508, -122.396706667284) | |||
| 57934 | 57934 | 193601 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 2001 25th St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 8ft | 6012482.13162 | 2101834.80897 | 37.7519408798827 | -122.399692471326 | (37.7519408798827, -122.399692471326) | |||
| 60161 | 60161 | 202236 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 28 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6013189.66424 | 2093144.91801 | 37.728119676166294 | -122.396636593026 | (37.7281196761663, -122.396636593026) | |||
| 60370 | 60370 | 202253 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 45 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 6013211.002830001 | 2093308.76677 | 37.7285707590106 | -122.396574305077 | (37.7285707590106, -122.396574305077) | |||
| 61514 | 61514 | 193592 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1201 20th St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 6ft | 6014276.2698800005 | 2104771.66657 | 37.760104709591396 | -122.39369357509199 | (37.7601047095914, -122.393693575092) | |||
| 62663 | 62663 | 177555 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1262 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 6008091.22398 | 2087157.2966900002 | 37.7113938563146 | -122.41383876666401 | (37.7113938563146, -122.413838766664) | |||
| 62847 | 62847 | 202234 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 26 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6013186.88595 | 2093125.91095 | 37.7280673320297 | -122.396644865872 | (37.7280673320297, -122.396644865872) | |||
| 64213 | 64213 | 202181 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1900 Armstrong Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6013222.94706 | 2093387.62112 | 37.7287879416857 | -122.396538538139 | (37.7287879416857, -122.396538538139) | ||||
| 65612 | 65612 | 210109 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1250 14th Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 5ft | 5991789.6172400005 | 2106834.59877 | 37.764493770786295 | -122.471613776178 | (37.7644937707863, -122.471613776178) | |||
| 67573 | 67573 | 210176 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 77 Mangels Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6000817.03746 | 2095186.4221400002 | 37.7330288117357 | -122.43955538059299 | (37.7330288117357, -122.439555380593) | ||||
| 68450 | 68450 | 177557 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1272 Sunnydale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6008002.127780001 | 2087190.6623 | 37.7114804673251 | -122.414149066054 | (37.7114804673251, -122.414149066054) | |||
| 68587 | 68587 | 177554 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1250 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6008137.76094 | 2087139.4402400001 | 37.711347439601 | -122.41367666025101 | (37.711347439601, -122.413676660251) | |||
| 69181 | 69181 | 193579 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 500 24th St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6016687.20636 | 2102628.57061 | 37.7543538967387 | -122.385205886941 | (37.7543538967387, -122.385205886941) | ||||
| 70409 | 70409 | 202220 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6013171.59545 | 2092996.56118 | 37.7277113129249 | -122.396688661969 | (37.7277113129249, -122.396688661969) | |||
| 73562 | 73562 | 193578 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 500 24th St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6016715.48057 | 2102629.85839 | 37.7543589967884 | -122.385108196298 | (37.7543589967884, -122.385108196298) | ||||
| 74266 | 74266 | 193576 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 500 24th St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6016775.537380001 | 2102634.6197099998 | 37.7543753923365 | -122.384900834212 | (37.7543753923365, -122.384900834212) | ||||
| 74642 | 74642 | 119410 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 375 32nd Ave | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 9ft | 5985887.68292 | 2113265.4589 | 37.78180786995821 | -122.49250029292101 | (37.7818078699582, -122.492500292921) | |||
| 74867 | 74867 | 193580 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 500 24th St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 6016656.51597 | 2102626.40234 | 37.754346245297704 | -122.385311872064 | (37.7543462452977, -122.385311872064) | ||||
| 75305 | 75305 | 202252 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 44 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6013209.67836 | 2093298.98157 | 37.728543817137705 | -122.396578198225 | (37.7285438171377, -122.396578198225) | |||
| 75390 | 75390 | 202239 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 31 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6013193.35893 | 2093174.4194599998 | 37.7282008867581 | -122.396625887476 | (37.7282008867581, -122.396625887476) | |||
| 75865 | 75865 | 202249 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6013205.71087 | 2093269.90652 | 37.7284637621797 | -122.396589876845 | (37.7284637621797, -122.396589876845) | |||
| 75880 | 75880 | 202227 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6013178.67077 | 2093060.8969999999 | 37.7278883597585 | -122.39666871048901 | (37.7278883597585, -122.396668710489) | |||
| 76598 | 76598 | 131210 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1990 Beach St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6000793.88519 | 2120995.1927900002 | 37.803891943721204 | -122.44148677448798 | (37.8038919437212, -122.441486774488) | |||
| 76877 | 76877 | 193600 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 2001 25th St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 8ft | 6012450.86154 | 2101834.3619999997 | 37.7519379094129 | -122.399800577033 | (37.7519379094129, -122.399800577033) | |||
| 121250 | 121250 | 193606 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 2001 25th St | 25 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 8ft | 6012631.43152 | 2101842.51338 | 37.7519703560546 | -122.399176708358 | (37.7519703560546, -122.399176708358) | |||
| 130399 | 130399 | 202187 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1900 Armstrong Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6013192.18875 | 2093410.8992700002 | 37.7288501469128 | -122.39664650355101 | (37.7288501469128, -122.396646503551) | ||||
| 131371 | 131371 | 177546 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1200 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 6ft | 6008407.5541199995 | 2087041.9081400002 | 37.711094783172 | -122.4127372923 | (37.711094783172, -122.4127372923) | |||
| 134932 | 134932 | 202258 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 50 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 9ft | 6013221.11687 | 2093370.23706 | 37.7287401067524 | -122.396543647186 | (37.7287401067524, -122.396543647186) | |||
| 136482 | 136482 | 202212 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6013161.674930001 | 2092916.86339 | 37.7274919268866 | -122.39671737281999 | (37.7274919268866, -122.39671737282) | |||
| 137380 | 137380 | 250012 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Peter Yorke Way | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 10ft | 6005639.67048 | 2114203.54458 | 37.785518665693004 | -122.424234295496 | (37.785518665693, -122.424234295496) | |||
| 137586 | 137586 | 202183 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1900 Armstrong Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6013209.30016 | 2093397.98949 | 37.728815651621794 | -122.39658644321999 | (37.7288156516218, -122.39658644322) | ||||
| 148510 | 148510 | 210141 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 158 Staples Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 5999025.5488599995 | 2093811.1604900002 | 37.7291505420527 | -122.445650140956 | (37.7291505420527, -122.445650140956) | ||||
| 148671 | 148671 | 202210 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6013159.58864 | 2092897.28158 | 37.727438043107796 | -122.39672321300101 | (37.7274380431078, -122.396723213001) | |||
| 150759 | 150759 | 202240 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 32 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6013194.80989 | 2093183.5011900002 | 37.728225904088895 | -122.396621507785 | (37.7282259040889, -122.396621507785) | |||
| 152057 | 152057 | 193605 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 2001 25th St | 23 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 8ft | 6012610.5609800005 | 2101841.33996 | 37.7519659709715 | -122.39924879979799 | (37.7519659709715, -122.399248799798) | |||
| 152959 | 152959 | 202225 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6013176.52464 | 2093041.86631 | 37.727835985918205 | -122.396674796225 | (37.7278359859182, -122.396674796225) | |||
| 154032 | 154032 | 202186 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1900 Armstrong Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6013197.89366 | 2093408.01538 | 37.7288425458475 | -122.396626579067 | (37.7288425458475, -122.396626579067) | ||||
| 154852 | 154852 | 202245 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 37 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6013200.83525 | 2093230.7571400001 | 37.728355994623996 | -122.396603988992 | (37.728355994624, -122.396603988992) | |||
| 156402 | 156402 | 202213 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 6013162.96536 | 2092924.96744 | 37.727514250778896 | -122.39671347965 | (37.7275142507789, -122.39671347965) | |||
| 156530 | 156530 | 250013 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Peter Yorke Way | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 10ft | 6005644.7352599995 | 2114200.81788 | 37.78551146482779 | -122.42421657883499 | (37.7855114648278, -122.424216578835) | |||
| 159614 | 159614 | 202224 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6013176.16423 | 2093034.4554599999 | 37.7278156171758 | -122.396675522878 | (37.7278156171758, -122.396675522878) | |||
| 159846 | 159846 | 202185 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1900 Armstrong Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6013201.169530001 | 2093404.0212700001 | 37.728831761154794 | -122.396614974207 | (37.7288317611548, -122.396614974207) | ||||
| 161478 | 161478 | 202217 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6013167.96472 | 2092963.2735400002 | 37.7276197097745 | -122.396698880956 | (37.7276197097745, -122.396698880956) | |||
| 161620 | 161620 | 202257 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 49 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 6ft | 6013220.214430001 | 2093360.4433 | 37.7287131648642 | -122.39654608076 | (37.7287131648642, -122.39654608076) | |||
| 162000 | 162000 | 202221 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6013173.04643 | 2093005.64291 | 37.7277363302611 | -122.396684282259 | (37.7277363302611, -122.396684282259) | |||
| 163639 | 163639 | 177552 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1252 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 6ft | 6008179.27118 | 2087123.9525 | 37.7113072443981 | -122.413532095133 | (37.7113072443981, -122.413532095133) | |||
| 164653 | 164653 | 202218 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6013169.31452 | 2092974.31986 | 37.727650115843794 | -122.396694988704 | (37.7276501158438, -122.396694988704) | |||
| 168123 | 168123 | 202242 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 34 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6013197.3579400005 | 2093205.03586 | 37.7282851757099 | -122.396614207973 | (37.7282851757099, -122.396614207973) | |||
| 168263 | 168263 | 193583 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 500 24th St | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 6016566.8369 | 2102621.0686 | 37.7543266382749 | -122.38562163635 | (37.7543266382749, -122.38562163635) | ||||
| 170594 | 170594 | 202235 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 27 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6013188.17067 | 2093133.73442 | 37.7280888851842 | -122.39664097272801 | (37.7280888851842, -122.396640972728) | |||
| 171447 | 171447 | 202211 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6013160.61758 | 2092906.3718700001 | 37.7274630604606 | -122.396720292924 | (37.7274630604606, -122.396720292924) | |||
| 172298 | 172298 | 202246 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 38 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6013202.20801 | 2093242.92412 | 37.728389479068 | -122.39660009581499 | (37.728389479068, -122.396600095815) | |||
| 172708 | 172708 | 177547 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1202 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 6ft | 6008380.574519999 | 2087049.08192 | 37.7111129665536 | -122.412831047535 | (37.7111129665536, -122.412831047535) | |||
| 174078 | 174078 | 119938 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 2500 Balboa St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5987749.91083 | 2111234.09886 | 37.77633903201821 | -122.48590878771401 | (37.7763390320182, -122.485908787714) | |||
| 174289 | 174289 | 202189 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1900 Armstrong Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6013185.46255 | 2093415.77263 | 37.7288631538118 | -122.396670098144 | (37.7288631538118, -122.396670098144) | ||||
| 174344 | 174344 | 193577 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 500 24th St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 6016746.30136 | 2102631.89145 | 37.754366284000795 | -122.385001750754 | (37.7543662840008, -122.385001750754) | ||||
| 174758 | 174758 | 202230 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6013182.01879 | 2093087.1816200002 | 37.727960718302896 | -122.396658978052 | (37.7279607183029, -122.396658978052) | |||
| 175713 | 175713 | 210175 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 77 Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 6000806.93054 | 2095185.9336700002 | 37.7330268952766 | -122.439590287785 | (37.7330268952766, -122.439590287785) | ||||
| 176678 | 176678 | 202216 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6013166.11984 | 2092955.6012799998 | 37.7275985406314 | -122.396704721146 | (37.7275985406314, -122.396704721146) | |||
| 176704 | 176704 | 210177 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 77 Mangels Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 8ft | 6000839.931480001 | 2095188.1820099999 | 37.733034946901704 | -122.43947635624399 | (37.7330349469017, -122.439476356244) | |||
| 178625 | 178625 | 202231 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 23 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6013182.918409999 | 2093096.83525 | 37.727987275271396 | -122.396656544473 | (37.7279872752714, -122.396656544473) | |||
| 180423 | 180423 | 202229 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 21 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6013180.4101 | 2093077.2619900003 | 37.7279333914885 | -122.39666384428001 | (37.7279333914885, -122.39666384428) | |||
| 185037 | 185037 | 193575 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 500 24th St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 6016805.54039 | 2102635.7401099997 | 37.7543801281586 | -122.38479715317 | (37.7543801281586, -122.38479715317) | ||||
| 185328 | 185328 | 202226 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6013177.60207 | 2093049.8453 | 37.7278579545638 | -122.396671630611 | (37.7278579545638, -122.396671630611) | |||
| 185762 | 185762 | 202254 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 46 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 6013211.29686 | 2093316.3299599998 | 37.7285915423502 | -122.39657381854401 | (37.7285915423502, -122.396573818544) |
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");