Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▼ | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4838 | 4838 | 243005 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 301 Dolores St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 6ft | 6004912.59389 | 2106510.6516400003 | 37.7643547760633 | -122.42620188801001 | (37.7643547760633, -122.42620188801) | |||
| 121754 | 121754 | 17176 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1601 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/1999 12:00:00 AM | 3 | 4X4 | 6004921.1693652 | 2114736.5058391998 | 37.7869414485048 | -122.426758067349 | (37.7869414485048, -122.426758067349) | ||
| 18206 | 18206 | 5473 | DPW Maintained 3 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 601 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/08/2016 05:56:00 AM | 3 | 4X4 | 6005007.93466 | 2104733.32137 | 37.7594800368996 | -122.42574561699301 | (37.7594800368996, -122.425745616993) | ||
| 18980 | 18980 | 5478 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 655 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/2013 12:00:00 AM | 2 | 3X3 | 6005024.7062 | 2104455.06021 | 37.7587169450524 | -122.42566780763501 | (37.7587169450524, -122.425667807635) | ||
| 59900 | 59900 | 84342 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1153 Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50832 | 6005241.68146 | 2120923.0691400003 | 37.8039462987346 | -122.426089751557 | (37.8039462987346, -122.426089751557) | |
| 79139 | 79139 | 108621 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 150-198X Webster St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2014 12:00:00 AM | 3 | Permit Number 774592 | 6005405.0 | 2109611.0 | 37.7728954095296 | -122.424719362301 | (37.7728954095296, -122.424719362301) | |
| 49040 | 49040 | 230420 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 143 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6005428.8647300005 | 2102882.34915 | 37.7544214771723 | -122.424158193041 | (37.7544214771723, -122.424158193041) | |||
| 97188 | 97188 | 109448 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 143 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/18/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770854 | 6005451.2 | 2102876.8 | 37.7544075015735 | -122.424080557223 | (37.7544075015735, -122.424080557223) |
| 112590 | 112590 | 104967 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 143-147 FAIR OAKS ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3x3 | Permit Number 770854 | 6005451.2 | 2102876.8 | 37.7544075015735 | -122.424080557223 | (37.7544075015735, -122.424080557223) | ||
| 94928 | 94928 | 108393 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 321 San Carlos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/19/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772685 | 6006734.79675 | 2104244.32387 | 37.7582347949878 | -122.419738566409 | (37.7582347949878, -122.419738566409) |
| 155237 | 155237 | 131012 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1661 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6006845.959840001 | 2116366.0433 | 37.7915243922801 | -122.420214413174 | (37.7915243922801, -122.420214413174) | |||
| 109745 | 109745 | 115375 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 230 Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2016 12:00:00 AM | 3 | Permit Number 776301 | 6007067.3 | 2096865.5 | 37.7379929380378 | -122.41806552154101 | (37.7379929380378, -122.418065521541) | ||
| 121527 | 121527 | 108628 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 741 Ellis St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774600 | 6007319.99858 | 2113650.90643 | 37.7840959912819 | -122.418381641984 | (37.7840959912819, -122.418381641984) | |
| 86642 | 86642 | 39178 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1050 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2015 12:00:00 AM | 3 | 4x4 | Permit Number 775243 | 6007589.88726975 | 2103539.15878969 | 37.7563467058962 | -122.416731326975 | (37.7563467058962, -122.416731326975) | |
| 114085 | 114085 | 39177 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1050 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2015 12:00:00 AM | 3 | 4x4 | Permit Number 775243 | 6007589.88726975 | 2103539.15878969 | 37.7563467058962 | -122.416731326975 | (37.7563467058962, -122.416731326975) | |
| 37611 | 37611 | 230424 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 387 Shotwell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6007831.12637 | 2105698.0394200003 | 37.76228806116921 | -122.41604991899099 | (37.7622880611692, -122.416049918991) | |||
| 74087 | 74087 | 230423 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 387 Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6007832.95914 | 2105672.86461 | 37.7622190400112 | -122.416041797198 | (37.7622190400112, -122.416041797198) | |||
| 61485 | 61485 | 230422 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 387 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6007833.76172 | 2105654.7259299997 | 37.7621692805159 | -122.41603773676901 | (37.7621692805159, -122.416037736769) | |||
| 144594 | 144594 | 82560 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 832 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2009 12:00:00 AM | 3x3 | Permit Number 52208 | 6009084.37207289 | 2104307.27777207 | 37.7585397298832 | -122.411617128308 | (37.7585397298832, -122.411617128308) | ||
| 45892 | 45892 | 230421 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 2851 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6009338.5093 | 2104971.08738 | 37.76037665287679 | -122.41078508446002 | (37.7603766528768, -122.41078508446) | |||
| 77661 | 77661 | 94252 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 2125 BRYANT ST | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6009652.0 | 2104721.0 | 37.7597075419954 | -122.40968320892 | (37.7597075419954, -122.40968320892) | |||
| 80296 | 80296 | 94248 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 2125 BRYANT ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6009652.0 | 2104721.0 | 37.7597075419954 | -122.40968320892 | (37.7597075419954, -122.40968320892) | |||
| 80407 | 80407 | 94251 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 2125 BRYANT ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6009652.0 | 2104721.0 | 37.7597075419954 | -122.40968320892 | (37.7597075419954, -122.40968320892) | |||
| 83236 | 83236 | 94249 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 2125 BRYANT ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6009652.0 | 2104721.0 | 37.7597075419954 | -122.40968320892 | (37.7597075419954, -122.40968320892) | |||
| 85527 | 85527 | 58794 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 2125 BRYANT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/17/1979 12:00:00 AM | Permit Number 18041 | 6009652.0 | 2104721.0 | 37.7597075419954 | -122.40968320892 | (37.7597075419954, -122.40968320892) | |||
| 96459 | 96459 | 94253 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 2125 BRYANT ST | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6009652.0 | 2104721.0 | 37.7597075419954 | -122.40968320892 | (37.7597075419954, -122.40968320892) | |||
| 116382 | 116382 | 94250 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 2125 BRYANT ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6009652.0 | 2104721.0 | 37.7597075419954 | -122.40968320892 | (37.7597075419954, -122.40968320892) | |||
| 116397 | 116397 | 94257 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 2777X 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6009684.4 | 2104752.7 | 37.7597963985886 | -122.40957339028499 | (37.7597963985886, -122.409573390285) | |||
| 119799 | 119799 | 94256 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 2777X 19th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6009684.4 | 2104752.7 | 37.7597963985886 | -122.40957339028499 | (37.7597963985886, -122.409573390285) | |||
| 174486 | 174486 | 230411 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 2901 Cesar Chavez St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6010009.797780001 | 2100525.6899 | 37.7482081987543 | -122.408149874844 | (37.7482081987543, -122.408149874844) | ||||
| 13398 | 13398 | 29248 | DPW Maintained 3 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 470X Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2006 12:00:00 AM | 3 | 3X3 | 6010243.1599 | 2097486.61497 | 37.7398766239144 | -122.40712872251999 | (37.7398766239144, -122.40712872252) | ||
| 14440 | 14440 | 26560 | DPW Maintained 3 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 430 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/14/2006 12:00:00 AM | 3 | 3X3 | 6010280.19543 | 2097760.62921 | 37.740631080471395 | -122.40701997739599 | (37.7406310804714, -122.407019977396) | ||
| 135447 | 135447 | 193437 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 420 Bay Shore Blvd | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6010286.5563 | 2097785.62722 | 37.7407000755616 | -122.40699974536501 | (37.7407000755616, -122.406999745365) | |||
| 18743 | 18743 | 18381 | DPW Maintained 3 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 768 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3x3 | 6010390.09454 | 2104720.536 | 37.7597476013854 | -122.40713046091801 | (37.7597476013854, -122.407130460918) | |||
| 13581 | 13581 | 18341 | DPW Maintained 3 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 425 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2014 12:00:00 AM | 3 | 3x3 | 6010391.567000001 | 2106310.47571 | 37.7641132991006 | -122.407237448759 | (37.7641132991006, -122.407237448759) | ||
| 15086 | 15086 | 18346 | DPW Maintained 3 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 447 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/21/2006 12:00:00 AM | 3 | 3x3 | 6010394.89315 | 2106204.37839 | 37.7638221660807 | -122.407218464984 | (37.7638221660807, -122.407218464984) | ||
| 16826 | 16826 | 18350 | DPW Maintained 3 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 459 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/08/2015 06:59:00 AM | 3 | 3x3 | 6010395.85662 | 2106161.99214 | 37.7637058369709 | -122.40721214454099 | (37.7637058369709, -122.407212144541) | ||
| 16499 | 16499 | 25480 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 501 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/21/2006 12:00:00 AM | 3 | 3x3 | 6010409.92318 | 2105901.91388 | 37.7629925082126 | -122.407145158522 | (37.7629925082126, -122.407145158522) | ||
| 160052 | 160052 | 230400 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 898 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6010432.2870000005 | 2104046.5208099997 | 37.7578992679501 | -122.406937031143 | (37.7578992679501, -122.406937031143) | |||
| 145233 | 145233 | 18367 | DPW Maintained 3 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 625 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/17/2015 09:59:00 AM | 3 | 4X3 | 6010438.66394 | 2105366.85434 | 37.7615249639888 | -122.407008038291 | (37.7615249639888, -122.407008038291) | ||
| 67791 | 67791 | 230398 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 625 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6010441.3524 | 2105364.41642 | 37.761518420453896 | -122.40699856812901 | (37.7615184204539, -122.406998568129) | |||
| 53201 | 53201 | 230399 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 635 Potrero Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6010446.039030001 | 2105294.43136 | 37.761326519519 | -122.406977425991 | (37.761326519519, -122.406977425991) | |||
| 31334 | 31334 | 230397 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 635 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010452.60466 | 2105203.30463 | 37.7610766734566 | -122.406948295125 | (37.7610766734566, -122.406948295125) | |||
| 162305 | 162305 | 230396 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 675 Potrero Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010452.66825 | 2105159.82839 | 37.7609573010551 | -122.406945010817 | (37.7609573010551, -122.406945010817) | |||
| 41687 | 41687 | 230410 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 701 Potrero Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6010454.77139 | 2105010.4435799997 | 37.7605472416892 | -122.406927207828 | (37.7605472416892, -122.406927207828) | |||
| 179529 | 179529 | 230395 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 675 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010455.482030001 | 2105111.38251 | 37.760824437031395 | -122.40693186450899 | (37.7608244370314, -122.406931864509) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) |
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |
| 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) | |||
| 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) | |||
| 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) | |
| 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) | |||
| 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) |
| 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) | |||
| 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) | |
| 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) | |
| 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) | |
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) |
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");