Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, DBH, PlotSize, PermitNotes
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7461 | 7461 | 2625 | Permitted Site 1 | Pittosporum tobira :: Japanese Mockorange 243 | 1843 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6004676.1259 | 2115014.606 | 37.7876911844813 | -122.427625683257 | (37.7876911844813, -122.427625683257) | |||
| 10300 | 10300 | 25372 | Permitted Site 1 | Pittosporum tobira :: Japanese Mockorange 243 | 1134 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/1996 12:00:00 AM | 3 | 3X3 | 6001336.176519999 | 2088457.2453299998 | 37.7145815500755 | -122.437278923085 | (37.7145815500755, -122.437278923085) | ||
| 17588 | 17588 | 29573 | DPW Maintained 3 | Pittosporum tobira :: Japanese Mockorange 243 | 400X Junipero Serra Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/2007 12:00:00 AM | 3 | 3X3 | 5991380.2029099995 | 2094265.78979 | 37.72995937881971 | -122.472113603178 | (37.7299593788197, -122.472113603178) | ||
| 18817 | 18817 | 17109 | DPW Maintained 3 | Pittosporum tobira :: Japanese Mockorange 243 | 1809 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5998305.0552 | 2109267.4722 | 37.7715486168192 | -122.449254046357 | (37.7715486168192, -122.449254046357) | |||
| 21428 | 21428 | 11880 | DPW Maintained 3 | Pittosporum tobira :: Japanese Mockorange 243 | 300X Junipero Serra Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 20 | 5991398.90192 | 2094575.3907700002 | 37.7308105475711 | -122.472071516681 | (37.7308105475711, -122.472071516681) | |||
| 21720 | 21720 | 29960 | DPW Maintained 3 | Pittosporum tobira :: Japanese Mockorange 243 | 400X Junipero Serra Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/2007 12:00:00 AM | 3 | 3x3 | 5991377.13547 | 2094257.77257 | 37.7299371880305 | -122.47212362343201 | (37.7299371880305, -122.472123623432) | ||
| 23947 | 23947 | 234025 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 1548 Noe St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | 6003282.4474 | 2099242.36534 | 37.744305509797 | -122.43132123828899 | (37.744305509797, -122.431321238289) | |||
| 26856 | 26856 | 211521 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 210 Vernon St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 5992480.41051 | 2089284.24436 | 37.7163448831965 | -122.46794788860399 | (37.7163448831965, -122.467947888604) | |||
| 27170 | 27170 | 211520 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 136 Caine Ave | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 10ft | 5997136.50298 | 2089006.99788 | 37.7158514071876 | -122.451834257948 | (37.7158514071876, -122.451834257948) | |||
| 28509 | 28509 | 234021 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 147 Nevada St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | Width 3ft | 6009064.5456300005 | 2097789.7459400003 | 37.7406429263284 | -122.411225300822 | (37.7406429263284, -122.411225300822) | |||
| 28950 | 28950 | 132461 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 1109 Chestnut St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6006461.025 | 2120401.5247299997 | 37.8025831108771 | -122.42183305885901 | (37.8025831108771, -122.421833058859) | ||||
| 29168 | 29168 | 132450 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 1270 Clay St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 6008641.43402 | 2116990.25696 | 37.793339334804 | -122.414046256445 | (37.793339334804, -122.414046256445) | |||
| 30065 | 30065 | 234026 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 415 Beacon St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6002307.79046 | 2098328.73055 | 37.741741597487895 | -122.43462607412901 | (37.7417415974879, -122.434626074129) | |||
| 30425 | 30425 | 211532 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 370 Monterey Blvd | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 8ft | 5999661.02521 | 2094721.9555900001 | 37.7316876338771 | -122.443518653277 | (37.7316876338771, -122.443518653277) | |||
| 30559 | 30559 | 132458 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 1111 Chestnut St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6006447.34782 | 2120399.73433 | 37.802577423578896 | -122.421880261576 | (37.8025774235789, -122.421880261576) | ||||
| 31718 | 31718 | 234024 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 1457 Noe St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6003332.4002 | 2099733.23178 | 37.7456561458138 | -122.431183542201 | (37.7456561458138, -122.431183542201) | |||
| 33132 | 33132 | 178424 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 421 Harvard St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6006514.98765 | 2091903.4778900002 | 37.724337211269706 | -122.419623183572 | (37.7243372112697, -122.419623183572) | |||
| 33911 | 33911 | 194608 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 1701 19th St | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 7ft | 6012624.29476 | 2105144.67 | 37.761036958503205 | -122.39943319231001 | (37.7610369585032, -122.39943319231) | |||
| 39108 | 39108 | 132463 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 10 Havens St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 5ft | 6007395.04412 | 2119352.97645 | 37.7997566900644 | -122.418526481017 | (37.7997566900644, -122.418526481017) | |||
| 39383 | 39383 | 211527 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 300 Junipero Serra Blvd | 27 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5991396.335969999 | 2094453.64108 | 37.7304761049763 | -122.47207151668002 | (37.7304761049763, -122.47207151668) | |||
| 40239 | 40239 | 211519 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 1215 Capitol Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5995031.256440001 | 2091999.9286599997 | 37.7239484802273 | -122.45932753335899 | (37.7239484802273, -122.459327533359) | |||
| 40573 | 40573 | 194605 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 601 Carolina St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 9ft | 6012419.56999 | 2105123.3254299997 | 37.7609669381886 | -122.40013975184401 | (37.7609669381886, -122.400139751844) | |||
| 42135 | 42135 | 234023 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 1457 Noe St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 6003332.6801 | 2099728.28161 | 37.7456425696603 | -122.431182221081 | (37.7456425696603, -122.431182221081) | |||
| 45925 | 45925 | 194607 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 1701 19th St | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 7ft | 6012598.43668 | 2105146.1644 | 37.7610396205128 | -122.399522729686 | (37.7610396205128, -122.399522729686) | |||
| 46805 | 46805 | 211523 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 401 Victoria St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 5993219.9423 | 2089913.80561 | 37.7181161851864 | -122.46543743469499 | (37.7181161851864, -122.465437434695) | |||
| 47078 | 47078 | 178427 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 316 Naylor St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 6002735.2545300005 | 2086567.4908099999 | 37.7094721319023 | -122.43230826222799 | (37.7094721319023, -122.432308262228) | ||||
| 48774 | 48774 | 211536 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 334 Judson Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | 5997845.92784 | 2093590.624 | 37.7284775820656 | -122.44971228330401 | (37.7284775820656, -122.449712283304) | |||
| 49062 | 49062 | 97339 | Permitted Site 1 | Pittosporum tobira :: Japanese Mockorange 243 | 1223 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 5989371.5403 | 2098984.5119 | 37.742799327814396 | -122.47940279801 | (37.7427993278144, -122.47940279801) | |||
| 49854 | 49854 | 132449 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 1341 Bay St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 4ft | 6004363.25375 | 2120796.06015 | 37.803547878401496 | -122.429120545984 | (37.8035478784015, -122.429120545984) | |||
| 50534 | 50534 | 61224 | Permitted Site 1 | Pittosporum tobira :: Japanese Mockorange 243 | 37 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/1983 12:00:00 AM | 6 | Permit Number 21093 | 6005096.469880001 | 2093267.0801900001 | 37.7280013568595 | -122.424623758583 | (37.7280013568595, -122.424623758583) | ||
| 51836 | 51836 | 178426 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 102 Bowdoin St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6008420.44433 | 2094541.08312 | 37.7316866608147 | -122.413222695081 | (37.7316866608147, -122.413222695081) | |||
| 52802 | 52802 | 194602 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 500 Wisconsin St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 9ft | 6012630.51831 | 2105140.83146 | 37.7610267655993 | -122.39941139812599 | (37.7610267655993, -122.399411398126) | |||
| 54821 | 54821 | 246877 | DPW Maintained 3 | Pittosporum tobira :: Japanese Mockorange 243 | 3090x Market St | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | 5999897.283969999 | 2105334.9627099996 | 37.760841873084004 | -122.443463930427 | (37.760841873084, -122.443463930427) | ||||
| 56369 | 56369 | 132454 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 1111 Chestnut St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6006428.736380001 | 2120397.55725 | 37.8025703962611 | -122.42194451183799 | (37.8025703962611, -122.421944511838) | ||||
| 57332 | 57332 | 178422 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 225 Silver Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 4ft | 6002666.77722 | 2093942.85568 | 37.7297193641361 | -122.433071531246 | (37.7297193641361, -122.433071531246) | |||
| 58438 | 58438 | 178425 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 102 Bowdoin St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6008414.59358 | 2094563.5798 | 37.7317481033768 | -122.41324451262899 | (37.7317481033768, -122.413244512629) | |||
| 60330 | 60330 | 250004 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 232 Filbert St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | Width 0ft | 6011504.01109 | 2120100.18107 | 37.802038796226796 | -122.40436048246599 | (37.8020387962268, -122.404360482466) | |||
| 60480 | 60480 | 234019 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 410 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6003269.19484 | 2099235.3401900004 | 37.744285469299605 | -122.43136656141199 | (37.7442854692996, -122.431366561412) | |||
| 61478 | 61478 | 211516 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 1919 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5993127.72068 | 2102391.5221700002 | 37.752371564303004 | -122.46666269445 | (37.752371564303, -122.46666269445) | |||
| 61666 | 61666 | 246880 | DPW Maintained 3 | Pittosporum tobira :: Japanese Mockorange 243 | 3090x Market St | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | 5999883.5078300005 | 2105331.77962 | 37.7608323474605 | -122.44351134718201 | (37.7608323474605, -122.443511347182) | ||||
| 62403 | 62403 | 132460 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 1109 Chestnut St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6006458.07728 | 2120400.55617 | 37.8025802852249 | -122.421843190623 | (37.8025802852249, -122.421843190623) | ||||
| 64328 | 64328 | 246881 | DPW Maintained 3 | Pittosporum tobira :: Japanese Mockorange 243 | 3090x Market St | 14 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | 5999878.735309999 | 2105330.61775 | 37.760828885074204 | -122.443527769696 | (37.7608288850742, -122.443527769696) | ||||
| 64461 | 64461 | 132451 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 1111 Chestnut St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6006416.48841 | 2120396.60809 | 37.8025670993539 | -122.421986828545 | (37.8025670993539, -122.421986828545) | ||||
| 65399 | 65399 | 178428 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 316 Naylor St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 6002738.37223 | 2086564.4862099998 | 37.709464058702295 | -122.43229727250099 | (37.7094640587023, -122.432297272501) | ||||
| 66475 | 66475 | 211531 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 370 Monterey Blvd | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 8ft | 5999679.864130001 | 2094723.36965 | 37.7316925909327 | -122.443453625099 | (37.7316925909327, -122.443453625099) | |||
| 68523 | 68523 | 138700 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 1600 BAKER ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6000120.6821 | 2114491.0953 | 37.785995033705795 | -122.443348974144 | (37.7859950337058, -122.443348974144) | |||
| 69490 | 69490 | 234020 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 131 Alma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5998015.60548 | 2106190.06538 | 37.7630822803398 | -122.45003342489599 | (37.7630822803398, -122.450033424896) | |||
| 70440 | 70440 | 194604 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 500 Wisconsin St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 9ft | 6012630.87805 | 2105129.76973 | 37.760996412581704 | -122.39940937733999 | (37.7609964125817, -122.39940937734) | |||
| 70975 | 70975 | 246878 | DPW Maintained 3 | Pittosporum tobira :: Japanese Mockorange 243 | 3090x Market St | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | 5999893.61927 | 2105333.85578 | 37.760838624734 | -122.443476525446 | (37.760838624734, -122.443476525446) | ||||
| 71115 | 71115 | 52950 | Permitted Site 1 | Pittosporum tobira :: Japanese Mockorange 243 | 781 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2006 12:00:00 AM | 5 | Permit Number 48937 | 6001329.274 | 2092453.83247 | 37.7255548870432 | -122.43758882318998 | (37.7255548870432, -122.43758882319) | |
| 71259 | 71259 | 246882 | DPW Maintained 3 | Pittosporum tobira :: Japanese Mockorange 243 | 3090x Market St | 15 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | 5999873.9494900005 | 2105329.5043 | 37.7608255548764 | -122.443544241685 | (37.7608255548764, -122.443544241685) | ||||
| 72649 | 72649 | 132465 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 1059 Vallejo St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6008496.61422 | 2118601.48862 | 37.7977552443725 | -122.414661419682 | (37.7977552443725, -122.414661419682) | |||
| 72830 | 72830 | 132447 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 2901 Steiner St | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6002002.72615 | 2118148.9018 | 37.796145570312795 | -122.437099605478 | (37.7961455703128, -122.437099605478) | |||
| 73505 | 73505 | 132456 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 1111 Chestnut St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6006440.1375400005 | 2120399.2096700002 | 37.8025755763694 | -122.421905175504 | (37.8025755763694, -122.421905175504) | ||||
| 74836 | 74836 | 132464 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 1080 Vallejo St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 5ft | 6008331.1974 | 2118642.46572 | 37.7978584622601 | -122.415236711511 | (37.7978584622601, -122.415236711511) | |||
| 75098 | 75098 | 132446 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 2901 Steiner St | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6002001.5494 | 2118158.83733 | 37.7961727837995 | -122.437104388968 | (37.7961727837995, -122.437104388968) | |||
| 75469 | 75469 | 234027 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 415 Beacon St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 2ft | 6002320.31614 | 2098303.69653 | 37.7416735709701 | -122.43458097493999 | (37.7416735709701, -122.43458097494) | |||
| 75657 | 75657 | 211528 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 300 Junipero Serra Blvd | 36 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5991392.4416 | 2094406.38685 | 37.7303461313484 | -122.47208153695298 | (37.7303461313484, -122.472081536953) | |||
| 79522 | 79522 | 109106 | Permitted Site 1 | Pittosporum tobira :: Japanese Mockorange 243 | 461X Cherry St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2015 12:00:00 AM | 3 | Permit Number 774020 | 5996243.86079 | 2114742.7280900003 | 37.7864641110096 | -122.456779845468 | (37.7864641110096, -122.456779845468) | ||
| 79660 | 79660 | 109111 | Permitted Site 1 | Pittosporum tobira :: Japanese Mockorange 243 | 461X Cherry St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 774020 | 5996243.86079 | 2114742.7280900003 | 37.7864641110096 | -122.456779845468 | (37.7864641110096, -122.456779845468) | ||||
| 81478 | 81478 | 109105 | Permitted Site 1 | Pittosporum tobira :: Japanese Mockorange 243 | 461X Cherry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2015 12:00:00 AM | 3 | Permit Number 774020 | 5996243.86079 | 2114742.7280900003 | 37.7864641110096 | -122.456779845468 | (37.7864641110096, -122.456779845468) | ||
| 89560 | 89560 | 132457 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 1111 Chestnut St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6006444.66097 | 2120399.4465900003 | 37.8025764819927 | -122.421889538986 | (37.8025764819927, -122.421889538986) | ||||
| 96449 | 96449 | 109108 | Permitted Site 1 | Pittosporum tobira :: Japanese Mockorange 243 | 461X Cherry St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2015 12:00:00 AM | 3 | Permit Number 774020 | 5996243.86079 | 2114742.7280900003 | 37.7864641110096 | -122.456779845468 | (37.7864641110096, -122.456779845468) | ||
| 96977 | 96977 | 109107 | Permitted Site 1 | Pittosporum tobira :: Japanese Mockorange 243 | 461X Cherry St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2015 12:00:00 AM | 3 | Permit Number 774020 | 5996243.86079 | 2114742.7280900003 | 37.7864641110096 | -122.456779845468 | (37.7864641110096, -122.456779845468) | ||
| 101581 | 101581 | 102477 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 760 Victoria St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5993664.7 | 2092172.3 | 37.7243431058269 | -122.464063971167 | (37.7243431058269, -122.464063971167) | |||||
| 110776 | 110776 | 109109 | Permitted Site 1 | Pittosporum tobira :: Japanese Mockorange 243 | 461X Cherry St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2015 12:00:00 AM | 3 | Permit Number 774020 | 5996243.86079 | 2114742.7280900003 | 37.7864641110096 | -122.456779845468 | (37.7864641110096, -122.456779845468) | ||
| 113481 | 113481 | 109110 | Permitted Site 1 | Pittosporum tobira :: Japanese Mockorange 243 | 461X Cherry St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2015 12:00:00 AM | 3 | Permit Number 774020 | 5996243.86079 | 2114742.7280900003 | 37.7864641110096 | -122.456779845468 | (37.7864641110096, -122.456779845468) | ||
| 124228 | 124228 | 111770 | Significant Tree 6 | Pittosporum tobira :: Japanese Mockorange 243 | 707 Douglass St | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | Permit Number 775627 | 6001281.0 | 2102187.2 | 37.7522776937422 | -122.438452748375 | (37.7522776937422, -122.438452748375) | ||||
| 130560 | 130560 | 234016 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 1101 San Jose Ave | 69 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 8ft | 6005055.13591 | 2096635.21867 | 37.7372471798214 | -122.425006192598 | (37.7372471798214, -122.425006192598) | |||
| 133521 | 133521 | 211524 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 401 Victoria St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 5993220.1826599995 | 2089909.9635299998 | 37.7181056496239 | -122.465436324932 | (37.7181056496239, -122.465436324932) | |||
| 133989 | 133989 | 234017 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 425 Valley St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6003150.22135 | 2099188.97086 | 37.744151406477 | -122.431774635991 | (37.744151406477, -122.431774635991) | ||||
| 136276 | 136276 | 211535 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 105 Flood Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 8ft | 6000046.63209 | 2094042.6030599999 | 37.729844273679205 | -122.442136789191 | (37.7298442736792, -122.442136789191) | |||
| 147672 | 147672 | 211518 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 312 Hearst Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | 5999384.26732 | 2094401.16336 | 37.730791025972295 | -122.444452411253 | (37.7307910259723, -122.444452411253) | ||||
| 147783 | 147783 | 234015 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 501 Alabama St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | 6008997.09738 | 2105837.4435900003 | 37.762736320135396 | -122.412027100378 | (37.7627363201354, -122.412027100378) | |||
| 148895 | 148895 | 178423 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 226 Athens St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6004525.81285 | 2091935.4006 | 37.7243126139184 | -122.426501755257 | (37.7243126139184, -122.426501755257) | ||||
| 149412 | 149412 | 211533 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 370 Monterey Blvd | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 8ft | 5999635.69214 | 2094724.28712 | 37.7316925909199 | -122.443606401922 | (37.7316925909199, -122.443606401922) | |||
| 151583 | 151583 | 132453 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 1111 Chestnut St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6006425.62699 | 2120397.1065599998 | 37.8025689834206 | -122.421955239867 | (37.8025689834206, -122.421955239867) | ||||
| 151684 | 151684 | 211526 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 300 Junipero Serra Blvd | 23 | : 4 | Tree 1 | Private 1 | 8 | Width 0ft | 5991395.5054 | 2094469.24487 | 37.730518901006604 | -122.472075524959 | (37.7305189010066, -122.472075524959) | |||
| 154158 | 154158 | 132459 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 1109 Chestnut St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6006454.20417 | 2120400.58953 | 37.8025801584021 | -122.42185659591699 | (37.8025801584021, -122.421856595917) | ||||
| 155162 | 155162 | 246879 | DPW Maintained 3 | Pittosporum tobira :: Japanese Mockorange 243 | 3090x Market St | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | 5999888.19644 | 2105332.59474 | 37.760834852969296 | -122.443495189965 | (37.7608348529693, -122.443495189965) | ||||
| 156184 | 156184 | 211517 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 2112 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5990709.94109 | 2100999.41898 | 37.7484093878914 | -122.474922077987 | (37.7484093878914, -122.474922077987) | |||
| 158603 | 158603 | 194606 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 1701 19th St | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 7ft | 6012593.28485 | 2105146.10358 | 37.7610391663527 | -122.39954054347601 | (37.7610391663527, -122.399540543476) | |||
| 159287 | 159287 | 178421 | DPW Maintained 3 | Pittosporum tobira :: Japanese Mockorange 243 | 10x Mansell St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 0ft | 6011808.96151 | 2090776.0249700001 | 37.7215382422674 | -122.40124336299101 | (37.7215382422674, -122.401243362991) | |||
| 159968 | 159968 | 132462 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 1275 Greenwich St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 6006821.45556 | 2119757.24178 | 37.8008343926403 | -122.420540025305 | (37.8008343926403, -122.420540025305) | |||
| 163941 | 163941 | 211530 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 321 Melrose Ave | 3 | : Yard 23 | Tree 1 | Private 1 | 16 | 5997959.2212 | 2095523.47143 | 37.733791203898704 | -122.44945983462699 | (37.7337912038987, -122.449459834627) | ||||
| 166091 | 166091 | 119919 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 3801 Anza St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 5986854.35901 | 2111807.96011 | 37.7778624645171 | -122.48904890720199 | (37.7778624645171, -122.489048907202) | |||
| 166369 | 166369 | 194603 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 500 Wisconsin St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 9ft | 6012631.4012 | 2105136.35292 | 37.761014517726295 | -122.399408030156 | (37.7610145177263, -122.399408030156) | |||
| 166538 | 166538 | 132452 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 1111 Chestnut St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6006420.79232 | 2120396.51969 | 37.802567099361795 | -122.421971928556 | (37.8025670993618, -122.421971928556) | ||||
| 169178 | 169178 | 246876 | DPW Maintained 3 | Pittosporum tobira :: Japanese Mockorange 243 | 3090x Market St | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | 5999901.9935099995 | 2105335.75905 | 37.7608443282147 | -122.44344769946998 | (37.7608443282147, -122.44344769947) | ||||
| 171148 | 171148 | 211534 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 289 Joost Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 10ft | 6000200.74101 | 2094921.6506 | 37.732266715441206 | -122.44166707868901 | (37.7322667154412, -122.441667078689) | |||
| 171192 | 171192 | 119917 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 3801 Anza St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5986865.48339 | 2111809.59249 | 37.7778675958491 | -122.489010544635 | (37.7778675958491, -122.489010544635) | |||
| 172305 | 172305 | 132448 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 181 Marina Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 6002667.37889 | 2121595.1987799997 | 37.805645957154205 | -122.435046380379 | (37.8056459571542, -122.435046380379) | |||
| 174061 | 174061 | 234028 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 415 Beacon St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 2ft | 6002321.00051 | 2098298.5666900002 | 37.7416595244747 | -122.434578241906 | (37.7416595244747, -122.434578241906) | |||
| 174198 | 174198 | 234022 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 541 Grand View Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 5ft | 6000039.364680001 | 2101755.5112799997 | 37.7510216765301 | -122.442715512834 | (37.7510216765301, -122.442715512834) | |||
| 179037 | 179037 | 234018 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 415 Valley St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 2ft | 6003158.64074 | 2099182.5520200003 | 37.7441342590911 | -122.43174506540501 | (37.7441342590911, -122.431745065405) | |||
| 179059 | 179059 | 132455 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 1111 Chestnut St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6006432.53794 | 2120398.16502 | 37.802572279438294 | -122.421931399716 | (37.8025722794383, -122.421931399716) | ||||
| 179762 | 179762 | 211522 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 401 Victoria St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 5993220.36391 | 2089918.5928 | 37.7181293539714 | -122.46543632495 | (37.7181293539714, -122.46543632495) | |||
| 183939 | 183939 | 246883 | DPW Maintained 3 | Pittosporum tobira :: Japanese Mockorange 243 | 3090x Market St | 16 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | 5999870.066869999 | 2105328.2836599997 | 37.76082198187 | -122.443557582215 | (37.76082198187, -122.443557582215) | ||||
| 185373 | 185373 | 211529 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 300 Junipero Serra Blvd | 41 | : 4 | Tree 1 | Private 1 | 9 | Width 0ft | 5991392.35207 | 2094374.63873 | 37.730258953789395 | -122.47207953326999 | (37.7302589537894, -122.47207953327) | |||
| 185800 | 185800 | 132466 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 84 MacOndray Ln | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6008265.75906 | 2119134.86872 | 37.799206800504706 | -122.41549802663602 | (37.7992068005047, -122.415498026636) |
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");