Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▲ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3544 | 3544 | 253465 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 98X Marston Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | 5998793.0 | 2093251.0 | 37.7275991927727 | -122.446413796362 | (37.7275991927727, -122.446413796362) | ||
| 3561 | 3561 | 253462 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 98X Marston Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | 5998793.0 | 2093251.0 | 37.7275991927727 | -122.446413796362 | (37.7275991927727, -122.446413796362) | ||
| 3567 | 3567 | 253463 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 98X Marston Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | 5998793.0 | 2093251.0 | 37.7275991927727 | -122.446413796362 | (37.7275991927727, -122.446413796362) | ||
| 3585 | 3585 | 253464 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 98X Marston Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | 5998793.0 | 2093251.0 | 37.7275991927727 | -122.446413796362 | (37.7275991927727, -122.446413796362) | ||
| 173722 | 173722 | 227683 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 923 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007409.880530001 | 2101914.88747 | 37.7518767015549 | -122.41723875888201 | (37.7518767015549, -122.417238758882) | |||
| 24818 | 24818 | 191371 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 900x Carolina St | 66 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | 6012518.79145 | 2102845.53786 | 37.7547181653131 | -122.39963665401699 | (37.7547181653131, -122.399636654017) | ||||
| 27702 | 27702 | 191370 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 900x Carolina St | 63 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 6012517.15762 | 2102887.31193 | 37.75483277672829 | -122.399645237162 | (37.7548327767283, -122.399645237162) | ||||
| 38640 | 38640 | 191369 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 900x Carolina St | 62 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 6012514.91638 | 2102899.16549 | 37.7548651990855 | -122.399653820263 | (37.7548651990855, -122.399653820263) | ||||
| 131762 | 131762 | 191368 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 900x Carolina St | 60 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | 6012502.16132 | 2102909.3105599997 | 37.7548923442165 | -122.399698643387 | (37.7548923442165, -122.399698643387) | ||||
| 21489 | 21489 | 29601 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 900X Junipero Serra Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991172.090009999 | 2091066.888 | 37.7211639453471 | -122.472599932234 | (37.7211639453471, -122.472599932234) | ||
| 21749 | 21749 | 29627 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 900X Junipero Serra Blvd | 36 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 12 | 3X3 | 5991152.87782 | 2090760.03066 | 37.7203202787275 | -122.472643981031 | (37.7203202787275, -122.472643981031) | ||
| 71643 | 71643 | 207108 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 89 Ralston St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 13 | 5992168.92954 | 2088415.8272900002 | 37.7139424279717 | -122.468961347182 | (37.7139424279717, -122.468961347182) | ||||
| 136701 | 136701 | 207107 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 89 Ralston St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 11 | 5992169.5585900005 | 2088419.4087099999 | 37.7139522980308 | -122.46895943344299 | (37.7139522980308, -122.468959433443) | ||||
| 25429 | 25429 | 119085 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 886 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5982037.396000001 | 2109722.65545 | 37.7718545033558 | -122.50555756428601 | (37.7718545033558, -122.505557564286) | |||
| 104926 | 104926 | 45431 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 851 Head St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/2001 12:00:00 AM | Permit Number 44219 | 5993920.58856776 | 2091576.5612161 | 37.72272209583179 | -122.463136201451 | (37.7227220958318, -122.463136201451) | ||
| 105417 | 105417 | 45429 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 851 Head St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/2001 12:00:00 AM | Permit Number 44219 | 5993920.58856776 | 2091576.5612161 | 37.72272209583179 | -122.463136201451 | (37.7227220958318, -122.463136201451) | ||
| 123652 | 123652 | 45430 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 851 Head St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/2001 12:00:00 AM | Permit Number 44219 | 5993920.58856776 | 2091576.5612161 | 37.72272209583179 | -122.463136201451 | (37.7227220958318, -122.463136201451) | ||
| 38129 | 38129 | 191390 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 845 Vermont St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 26 | 6011298.55233 | 2104376.91383 | 37.7588548893488 | -122.403964355369 | (37.7588548893488, -122.403964355369) | ||||
| 62936 | 62936 | 191394 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 845 Vermont St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 6011327.58138 | 2104381.4608 | 37.7588689961229 | -122.403864278838 | (37.7588689961229, -122.403864278838) | ||||
| 168815 | 168815 | 191391 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 845 Vermont St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6011306.2123 | 2104378.54497 | 37.7588597960547 | -122.40393797827299 | (37.7588597960547, -122.403937978273) | ||||
| 175448 | 175448 | 191392 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 845 Vermont St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 6011311.05886 | 2104374.20224 | 37.7588481426559 | -122.403920910926 | (37.7588481426559, -122.403920910926) | ||||
| 188045 | 188045 | 191393 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 845 Vermont St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 26 | 6011318.33835 | 2104379.19174 | 37.758862249405 | -122.40389608603901 | (37.758862249405, -122.403896086039) | ||||
| 61754 | 61754 | 227689 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 84 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008214.299790001 | 2099586.39862 | 37.7455284159971 | -122.41429222281 | (37.7455284159971, -122.41429222281) | |||
| 128740 | 128740 | 69291 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 830 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/1994 12:00:00 AM | Permit Number 33363 | 5991479.92264349 | 2102518.55863113 | 37.752625141975706 | -122.472370253301 | (37.7526251419757, -122.472370253301) | ||
| 85479 | 85479 | 49654 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 81 Alpha St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/16/2003 12:00:00 AM | Permit Number 46507 | 6011171.19956943 | 2088331.01703059 | 37.7147891465513 | -122.403276034448 | (37.7147891465513, -122.403276034448) | ||
| 50006 | 50006 | 191374 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 800 Vermont St | 15 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 6011292.66605 | 2104334.91271 | 37.7587392347502 | -122.403981757255 | (37.7587392347502, -122.403981757255) | ||||
| 69239 | 69239 | 191385 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 800 Vermont St | 37 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 6011271.65755 | 2104161.44484 | 37.7582617567794 | -122.404042206986 | (37.7582617567794, -122.404042206986) | |||
| 130276 | 130276 | 191375 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 800 Vermont St | 16 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | 6011300.325759999 | 2104333.131 | 37.7587347705187 | -122.40395514093399 | (37.7587347705187, -122.403955140934) | ||||
| 130366 | 130366 | 191373 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 800 Vermont St | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 6011285.49599 | 2104337.84522 | 37.758746886173896 | -122.40400676112 | (37.7587468861739, -122.40400676112) | ||||
| 132346 | 132346 | 191376 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 800 Vermont St | 19 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6011285.447430001 | 2104312.53247 | 37.758677380280105 | -122.40400514772699 | (37.7586773802801, -122.404005147727) | ||||
| 136406 | 136406 | 191382 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 800 Vermont St | 33 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 6011269.0108900005 | 2104184.59965 | 37.758325186865896 | -122.404052989848 | (37.7583251868659, -122.404052989848) | |||
| 147326 | 147326 | 191386 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 800 Vermont St | 38 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 4ft | 6011275.5914199995 | 2104157.94605 | 37.758252369672604 | -122.40402835564899 | (37.7582523696726, -122.404028355649) | |||
| 151607 | 151607 | 191377 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 800 Vermont St | 27 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | 6011285.82751 | 2104250.98235 | 37.75850839857429 | -122.40399950177601 | (37.7585083985743, -122.403999501776) | ||||
| 154417 | 154417 | 191378 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 800 Vermont St | 28 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 6011285.84337 | 2104240.2990099997 | 37.7584790653842 | -122.40399869511002 | (37.7584790653842, -122.40399869511) | ||||
| 164118 | 164118 | 191384 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 800 Vermont St | 35 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 6011268.81564 | 2104171.75859 | 37.7582899172605 | -122.40405276143 | (37.7582899172605, -122.40405276143) | |||
| 169449 | 169449 | 191383 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 800 Vermont St | 34 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 4ft | 6011269.17641 | 2104180.10815 | 37.7583128634534 | -122.404052101317 | (37.7583128634534, -122.404052101317) | |||
| 170082 | 170082 | 191380 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 800 Vermont St | 30 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 6011289.9844 | 2104226.0484599997 | 37.7584401679041 | -122.403983370659 | (37.7584401679041, -122.403983370659) | ||||
| 172179 | 172179 | 191388 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 800 Vermont St | 40 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 6011282.56063 | 2104153.62595 | 37.7582408970175 | -122.40400394893 | (37.7582408970175, -122.40400394893) | |||
| 173683 | 173683 | 191381 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 800 Vermont St | 32 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 6011271.17001 | 2104191.3624299997 | 37.7583438765916 | -122.40404599854601 | (37.7583438765916, -122.404045998546) | |||
| 176854 | 176854 | 191389 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 800 Vermont St | 43 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 9ft | 6011309.9548 | 2104119.65272 | 37.758149144577104 | -122.403906816767 | (37.7581491445771, -122.403906816767) | |||
| 177045 | 177045 | 191387 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 800 Vermont St | 39 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 4ft | 6011279.1597 | 2104155.2145599998 | 37.7582450689735 | -122.40401582268801 | (37.7582450689735, -122.404015822688) | |||
| 186287 | 186287 | 191379 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 800 Vermont St | 29 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6011295.7098900005 | 2104243.81406 | 37.758489268176 | -122.403964819445 | (37.758489268176, -122.403964819445) | ||||
| 110567 | 110567 | 51442 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 775 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/19/2004 12:00:00 AM | Permit Number 47761 | 6007380.25742092 | 2095203.71769531 | 37.7334476580973 | -122.41686576869301 | (37.7334476580973, -122.416865768693) | ||
| 145200 | 145200 | 109133 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 774 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/29/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773526 | 5985442.4 | 2110611.6 | 37.7744950899459 | -122.493845109753 | (37.7744950899459, -122.493845109753) |
| 142319 | 142319 | 24738 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 7700 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/09/1996 12:00:00 AM | 3 | 3X3 | 5983089.132019999 | 2112566.68135 | 37.7797252106941 | -122.502130088809 | (37.7797252106941, -122.502130088809) | ||
| 94727 | 94727 | 68575 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 7633 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32467 | 5983299.26193695 | 2112364.72668983 | 37.779183045029896 | -122.501388226383 | (37.7791830450299, -122.501388226383) | ||
| 142094 | 142094 | 109138 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 759 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/29/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773583 | 5985365.401319999 | 2110729.9835 | 37.7748156320332 | -122.49412018624099 | (37.7748156320332, -122.494120186241) |
| 151013 | 151013 | 118250 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 759 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5985366.8002 | 2110712.8219999997 | 37.7747685933044 | -122.494114082166 | (37.7747685933044, -122.494114082166) | |||
| 38448 | 38448 | 35388 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 753 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | 7 | Permit Number 38842 | 6011306.158319999 | 2104840.46729 | 37.7601281288176 | -122.40397067131799 | (37.7601281288176, -122.403970671318) | |
| 123353 | 123353 | 44124 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 751 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/29/2000 12:00:00 AM | Permit Number 43628 | 5981028.36208653 | 2110606.15983469 | 37.774220913121 | -122.509113438342 | (37.774220913121, -122.509113438342) | |||
| 153486 | 153486 | 207109 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 75 Ralston St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 14 | 5992170.77084 | 2088338.0326 | 37.713728928924105 | -122.46894932506599 | (37.7137289289241, -122.468949325066) | ||||
| 180188 | 180188 | 227692 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 75 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006684.36987 | 2096973.81613 | 37.738268789882795 | -122.419397184857 | (37.7382687898828, -122.419397184857) | |||
| 113922 | 113922 | 50423 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 75 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2003 12:00:00 AM | Permit Number 47076 | 5995600.08487961 | 2090390.5729411999 | 37.7195622602365 | -122.45724482931699 | (37.7195622602365, -122.457244829317) | ||
| 70974 | 70974 | 121603 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 749 Carolina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3x3 | 6012453.25739 | 2104452.2107 | 37.7591260835233 | -122.399976111225 | (37.7591260835233, -122.399976111225) | |||
| 179206 | 179206 | 176986 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 745 France Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6002864.08823 | 2089338.03726 | 37.7170867510327 | -122.43206070495899 | (37.7170867510327, -122.432060704959) | |||
| 86481 | 86481 | 52106 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 727 Rockdale Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/2005 12:00:00 AM | Permit Number 48298 | 5997405.05193713 | 2098248.96190456 | 37.741243026323 | -122.451572279627 | (37.741243026323, -122.451572279627) | ||
| 83364 | 83364 | 31185 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 720 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34883 | 5992147.8527206 | 2089880.99524616 | 37.7179642061069 | -122.469140766842 | (37.7179642061069, -122.469140766842) | ||
| 56497 | 56497 | 118789 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 718 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 5981995.4955 | 2110847.43445 | 37.7749403522663 | -122.505785898051 | (37.7749403522663, -122.505785898051) | |||
| 112441 | 112441 | 24808 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 7117 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/22/1996 12:00:00 AM | 3 | 3X3 | 5984967.23631 | 2112432.54215 | 37.7794670623637 | -122.49562310699899 | (37.7794670623637, -122.495623106999) | ||
| 59870 | 59870 | 98307 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 701 04th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/2012 12:00:00 AM | 3 | Permit Number 768498 | 5994707.05848 | 2110712.1855099997 | 37.7753089605415 | -122.46180439880399 | (37.7753089605415, -122.461804398804) | ||
| 60744 | 60744 | 59481 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 701 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/2012 12:00:00 AM | 3 | Permit Number 768498 | 5994707.05513 | 2110730.54303 | 37.7753593652253 | -122.461805741777 | (37.7753593652253, -122.461805741777) | ||
| 63860 | 63860 | 207135 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 700 Junipero Serra Blvd | 99 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5991243.409109999 | 2092046.59438 | 37.7238581046423 | -122.472424791093 | (37.7238581046423, -122.472424791093) | |||
| 67484 | 67484 | 207132 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 700 Junipero Serra Blvd | 87 | : 4 | Tree 1 | Private 1 | 16 | Width 0ft | 5991236.29103 | 2092157.26983 | 37.7241615799784 | -122.472457461649 | (37.7241615799784, -122.472457461649) | |||
| 148023 | 148023 | 207134 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 700 Junipero Serra Blvd | 98 | : 4 | Tree 1 | Private 1 | 12 | Width 0ft | 5991244.20773 | 2092057.90852 | 37.723889216687496 | -122.47242285485201 | (37.7238892166875, -122.472422854852) | |||
| 148752 | 148752 | 207137 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 700 Junipero Serra Blvd | 103 | : 4 | Tree 1 | Private 1 | 12 | Width 0ft | 5991231.72322 | 2092011.81443 | 37.7237619311543 | -122.47246265254 | (37.7237619311543, -122.47246265254) | |||
| 152163 | 152163 | 207138 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 700 Junipero Serra Blvd | 123 | : 4 | Tree 1 | Private 1 | 8 | Width 0ft | 5991217.227519999 | 2091775.34767 | 37.7231118130309 | -122.472495529957 | (37.7231118130309, -122.472495529957) | |||
| 167635 | 167635 | 207136 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 700 Junipero Serra Blvd | 100 | : 4 | Tree 1 | Private 1 | 6 | Width 0ft | 5991240.31686 | 2092039.5475299999 | 37.723838576763896 | -122.47243496690399 | (37.7238385767639, -122.472434966904) | |||
| 185196 | 185196 | 207133 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 700 Junipero Serra Blvd | 90 | : 4 | Tree 1 | Private 1 | 10 | Width 0ft | 5991231.48328 | 2092142.9158700001 | 37.724121889294295 | -122.472473035196 | (37.7241218892943, -122.472473035196) | |||
| 72687 | 72687 | 119095 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 6700 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 5982534.89521 | 2109675.70682 | 37.7717548615052 | -122.503833231018 | (37.7717548615052, -122.503833231018) | |||
| 98528 | 98528 | 47604 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 645 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/2002 12:00:00 AM | Permit Number 45440 | 6008713.69382569 | 2095849.48701302 | 37.7352957148385 | -122.412301312985 | (37.7352957148385, -122.412301312985) | ||
| 96706 | 96706 | 52103 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 641 Rockdale Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/2005 12:00:00 AM | Permit Number 48295 | 5997742.5728031 | 2098061.02519693 | 37.7407463206184 | -122.450391713191 | (37.7407463206184, -122.450391713191) | ||
| 92573 | 92573 | 31375 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 630 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1995 12:00:00 AM | Permit Number 34977 | 5991276.37232485 | 2099107.33925567 | 37.7432470351435 | -122.47282544581499 | (37.7432470351435, -122.472825445815) | ||
| 141290 | 141290 | 48774 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 629 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/20/2004 12:00:00 AM | Permit Number 47773 | 6007825.24973386 | 2095718.75627166 | 37.7348868619711 | -122.415363748684 | (37.7348868619711, -122.415363748684) | ||
| 143583 | 143583 | 34718 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 626 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38373 | 5981358.16274912 | 2111480.6327423 | 37.7766413961782 | -122.508037533581 | (37.7766413961782, -122.508037533581) | ||
| 93184 | 93184 | 119281 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 59x Ralston St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5992077.0 | 2088275.0 | 37.713550438396396 | -122.469268843393 | (37.7135504383964, -122.469268843393) | ||||
| 31147 | 31147 | 207112 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 59 Ralston St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 12 | 5992171.746719999 | 2088295.8735200001 | 37.7136132266511 | -122.46894288591899 | (37.7136132266511, -122.468942885919) | ||||
| 162496 | 162496 | 207110 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 59 Ralston St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 7 | 5992170.63195 | 2088310.84387 | 37.7136542672107 | -122.468947827707 | (37.7136542672107, -122.468947827707) | ||||
| 171720 | 171720 | 207111 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 59 Ralston St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 11 | 5992171.5605 | 2088305.6585 | 37.713640083085 | -122.468944241206 | (37.713640083085, -122.468944241206) | ||||
| 110211 | 110211 | 31168 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 570 Ramsell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34869 | 5993027.58275469 | 2090995.29108117 | 37.7210745862886 | -122.466180882741 | (37.7210745862886, -122.466180882741) | ||
| 143225 | 143225 | 47963 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 558 Melrose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2002 12:00:00 AM | Permit Number 45693 | 5996827.75466141 | 2095403.22069376 | 37.73339623393571 | -122.453362951949 | (37.7333962339357, -122.453362951949) | ||
| 150971 | 150971 | 52086 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 550 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/19/2005 12:00:00 AM | 7 | Permit Number 48283 | 5982264.87127 | 2112012.82882 | 37.7781560348973 | -122.50494046388201 | (37.7781560348973, -122.504940463882) | |
| 176859 | 176859 | 191367 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 548 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 3ft | 6011194.69766 | 2105791.5268900003 | 37.762733297531206 | -122.404423107658 | (37.7627332975312, -122.404423107658) | |||
| 98932 | 98932 | 52980 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 531 Arch St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/2006 12:00:00 AM | Permit Number 49067 | 5992711.66457877 | 2090721.03501475 | 37.720303313737105 | -122.467252978798 | (37.7203033137371, -122.467252978798) | ||
| 68946 | 68946 | 207113 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 53 Ralston St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | 5992170.39113 | 2088282.9530900002 | 37.7135776719473 | -122.468946631596 | (37.7135776719473, -122.468946631596) | ||||
| 188129 | 188129 | 207114 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 53 Ralston St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 23 | 5992175.21623 | 2088282.1627599997 | 37.7135757806697 | -122.468929896991 | (37.7135757806697, -122.468929896991) | ||||
| 31114 | 31114 | 118441 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 5201 Anza St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5982477.73735 | 2111660.7356 | 37.7772018111581 | -122.504178007129 | (37.7772018111581, -122.504178007129) | |||
| 182431 | 182431 | 218284 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 50x Junipero Serra Frontage West | 0 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | 5991438.8932 | 2095398.7783700002 | 37.7330736770928 | -122.4719932523 | (37.7330736770928, -122.4719932523) | ||||
| 88257 | 88257 | 47451 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 5049 Anza St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | Permit Number 45359 | 5983034.2663237 | 2111680.83899779 | 37.7772897229163 | -122.502254315782 | (37.7772897229163, -122.502254315782) | ||
| 108311 | 108311 | 47453 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 5049 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | Permit Number 45359 | 5983034.2663237 | 2111680.83899779 | 37.7772897229163 | -122.502254315782 | (37.7772897229163, -122.502254315782) | ||
| 178121 | 178121 | 47450 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 5049 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 7 | Permit Number 45359 | 5982925.588409999 | 2111676.1494 | 37.7772704608477 | -122.502629914355 | (37.7772704608477, -122.502629914355) | |
| 21000 | 21000 | 29586 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 500X Junipero Serra Blvd | 21 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | 3X3 | 5991342.7865 | 2093687.81781 | 37.7283702470744 | -122.47220084100901 | (37.7283702470744, -122.472200841009) | |||
| 132080 | 132080 | 207131 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 500 Junipero Serra Blvd | 23 | : 4 | Tree 1 | Private 1 | 14 | Width 0ft | 5991341.745569999 | 2093676.61882 | 37.7283394372056 | -122.47220362351901 | (37.7283394372056, -122.472203623519) | |||
| 166550 | 166550 | 227682 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 500 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008186.7931 | 2096476.1256400002 | 37.7369867469298 | -122.41416732857999 | (37.7369867469298, -122.41416732858) | |||
| 88909 | 88909 | 45437 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 50 Urbano Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/2001 12:00:00 AM | Permit Number 44224 | 5993813.83621392 | 2092411.23769418 | 37.7250077648019 | -122.46356576496599 | (37.7250077648019, -122.463565764966) | ||
| 32724 | 32724 | 227696 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 50 Belcher St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6003774.74871 | 2108065.2472200003 | 37.7685589402651 | -122.43024829315 | (37.7685589402651, -122.43024829315) | |||
| 69927 | 69927 | 123588 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 50 05th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 5994278.2202699995 | 2115268.8908700002 | 37.787795749172794 | -122.46361861929701 | (37.7877957491728, -122.463618619297) | |||
| 172053 | 172053 | 207129 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 4986 19th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 5990655.7482 | 2093855.39662 | 37.7287905920011 | -122.47458816511002 | (37.7287905920011, -122.47458816511) | |||
| 110762 | 110762 | 68097 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 49 Bessie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/1993 12:00:00 AM | Permit Number 31842 | 6008240.85722104 | 2100065.07433688 | 37.746844244689605 | -122.414234251858 | (37.7468442446896, -122.414234251858) | ||
| 60662 | 60662 | 207115 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 47 Ralston St | 8 | Back Yard : Yard 13 | Tree 1 | Private 1 | 8 | 5992168.43399 | 2088239.2563900002 | 37.7134575782774 | -122.468950218099 | (37.7134575782774, -122.468950218099) | ||||
| 164753 | 164753 | 207116 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 47 Ralston St | 9 | Back Yard : Yard 13 | Tree 1 | Private 1 | 8 | 5992178.8337 | 2088240.4151599999 | 37.7134613608383 | -122.46891435762801 | (37.7134613608383, -122.468914357628) |
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");