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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
142496 | 142496 | 31633 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 2522 Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1995 12:00:00 AM | Permit Number 35150 | 5981503.28977265 | 2097904.29050404 | 37.739373184525704 | -122.506528416597 | (37.7393731845257, -122.506528416597) | ||
145753 | 145753 | 31644 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 3601 Taraval St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1995 12:00:00 AM | Permit Number 35157 | 5982065.15070434 | 2098736.73871701 | 37.7416919237879 | -122.504647444825 | (37.7416919237879, -122.504647444825) | ||
86051 | 86051 | 38919 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 739 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/25/2002 12:00:00 AM | Permit Number 40729 | 5994644.0321122 | 2089899.68618843 | 37.7181594465135 | -122.460513981509 | (37.7181594465135, -122.460513981509) | ||
84488 | 84488 | 37087 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 1431 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | Permit Number 39687 | 5981822.5647819 | 2105347.10091721 | 37.7598278475269 | -122.50597620053001 | (37.7598278475269, -122.50597620053) | ||
100012 | 100012 | 37107 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 4501 Irving St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | Permit Number 39705 | 5981809.38189346 | 2106215.79884963 | 37.7622122675222 | -122.506086203855 | (37.7622122675222, -122.506086203855) | ||
120495 | 120495 | 37116 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 4542 Irving St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | Permit Number 39708 | 5981682.74450716 | 2106263.49145698 | 37.762335762281 | -122.506527724058 | (37.762335762281, -122.506527724058) | ||
134786 | 134786 | 37114 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 4540 Irving St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 0 | Permit Number 39707 | 5981688.69009077 | 2106263.69511954 | 37.7623366715481 | -122.506507175967 | (37.7623366715481, -122.506507175967) | |
135660 | 135660 | 37119 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 4731 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 0 | Permit Number 39709 | 5981101.19035238 | 2106191.54023256 | 37.762103946482505 | -122.508533725105 | (37.7621039464825, -122.508533725105) | |
140797 | 140797 | 37132 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 4447 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | Permit Number 39714 | 5981086.08651436 | 2104832.07084282 | 37.7583703439041 | -122.508485038953 | (37.7583703439041, -122.508485038953) | ||
164869 | 164869 | 37115 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 4540 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 0 | Permit Number 39707 | 5981688.69009077 | 2106263.69511954 | 37.7623366715481 | -122.506507175967 | (37.7623366715481, -122.506507175967) | |
182887 | 182887 | 37113 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 4523 IRVING ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 0 | Permit Number 39706 | 5981665.2 | 2106185.8 | 37.7621214108202 | -122.506582640723 | (37.7621214108202, -122.506582640723) | |
137605 | 137605 | 80263 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 2074 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50734 | 5982335.751 | 2100990.6763 | 37.747896525944796 | -122.50387871228399 | (37.7478965259448, -122.503878712284) | |
86529 | 86529 | 37248 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 3038 Pacheco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1998 12:00:00 AM | Permit Number 39801 | 5985578.39129143 | 2101634.00517992 | 37.7498530704582 | -122.492713344722 | (37.7498530704582, -122.492713344722) | ||
53256 | 53256 | 47907 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 746 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2002 12:00:00 AM | 7 | Permit Number 45646 | 6000056.4472 | 2111499.7732 | 37.7777779701242 | -122.44335627129999 | (37.7777779701242, -122.4433562713) | |
90351 | 90351 | 37484 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 1246 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | Permit Number 39953 | 5990822.12261544 | 2106914.97361747 | 37.7646584370326 | -122.47496590913099 | (37.7646584370326, -122.474965909131) | ||
104329 | 104329 | 37633 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 793 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | Permit Number 40051 | 5990357.97842308 | 2109989.05024853 | 37.773072107347495 | -122.476795862973 | (37.7730721073475, -122.476795862973) | ||
121472 | 121472 | 37635 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 797 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | Permit Number 40053 | 5990358.92841621 | 2109962.95608948 | 37.7730005150319 | -122.476790669979 | (37.7730005150319, -122.476790669979) | ||
129115 | 129115 | 40541 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 389 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/30/2005 12:00:00 AM | Permit Number 48035 | 5992634.70647519 | 2093966.0670834 | 37.7292089323345 | -122.467754881103 | (37.7292089323345, -122.467754881103) | ||
54311 | 54311 | 46406 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 2443 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/03/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51149 | 5982682.2949 | 2098486.1858 | 37.741040257888706 | -122.50249506178801 | (37.7410402578887, -122.502495061788) | |
97252 | 97252 | 37811 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 354 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/1998 12:00:00 AM | Permit Number 40131 | 6004085.30799236 | 2091240.01678916 | 37.722378331197206 | -122.427974988755 | (37.7223783311972, -122.427974988755) | ||
142338 | 142338 | 43216 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 44 Dunsmuir St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | Permit Number 43006 | 6008111.99433178 | 2094081.5468642 | 37.73040755168461 | -122.41425657074 | (37.7304075516846, -122.41425657074) | ||
14525 | 14525 | 43623 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 210 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/20/2000 12:00:00 AM | Permit Number 43272 | ||||||||
30475 | 30475 | 43625 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 2218 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2000 12:00:00 AM | 8 | Permit Number 43274 | 5985464.7649 | 2100091.9996 | 37.7456124972844 | -122.49299269129699 | (37.7456124972844, -122.492992691297) | |
42850 | 42850 | 43626 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 2222 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2000 12:00:00 AM | 7 | Permit Number 43275 | 5985464.7649 | 2100074.5033 | 37.7455644571804 | -122.49299140272 | (37.7455644571804, -122.49299140272) | |
86011 | 86011 | 43610 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 2174 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2000 12:00:00 AM | Permit Number 43264 | 5986078.58326706 | 2100441.09799391 | 37.746606905591996 | -122.49089591351401 | (37.746606905592, -122.490895913514) | ||
79217 | 79217 | 43824 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 2539 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | Permit Number 43452 | 5985490.59688758 | 2097934.34218836 | 37.7396896615859 | -122.492744480822 | (37.7396896615859, -122.492744480822) | ||
141727 | 141727 | 38353 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 1800 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/31/1998 12:00:00 AM | Permit Number 40421 | 5981341.25756614 | 2102804.1865841 | 37.7528173861664 | -122.507452100184 | (37.7528173861664, -122.507452100184) | ||
139347 | 139347 | 51245 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 35 Majestic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/17/2004 12:00:00 AM | Permit Number 47620 | 5997371.20755939 | 2089722.08093206 | 37.7178282993487 | -122.451074550694 | (37.7178282993487, -122.451074550694) | ||
531 | 531 | 27691 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 1765 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/2015 12:00:00 AM | 7 | 3X3 | 6001581.2067 | 2112155.8038 | 37.779666096456 | -122.438128618136 | (37.779666096456, -122.438128618136) | ||
6133 | 6133 | 27582 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 1777 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/2015 12:00:00 AM | 5 | 3X3 | 6001533.8276 | 2112150.0507 | 37.7796476052413 | -122.438292110376 | (37.7796476052413, -122.438292110376) | ||
17904 | 17904 | 27583 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 1781 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/2015 12:00:00 AM | 5 | 3X3 | 6001531.97079 | 2112100.50741 | 37.7795114663002 | -122.43829498357901 | (37.7795114663002, -122.438294983579) | ||
140057 | 140057 | 31631 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 2506 Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/09/2000 12:00:00 AM | Permit Number 35148 | 5981494.85529112 | 2098008.01672128 | 37.739657491429796 | -122.506565269459 | (37.7396574914298, -122.506565269459) | ||
5374 | 5374 | 120897 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 3760 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2016 12:00:00 AM | 3 | 2x5 | Permit Number 778876 | 6002560.418 | 2121574.39052 | 37.805582749215105 | -122.43541504397301 | (37.8055827492151, -122.435415043973) | |
80926 | 80926 | 87297 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 4227 Lincoln Way | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/16/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773956 | 5982573.0 | 2106897.6 | 37.764129220397294 | -122.50349567213001 | (37.7641292203973, -122.50349567213) | ||
100449 | 100449 | 35513 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 3488 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/2006 12:00:00 AM | Permit Number 38915 | 6005128.06949501 | 2103142.26204564 | 37.755118149138 | -122.42521691501899 | (37.755118149138, -122.425216915019) | ||
146438 | 146438 | 43057 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 1922 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/27/2010 12:00:00 AM | 5 | 3x3 | Permit Number 53821 | 5981365.4957 | 2101971.9303 | 37.750533673272706 | -122.507306541093 | (37.7505336732727, -122.507306541093) |
109535 | 109535 | 31636 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 2542 Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37115 | 5981513.83287394 | 2097774.63274006 | 37.73901780088121 | -122.506482350919 | (37.7390178008812, -122.506482350919) | ||
98714 | 98714 | 38927 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 30 Lunado Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | Permit Number 40735 | 5991530.391079799 | 2091455.54556163 | 37.7222518366051 | -122.47138970523199 | (37.7222518366051, -122.471389705232) | ||
57844 | 57844 | 72845 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 2625 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1998 12:00:00 AM | 10 | 5989234.0157 | 2097465.6374 | 37.7386209048407 | -122.479767197253 | (37.7386209048407, -122.479767197253) | ||
112675 | 112675 | 48954 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 1425 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/26/2002 12:00:00 AM | Permit Number 46141 | 6009586.08390989 | 2100908.24074194 | 37.7492348647629 | -122.409642067631 | (37.7492348647629, -122.409642067631) | ||
83587 | 83587 | 114672 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 85X Peralta Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11/30/2015 12:00:00 AM | Permit Number 775155 | 6010502.29579 | 2100335.12269 | 37.7477125069204 | -122.40643339757601 | (37.7477125069204, -122.406433397576) | |||
88155 | 88155 | 114671 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 85X Peralta Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11/30/2015 12:00:00 AM | Permit Number 775155 | 6010502.29579 | 2100335.12269 | 37.7477125069204 | -122.40643339757601 | (37.7477125069204, -122.406433397576) | |||
112258 | 112258 | 114673 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 85X Peralta Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11/30/2015 12:00:00 AM | Permit Number 775155 | 6010502.29579 | 2100335.12269 | 37.7477125069204 | -122.40643339757601 | (37.7477125069204, -122.406433397576) | |||
141651 | 141651 | 24770 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 201X Point Lobos Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/1998 12:00:00 AM | 12 | 5982138.31917 | 2112600.73174 | 37.779762797108205 | -122.505421833339 | (37.7797627971082, -122.505421833339) |
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");