Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▲ | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
532 | 532 | 6761 | DPW Maintained 3 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1275 Fairfax Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2017 01:35:00 PM | 3 | 3x3 | 6017199.30801 | 2096970.01555 | 37.738844977413 | -122.383041088382 | (37.738844977413, -122.383041088382) | ||
14228 | 14228 | 46416 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 700 Illinois St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2002 12:00:00 AM | 5 | 3x3 | Permit Number 44641 | 6015974.86179 | 2105759.1893599997 | 37.7629104774528 | -122.38788781187701 | (37.7629104774528, -122.387887811877) | |
13613 | 13613 | 46415 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 700 Illinois St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2002 12:00:00 AM | 5 | 3x3 | Permit Number 44641 | 6015975.2824099995 | 2105780.03754 | 37.7629677453768 | -122.3878878119 | (37.7629677453768, -122.3878878119) | |
150182 | 150182 | 193425 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 501 18th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6015950.63788 | 2105804.61367 | 37.7630338608554 | -122.38797476464799 | (37.7630338608554, -122.387974764648) | |||
26689 | 26689 | 193419 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 610 Illinois St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6015956.40459 | 2106139.49843 | 37.763953701820604 | -122.387978189259 | (37.7639537018206, -122.387978189259) | |||
46903 | 46903 | 193418 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 610 Illinois St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6015955.040580001 | 2106161.7939400002 | 37.7640148449206 | -122.387984462917 | (37.7640148449206, -122.387984462917) | |||
31798 | 31798 | 193424 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 501 18th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6015930.41591 | 2105802.18595 | 37.7630260745267 | -122.38804453674801 | (37.7630260745267, -122.388044536748) | |||
165780 | 165780 | 193423 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 501 18th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6015877.90137 | 2105798.99134 | 37.7630143932264 | -122.388225945268 | (37.7630143932264, -122.388225945268) | |||
172396 | 172396 | 193422 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 501 18th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6015855.7958 | 2105797.31045 | 37.763008553013 | -122.388302284235 | (37.763008553013, -122.388302284235) | |||
175041 | 175041 | 193421 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 501 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6015817.08868 | 2105796.2011 | 37.763003362128 | -122.38843608266899 | (37.763003362128, -122.388436082669) | |||
44609 | 44609 | 193420 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 501 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6015798.54633 | 2105794.6845 | 37.76299817034379 | -122.38850010901001 | (37.7629981703438, -122.38850010901) | |||
2266 | 2266 | 253000 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1201 Tennessee St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | |||
2272 | 2272 | 253002 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1201 Tennessee St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | |||
2273 | 2273 | 252995 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1201 Tennessee St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | |||
2275 | 2275 | 253003 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1201 Tennessee St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | |||
2276 | 2276 | 252994 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1201 Tennessee St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | |||
2278 | 2278 | 252992 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1201 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | |||
2281 | 2281 | 252998 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1201 Tennessee St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | |||
2288 | 2288 | 252996 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1201 Tennessee St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | |||
2289 | 2289 | 252993 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1201 Tennessee St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | |||
2290 | 2290 | 252997 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1201 Tennessee St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | |||
2294 | 2294 | 252999 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1201 Tennessee St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | |||
2296 | 2296 | 253001 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1201 Tennessee St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | |||
37325 | 37325 | 193426 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 807 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6015414.46793 | 2103902.8500099997 | 37.7577823075377 | -122.389696374594 | (37.7577823075377, -122.389696374594) | |||
132389 | 132389 | 46977 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1310 Minnesota St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2002 12:00:00 AM | 2 | Permit Number 44998 | 6015323.660209999 | 2102361.18474 | 37.7535441867291 | -122.38990274114201 | (37.7535441867291, -122.389902741142) | ||
76597 | 76597 | 46980 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1310 Minnesota St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2002 12:00:00 AM | 2 | Permit Number 44998 | 6015320.4365300005 | 2102435.8456200003 | 37.7537490109239 | -122.38991910430799 | (37.7537490109239, -122.389919104308) | ||
174880 | 174880 | 46981 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1310 Minnesota St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2002 12:00:00 AM | 1 | Permit Number 44998 | 6015319.9852 | 2102418.03165 | 37.7537000725041 | -122.389919420856 | (37.7537000725041, -122.389919420856) | ||
80702 | 80702 | 29817 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1695X Evans Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Purchasing Dept 15 | 09/11/2006 12:00:00 AM | 3 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.74391708243721 | -122.39024991836901 | (37.7439170824372, -122.390249918369) | ||
159837 | 159837 | 193415 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1425 Indiana St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6015129.4675 | 2101818.79874 | 37.75204413825129 | -122.390536410622 | (37.7520441382513, -122.390536410622) | |||
151479 | 151479 | 193416 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1425 Indiana St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6015128.54714 | 2101843.94886 | 37.75211314410829 | -122.390541350608 | (37.7521131441083, -122.390541350608) | |||
57871 | 57871 | 193417 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1425 Indiana St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6015126.28801 | 2101884.04231 | 37.7522231069197 | -122.39055196440201 | (37.7522231069197, -122.390551964402) | |||
130484 | 130484 | 193429 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1151 22nd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6014506.85634 | 2103858.18885 | 37.7576093076281 | -122.39283217206699 | (37.7576093076281, -122.392832172067) | |||
60282 | 60282 | 193428 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1151 22nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6014491.22334 | 2103857.32403 | 37.7576060646987 | -122.392886177259 | (37.7576060646987, -122.392886177259) | |||
54459 | 54459 | 193427 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1151 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6014474.19771 | 2103855.91322 | 37.75760124521779 | -122.39294496056499 | (37.7576012452178, -122.392944960565) | |||
74732 | 74732 | 117153 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 701 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6014462.23102 | 2103712.78244 | 37.757207574192 | -122.392976332502 | (37.757207574192, -122.392976332502) | |||
61175 | 61175 | 117154 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 701 Pennsylvania Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6014461.75742 | 2103731.13458 | 37.757257938912 | -122.3929792544 | (37.757257938912, -122.3929792544) | |||
26639 | 26639 | 117155 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 701 Pennsylvania Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6014460.76675 | 2103748.99279 | 37.757306918684 | -122.392983929988 | (37.757306918684, -122.392983929988) | |||
176083 | 176083 | 117157 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 701 Pennsylvania Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6014459.2864 | 2103784.30474 | 37.7574037954676 | -122.39299152024999 | (37.7574037954676, -122.39299152025) | |||
48188 | 48188 | 117156 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 701 Pennsylvania Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6014458.776219999 | 2103767.54398 | 37.7573577456892 | -122.392992112005 | (37.7573577456892, -122.392992112005) | |||
47570 | 47570 | 117158 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 701 Pennsylvania Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6014455.94065 | 2103803.2979900003 | 37.7574557609929 | -122.393004420141 | (37.7574557609929, -122.393004420141) | |||
36596 | 36596 | 117159 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 701 Pennsylvania Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6014455.7871900005 | 2103822.04979 | 37.7575072408736 | -122.39300626284799 | (37.7575072408736, -122.393006262848) | |||
136176 | 136176 | 117160 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 701 Pennsylvania Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6014455.03317 | 2103837.45298 | 37.7575494928317 | -122.393009948265 | (37.7575494928317, -122.393009948265) | |||
123713 | 123713 | 67599 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 380 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/1992 12:00:00 AM | 5 | Permit Number 31168 | 6014306.36915 | 2105365.66412 | 37.7617373703071 | -122.393631049748 | (37.7617373703071, -122.393631049748) | |
184780 | 184780 | 202019 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1350 Fitzgerald Ave | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6013890.086209999 | 2091145.17982 | 37.7226677548035 | -122.394075255469 | (37.7226677548035, -122.394075255469) | |||
54038 | 54038 | 202020 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1330 Fitzgerald Ave | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6013858.20959 | 2091166.1399 | 37.7227235352339 | -122.39418691350599 | (37.7227235352339, -122.394186913506) | |||
58655 | 58655 | 202021 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1330 Fitzgerald Ave | 3 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6013834.37055 | 2091185.2446599999 | 37.722774667999 | -122.39427065747101 | (37.722774667999, -122.394270657471) | |||
69513 | 69513 | 202022 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1330 Fitzgerald Ave | 4 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6013717.54523 | 2091271.8320400002 | 37.723005925068605 | -122.39468056126199 | (37.7230059250686, -122.394680561262) | |||
154620 | 154620 | 202023 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1330 Fitzgerald Ave | 5 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6013701.15269 | 2091283.23076 | 37.723036312264796 | -122.394738025239 | (37.7230363122648, -122.394738025239) | |||
50998 | 50998 | 202024 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1330 Fitzgerald Ave | 6 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6013681.0358 | 2091298.8599 | 37.7230781082384 | -122.394808659817 | (37.7230781082384, -122.394808659817) | |||
161322 | 161322 | 202025 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1330 Fitzgerald Ave | 7 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6013662.901769999 | 2091312.2744599998 | 37.723113933631204 | -122.394872285044 | (37.7231139336312, -122.394872285044) | |||
170064 | 170064 | 202026 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1330 Fitzgerald Ave | 8 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6013645.7458 | 2091325.32173 | 37.723148804870206 | -122.394932503635 | (37.7231488048702, -122.394932503635) | |||
175470 | 175470 | 202027 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1330 Fitzgerald Ave | 9 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6013629.1875599995 | 2091337.20695 | 37.72318051856 | -122.39499057468001 | (37.72318051856, -122.39499057468) | |||
35864 | 35864 | 202028 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1330 Fitzgerald Ave | 10 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6013610.79633 | 2091351.15014 | 37.723217781063205 | -122.395055126189 | (37.7232177810632, -122.395055126189) | |||
36116 | 36116 | 75673 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 618X Missouri St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/1996 12:00:00 AM | 7 | 6013545.06469 | 2104202.26889 | 37.7585006086339 | -122.396182576568 | (37.7585006086339, -122.396182576568) | ||
183298 | 183298 | 193436 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 608 Missouri St | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6013540.38062 | 2104266.7592 | 37.758677424352896 | -122.39620329606899 | (37.7586774243529, -122.396203296069) | |||
186395 | 186395 | 193434 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 598 Missouri St | 3 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6013537.98707 | 2104307.6187400003 | 37.758789482567295 | -122.396214437761 | (37.7587894825673, -122.396214437761) | |||
163256 | 163256 | 193435 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 600 Missouri St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6013537.44197 | 2104295.86136 | 37.7587571690323 | -122.39621549896299 | (37.7587571690323, -122.396215498963) | |||
40746 | 40746 | 193433 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 588 Missouri St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6013536.39974 | 2104342.74788 | 37.758885851209 | -122.396222389564 | (37.758885851209, -122.396222389564) | |||
58037 | 58037 | 193432 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 572 Missouri St | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6013532.897999999 | 2104416.8953299997 | 37.759089249099105 | -122.39623969701401 | (37.7590892490991, -122.396239697014) | |||
26296 | 26296 | 193431 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 568 Missouri St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6013531.88693 | 2104447.0848 | 37.7591720865425 | -122.39624530967801 | (37.7591720865425, -122.396245309678) | |||
36283 | 36283 | 193430 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 560 Missouri St | 4 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6013531.28257 | 2104470.6669900003 | 37.7592368044652 | -122.396249052661 | (37.7592368044652, -122.396249052661) | |||
83678 | 83678 | 99998 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 501X Mission St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 06/26/2012 12:00:00 AM | Permit Number 768978 | 6013420.0 | 2115433.0 | 37.7893307029327 | -122.397402707509 | (37.7893307029327, -122.397402707509) | |||
170086 | 170086 | 37947 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 255 Connecticut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | 8 | Permit Number 40187 | 6013212.35398 | 2105880.56458 | 37.7630903220716 | -122.39745094713001 | (37.7630903220716, -122.39745094713) | |
45215 | 45215 | 37946 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 255 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | 6 | Permit Number 40187 | 6013211.43951 | 2105863.92108 | 37.7630445717758 | -122.397452942701 | (37.7630445717758, -122.397452942701) | |
94785 | 94785 | 100008 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 501X Mission St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 06/26/2012 12:00:00 AM | Permit Number 768978 | 6013380.8 | 2115570.5 | 37.789706063197606 | -122.39754798333901 | (37.7897060631976, -122.397547983339) | |||
124691 | 124691 | 100003 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 501X Mission St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 06/26/2012 12:00:00 AM | Permit Number 768978 | 6013380.8 | 2115570.5 | 37.789706063197606 | -122.39754798333901 | (37.7897060631976, -122.397547983339) | |||
128958 | 128958 | 100007 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 501X Mission St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 06/26/2012 12:00:00 AM | Permit Number 768978 | 6013380.8 | 2115570.5 | 37.789706063197606 | -122.39754798333901 | (37.7897060631976, -122.397547983339) | |||
149115 | 149115 | 93670 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 12 Robblee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/2011 12:00:00 AM | 1 | 3x3 | Permit Number 54071 | 6012650.87025 | 2095997.96753 | 37.735923558519104 | -122.39869937070299 | (37.7359235585191, -122.398699370703) | |
70771 | 70771 | 193438 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 170 Scotia Ave | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6012250.26105 | 2094642.5839099998 | 37.7321796295918 | -122.39998929257601 | (37.7321796295918, -122.399989292576) | |||
175333 | 175333 | 95808 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 974 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/14/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767552 | 6011863.56882 | 2103875.82821 | 37.757510570168705 | -122.401975028944 | (37.7575105701687, -122.401975028944) |
63056 | 63056 | 193414 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 563 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6011255.16087 | 2105737.93689 | 37.762589530116 | -122.40421021383999 | (37.762589530116, -122.40421021384) | |||
28347 | 28347 | 35383 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 557 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | 6 | Permit Number 38839 | 6011254.224359999 | 2105785.2809900003 | 37.7627194740588 | -122.4042167852 | (37.7627194740588, -122.4042167852) | |
182864 | 182864 | 193412 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 2200 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6011187.90739 | 2105585.43525 | 37.7621670366875 | -122.404432085586 | (37.7621670366875, -122.404432085586) | |||
58293 | 58293 | 193413 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 2200 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6011171.17043 | 2105584.0111700003 | 37.7621621911485 | -122.404489872412 | (37.7621621911485, -122.404489872412) | |||
138689 | 138689 | 35331 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 2222 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | 7 | Permit Number 38797 | 6011102.74031 | 2105580.11017 | 37.7621476554073 | -122.404726272704 | (37.7621476554073, -122.404726272704) | |
30004 | 30004 | 193411 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 681 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6011009.79725 | 2105127.16685 | 37.7608987794618 | -122.40501583552 | (37.7608987794618, -122.40501583552) | |||
146792 | 146792 | 101611 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 681 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x6 | 6011008.341990001 | 2105144.37638 | 37.7609459516243 | -122.40502208042 | (37.7609459516243, -122.40502208042) | |||
31110 | 31110 | 101612 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 681 San Bruno Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 7x5 | 6011003.086019999 | 2105162.84205 | 37.7609963604006 | -122.40504155884399 | (37.7609963604006, -122.405041558844) | |||
36526 | 36526 | 101613 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 681 San Bruno Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 9x7 | 6011003.32363 | 2105183.63205 | 37.7610534583629 | -122.405042200948 | (37.7610534583629, -122.405042200948) | |||
127359 | 127359 | 34304 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1248 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/2016 12:00:00 AM | Permit Number 777415 | 6010821.325282 | 2102511.88817286 | 37.7537072691799 | -122.40548348700099 | (37.7537072691799, -122.405483487001) | ||
70356 | 70356 | 193410 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 551 Utah St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6010705.60274 | 2105553.4377099997 | 37.762052213957794 | -122.40609794748501 | (37.7620522139578, -122.406097947485) | |||
21619 | 21619 | 18476 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1263 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/23/1997 12:00:00 AM | 18 | 3X3 | 6010629.32405 | 2101956.3743 | 37.7521712133345 | -122.406108340032 | (37.7521712133345, -122.406108340032) | ||
21711 | 21711 | 18473 | DPW Maintained 3 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1255 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/15/2013 12:00:00 AM | 3 | 3x3 | 6010628.31505 | 2101997.99365 | 37.7522854344497 | -122.40611476119301 | (37.7522854344497, -122.406114761193) | ||
20449 | 20449 | 18472 | DPW Maintained 3 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1245 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/11/2015 07:25:00 AM | 3 | 3X3 | 6010625.30786 | 2102050.90235 | 37.7524305418599 | -122.406128887762 | (37.7524305418599, -122.406128887762) | ||
187968 | 187968 | 193409 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 551 Utah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6010674.14728 | 2105512.6689400002 | 37.7619385126714 | -122.40620386783701 | (37.7619385126714, -122.406203867837) | |||
18510 | 18510 | 27621 | DPW Maintained 3 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1143 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/14/2013 12:00:00 AM | 3 | 3x3 | 6010597.97715 | 2102516.5515099997 | 37.7537075827479 | -122.406256207463 | (37.7537075827479, -122.406256207463) | ||
21944 | 21944 | 18455 | DPW Maintained 3 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1115 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/17/2015 12:46:00 PM | 3 | 3X3 | 6010591.726009999 | 2102631.1286299997 | 37.754021836464794 | -122.406285897673 | (37.7540218364648, -122.406285897673) | ||
21177 | 21177 | 18475 | DPW Maintained 3 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1260 Potrero Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/10/2013 12:00:00 AM | 3 | 3x3 | 6010550.213330001 | 2101942.07688 | 37.75212753057279 | -122.406380911075 | (37.7521275305728, -122.406380911075) | ||
21253 | 21253 | 18474 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1260 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/2015 12:00:00 AM | 3 | 0 | Permit Number 773798 | 6010545.83787 | 2101980.95756 | 37.752234043567206 | -122.406398781502 | (37.7522340435672, -122.406398781502) |
23345 | 23345 | 18460 | DPW Maintained 3 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1146 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/26/2006 12:00:00 AM | 5 | 3X3 | 6010512.14548 | 2102543.99159 | 37.753778125574 | -122.40655496764099 | (37.753778125574, -122.406554967641) | ||
173435 | 173435 | 230401 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1140 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6010508.63913 | 2102581.4092 | 37.753880669869794 | -122.406569730021 | (37.7538806698698, -122.406569730021) | |||
17958 | 17958 | 18458 | DPW Maintained 3 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1136 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/01/2006 12:00:00 AM | 3 | 4X4 | 6010508.182130001 | 2102591.0282099997 | 37.753907055971105 | -122.406571988228 | (37.7539070559711, -122.406571988228) | ||
138541 | 138541 | 230402 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 995 Potrero Ave | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 4ft | 6010527.0507 | 2103856.48907 | 37.7573827855076 | -122.406595905697 | (37.7573827855076, -122.406595905697) | |||
167491 | 167491 | 230403 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 995 Potrero Ave | 10 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6010508.06667 | 2104211.71419 | 37.758357092123106 | -122.406686593337 | (37.7583570921231, -122.406686593337) | |||
71026 | 71026 | 230404 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 995 Potrero Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6010493.00859 | 2104414.71875 | 37.7589136546545 | -122.406752977672 | (37.7589136546545, -122.406752977672) | |||
175478 | 175478 | 230405 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 701 Potrero Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6010473.72719 | 2104680.02328 | 37.7596410425128 | -122.406838360202 | (37.7596410425128, -122.406838360202) | |||
44441 | 44441 | 230406 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 701 Potrero Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6010469.85138 | 2104738.84531 | 37.7598023377254 | -122.406855910494 | (37.7598023377254, -122.406855910494) | |||
61392 | 61392 | 230407 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 701 Potrero Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6010466.98 | 2104784.69833 | 37.75992807914729 | -122.406869072951 | (37.7599280791473, -122.406869072951) | |||
147472 | 147472 | 230408 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 701 Potrero Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6010466.90309 | 2104889.86859 | 37.7602168487345 | -122.40687675138001 | (37.7602168487345, -122.40687675138) | |||
76703 | 76703 | 230409 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 701 Potrero Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6010459.52552 | 2104963.6053 | 37.7604189003367 | -122.406907464126 | (37.7604189003367, -122.406907464126) |
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");