Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, PlantDate, DBH, PlotSize, PermitNotes
Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
88059 | 88059 | 88281 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 16 | 935 Ulloa St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/09/2008 12:00:00 AM | 3x3 | Permit Number 51275 | 5993125.0 | 2098282.0 | 37.7410877064311 | -122.466373457073 | (37.7410877064311, -122.466373457073) | ||
93838 | 93838 | 94852 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 769 Joost Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 5997030.4 | 2094957.2 | 37.7321831815324 | -122.45263017562 | (37.7321831815324, -122.45263017562) | ||||
123568 | 123568 | 96765 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 16 | 184 Edgewood Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/12/2011 12:00:00 AM | Permit Number 767998 | 5996632.0 | 2105999.0 | 37.76247839448661 | -122.45480501488301 | (37.7624783944866, -122.454805014883) | |||
80392 | 80392 | 98149 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 850 Rockdale Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/23/2012 12:00:00 AM | Permit Number 768501 | 5996729.9 | 2098301.3 | 37.7413480470066 | -122.453910481227 | (37.7413480470066, -122.453910481227) | |||
94269 | 94269 | 98150 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 850 Rockdale Dr | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/23/2012 12:00:00 AM | Permit Number 768501 | 5996729.9 | 2098301.3 | 37.7413480470066 | -122.453910481227 | (37.7413480470066, -122.453910481227) | |||
128628 | 128628 | 107635 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 16 | 1150 Lombard St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/01/2014 12:00:00 AM | 3 | Permit Number 773092 | 6006825.00646 | 2120436.80144 | 37.8027004912885 | -122.42057600387301 | (37.8027004912885, -122.420576003873) | ||
82402 | 82402 | 114388 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 16 | 361x ARBALLO DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 5988379.0 | 2090615.0 | 37.7197611043299 | -122.48222163222201 | (37.7197611043299, -122.482221632222) | ||||
110551 | 110551 | 117619 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 5700 03RD ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6013866.0 | 2092333.0 | 37.7259279317454 | -122.394241638465 | (37.7259279317454, -122.394241638465) | |||||
172165 | 172165 | 135823 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1015 Vallejo St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6008630.162959999 | 2118635.32656 | 37.7978556572789 | -122.414201697946 | (37.7978556572789, -122.414201697946) | ||||
32547 | 32547 | 135824 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1013 Vallejo St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 6008637.906 | 2118634.49639 | 37.7978538127598 | -122.41417484600099 | (37.7978538127598, -122.414174846001) | ||||
171682 | 171682 | 135825 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 941 Vallejo St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6008892.44244 | 2118672.21795 | 37.7979716806151 | -122.413296744356 | (37.7979716806151, -122.413296744356) | ||||
30016 | 30016 | 135826 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 900 Green St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6008677.52116 | 2119019.1422200003 | 37.798912179918396 | -122.414064992014 | (37.7989121799184, -122.414064992014) | ||||
63126 | 63126 | 135827 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 900 Green St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6008668.93858 | 2119018.75606 | 37.7989106375677 | -122.414094663337 | (37.7989106375677, -122.414094663337) | ||||
177555 | 177555 | 135829 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 900 Green St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6008653.20032 | 2119016.0444 | 37.798902308044205 | -122.414148931139 | (37.7989023080442, -122.414148931139) | ||||
170177 | 170177 | 135830 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 900 Green St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6008645.65329 | 2119014.61059 | 37.7988979472514 | -122.41417494494101 | (37.7988979472514, -122.414174944941) | ||||
156622 | 156622 | 135832 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 900 Green St | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6008638.145690001 | 2119013.6558 | 37.7988949039377 | -122.414200856206 | (37.7988949039377, -122.414200856206) | ||||
164608 | 164608 | 135833 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 900 Green St | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6008637.50385 | 2119009.84925 | 37.798884416044295 | -122.414202807733 | (37.7988844160443, -122.414202807733) | ||||
153540 | 153540 | 196078 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1301 Minnesota St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6015385.56179 | 2102265.48112 | 37.7532848375261 | -122.389681986358 | (37.7532848375261, -122.389681986358) | ||||
31066 | 31066 | 196079 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1301 Minnesota St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6015395.01764 | 2102273.41777 | 37.753307154219996 | -122.389649840082 | (37.75330715422, -122.389649840082) | ||||
58156 | 58156 | 196080 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1301 Minnesota St | 26 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6015379.264690001 | 2102450.5128 | 37.7537925462017 | -122.389716685804 | (37.7537925462017, -122.389716685804) | ||||
56155 | 56155 | 196081 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1301 Minnesota St | 27 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6015382.92285 | 2102459.87565 | 37.7538184574574 | -122.389704688841 | (37.7538184574574, -122.389704688841) | ||||
175538 | 175538 | 196115 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1900 19th St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6012049.31066 | 2105149.60429 | 37.7610184423716 | -122.401422171593 | (37.7610184423716, -122.401422171593) | ||||
76422 | 76422 | 196116 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1900 19th St | 26 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6011922.16115 | 2105142.4561099997 | 37.760991719900204 | -122.401861426588 | (37.7609917199002, -122.401861426588) | ||||
48647 | 48647 | 196283 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1900 19th St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6012056.94369 | 2105140.22302 | 37.760993109370396 | -122.40139511279699 | (37.7609931093704, -122.401395112797) | ||||
132725 | 132725 | 196284 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1900 19th St | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6012010.81068 | 2105139.52055 | 37.76098860647 | -122.401554618352 | (37.76098860647, -122.401554618352) | ||||
185940 | 185940 | 196285 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2209 25th St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6012134.59471 | 2101859.1570900003 | 37.7519883551004 | -122.400896021442 | (37.7519883551004, -122.400896021442) | ||||
72281 | 72281 | 196286 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Jack Balestreri Way | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 27 | 6012387.37414 | 2104738.06992 | 37.7599073164914 | -122.40022404532301 | (37.7599073164914, -122.400224045323) | ||||
45385 | 45385 | 196287 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Jack Balestreri Way | 16 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6012398.9699099995 | 2104759.28758 | 37.7599662220764 | -122.400185431124 | (37.7599662220764, -122.400185431124) | ||||
34763 | 34763 | 196288 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Jack Balestreri Way | 19 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6012383.755890001 | 2104753.48944 | 37.7599494533344 | -122.40023764215799 | (37.7599494533344, -122.400237642158) | ||||
53555 | 53555 | 196289 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Jack Balestreri Way | 20 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6012382.84954 | 2104763.06022 | 37.7599756820445 | -122.400241449008 | (37.7599756820445, -122.400241449008) | ||||
174122 | 174122 | 196290 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Jack Balestreri Way | 23 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6012385.57921 | 2104781.3261 | 37.760025988325296 | -122.400233291241 | (37.7600259883253, -122.400233291241) | ||||
132745 | 132745 | 196291 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Jack Balestreri Way | 24 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6012380.38083 | 2104793.15065 | 37.7600581660633 | -122.40025210055401 | (37.7600581660633, -122.400252100554) | ||||
35147 | 35147 | 196292 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Jack Balestreri Way | 25 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6012388.17486 | 2104794.0427599996 | 37.760061050199596 | -122.400225207229 | (37.7600610501996, -122.400225207229) | ||||
69480 | 69480 | 196293 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Jack Balestreri Way | 26 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6012394.755369999 | 2104793.13157 | 37.760058915200894 | -122.40020238425899 | (37.7600589152009, -122.400202384259) | ||||
151012 | 151012 | 196294 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Jack Balestreri Way | 29 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6012397.7351 | 2104775.9114900003 | 37.7600117988112 | -122.400190869313 | (37.7600117988112, -122.400190869313) | ||||
46448 | 46448 | 196295 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Jack Balestreri Way | 30 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6012406.535130001 | 2104796.6998799997 | 37.760069369818396 | -122.400161894071 | (37.7600693698184, -122.400161894071) | ||||
75496 | 75496 | 213000 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1624 09th Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Width 6ft | 5993419.01621 | 2104404.96618 | 37.757916767851 | -122.465801633144 | (37.757916767851, -122.465801633144) | |||
67129 | 67129 | 213001 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1684 09th Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | Width 6ft | 5993433.46083 | 2104046.51042 | 37.75693337449479 | -122.465725635034 | (37.7569333744948, -122.465725635034) | |||
49076 | 49076 | 213002 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1684 09th Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Width 6ft | 5993433.63561 | 2104037.38887 | 37.756908339163104 | -122.46572436788401 | (37.7569083391631, -122.465724367884) | |||
151464 | 151464 | 235817 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1100 San Jose Ave | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6004822.42973 | 2096709.04499 | 37.7374367425214 | -122.425816018614 | (37.7374367425214, -122.425816018614) | ||||
175316 | 175316 | 235818 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1100 San Jose Ave | 43 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | 6004748.03107 | 2096617.2038599998 | 37.7371803628754 | -122.426066713609 | (37.7371803628754, -122.426066713609) | ||||
162715 | 162715 | 235819 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1100 San Jose Ave | 31 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 6004808.19427 | 2096683.55845 | 37.7373659577613 | -122.42586342366 | (37.7373659577613, -122.42586342366) | ||||
40808 | 40808 | 235821 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1101 San Jose Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6004684.25074 | 2096286.8967900001 | 37.7362698092063 | -122.426263721818 | (37.7362698092063, -122.426263721818) | ||||
176516 | 176516 | 235822 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 200 Eugenia Ave | 36 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6006569.74565 | 2098123.14893 | 37.7414181446448 | -122.419875033313 | (37.7414181446448, -122.419875033313) | ||||
174515 | 174515 | 236750 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 3943 21st St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 6002208.02955 | 2103519.5484700003 | 37.7559886915345 | -122.43534223396601 | (37.7559886915345, -122.435342233966) | ||||
170863 | 170863 | 236791 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 192 Marview Way | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | Width 0ft | 5998125.74661 | 2103459.41933 | 37.755590911501606 | -122.44945572381799 | (37.7555909115016, -122.449455723818) | |||
29068 | 29068 | 237593 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 37 Seward St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | Width 3ft | 6000955.31205 | 2104253.31098 | 37.7579322029301 | -122.439727139419 | (37.7579322029301, -122.439727139419) | |||
138241 | 138241 | 237594 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 37 Seward St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Width 3ft | 6000962.1319699995 | 2104249.24086 | 37.757921415553604 | -122.439703261523 | (37.7579214155536, -122.439703261523) | |||
29351 | 29351 | 237735 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 701 Church St | 25 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | Width 3ft | 6004351.71049 | 2104523.66761 | 37.758867273023604 | -122.42800022455499 | (37.7588672730236, -122.428000224555) | |||
22288 | 22288 | 237856 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 636 30th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 6ft | 6002455.57988 | 2098272.49197 | 37.7415955682714 | -122.434111048608 | (37.7415955682714, -122.434111048608) | |||
160246 | 160246 | 237862 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1000 San Jose Ave | 16 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6005165.80079 | 2097273.24395 | 37.7390053040631 | -122.424668946839 | (37.7390053040631, -122.424668946839) | ||||
162343 | 162343 | 237863 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1100 San Jose Ave | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6004816.92245 | 2096702.3480099998 | 37.737418042901204 | -122.42583458331801 | (37.7374180429012, -122.425834583318) | ||||
35443 | 35443 | 237864 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1201 San Jose Ave | 41 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6004410.62481 | 2096042.76783 | 37.735584015890204 | -122.427192376154 | (37.7355840158902, -122.427192376154) | ||||
129663 | 129663 | 237865 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1201 San Jose Ave | 42 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6004416.51581 | 2096041.25908 | 37.735580206346704 | -122.427171901277 | (37.7355802063467, -122.427171901277) | ||||
59058 | 59058 | 246632 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 3320 Harrison St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6009038.19965 | 2099264.8934299997 | 37.744691880139705 | -122.411420585011 | (37.7446918801397, -122.411420585011) | ||||
41647 | 41647 | 246741 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 132 Ripley St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 8ft | 6008870.15252 | 2099074.1430099998 | 37.7441586945704 | -122.41198818403099 | (37.7441586945704, -122.411988184031) | |||
68114 | 68114 | 246828 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 400 Franconia St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6009896.65994 | 2098729.7560099997 | 37.743270622146 | -122.408414443683 | (37.743270622146, -122.408414443683) | ||||
123929 | 123929 | 247956 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 6 Joy St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6010454.452819999 | 2098883.02488 | 37.7437226861619 | -122.40649652970501 | (37.7437226861619, -122.406496529705) | ||||
168699 | 168699 | 247958 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Joy St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6010403.29697 | 2098902.73698 | 37.7437739492996 | -122.406674804102 | (37.7437739492996, -122.406674804102) | ||||
74729 | 74729 | 247959 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 12 Joy St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6010396.832769999 | 2098907.5359799997 | 37.743786764640795 | -122.40669749401 | (37.7437867646408, -122.40669749401) | ||||
32465 | 32465 | 248037 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 55 Rutledge St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6010488.35763 | 2099431.59018 | 37.745230824035204 | -122.40641793974599 | (37.7452308240352, -122.406417939746) | ||||
64801 | 64801 | 248042 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 43 Rutledge St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6010523.22894 | 2099409.2799 | 37.745171515566796 | -122.40629578842301 | (37.7451715155668, -122.406295788423) | ||||
33070 | 33070 | 249679 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2400 Baker St | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 5999741.43988 | 2117216.47572 | 37.793456580320395 | -122.44485702433998 | (37.7934565803204, -122.44485702434) | ||||
184038 | 184038 | 249689 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2400 Baker St | 21 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 5999718.81935 | 2117298.99939 | 37.7936818775552 | -122.444941227873 | (37.7936818775552, -122.444941227873) | ||||
30309 | 30309 | 249829 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 339 Greenwich St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 0ft | 6011201.84726 | 2120367.04696 | 37.802754654775704 | -122.405424923615 | (37.8027546547757, -122.405424923615) | |||
39263 | 39263 | 249833 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 333 Greenwich St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Width 0ft | 6011234.89731 | 2120366.37397 | 37.8027546547576 | -122.40531050560101 | (37.8027546547576, -122.405310505601) | |||
35676 | 35676 | 249834 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 333 Greenwich St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | Width 0ft | 6011234.1519 | 2120371.9476900003 | 37.8027699171526 | -122.40531347785401 | (37.8027699171526, -122.405313477854) | |||
63079 | 63079 | 249835 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 333 Greenwich St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | Width 0ft | 6011233.03828 | 2120380.52255 | 37.8027933993566 | -122.40531793578 | (37.8027933993566, -122.40531793578) | |||
116481 | 116481 | 249933 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 345 Filbert St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Width 0ft | 6011225.47356 | 2120026.31802 | 37.801820417444 | -122.405319155254 | (37.801820417444, -122.405319155254) | |||
184115 | 184115 | 249937 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 339 Filbert St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Width 0ft | 6011248.56733 | 2120031.66705 | 37.8018363956996 | -122.405239616532 | (37.8018363956996, -122.405239616532) | |||
76837 | 76837 | 249945 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 325 Filbert St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | Width 0ft | 6011292.48387 | 2120026.50548 | 37.8018246784261 | -122.40508728037399 | (37.8018246784261, -122.405087280374) | |||
182162 | 182162 | 249963 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 271 Filbert St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | Width 0ft | 6011592.60874 | 2120072.38059 | 37.8019674134157 | -122.404051933175 | (37.8019674134157, -122.404051933175) | |||
173495 | 173495 | 249974 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 28 Napier Ln | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | Width 0ft | 6011652.50252 | 2120258.9240099997 | 37.802482962378704 | -122.403857805517 | (37.8024829623787, -122.403857805517) | |||
159690 | 159690 | 249982 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 224 Filbert St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | Width 0ft | 6011639.74764 | 2120113.25639 | 37.8020822820333 | -122.403891687471 | (37.8020822820333, -122.403891687471) |
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");