Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▼ | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1773 | 1773 | 251685 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 66 Lee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996558.0 | 2090330.0 | 37.719450911009005 | -122.453929311088 | (37.719450911009, -122.453929311088) | ||||
| 1779 | 1779 | 251684 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 62 Lee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996557.0 | 2090306.0 | 37.719384955305294 | -122.453931035382 | (37.7193849553053, -122.453931035382) | ||||
| 2094 | 2094 | 252881 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 3536 Jennings St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | Width 3ft | 6013049.3063900005 | 2089480.54762 | 37.718050242412296 | -122.39686501810199 | (37.7180502424123, -122.396865018102) | ||||
| 5541 | 5541 | 81381 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 822 Geary St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/08/2003 12:00:00 AM | 3x3 | 6007769.502 | 2114456.07002 | 37.7863320683098 | -122.41688358241899 | (37.7863320683098, -122.416883582419) | ||
| 11700 | 11700 | 109233 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2570 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3x9 | 5986169.5717 | 2097728.0842 | 37.7391630116047 | -122.490381738824 | (37.7391630116047, -122.490381738824) | |||
| 11855 | 11855 | 112294 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2606 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x2 | 5989896.9401 | 2097604.9354 | 37.7390418709124 | -122.47748532406099 | (37.7390418709124, -122.477485324061) | |||
| 17282 | 17282 | 27708 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 720 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2X3 | 5992097.16127 | 2089870.17428 | 37.717931565159795 | -122.46931519623301 | (37.7179315651598, -122.469315196233) | |||
| 20367 | 20367 | 29572 | DPW Maintained 3 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 400X Junipero Serra Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/2007 12:00:00 AM | 3 | 3X3 | 5991380.33669 | 2094272.13717 | 37.7299768148765 | -122.47211360317 | (37.7299768148765, -122.47211360317) | ||
| 20702 | 20702 | 16302 | DPW Maintained 3 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 747 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/18/1992 12:00:00 AM | 3 | 3X3 | 5997139.1851 | 2094676.1292299998 | 37.73141766098679 | -122.452233809638 | (37.7314176609868, -122.452233809638) | ||
| 23605 | 23605 | 207223 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 137 Marston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 1ft | 5998550.7404 | 2093191.23092 | 37.7274212410962 | -122.447246987057 | (37.7274212410962, -122.447246987057) | |||
| 24738 | 24738 | 207248 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 574 Arch St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5992756.55156 | 2091026.1972 | 37.7211438059241 | -122.46711999608401 | (37.7211438059241, -122.467119996084) | |||
| 26283 | 26283 | 226595 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 880 Douglass St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 3ft | 6001269.3073 | 2101283.04072 | 37.749794423884794 | -122.438428410468 | (37.7497944238848, -122.438428410468) | |||
| 26934 | 26934 | 227699 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 194 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6005300.17225 | 2100223.67209 | 37.7471140970563 | -122.42441415180099 | (37.7471140970563, -122.424414151801) | |||
| 27028 | 27028 | 207203 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 659 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 1ft | 5997731.1976 | 2094979.2607200001 | 37.732283884374 | -122.450208962681 | (37.732283884374, -122.450208962681) | |||
| 27445 | 27445 | 207324 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 85 Sequoia Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 5998176.702190001 | 2097175.31508 | 37.7383392103809 | -122.44882688276199 | (37.7383392103809, -122.448826882762) | |||
| 27878 | 27878 | 226609 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 4005 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008395.3202599995 | 2096426.5831400002 | 37.736862424666704 | -122.413442851824 | (37.7368624246667, -122.413442851824) | |||
| 27919 | 27919 | 207196 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 580 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5997574.55439 | 2094416.3667 | 37.7307293459771 | -122.450709941708 | (37.7307293459771, -122.450709941708) | |||
| 30981 | 30981 | 71589 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 177 Goethe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 8 | 5994699.454059999 | 2086647.11862 | 37.7092318519263 | -122.460086907391 | (37.7092318519263, -122.460086907391) | ||
| 31099 | 31099 | 226629 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 54 Collingwood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001984.40508 | 2105553.3896 | 37.761560425102 | -122.43626114684099 | (37.761560425102, -122.436261146841) | |||
| 31229 | 31229 | 226622 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6004058.08528 | 2103018.40015 | 37.7547175483925 | -122.42890840132799 | (37.7547175483925, -122.428908401328) | |||
| 31710 | 31710 | 207290 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 81 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5993410.050430001 | 2093515.91328 | 37.7280176597738 | -122.465041791443 | (37.7280176597738, -122.465041791443) | |||
| 33118 | 33118 | 118541 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 8250 Geary Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5981337.423690001 | 2112399.66579 | 37.779163567264 | -122.50817750438699 | (37.779163567264, -122.508177504387) | ||||
| 33252 | 33252 | 129488 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 3320 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5999321.62812 | 2120233.7842099997 | 37.801717336245105 | -122.44652677938801 | (37.8017173362451, -122.446526779388) | |||
| 33451 | 33451 | 191410 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 777 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6011870.78856 | 2104734.77484 | 37.7598694505299 | -122.402010442428 | (37.7598694505299, -122.402010442428) | |||
| 34009 | 34009 | 70454 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2631 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1994 12:00:00 AM | 1 | 5982726.9666 | 2097193.7529 | 37.7374942155975 | -122.502244984058 | (37.7374942155975, -122.502244984058) | ||
| 36484 | 36484 | 207243 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 324 Lakeview Ave | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5996808.75565 | 2089668.4523599998 | 37.7176488300194 | -122.453014817795 | (37.7176488300194, -122.453014817795) | |||
| 36611 | 36611 | 207332 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 139 Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 6000483.56606 | 2095198.0934400002 | 37.7330418734682 | -122.44070911276 | (37.7330418734682, -122.44070911276) | |||
| 37229 | 37229 | 207260 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 282 Arch St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 5992744.11171 | 2089090.22365 | 37.7158273737034 | -122.46702231894 | (37.7158273737034, -122.46702231894) | |||
| 37320 | 37320 | 207230 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 437 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5995450.98225 | 2091203.60917 | 37.7217860999295 | -122.457819021351 | (37.7217860999295, -122.457819021351) | |||
| 37609 | 37609 | 207322 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 734 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5998892.3170300005 | 2095965.24165 | 37.7350575338629 | -122.44626562436001 | (37.7350575338629, -122.44626562436) | |||
| 37967 | 37967 | 117755 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 406 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 5983780.251180001 | 2113048.87393 | 37.781089749801204 | -122.499774894099 | (37.7810897498012, -122.499774894099) | |||
| 38348 | 38348 | 119479 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 426 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5985644.21808 | 2112952.33317 | 37.7809338791525 | -122.493319479205 | (37.7809338791525, -122.493319479205) | |||
| 38449 | 38449 | 226599 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1832 Castro St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 6002599.9125 | 2100157.5460099997 | 37.746779676940896 | -122.43374669365 | (37.7467796769409, -122.43374669365) | |||
| 39672 | 39672 | 207255 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 551 Arch St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5992722.91506 | 2090824.1387 | 37.72058706082171 | -122.467221582632 | (37.7205870608217, -122.467221582632) | |||
| 39694 | 39694 | 191411 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 462 Thornton Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 6012808.38143 | 2094403.0124599999 | 37.7315529172119 | -122.39804293216001 | (37.7315529172119, -122.39804293216) | |||
| 40455 | 40455 | 177006 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 271 Teddy Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009831.15293 | 2088401.27476 | 37.7149071271443 | -122.40791276406 | (37.7149071271443, -122.40791276406) | |||
| 42565 | 42565 | 226630 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 17 Temple St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 6000001.75416 | 2105889.17936 | 37.7623695721306 | -122.443142420082 | (37.7623695721306, -122.443142420082) | |||
| 42681 | 42681 | 207330 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 345 Ulloa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5995685.60702 | 2098472.19978 | 37.7417573653183 | -122.45753361969601 | (37.7417573653183, -122.457533619696) | |||
| 42942 | 42942 | 207270 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1439 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5994256.24514 | 2105719.06013 | 37.7615731891695 | -122.463001505824 | (37.7615731891695, -122.463001505824) | |||
| 43666 | 43666 | 207282 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 163 Westwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5995118.51339 | 2093829.85755 | 37.7289780403896 | -122.459158347475 | (37.7289780403896, -122.459158347475) | |||
| 43733 | 43733 | 207159 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 345 San Fernando Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992101.70168 | 2094641.4985900002 | 37.7310327079752 | -122.469646658486 | (37.7310327079752, -122.469646658486) | |||
| 44325 | 44325 | 207349 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 618 Mangels Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5997332.96655 | 2095282.6428599998 | 37.733094101592705 | -122.451607607218 | (37.7330941015927, -122.451607607218) | |||
| 45169 | 45169 | 183658 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1487 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5981219.3285 | 2104945.9280000003 | 37.7586908149842 | -122.508032687607 | (37.7586908149842, -122.508032687607) | |||
| 46244 | 46244 | 250337 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 21 25th Ave North | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 5ft | 5987995.71435 | 2115876.11718 | 37.7890990187437 | -122.485399212222 | (37.7890990187437, -122.485399212222) | |||
| 46658 | 46658 | 207264 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 319 Victoria St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5993222.99582 | 2089325.40947 | 37.716500767187 | -122.465384161548 | (37.716500767187, -122.465384161548) | |||
| 48128 | 48128 | 207250 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 571 Arch St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5992722.93824 | 2090965.0292099998 | 37.7209739131985 | -122.467231741345 | (37.7209739131985, -122.467231741345) | |||
| 48704 | 48704 | 207278 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 575 Dewey Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5994134.4568 | 2099399.45739 | 37.7442141593615 | -122.462964201952 | (37.7442141593615, -122.462964201952) | |||
| 48932 | 48932 | 70374 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1494 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 6 | 5983124.8306 | 2104978.8403 | 37.7588932768889 | -122.501445132559 | (37.7588932768889, -122.501445132559) | ||
| 48941 | 48941 | 177000 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 759 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6002010.1952 | 2089376.96729 | 37.717145196164395 | -122.435014983257 | (37.7171451961644, -122.435014983257) | |||
| 49438 | 49438 | 226600 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1463 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6003321.08221 | 2099703.03715 | 37.7455725970047 | -122.431220523219 | (37.7455725970047, -122.431220523219) | |||
| 50277 | 50277 | 226617 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 58 Gladys St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005670.60555 | 2097390.14395 | 37.739354782382996 | -122.422931867621 | (37.739354782383, -122.422931867621) | |||
| 51460 | 51460 | 226589 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1100 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5999827.96585 | 2100023.61803 | 37.7462542624189 | -122.443322166684 | (37.7462542624189, -122.443322166684) | |||
| 51759 | 51759 | 207273 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2486 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5991107.555 | 2098499.64463 | 37.741568687546604 | -122.473364852413 | (37.7415686875466, -122.473364852413) | |||
| 52054 | 52054 | 226616 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2 Appleton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6005523.88104 | 2097105.4034 | 37.7385646686269 | -122.42341893953899 | (37.7385646686269, -122.423418939539) | |||
| 52088 | 52088 | 177024 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 11 Athens St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6005372.1534 | 2093185.8595 | 37.7277939084451 | -122.42366493918301 | (37.7277939084451, -122.423664939183) | ||||
| 54071 | 54071 | 207232 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 226 Thrift St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 6ft | 5994766.53745 | 2089660.64097 | 37.7175101320775 | -122.46007322780301 | (37.7175101320775, -122.460073227803) | |||
| 55980 | 55980 | 207361 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 452 Circular Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5999521.461730001 | 2093554.76745 | 37.72847484721579 | -122.443917320952 | (37.7284748472158, -122.443917320952) | |||
| 56032 | 56032 | 207275 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 315 Dorantes Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5993069.797230001 | 2099663.50314 | 37.7448777789813 | -122.46666472241999 | (37.7448777789813, -122.46666472242) | |||
| 56436 | 56436 | 207226 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 224 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5995369.52282 | 2091446.6873400002 | 37.722448854419795 | -122.45811818710399 | (37.7224488544198, -122.458118187104) | |||
| 56500 | 56500 | 177008 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 67 Capistrano Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6001385.71309 | 2093783.96595 | 37.7292103388668 | -122.43748892737301 | (37.7292103388668, -122.437488927373) | ||||
| 57295 | 57295 | 207143 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1617 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5991127.14012 | 2104370.55559 | 37.7576898140615 | -122.473725315989 | (37.7576898140615, -122.473725315989) | |||
| 59000 | 59000 | 227698 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 517 Hickory St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6004312.97566 | 2110291.73585 | 37.7747028072132 | -122.428545336007 | (37.7747028072132, -122.428545336007) | |||
| 59140 | 59140 | 207326 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 43 Gaviota Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5998477.362380001 | 2097389.2678 | 37.7389438623547 | -122.447802750104 | (37.7389438623547, -122.447802750104) | |||
| 59419 | 59419 | 207291 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 135 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5993593.95913 | 2093848.0757900001 | 37.7289402994475 | -122.464430125662 | (37.7289402994475, -122.464430125662) | |||
| 59513 | 59513 | 207233 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 422 Orizaba Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5994045.888719999 | 2089197.1437900001 | 37.7161960040241 | -122.462530559657 | (37.7161960040241, -122.462530559657) | |||
| 59680 | 59680 | 207153 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 37 Cragmont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992857.79641 | 2101696.45596 | 37.750447510654396 | -122.467545586773 | (37.7504475106544, -122.467545586773) | |||
| 60300 | 60300 | 182865 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1845 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5989054.8495 | 2102750.5341 | 37.75312143070521 | -122.480773464165 | (37.7531214307052, -122.480773464165) | |||
| 60876 | 60876 | 226631 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 141 Moffitt St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6002644.82708 | 2096800.8937799998 | 37.737565638743895 | -122.43335156393299 | (37.7375656387439, -122.433351563933) | |||
| 61063 | 61063 | 207293 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 965 Darien Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5994659.04342 | 2093888.37752 | 37.729112296585996 | -122.460750997386 | (37.729112296586, -122.460750997386) | |||
| 61510 | 61510 | 207295 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 217 Colon Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5996039.75572 | 2094297.6973299999 | 37.7303155346371 | -122.45600737215 | (37.7303155346371, -122.45600737215) | |||
| 61927 | 61927 | 184535 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1914 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5981673.4595 | 2102023.0319999997 | 37.7506921190217 | -122.506245385817 | (37.7506921190217, -122.506245385817) | |||
| 61977 | 61977 | 226613 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 322 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006488.43942 | 2097246.62658 | 37.7390068293023 | -122.42009397237601 | (37.7390068293023, -122.420093972376) | |||
| 62171 | 62171 | 207300 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 145 Hazelwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5996448.99813 | 2094535.9636799998 | 37.730993237639105 | -122.45460977981199 | (37.7309932376391, -122.454609779812) | |||
| 62758 | 62758 | 207140 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1682 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5990920.30999 | 2103955.3917900003 | 37.7565379030086 | -122.474410316087 | (37.7565379030086, -122.474410316087) | |||
| 63132 | 63132 | 207265 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 542 Head St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 10ft | 5993523.314809999 | 2089466.4912400001 | 37.7169054593937 | -122.464356356062 | (37.7169054593937, -122.464356356062) | |||
| 63341 | 63341 | 207360 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 374 Judson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5997612.78816 | 2093589.9194 | 37.7284623061695 | -122.450518204475 | (37.7284623061695, -122.450518204475) | |||
| 63672 | 63672 | 226582 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 383 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006413.772530001 | 2097021.64328 | 37.738384868057295 | -122.420336172385 | (37.7383848680573, -122.420336172385) | |||
| 67219 | 67219 | 129495 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1136 Havens St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 7ft | 6007480.35855 | 2119354.0245 | 37.7997643702969 | -122.418231335218 | (37.7997643702969, -122.418231335218) | |||
| 67812 | 67812 | 207165 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 501 Laguna Honda Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5995466.11989 | 2100230.17484 | 37.746571717707205 | -122.458419748693 | (37.7465717177072, -122.458419748693) | |||
| 67977 | 67977 | 117858 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 600 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5983830.55841 | 2111665.32715 | 37.777293884605704 | -122.499498581311 | (37.7772938846057, -122.499498581311) | |||
| 68271 | 68271 | 177021 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1538 Burrows St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 6006775.37088 | 2092172.2563099999 | 37.72508988269 | -122.41874212587 | (37.72508988269, -122.41874212587) | |||
| 68354 | 68354 | 207353 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 678 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5997598.43347 | 2095021.49363 | 37.7323922472992 | -122.45067100017201 | (37.7323922472992, -122.450671000172) | |||
| 69462 | 69462 | 119126 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 601 46th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 5981603.35382 | 2111608.79109 | 37.777007725640104 | -122.507198870746 | (37.7770077256401, -122.507198870746) | |||
| 70030 | 70030 | 177026 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 501 Sweeny St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 6ft | 6008206.81715 | 2094351.9900900002 | 37.7311554564421 | -122.41394787781601 | (37.7311554564421, -122.413947877816) | |||
| 70124 | 70124 | 207280 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 595 Darien Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5993435.14458 | 2094919.26873 | 37.731872375313294 | -122.46505692344299 | (37.7318723753133, -122.465056923443) | |||
| 70729 | 70729 | 177010 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 78 Lamartine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002632.11132 | 2094355.1655700002 | 37.73084950708879 | -122.433220824095 | (37.7308495070888, -122.433220824095) | |||
| 71287 | 71287 | 207201 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 351 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5998416.44412 | 2094074.8160299999 | 37.7298396835571 | -122.447774830644 | (37.7298396835571, -122.447774830644) | |||
| 73076 | 73076 | 207146 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1440 16th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 4ft | 5991174.2447 | 2105585.9909099997 | 37.7610298052998 | -122.47365107156601 | (37.7610298052998, -122.473651071566) | |||
| 73643 | 73643 | 207345 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 628 Edna St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 5998591.38299 | 2094890.7633 | 37.732090079596794 | -122.44722875061399 | (37.7320900795968, -122.447228750614) | |||
| 73666 | 73666 | 184518 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 4108 Pacheco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5982209.6889 | 2101522.5062 | 37.7493493689338 | -122.504354014902 | (37.7493493689338, -122.504354014902) | |||
| 73920 | 73920 | 207210 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 146 Staples Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 5999095.98576 | 2093806.86087 | 37.7291427575169 | -122.445406326639 | (37.7291427575169, -122.445406326639) | ||||
| 73988 | 73988 | 207312 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 101 Ridgewood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5996777.2193 | 2094487.3918299999 | 37.730878690977704 | -122.45347156457399 | (37.7308786909777, -122.453471564574) | |||
| 74258 | 74258 | 207354 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 236 Ridgewood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5996818.09015 | 2094943.97322 | 37.732134696764 | -122.453363219655 | (37.732134696764, -122.453363219655) | |||
| 74830 | 74830 | 207158 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 237 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992472.8250400005 | 2097675.82148 | 37.739385640835295 | -122.468584327098 | (37.7393856408353, -122.468584327098) | |||
| 75032 | 75032 | 207204 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 655 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 1ft | 5997746.28105 | 2094978.11771 | 37.7322816091084 | -122.450156733641 | (37.7322816091084, -122.450156733641) | |||
| 75063 | 75063 | 123520 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2808 Fulton St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 5994672.01997 | 2110241.5879900004 | 37.774014807441795 | -122.461891472498 | (37.7740148074418, -122.461891472498) | |||
| 75859 | 75859 | 207224 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 49 Edna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 1ft | 5998734.87043 | 2093158.9272 | 37.727343062112396 | -122.446608128468 | (37.7273430621124, -122.446608128468) | |||
| 75893 | 75893 | 70393 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 63 Madison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 6 | 6005472.78201 | 2093254.0606099998 | 37.7279868534853 | -122.42332190988998 | (37.7279868534853, -122.42332190989) | ||
| 76051 | 76051 | 207298 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 111 Valdez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5996286.51947 | 2094316.70178 | 37.73038187671379 | -122.45515565391099 | (37.7303818767138, -122.455155653911) | |||
| 76065 | 76065 | 207186 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 50 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6000874.80167 | 2094365.21675 | 37.730777259156 | -122.43929683358299 | (37.730777259156, -122.439296833583) |
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");