Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qCaretaker, PlantDate, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6171 | 6171 | 8616 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2600 Geary Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 20 | 5999337.0471 | 2113224.2861 | 37.78247198716561 | -122.44596898090299 | (37.7824719871656, -122.445968980903) | |||
6495 | 6495 | 26421 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2235X Octavia St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 20 | 6004624.1328 | 2116974.76242 | 37.793070338586205 | -122.427945300259 | (37.7930703385862, -122.427945300259) | |||
8054 | 8054 | 14425 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 90X Masonic Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 12 | 5998875.1013 | 2112962.0092 | 37.781725454134396 | -122.447548220181 | (37.7817254541344, -122.447548220181) | |||
9882 | 9882 | 173729 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 994 Carolina St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 3x3 | 6012439.0 | 2103318.0 | 37.7560109950145 | -122.399945772243 | (37.7560109950145, -122.399945772243) | |||
9888 | 9888 | 173719 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 922 Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 3x3 | 6012422.0 | 2103621.0 | 37.7568420188621 | -122.40002584196199 | (37.7568420188621, -122.400025841962) | |||
9889 | 9889 | 3743 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 906 Carolina St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 18 | 6012418.0 | 2103694.0 | 37.757042237838796 | -122.400044801952 | (37.7570422378388, -122.400044801952) | |||
9898 | 9898 | 3765 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1074 Carolina St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | 18 | 6012456.6037355 | 2102966.9856684 | 37.7550481677782 | -122.39986024500799 | (37.7550481677782, -122.399860245008) | |||
9903 | 9903 | 3758 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1056 Carolina St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | 18 | 6012452.0863519 | 2103047.5184298 | 37.7552690413169 | -122.399881522302 | (37.7552690413169, -122.399881522302) | |||
9906 | 9906 | 173728 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 994 Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | 3x3 | 6012439.0 | 2103318.0 | 37.7560109950145 | -122.399945772243 | (37.7560109950145, -122.399945772243) | |||
9908 | 9908 | 3768 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1098 Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 18 | 6012462.6103665 | 2102859.9036449 | 37.754754478768 | -122.39983195341699 | (37.754754478768, -122.399831953417) | |||
10951 | 10951 | 24278 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 350X Winding Way | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 6000808.42529 | 2086790.5767400002 | 37.709975233345 | -122.438983668972 | (37.709975233345, -122.438983668972) | |||
12225 | 12225 | 24277 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 350X Winding Way | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 6000814.16949 | 2086790.4577099998 | 37.709975233345496 | -122.43896380743999 | (37.7099752333455, -122.43896380744) | |||
13612 | 13612 | 3695 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 400X Cargo Way | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8 | 6017120.58643 | 2098873.01635 | 37.7440658827378 | -122.383445712243 | (37.7440658827378, -122.383445712243) | |||
13675 | 13675 | 18550 | Landmark tree 9 | Acacia melanoxylon :: Blackwood Acacia 5 | 1700X Quesada Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 19 | 6014656.2717 | 2095062.2920900001 | 37.733465912826 | -122.391700443637 | (37.733465912826, -122.391700443637) | |||
13955 | 13955 | 97226 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301X Newcomb Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 09/30/2011 12:00:00 AM | 3 | 15x200 | 6016643.51258 | 2094941.1276900002 | 37.7332433315076 | -122.38482148523899 | (37.7332433315076, -122.384821485239) | ||
15352 | 15352 | 97230 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301X Newcomb Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | 15x200 | 6016626.81073 | 2094919.21722 | 37.7331822459561 | -122.38487770274999 | (37.7331822459561, -122.38487770275) | |||
15525 | 15525 | 3745 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900 Carolina St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 18 | 6012461.71984 | 2103674.63492 | 37.7569915030708 | -122.39989224135799 | (37.7569915030708, -122.399892241358) | |||
15842 | 15842 | 97227 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301X Newcomb Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | 15x200 | 6016638.64484 | 2094938.128 | 37.733234825728296 | -122.384838105605 | (37.7332348257283, -122.384838105605) | |||
16107 | 16107 | 97223 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301X Newcomb Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 09/30/2011 12:00:00 AM | 3 | 15x200 | 6016661.55982 | 2094959.63165 | 37.733295137843 | -122.384760378985 | (37.733295137843, -122.384760378985) | ||
16240 | 16240 | 97228 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301X Newcomb Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 15x200 | 6016642.6726 | 2094934.5266099998 | 37.733225159799204 | -122.384823929606 | (37.7332251597992, -122.384823929606) | |||
16402 | 16402 | 97222 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301X Newcomb Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 15x200 | 6016676.72369 | 2094975.37763 | 37.733339211818105 | -122.38470904929702 | (37.7333392118181, -122.384709049297) | |||
16543 | 16543 | 15277 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1563X Mission St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/28/2016 12:00:00 AM | 3 | 4X4 | Permit Number 777705 | 6007250.560819999 | 2109703.40074 | 37.7732531819334 | -122.418341887077 | (37.7732531819334, -122.418341887077) | |
18211 | 18211 | 11709 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 700X Junipero Serra Blvd | 26 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 6X6 | 5991284.83406 | 2092750.4086799999 | 37.7257930014245 | -122.472332875878 | (37.7257930014245, -122.472332875878) | ||
20854 | 20854 | 11187 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 Idora Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8 | 5995309.2253 | 2099420.08132 | 37.7443383854121 | -122.458903627104 | (37.7443383854121, -122.458903627104) | |||
21068 | 21068 | 29972 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 500X Junipero Serra Blvd | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/2007 12:00:00 AM | 3 | 3x3 | 5991341.172 | 2093706.68724 | 37.7284219643784 | -122.47220779725299 | (37.7284219643784, -122.472207797253) | ||
21937 | 21937 | 29584 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 500X Junipero Serra Blvd | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/12/2016 12:00:00 AM | 3 | 3X3 | 5991345.88941 | 2093701.3780900002 | 37.728407659786 | -122.47219110225299 | (37.728407659786, -122.472191102253) | ||
23028 | 23028 | 97224 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301X Newcomb Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 09/30/2011 12:00:00 AM | 6 | 15x200 | 6016653.042219999 | 2094950.9325 | 37.733270780626995 | -122.38478922115499 | (37.733270780627, -122.384789221155) | ||
23851 | 23851 | 200603 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 52 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | Width 0ft | 6016419.7448 | 2095144.9307 | 37.733790555057 | -122.38560931762301 | (37.733790555057, -122.385609317623) | |||
34139 | 34139 | 200562 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 38 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 0ft | 6016315.2256 | 2095489.7997 | 37.73473171245129 | -122.385994706933 | (37.7347317124513, -122.385994706933) | |||
36772 | 36772 | 175020 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 500x Mansell St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 0ft | 6010396.843230001 | 2090323.76583 | 37.7202175482911 | -122.40609285101401 | (37.7202175482911, -122.406092851014) | |||
38412 | 38412 | 200551 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 27 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 0ft | 6016216.4893 | 2095621.6927 | 37.735088399287 | -122.38634526793001 | (37.735088399287, -122.38634526793) | |||
38644 | 38644 | 200553 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 29 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6016224.312999999 | 2095613.1578 | 37.7350653972301 | -122.38631762348301 | (37.7350653972301, -122.386317623483) | |||
42056 | 42056 | 200548 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 0ft | 6016205.9984 | 2095634.3174 | 37.7351224834655 | -122.38638241900699 | (37.7351224834655, -122.386382419007) | |||
42146 | 42146 | 220273 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 500x 27th St | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 23 | Width 4ft | 6002878.6956 | 2100066.19718 | 37.746544669703106 | -122.432776165093 | (37.7465446697031, -122.432776165093) | |||
42702 | 42702 | 200540 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6016179.8101 | 2095650.1621 | 37.7351645401576 | -122.38647406665501 | (37.7351645401576, -122.386474066655) | |||
44175 | 44175 | 99145 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 302X Pacheco St | 29 | Median : Cutout 11 | Tree 1 | Private 1 | 9 | 5994341.5 | 2100725.2 | 37.747866238402096 | -122.46234443277001 | (37.7478662384021, -122.46234443277) | ||||
46940 | 46940 | 200568 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 40 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 0ft | 6016324.0126 | 2095472.2809 | 37.7346840956345 | -122.385963106208 | (37.7346840956345, -122.385963106208) | |||
49094 | 49094 | 200518 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | Width 0ft | 6016087.5147 | 2095748.7503 | 37.7354301338826 | -122.386800041299 | (37.7354301338826, -122.386800041299) | |||
49943 | 49943 | 200538 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6016175.1953 | 2095654.7768 | 37.7351769557335 | -122.38649034349899 | (37.7351769557335, -122.386490343499) | |||
51216 | 51216 | 200556 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 32 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 6016262.7203 | 2095558.3918 | 37.734917146653 | -122.38618101771601 | (37.734917146653, -122.386181017716) | |||
54812 | 54812 | 175058 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1132x Alemany Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 3ft | 6003548.97454 | 2094354.07012 | 37.7308984688672 | -122.430051002559 | (37.7308984688672, -122.430051002559) | |||
55316 | 55316 | 200609 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 49 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 0ft | 6016412.3996 | 2095168.4353 | 37.7338546875634 | -122.385636349995 | (37.7338546875634, -122.385636349995) | |||
55546 | 55546 | 200544 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 20 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 0ft | 6016191.0622 | 2095640.0073 | 37.73513727999379 | -122.38643445590401 | (37.7351372799938, -122.386434455904) | |||
58892 | 58892 | 200537 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 0ft | 6016177.7125 | 2095662.3283 | 37.735197829979 | -122.38648216691001 | (37.735197829979, -122.38648216691) | |||
59915 | 59915 | 200610 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 50 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 6016417.2964 | 2095161.5798 | 37.733836134681795 | -122.385618942498 | (37.7338361346818, -122.385618942498) | |||
62523 | 62523 | 220272 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 500x 27th St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 4ft | 6002834.52979 | 2100065.9287400004 | 37.7465414276535 | -122.432928866369 | (37.7465414276535, -122.432928866369) | |||
62628 | 62628 | 200574 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 44 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 0ft | 6016364.4111 | 2095326.6015 | 37.734286324847005 | -122.385813282871 | (37.734286324847, -122.385813282871) | |||
63458 | 63458 | 220274 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 500x 27th St | 23 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 4ft | 6002921.47786 | 2100071.21628 | 37.7465608772933 | -122.43262858725299 | (37.7465608772933, -122.432628587253) | |||
69094 | 69094 | 200554 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 30 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 0ft | 6016223.9574 | 2095601.7778 | 37.7350341303539 | -122.386318059776 | (37.7350341303539, -122.386318059776) | |||
73683 | 73683 | 203961 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 200x Dorantes Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 38 | Width 3ft | 5993559.03115 | 2099734.05216 | 37.745099710091296 | -122.4649781788 | (37.7450997100913, -122.4649781788) | |||
73902 | 73902 | 200534 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 0ft | 6016166.8048 | 2095673.2359 | 37.7352271762292 | -122.386520639457 | (37.7352271762292, -122.386520639457) | |||
77349 | 77349 | 3742 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 450X Cargo Way | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8 | 6016957.733924 | 2099023.86587 | 37.74447108289971 | -122.38401932754 | (37.7444710828997, -122.38401932754) | |||
81565 | 81565 | 443 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 700x 23rd Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5988815.988030001 | 2110428.99683 | 37.774190512498706 | -122.482161976658 | (37.7741905124987, -122.482161976658) | ||||
82822 | 82822 | 3694 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 400X Cargo Way | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8 | 6017199.673908999 | 2098835.752969 | 37.7439679357533 | -122.383169649574 | (37.7439679357533, -122.383169649574) | |||
83201 | 83201 | 21481 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2792X Sunset Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | 60 | 5985060.3629888 | 2096294.4798015 | 37.735161871163605 | -122.49411119238 | (37.7351618711636, -122.49411119238) | |||
83214 | 83214 | 448 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 700x 23rd Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5988818.05287 | 2110350.21953 | 37.773974331987795 | -122.482149061597 | (37.7739743319878, -122.482149061597) | ||||
86341 | 86341 | 3693 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 300X Cargo Way | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8 | 6017817.275253 | 2098336.256691 | 37.742630528905295 | -122.380999383309 | (37.7426305289053, -122.380999383309) | |||
88947 | 88947 | 4806 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 260 Corona St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 35 | 5992988.2755218 | 2092740.8940691003 | 37.7258653179999 | -122.46644356219299 | (37.7258653179999, -122.466443562193) | |||
91586 | 91586 | 4807 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 260 Corona St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 35 | 5992988.2755218 | 2092740.8940691003 | 37.7258653179999 | -122.46644356219299 | (37.7258653179999, -122.466443562193) | |||
99473 | 99473 | 3689 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 200X Cargo Way | 3 | Median : Cutout 11 | Tree 1 | Port 9 | 12 | 8 | 6017218.5539168 | 2098854.5663776 | 37.7440206368399 | -122.38310567533199 | (37.7440206368399, -122.383105675332) | |||
104843 | 104843 | 3692 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 300X Cargo Way | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 8 | 6017817.275253 | 2098336.256691 | 37.742630528905295 | -122.380999383309 | (37.7426305289053, -122.380999383309) | |||
108562 | 108562 | 4809 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 260 Corona St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 35 | 5992988.2755218 | 2092740.8940691003 | 37.7258653179999 | -122.46644356219299 | (37.7258653179999, -122.466443562193) | |||
111013 | 111013 | 4808 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 260 Corona St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 35 | 5992988.2755218 | 2092740.8940691003 | 37.7258653179999 | -122.46644356219299 | (37.7258653179999, -122.466443562193) | |||
118559 | 118559 | 3686 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 100X Cargo Way | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 12 | 8 | 6018980.3390981 | 2097500.2540781004 | 37.740399159699294 | -122.376919818221 | (37.7403991596993, -122.376919818221) | |||
120664 | 120664 | 99135 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 302X Pacheco St | 18 | Median : Cutout 11 | Tree 1 | Private 1 | 3 | 5994341.5 | 2100725.2 | 37.747866238402096 | -122.46234443277001 | (37.7478662384021, -122.46234443277) | ||||
121090 | 121090 | 200539 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6016182.3272 | 2095656.8744 | 37.735183110122 | -122.38646583191401 | (37.735183110122, -122.386465831914) | |||
127580 | 127580 | 3691 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 200X Cargo Way | 5 | Median : Cutout 11 | Tree 1 | Port 9 | 12 | 8 | 6017218.5539168 | 2098854.5663776 | 37.7440206368399 | -122.38310567533199 | (37.7440206368399, -122.383105675332) | |||
127726 | 127726 | 3690 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 200X Cargo Way | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 12 | 8 | 6017218.5539168 | 2098854.5663776 | 37.7440206368399 | -122.38310567533199 | (37.7440206368399, -122.383105675332) | |||
128521 | 128521 | 3688 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 200X Cargo Way | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 18 | 8 | 6017218.5539168 | 2098854.5663776 | 37.7440206368399 | -122.38310567533199 | (37.7440206368399, -122.383105675332) | |||
130157 | 130157 | 200606 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 47 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 0ft | 6016400.6473 | 2095190.9605 | 37.7339158869669 | -122.385678551006 | (37.7339158869669, -122.385678551006) | |||
131211 | 131211 | 200607 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 48 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6016406.5235 | 2095183.1256 | 37.73389469904829 | -122.385657689133 | (37.7338946990483, -122.385657689133) | |||
133613 | 133613 | 200541 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 0ft | 6016186.7948 | 2095652.8098 | 37.7351721968582 | -122.386450102344 | (37.7351721968582, -122.386450102344) | |||
134402 | 134402 | 200552 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 28 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 0ft | 6016213.9999 | 2095615.2915 | 37.7350706850821 | -122.386353428604 | (37.7350706850821, -122.386353428604) | |||
137314 | 137314 | 200611 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 51 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 0ft | 6016421.2138 | 2095153.2552 | 37.7338134937512 | -122.385604818769 | (37.7338134937512, -122.385604818769) | |||
137749 | 137749 | 200543 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 19 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6016187.8616 | 2095644.6304 | 37.7351497969246 | -122.38644584387501 | (37.7351497969246, -122.386445843875) | |||
140153 | 140153 | 3687 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 200X Cargo Way | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 12 | 8 | 6017218.5539168 | 2098854.5663776 | 37.7440206368399 | -122.38310567533199 | (37.7440206368399, -122.383105675332) | |||
153209 | 153209 | 200532 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 0ft | 6016155.8972 | 2095677.4311 | 37.7352380915724 | -122.386558643793 | (37.7352380915724, -122.386558643793) | |||
159406 | 159406 | 200605 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 46 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 0ft | 6016398.6886 | 2095199.7747 | 37.7339399806144 | -122.385685937001 | (37.7339399806144, -122.385685937001) | |||
169172 | 169172 | 200560 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 37 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 0ft | 6016311.7963 | 2095496.5134 | 37.7347499571366 | -122.38600703115401 | (37.7347499571366, -122.386007031154) | |||
169201 | 169201 | 200549 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 25 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 0ft | 6016205.8206 | 2095623.8265 | 37.7350936677212 | -122.386382302519 | (37.7350936677212, -122.386382302519) | |||
169431 | 169431 | 200546 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 22 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6016197.8191 | 2095632.8949 | 37.735118124804394 | -122.386410598906 | (37.7351181248044, -122.386410598906) | |||
172385 | 172385 | 200555 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 31 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6016252.4072 | 2095574.3949 | 37.7349605171331 | -122.386217789361 | (37.7349605171331, -122.386217789361) | |||
173916 | 173916 | 200530 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 0ft | 6016148.3458 | 2095686.6607 | 37.735263016153105 | -122.386585395355 | (37.7352630161531, -122.386585395355) | |||
177749 | 177749 | 200602 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 45 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 0ft | 6016396.2402 | 2095212.996 | 37.7339761481789 | -122.385695323117 | (37.7339761481789, -122.385695323117) | |||
180983 | 180983 | 200531 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 6016156.3167 | 2095682.0459 | 37.7352507861079 | -122.386557515095 | (37.7352507861079, -122.386557515095) | |||
187646 | 187646 | 200535 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 0ft | 6016168.4829 | 2095664.0064 | 37.735201926775396 | -122.386514194261 | (37.7352019267754, -122.386514194261) | |||
188905 | 188905 | 200550 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 26 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6016212.9331 | 2095623.1152 | 37.7350921083386 | -122.386357662249 | (37.7350921083386, -122.386357662249) |
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");