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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5259 | 5259 | 42922 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2000 12:00:00 AM | Permit Number 42829 | |||||||||
| 157253 | 157253 | 131214 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | * Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6004570.89315 | 2118403.70426 | 37.7969908368189 | -122.428231397978 | (37.7969908368189, -122.428231397978) | |||
| 106038 | 106038 | 39328 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 0 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40896 | 6017074.59942826 | 2104815.9109509 | 37.7603812969624 | -122.38401847505399 | (37.7603812969624, -122.384018475054) | |||
| 126642 | 126642 | 39330 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 0 20th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40896 | 6017074.59942826 | 2104815.9109509 | 37.7603812969624 | -122.38401847505399 | (37.7603812969624, -122.384018475054) | |||
| 145158 | 145158 | 39329 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 0 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40896 | 6017074.59942826 | 2104815.9109509 | 37.7603812969624 | -122.38401847505399 | (37.7603812969624, -122.384018475054) | |||
| 52332 | 52332 | 201344 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Bitting Ave | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 2ft | 6012750.594330001 | 2092624.2153200002 | 37.7266654868035 | -122.39811796796499 | (37.7266654868035, -122.398117967965) | |||
| 64584 | 64584 | 201341 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Bitting Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 2ft | 6012735.10181 | 2092634.8954900003 | 37.726693949445 | -122.398172274424 | (37.726693949445, -122.398172274424) | |||
| 151860 | 151860 | 201339 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Bitting Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 2ft | 6012722.61322 | 2092644.3841099998 | 37.7267193076322 | -122.39821611279899 | (37.7267193076322, -122.398216112799) | |||
| 15345 | 15345 | 25550 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1 Industrial St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/1997 12:00:00 AM | 8 | 3X3 | 6012164.070040001 | 2097372.25832 | 37.739669937231 | -122.40047894733999 | (37.739669937231, -122.40047894734) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 185974 | 185974 | 202222 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6013173.80227 | 2093015.1592700002 | 37.7277625023133 | -122.396682336131 | (37.7277625023133, -122.396682336131) | |||
| 188576 | 188576 | 202247 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 39 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6013203.9034 | 2093250.1788700002 | 37.728409493486296 | -122.39659474307501 | (37.7284094934863, -122.396594743075) | |||
| 36083 | 36083 | 250018 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Peter Yorke Way | 7 | : 4 | Tree 1 | Private 1 | 11 | Width 5ft | 6005787.19276 | 2114383.50511 | 37.7860211214227 | -122.42373671138701 | (37.7860211214227, -122.423736711387) | |||
| 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) | |||
| 59834 | 59834 | 250019 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Peter Yorke Way | 9 | : 4 | Tree 1 | Private 1 | 10 | Width 5ft | 6005819.0053199995 | 2114422.18901 | 37.786129133596 | -122.42362939977501 | (37.786129133596, -122.423629399775) | |||
| 60363 | 60363 | 250011 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Peter Yorke Way | 5 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6005651.53308 | 2114225.44639 | 37.7855794724472 | -122.424194812544 | (37.7855794724472, -122.424194812544) | |||
| 74661 | 74661 | 250017 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Peter Yorke Way | 6 | : 4 | Tree 1 | Private 1 | 10 | Width 5ft | 6005762.80005 | 2114349.91412 | 37.7859275118887 | -122.423818714288 | (37.7859275118887, -122.423818714288) | |||
| 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) | |||
| 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) | |||
| 163792 | 163792 | 250010 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Peter Yorke Way | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6005626.073059999 | 2114211.10885 | 37.785538667527206 | -122.424281876805 | (37.7855386675272, -122.424281876805) | |||
| 144351 | 144351 | 41038 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 10 Jennings St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/1999 12:00:00 AM | Permit Number 41823 | 6012891.67554567 | 2089346.007114 | 37.717672045776204 | -122.39740045328699 | (37.7176720457762, -122.397400453287) | |||
| 83598 | 83598 | 88611 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 10 Kirkham St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2010 12:00:00 AM | 3x3 | Permit Number 53153 | 5994911.9 | 2105351.2 | 37.7606008853336 | -122.460707220473 | (37.7606008853336, -122.460707220473) | ||
| 90818 | 90818 | 88609 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 10 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2010 12:00:00 AM | 3x3 | Permit Number 53153 | 5994911.9 | 2105351.2 | 37.7606008853336 | -122.460707220473 | (37.7606008853336, -122.460707220473) | ||
| 101310 | 101310 | 88610 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 10 Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2010 12:00:00 AM | 3x3 | Permit Number 53153 | 5994911.9 | 2105351.2 | 37.7606008853336 | -122.460707220473 | (37.7606008853336, -122.460707220473) | ||
| 127562 | 127562 | 88613 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 10 Kirkham St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2010 12:00:00 AM | 3x3 | Permit Number 53153 | 5994911.9 | 2105351.2 | 37.7606008853336 | -122.460707220473 | (37.7606008853336, -122.460707220473) | ||
| 143573 | 143573 | 93073 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 10 Kirkham St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2010 12:00:00 AM | 3x3 | Permit Number 53153 | 5994911.9 | 2105351.2 | 37.7606008853336 | -122.460707220473 | (37.7606008853336, -122.460707220473) | ||
| 144935 | 144935 | 88612 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 10 Kirkham St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2010 12:00:00 AM | 3x3 | Permit Number 53153 | 5994911.9 | 2105351.2 | 37.7606008853336 | -122.460707220473 | (37.7606008853336, -122.460707220473) | ||
| 146123 | 146123 | 93071 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 10 Kirkham St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2010 12:00:00 AM | 3x3 | Permit Number 53153 | 5994911.9 | 2105351.2 | 37.7606008853336 | -122.460707220473 | (37.7606008853336, -122.460707220473) | ||
| 64294 | 64294 | 177562 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 10 Ruth St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 2ft | 6001656.83533 | 2091594.1990900002 | 37.7232131468593 | -122.43639497677201 | (37.7232131468593, -122.436394976772) | |||
| 76672 | 76672 | 177561 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 10 Ruth St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 2ft | 6001695.33402 | 2091574.4813599999 | 37.7231611939064 | -122.436260484046 | (37.7231611939064, -122.436260484046) | |||
| 78655 | 78655 | 41040 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 100 Jennings St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/1999 12:00:00 AM | Permit Number 41824 | 6018973.83890969 | 2097433.1098399 | 37.740214436894604 | -122.376937636731 | (37.7402144368946, -122.376937636731) | |||
| 80072 | 80072 | 11492 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 100 Jennings St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/13/2000 12:00:00 AM | 3 | 4X4 | 6018974.640384 | 2097432.5118216 | 37.7402128389975 | -122.376934824049 | (37.7402128389975, -122.376934824049) | ||
| 85301 | 85301 | 11491 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 100 Jennings St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/13/2000 12:00:00 AM | 3 | 4X4 | 6018974.640384 | 2097432.5118216 | 37.7402128389975 | -122.376934824049 | (37.7402128389975, -122.376934824049) | ||
| 87201 | 87201 | 11504 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 100 Jennings St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/1998 12:00:00 AM | 3 | 4X4 | 6018974.640384 | 2097432.5118216 | 37.7402128389975 | -122.376934824049 | (37.7402128389975, -122.376934824049) | ||
| 95813 | 95813 | 41043 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 100 Jennings St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/1999 12:00:00 AM | Permit Number 41824 | 6018973.83890969 | 2097433.1098399 | 37.740214436894604 | -122.376937636731 | (37.7402144368946, -122.376937636731) | |||
| 102462 | 102462 | 11493 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 100 Jennings St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2008 12:00:00 AM | 3 | 4X4 | 6018974.640384 | 2097432.5118216 | 37.7402128389975 | -122.376934824049 | (37.7402128389975, -122.376934824049) | ||
| 106048 | 106048 | 41042 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 100 Jennings St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/1999 12:00:00 AM | Permit Number 41824 | 6018973.83890969 | 2097433.1098399 | 37.740214436894604 | -122.376937636731 | (37.7402144368946, -122.376937636731) | |||
| 122197 | 122197 | 41039 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 100 Jennings St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/1999 12:00:00 AM | Permit Number 41824 | 6018973.83890969 | 2097433.1098399 | 37.740214436894604 | -122.376937636731 | (37.7402144368946, -122.376937636731) | |||
| 124419 | 124419 | 41041 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 100 Jennings St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/1999 12:00:00 AM | Permit Number 41824 | 6018973.83890969 | 2097433.1098399 | 37.740214436894604 | -122.376937636731 | (37.7402144368946, -122.376937636731) | |||
| 140516 | 140516 | 11495 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 100 Jennings St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/13/2000 12:00:00 AM | 3 | 4X4 | 6018974.640384 | 2097432.5118216 | 37.7402128389975 | -122.376934824049 | (37.7402128389975, -122.376934824049) | ||
| 22321 | 22321 | 3630 | Private 5 | Melaleuca quinquenervia :: Cajeput 50 | 100X Cargo Way | 66 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12 | 3X3 | 6017698.24794 | 2098446.68655 | 37.7429271764597 | -122.381418626885 | (37.7429271764597, -122.381418626885) | |||
| 9247 | 9247 | 24150 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 100X Whitney Young Cir | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/12/1996 12:00:00 AM | 7 | 3x3 | 6016357.373923 | 2096088.8828188 | 37.736379006835996 | -122.385890729183 | (37.736379006836, -122.385890729183) | ||
| 14351 | 14351 | 24146 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 100X Whitney Young Cir | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/24/2016 12:00:00 AM | 12 | 3x3 | 6016692.87185 | 2095191.38157 | 37.733933208639606 | -122.384668261453 | (37.7339332086396, -122.384668261453) | ||
| 165463 | 165463 | 104005 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 101 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6013458.50416 | 2106497.83722 | 37.7647989188549 | -122.396642864878 | (37.7647989188549, -122.396642864878) | |||
| 119829 | 119829 | 39562 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1012 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2016 12:00:00 AM | 9 | 3x3 | Permit Number 40983 | 6012154.28622 | 2103652.62912 | 37.7569139356407 | -122.40095392338002 | (37.7569139356407, -122.40095392338) |
| 15112 | 15112 | 11554 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 101X Jennings St | 44 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/23/1997 12:00:00 AM | 3 | 3X3 | 6018972.44427 | 2097338.24769 | 37.7399538873755 | -122.37693587968398 | (37.7399538873755, -122.376935879684) | ||
| 78194 | 78194 | 11543 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 101X Jennings St | 33 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/23/1997 12:00:00 AM | 3 | 3X3 | 6018704.60401 | 2097015.07701 | 37.7390517691962 | -122.377839546083 | (37.7390517691962, -122.377839546083) | ||
| 109551 | 109551 | 11514 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 101X Jennings St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/23/1997 12:00:00 AM | 3 | 3X3 | 6018414.23901 | 2096612.7330099999 | 37.7379310078681 | -122.378815574261 | (37.7379310078681, -122.378815574261) | ||
| 13934 | 13934 | 24172 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 101X Whitney Young Cir | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/26/2000 12:00:00 AM | 12 | 3x3 | 6016627.62077 | 2095425.11976 | 37.7345713981576 | -122.384910134993 | (37.7345713981576, -122.384910134993) | ||
| 14512 | 14512 | 24130 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 101X Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016633.73992 | 2095504.76195 | 37.734790418140605 | -122.384894525455 | (37.7347904181406, -122.384894525455) | |||
| 103134 | 103134 | 1983 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 102 Bertha Ln | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/1996 12:00:00 AM | 12 | 3X4 | 6017840.507549 | 2094792.7784106003 | 37.732902124826104 | -122.38067279528299 | (37.7329021248261, -122.380672795283) | ||
| 132102 | 132102 | 232084 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 103 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006751.33512 | 2096933.5524400002 | 37.7381620061748 | -122.41916279631901 | (37.7381620061748, -122.419162796319) | |||
| 32914 | 32914 | 210110 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1039 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5991591.03653 | 2105189.72808 | 37.7599659019171 | -122.47218069799999 | (37.7599659019171, -122.472180698) | |||
| 80027 | 80027 | 46691 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1039 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/2002 12:00:00 AM | Permit Number 44820 | 5991711.18613678 | 2105195.27676174 | 37.75998808961071 | -122.47176556697201 | (37.7599880896107, -122.471765566972) | ||
| 12251 | 12251 | 97320 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1044 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/16/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774147 | 5989913.4382 | 2099069.7096 | 37.7430647189098 | -122.47753531433399 | (37.7430647189098, -122.477535314334) | |
| 9342 | 9342 | 24095 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 105X Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/15/1996 12:00:00 AM | 5 | 3x3 | 6016397.2233978 | 2096041.0813580002 | 37.7362499588234 | -122.385749620885 | (37.7362499588234, -122.385749620885) | ||
| 34925 | 34925 | 202296 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 106 Orsi Cir | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 2ft | 6012783.083 | 2093197.04815 | 37.7282401781334 | -122.39804582346001 | (37.7282401781334, -122.39804582346) |
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");